My phpmyadmin answered:
Table Op Msg_type Msg_text
mysite_drpl1.watchdog repair Error Table './mysite_drpl1/watchdog' is marked as cras...
mysite_drpl1.watchdog repair Error Table 'watchdog' is marked as crashed and should b...
mysite_drpl1.watchdog repair status Table is already up to date
Now I can see the main page again but the watchdog error still appears.
So I truncated watchdog and accesslog and then repaired the tables and all is fine now.
I'm seeing my accesslog and watchdog getting messed up quite often (every 24-48 hours) and would like to know if someone has any idea as to where I should look for an explanation.
Granted, I can just repair the tables every time it happens, but it's getting a bit tedious, both for me and the users.
Comments
If you have phpmyadmin you
If you have phpmyadmin you can just select the table and click 'repair' from the dropdown list below.
This should settle the things :)
This worked for me too!
This worked for me too! awesome! I love it when things are a quick and easy fix and don't require hours upon hours of searching for a solution :-)
watchdog
My phpmyadmin answered:
Table Op Msg_type Msg_text
mysite_drpl1.watchdog repair Error Table './mysite_drpl1/watchdog' is marked as cras...
mysite_drpl1.watchdog repair Error Table 'watchdog' is marked as crashed and should b...
mysite_drpl1.watchdog repair status Table is already up to date
Now I can see the main page again but the watchdog error still appears.
So I truncated watchdog and accesslog and then repaired the tables and all is fine now.
I'm seeing my accesslog and
I'm seeing my accesslog and watchdog getting messed up quite often (every 24-48 hours) and would like to know if someone has any idea as to where I should look for an explanation.
Granted, I can just repair the tables every time it happens, but it's getting a bit tedious, both for me and the users.