DearDiary Logo
Public DiariesHomeLogin

OK, its back
Thu Jan 10 2002

And as you can see from the autochosen date, its past midnight here in the UK...

I don't yet know what caused the initial crash, and I may never know, sometimes software just goes belly up. But the initial data loss was caused by indexes being invalid and MySQL not alerting me to the fact that they were toast when I ran the checking process. Upon instructing it to check a little more thoroughly it came back and said, basically, 'These indexes are f-f-f-flawed'.

Or as Matt and I would say, fat... Fat flucked.

I believe I have recovered all the data now, however, if you notice something is missing please give me as much information about it as you can (time entered, userid and if possible some text from the entry) so that I can check the hot backup and restore any missing entries from there.

Thank you for your patience folks, apologies for the problems - I seem to be saying that a lot lately :(

Steve.

4 Comments
  • From:
    TheNavidson (Legacy)
    On:
    Thu Jan 10 2002
    Thanks Boss!
  • From:
    Miraclewhip (Legacy)
    On:
    Thu Jan 10 2002
    hope you get some good sleep, you deserve it!
  • From:
    Cutypops (Legacy)
    On:
    Thu Jan 10 2002
    connected to Angel Huggers diary, which was not a problem. Then clicked on 'vote for me'
    I was taken to some sites that, shall I say, you wouldn't want to show your grandmotehr.
    I suspect it has been harnessed from outside.
    I have told AngelHugger.
    Just thought I'd let you know
    cutypops
  • From:
    CastleMistress (Legacy)
    On:
    Sat Jan 12 2002
    Hey Guy's I found a bug! :)

    If anyone tries to leave a comment ( Non Atomic Users ) and uses an apostrophe in their name, they get an error that looks like this:

    Error:
    Query failed [INSERT INTO comments VALUES(26451, 1009843200, 9, 'Kid's Say (Unauthenticated)', '', 'This is so funny', 1010805874, 3501919464, 0, 1)] - You have an error in your SQL syntax near 's Say (Unauthenticated)', '', 'This is so funny', 1010805874, 3501919464, 0, 1)' at line 1

    The error is in the SQL Code you have set up for your database... It can be solved easily. The server is reading the apostrophe submitted where From = Kid's say ( the apostorphe after the d, and before the s ) to be part of the syntax.
    Since some user's may use an apostrophe, you can solve this problem by using " and " in your code around the values given by the user. :)