[Solved] Suddenly getting 'bonk' error on every page of forum : DB corrupt*

I've tried to run /dashboard/utility/structure/ and it says:

Incorrect information in file: './path/GDN_Session.frm'|Gdn_Database|Query|show columns from `GDN_Session` Incorrect information in file: './path/GDN_UserCategory.frm'|Gdn_Database|Query|show columns from `GDN_UserCategory` There are no database structure changes required. There may, however, be data changes.

I've also tried disabling all add-ons to no avail. And I've just updated to the very latest version of Vanilla.

For what it's worth, I've not made any changes at all to the forum for over a month and it's never done this before. The database is up and running just fine, and the admin pages load okay.

Thanks

x00

You could try error logging

 $Configuration['Garden']['Errors']['LogEnabled'] = TRUE;
 $Configuration['Garden']['Errors']['LogFile'] = 'error-log.txt';

blizeH

Many thanks, the error log says:

>[Garden] /hsphere/local/home/path/library/database/class.database.php, 280, Gdn_Database.Query(), Incorrect information in file: './path/GDN_UserCategory.frm', select * from GDN_UserCategory UserCategory where UserID = :UserID

UnderDog

Focus on this error message: Incorrect information in file

It is an error message that was sent to the error handler by vanilla, meaning that somewhere in the sourcecode this exact text can be found.

Find the exact text and the code surrounding that text.

Figure out, why that exact text was sent to the error handler and ultimately to the error log.

blizeH

Please pardon my ignorance but I'm not sure where to start with that :( I've tried uploading over all of the files with no joy, and I'm now speaking with my host to check there isn't a database error - which there isn't. Ahh!

Running this in phpMyAdmin:

SELECT * FROM 'GDN_UserCategory' LIMIT 0 , 30

returns the same error: 1033 - Incorrect information in file: './path/GDN_UserCategory.frm'

damn!

blizeH

had to restore my database. thousands of posts lost ;_;

UnderDog

My bad!

Have your host look at these urls

https://www.google.com/search?q=Incorrect+information+in+file&hl=en&newwindow=1&num=100&lr=&ft=i&cr=&safe=images

Tim

The database became corrupt. Not a Vanilla problem I'm afraid, but I feel for your loss. Keep backups.

whu606

Have you checked with your host if they have a database backup? Mine automatically does one on a daily and weekly basis.

blizeH

Thanks guys, just a weekly (kinda) basis it seems, had to kick back to 11th Jan ;_;

x00

Yep really important to back up before. Oh well it happens.

I should have clicked these where mysql files that is one of their extensions.

11 Jan not to bad, all thing considering.