Getting this error message from my site - anyone help with how to fix it?
A fatal MySQL error was encountered.
Query: SELECT * FROM fanfiction_online WHERE online_uid=0 AND online_ip = INET_ATON('82.31.73.19')
Error: (145) Table './laiquend_weev/fanfiction_online' is marked as crashed and should be repaired
Well, that table's only for the Who's Online block, so if you go to Admin > Blocks and set it to Inactive it will likely stop the error from appearing. You may also have a variables.php file in your skins where you'd need to turn it off. I haven't ever seen that kind of message before, though. Perhaps try uploading a backup of just that table?
However you deal with your MySQL data (via phpmyadmin or some other program), you need to go to that table in MySQL and repair it. Your host also may have instructions in their knowledgebase of FAQs on how to repair crashed tables.
Without more information (that you should supply, read the sticky post entitled "READ THIS BEFORE POSTING!" at the top of each forum), more specific instructions can't be given.
In the admin section/Archive Maintenance is a link to "optimize database tables", but I'm not sure an optimize would repair a broken table. (Nope, just checked, it doesn't!). It may make sense if this option were added to that section (grin).
efiction - 3.5.3
MySql - 5.5.32
php - 5.5.22
Linex - Apache 2.2.17
Hosted by: Fatcow!
http://www.hobert.net/fic/
And if all else fails, you're okay deleting that table from your database and re-installing it from the mysql files. There's no permanent data kept there.
