i got drupal running fine for few months here:
http://polarisnetwork.com/portal/
suddenly i see the web content disappear!
and i get lots of these error on the log:
error php 2006-02-12 23:45 Incorrect key file for table 'node'; try to repair it query: SEL Anonymous details
error php 2006-02-12 23:45 Incorrect key file for table 'n'; try to repair it query: SELECT Anonymous details
error php 2006-02-12 23:35 mysql_query(): Unable to save result set in /usr/www/users/polar Anonymous details
error php 2006-02-12 23:35 Incorrect key file for table 'n'; try to repair it query: SELECT Anonymous details
warning page not found 2006-02-12 23:35 node/19 not found. Anonymous details
error php 2006-02-12 23:35 Incorrect key file for table 'node'; try to repair it query: SEL Anonymous details
error php 2006-02-12 23:35 Incorrect key file for table 'n'; try to repair it query: SELECT Anonymous details
when i go to admin content menu, i see all my posted items there.
except, when i click to edit the items it shows up empty!
and the form is not complete either.
all i can see in the form is only down to path alias form.
and directly after that is the preview button.
this error start happens exactly at 2006-02-12 23:35
before that, i see no error in the log.
am i being hacked!?
any help is much appreciated.
tia
rex
Comments
Damaged database
Your database seems to be damaged. See http://dev.mysql.com/doc/refman/5.0/en/repair-table.html for repair instructions and additional information.
Can you post the entire errormessage between <code> tags?
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.
repair worked for me
Just thought I would post a note because I had the same problem and was nervous to do a repair. I backed up the database and did a repair on the node table - there were no problems and drupal is working fine now.
cheers
alynner
If you have phpMyAdmin, you can login
And probably repair the tables from there.
Check the box next to all the tables, hit the drop down box at the bottom, and choose "repair table".
Then check the box next to all the tables again, and choose "check table". If all worked then everything should come up as ok.
Here's a screenshot of what I'm talking about: http://jbeall.com/personal/phpMyAdmin.jpg
Oh, and this is a MySQL problem
Not a security problem.
I guess it's theoretically possible that someone hacking your system might corrupt your database... but it can certainly happen without anything malicious happening.