Sporks R' Us || Comments || who the fuck deleted my comment history

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 | 12 comments (12 topical, 0 hidden)

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 ]

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

Display: Sort:

Menu

· create account · faq · search · mission · topics

Login

Make a new account

Username:

Password:

Inspiration

Sex is not the answer. Sex is the question. "Yes" is the answer.

- Swami X

create account | faq | search