By rohitgonsalves on

Yetsterday when I was about to create a node and save it in Drupal my pc shut down because of power cut down. The next time I started the site I got really wierd errors on the all pages of my site.

Like: Warning watchdog failed to LOCK TABLES query insert into....

Again there is big node displayed all over the pages which contains 4 to 5 errors showing about function.mysql failed.

Please let me know how to solve such type of issues if they come when u have already deployed the site.

I actually created new site using the same node info but I kept this site to reconfigure it and solve the problem. need ur help guys.

Regards,
Rohit

Comments

calebgilbert’s picture

calebgilbert commented

What is happening based on your description. You should probably do a search on Drupal.org for the exact error you're getting.

Bloggyland.com

dman’s picture

dman commented

If you've got a corrupt database (yeh, likely through a hard shutdown) it's a database problem.
Go over to MySQL and read up on the 'REPAIR TABLE' options and stuff.

I don't know it by heart myself, but I've been through the motions a few times, and eventually massaged the problems out. Search (the web) for troubleshooting guides for MySQL.

(and learn to backup your database while you're there)

.dan.
How to troubleshoot Drupal | http://www.coders.co.nz/

.dan. is the New Zealand Drupal Developer working on Government Web Standards

rohitgonsalves’s picture

rohitgonsalves commented

Again I have deleted entries from the watchdog and started drupal next day. Everything is fine now.

I must learn backing up databases now.