I get the following error and I would like information on how I have to go about to repair it please.

An error occurred. /admin/content/node_import/51/continue
Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:677:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'nodewords', '%name changed the meta tags for %type (%id).', 'a:3:{s:5:\\"%name\\";s:3:\\"jan\\";s:5:\\"%type\\";s:4:\\"node\\";s:3:\\"%id\\";s:5:\\"10627\\";}', 5, '', 'http://www.houseproducts.co.za in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:694:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:6:\\"lights\\";s:6:\\"%title\\";s:34:\\"B.L RECESSED SLOT EYELID LED WHITE\\";}', 5, '<a href=\\"/node/10627\\">view</a>', 'http:// in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:677:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'nodewords', '%name changed the meta tags for %type (%id).', 'a:3:{s:5:\\"%name\\";s:3:\\"jan\\";s:5:\\"%type\\";s:4:\\"node\\";s:3:\\"%id\\";s:5:\\"10628\\";}', 5, '', 'http://www.houseproducts.co.za in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:686:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:6:\\"lights\\";s:6:\\"%title\\";s:26:\\"BULKHEAD LARGE PLAIN BLACK\\";}', 5, '<a href=\\"/node/10628\\">view</a>', 'http://www.hous in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:677:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'nodewords', '%name changed the meta tags for %type (%id).', 'a:3:{s:5:\\"%name\\";s:3:\\"jan\\";s:5:\\"%type\\";s:4:\\"node\\";s:3:\\"%id\\";s:5:\\"10629\\";}', 5, '', 'http://www.houseproducts.co.za in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:687:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:6:\\"lights\\";s:6:\\"%title\\";s:27:\\"BULKHEAD LARGE PLAIN SILVER\\";}', 5, '<a href=\\"/node/10629\\">view</a>', 'http://www.hou in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:677:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'nodewords', '%name changed the meta tags for %type (%id).', 'a:3:{s:5:\\"%name\\";s:3:\\"jan\\";s:5:\\"%type\\";s:4:\\"node\\";s:3:\\"%id\\";s:5:\\"10630\\";}', 5, '', 'http://www.houseproducts.co.za in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:686:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:6:\\"lights\\";s:6:\\"%title\\";s:26:\\"BULKHEAD LARGE PLAIN WHITE\\";}', 5, '<a href=\\"/node/10630\\">view</a>', 'http://www.hous in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:677:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'nodewords', '%name changed the meta tags for %type (%id).', 'a:3:{s:5:\\"%name\\";s:3:\\"jan\\";s:5:\\"%type\\";s:4:\\"node\\";s:3:\\"%id\\";s:5:\\"10631\\";}', 5, '', 'http://www.houseproducts.co.za in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:688:\"Table './houseproducts/watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (4, 'content', '@type: added %title.', 'a:2:{s:5:\\"@type\\";s:6:\\"lights\\";s:6:\\"%title\\";s:28:\\"BULKHEAD LARGE W/CROSS BLACK\\";}', 5, '<a href=\\"/node/10631\\">view</a>', 'http://www.ho in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128

Warning: Table './houseproducts/watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (4, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:155:\"Cannot modify header information - headers already sent by (output started at /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc:128)\";s:5:\"%file\";s:63:\"/var/www/virtual/houseproducts.co.za/htdocs/includes/common.inc\";s:5:\"%line\";i:148;}', 3, '', 'http://www.houseproducts.co.za/admin/content/node_import/51/continue', 'http://www.houseproducts.co.za/admin/content/node_import/51', '198.54.202.110', 1270303029) in /var/www/virtual/houseproducts.co.za/htdocs/includes/database.mysqli.inc on line 128
{ "status": 1, "message": "15 rows imported\x3cbr /\x3e0 rows with errors", "percentage": 0 }

Comments

vip_sa’s picture

How do I fix a table marked as crached? What can I do to fix this please. It's an emergency

dddave’s picture

vip_sa’s picture

Thank you I raed what they write there. I don't have the option of repairing the database from PHPMyAdmin. The following is the error I get. There is no repair table in any drop down. Please help me.

#145 - Table './houseproducts/watchdog' is marked as crashed and should be repaired
SELECT *
FROM `watchdog`
LIMIT 0 , 30
[ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]

Error

SQL query: Edit

SHOW FULL FIELDS FROM `watchdog` ;

MySQL said: Documentation
#145 - Table './houseproducts/watchdog' is marked as crashed and should be repaired
Connection for controluser as defined in your configuration failed.

mdupont’s picture

Status: Active » Closed (won't fix)

This is a MySQL issue, nothing related to Drupal. If you don't have access to any way to repair a crashed table (either through PHPMyAdmin or SSH console or issuing REPAIR TABLE watchdog on a custom PHP script, then you should contact your hosting provider.

mahtoranjeet’s picture

Mysql command to repair the tables

To check the crashed table

Run these commends
mysqlcheck -uuser -ppass database (ex watchdog)

To repair crashed table

mysqlcheck -uroot -ppass --auto-repair database table (ex watchdog)