Database Error w/No warnings w/install screen
-
Hi,
I have been running a site for almost 3 months, and then I installed the update from 2.5.0 to 2.5.1, everything went fine, but today to days later when I checked the site, it was asking me to install wordpress, like it was never intalled.
I quickly logged into phpmyadmin to see if my database was still there.
I checked my tables and I got this error after running a check tables command in phpmyadmin
mydata_wrdp1.wp_ak_popularity check status OK
mydata_wrdp1.wp_ak_popularity_options check status OK
mydata_wrdp1.wp_comments check status OK
mydata_wrdp1.wp_links check status OK
mydata_wrdp1.wp_options check error Table ‘./mydata_wrdp1/wp_options’ is marked as corrupt
mydata_wrdp1.wp_postmeta check status OK
mydata_wrdp1.wp_posts check status OK
mydata_wrdp1.wp_terms check status OK
mydata_wrdp1.wp_term_relationships check status OK
mydata_wrdp1.wp_term_taxonomy check status OK
mydata_wrdp1.wp_usermeta check warning 1 client is using or hasn’t closed the table
mydata_wrdp1.wp_usermeta check status OK
mydata_wrdp1.wp_users check status OKFor just good measure, I selected all tables and did a repair table from phpmyadmin and it gave me this info.
mydata_wrdp1.wp_options repair info Wrong block with wrong total length starting at 51…
mydata_wrdp1.wp_options repair info Wrong block with wrong total length starting at 54…
mydata_wrdp1.wp_options repair warning Number of rows changed from 145 to 142
mydata_wrdp1.wp_options repair status OKAnd now everything works fine, but for a while anyone could have reinstalled my blog, and I would have lost everything.. Was this just a glitch in the release or something else, I have not made a post in over a week.
I will let you know if it happens again.
The topic ‘Database Error w/No warnings w/install screen’ is closed to new replies.