This is a MySQL error, so tell your sysadmin to run a repair on the table asap.
Thread Starter
ian2
(@ian2)
Thanks Matt. I own the server and have root access. I did a repair and this is what I got:
teen_wrdp1.wp_categories repair status OK
teen_wrdp1.wp_comments repair status OK
teen_wrdp1.wp_email_list repair status OK
teen_wrdp1.wp_linkcategories repair status OK
teen_wrdp1.wp_links repair status OK
teen_wrdp1.wp_options repair status OK
teen_wrdp1.wp_post2cat repair status OK
teen_wrdp1.wp_postmeta repair status OK
teen_wrdp1.wp_posts repair error 13 when fixing table
teen_wrdp1.wp_posts repair error Can’t copy datafile-header to tempfile, error 9
teen_wrdp1.wp_posts repair status Operation failed
teen_wrdp1.wp_snowfall repair status OK
teen_wrdp1.wp_usermeta repair status OK
teen_wrdp1.wp_users repair status OK
Thread Starter
ian2
(@ian2)
BTW: If this makes any difference, when I am looking at all of my databases at the home, it says wp_posts is “in use”.
And when I try to access it I Get this:
SQL query: Edit
SHOW KEYS FROM wp_posts
;
MySQL said: Documentation
#1016 – Can’t open file: ‘wp_posts.MYI’. (errno: 144)
Thread Starter
ian2
(@ian2)
Ok, my friend who knows MYSQL helped me and fixed it. For future reference I will note what he said was the problem and what he did:
: The issues were 1 : mysql had crashed, and had taken mysql into journal editing mode – you’d need to use phpmyadmin to run repair on any tables that shows ” in use ”
and 2) the server was stopped in appropriately.