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
Comment #1
vip_sa commentedHow do I fix a table marked as crached? What can I do to fix this please. It's an emergency
Comment #2
dddave commentedhttp://lmgtfy.com/?q=Fixing+crashed+database+tables
Comment #3
vip_sa commentedThank 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.
Comment #4
mdupontThis 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.
Comment #5
mahtoranjeet commentedMysql 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)