Sporks-R-Us: Bastard Hybrid Utensil of D00M!
Front Page · Everything · News · Op/Ed · Ask A Spork · Interviews · Religion · Reviews · MLP · AK5CG · Strange · Cats · Nonsense · Fiction · Dead at 54 · The Pits of Hell · Meta · Vlad's Store · Diaries · Site News
who the fuck deleted my comment history

Diary
By m0rk
from the wtf department, Section Diaries
Posted on Sun Apr 24, 2005 at 08:52:53 AM GMT
all of my stroies have been deleted, all of my comments, half of my diary.

some one kindly tell me what the fuck happened!!!!!!!!!!!!!!!!!!!!!!!!!!!

dividing image

< Sorry for my absence (not absinthe) | The Beginning of Sporks >
Menu
· create account · faq · search · mission · topics

Login
Make a new account
Username:
Password:

Related Links
· m0rk's Diary

Display: Sort:
who the fuck deleted my comment history | 12 comments (12 topical, 0 hidden)
our comment histories (5.00 / 3) (#9)
by MFS on Sun Apr 24, 2005 at 08:59:54 PM GMT

were declared to be terrorists by the Patriot Act.


When my fist clenches, crack it open, before I use it and lose my cool...



SHIT (none / 0) (#1)
by Vladinator on Sun Apr 24, 2005 at 09:33:59 AM GMT

DB corruption. Hopefully, I can fix it. We ran out of space on the server, and the DB got lightly toasted.

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"



INSERT 8==> INTO * (5.00 / 2) (#5)
by Beef on Sun Apr 24, 2005 at 04:10:04 PM GMT

in other words, your DB was raped up the ass.

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



Sorry (5.00 / 1) (#6)
by Beef on Sun Apr 24, 2005 at 04:11:14 PM GMT

been coding WAY too much DBI at work these past few weeks.

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



Oh good! (none / 0) (#8)
by Vladinator on Sun Apr 24, 2005 at 08:04:01 PM GMT

What's some perl-fu to rebuild the indexes?

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



If you can give me (5.00 / 1) (#10)
by Beef on Sun Apr 24, 2005 at 09:28:20 PM GMT

the brand of DB and a complete schema, I might be able to whip something up.  Hopefully it's something simple like some foreign key relationship getting blown away.

I'm not sure how missing indexes would cause this to happen, but if you can also send me the list of what the indexes used to be, restoring those should be a snap.

You hace my email, right?

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



Indexes may be the wrong word. (none / 0) (#11)
by Vladinator on Sun Apr 24, 2005 at 10:56:02 PM GMT

It's a MySQL database, and the schema is in the Scoop tarball... I'm not 100% sure what version we're running.

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



when I have a mo' (5.00 / 1) (#12)
by Beef on Mon Apr 25, 2005 at 02:28:08 PM GMT

I've worked with MySQL, and it's documented to death.  I'll look at the scoop schema and take a crack at it.

The comments are still there.  So my first guess is that there's a user-comments table with foreign keys to a user table and to a comments table.  This should be easy to rebuild.  Unless I'm completely and totally wrong, which is entirely possible.

--
Be conservative in what you do. Be liberal in what you accept from others.
[ Parent ]



Oh, and (none / 0) (#2)
by Vladinator on Sun Apr 24, 2005 at 09:34:48 AM GMT

mine are all gone, too.

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



yikes (5.00 / 1) (#3)
by m0rk on Sun Apr 24, 2005 at 10:48:45 AM GMT

probably not much i can do to help.

hack? or db fart?



[ Parent ]


and i must apologize for sounding pissed (5.00 / 1) (#4)
by m0rk on Sun Apr 24, 2005 at 10:50:13 AM GMT

i'm assuming, with your comments gone, you know where the anger is coming from.



[ Parent ]


The good news is, (none / 0) (#7)
by Vladinator on Sun Apr 24, 2005 at 08:03:23 PM GMT

we just need to rebuild the indexes (I think) and it will all show back up. :-)

"It's clearly a budget. It's got a lot of numbers in it. - G.W. Bush"
[ Parent ]



who the fuck deleted my comment history | 12 comments (12 topical, 0 hidden)
Display: Sort:

SRU - Embrace the Spork! SourceForge Logo Powered by Scoop
Inspiration
You are here: *** *** ********* ******* ***** *** * But you're not all there.

Please buy the stuff we sell on ebay.
All trademarks and copyrights on this page are owned by their respective companies. Comments are owned by the Poster. The Rest © 2003-2006 The Management

create account | faq | search