By the fatman on

After a few days away from the site, it was working fine last time I checked, I try to log in as admin and get this

PDOException: SQLSTATE[HY000]: General error: 145 Table './playcbg_drupal/watchdog' is marked as crashed and should be repaired: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => user [:db_insert_placeholder_2] => Session opened for %name. [:db_insert_placeholder_3] => a:1:{s:5:"%name";s:5:"admin";} [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://www.playcigarboxguitar.com/how?destination=node/10 [:db_insert_placeholder_7] => http://www.playcigarboxguitar.com/ [:db_insert_placeholder_8] => 124.149.188.197 [:db_insert_placeholder_9] => 1366576685 ) in dblog_watchdog() (line 154 of /home/playcbg/public_html/drupal/modules/dblog/dblog.module).

I have a test user account on another browser that has remained logged in and it appears to work OK.

The site is relatively new and I don't have a backup of the database.

I have access to phpmyadmin but am not confident enough with SQL to attempt a DB repair without some expert guidance.

⋅ Categories: Drupal 7.x

Comments

VM’s picture

VM commented

with phpmyadmin

backup the database
empty the watchdog table or use the repair table command in the select list

test

the fatman’s picture

the fatman commented

Thanks VM, that was painless.

Abhimanyu Bose’s picture

Abhimanyu Bose commented

The solution works great. I am a not an expert. I truncated the watchdog table and the issue was solved.

Thanks again.