When My website's members are try to access thier account the following message displays:

Example 1:

user warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'user', 'Session opened for admin.', 0, '', 'http://www.chillicious.com/rapper_ja_rule_posts_co_defendant_s_bail?dest...', 'http://www.chillicious.com/rapper_ja_rule_posts_co_defendant_s_bail', '202.63.101.3', 1204256031) in /home/chi10000/public_html/includes/database.mysql.inc on line 172.
warning: Cannot modify header information - headers already sent by (output started at /home/chi10000/public_html/includes/database.mysql.inc:172) in /home/chi10000/public_html/includes/session.inc on line 100.
warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/chi10000/public_html/includes/session.inc on line 103.

Example 2 :

* user warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'user', 'Session opened for csuseela.', 0, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chillicious.com/', '202.63.101.3', 1204255581) in /home/chi10000/public_html/includes/database.mysql.inc on line 172.
* warning: Cannot modify header information - headers already sent by (output started at /home/chi10000/public_html/includes/database.mysql.inc:172) in /home/chi10000/public_html/includes/session.inc on line 100.
* warning: session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent in /home/chi10000/public_html/includes/session.inc on line 103.

So I request Drupal Community to help me on this matter by telling me how to solve this problem. I am using Drupal 5.5 for this website.

I wait for immediate responses/solutions and I must be appreciate it very much.

Yours Sincerely,

Mrs. Nagalakshmi
www.chillicious.com

Comments

Anonymous’s picture

Anonymous (not verified) commented
Status: Active » Closed (fixed)

this is not because of watchdog live.

this module does NOT do any INSERT statements.

nagatlakshmi’s picture

nagatlakshmi commented

Hello Steve,

Thank you very much for your quick reply.

When a member try to login they get error like following:

Warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', 'Table 'watchdog' is marked as crashed and should be repaired\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'user', 'Session opened for <em>csuseela</em>.', 0, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chillicious.com/', '202.63.101.3', 1204337398) in /home/chi10000/public_html/includes/database.mysql.inc on line 172.', 2, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chilli in /home/chi10000/public_html/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', 'Cannot modify header information - headers already sent by (output started at /home/chi10000/public_html/includes/database.mysql.inc:172) in /home/chi10000/public_html/includes/session.inc on line 100.', 2, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chillicious.com/', '202.63.101.3', 1204337398) in /home/chi10000/public_html/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', 'session_regenerate_id() [<a href='function.session-regenerate-id'>function.session-regenerate-id</a>]: Cannot regenerate session id - headers already sent in /home/chi10000/public_html/includes/session.inc on line 103.', 2, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chillicious.com/', '202.63.101.3', 1204337398) in /home/chi10000/public_html/includes/database.mysql.inc on line 172

Warning: Table 'watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (3, 'php', 'Cannot modify header information - headers already sent by (output started at /home/chi10000/public_html/includes/database.mysql.inc:172) in /home/chi10000/public_html/includes/common.inc on line 314.', 2, '', 'http://www.chillicious.com/node?destination=node', 'http://www.chillicious.com/', '202.63.101.3', 1204337398) in /home/chi10000/public_html/includes/database.mysql.inc on line 172

And we again try in next window they can successfully login without errors.

Please let me now how can solve this problem? And who is help me in this matter.

I wait for your immediate response.

Yours Sincerely,

Mrs. Nagalakshmi.
www.chillicious.com

Anonymous’s picture

Anonymous (not verified) commented

you are not suppose to use issue tickets like this.

you should have posted in the forum looking for support help or go on IRC and talk in #drupal-support

You may need to run the repair table watchdog; sql statement.

iancawthorne’s picture

iancawthorne commented

This is the only post I've been able to find as I have the same problem.

What is the "repair table watchdog; sql statement"?

Where can I look for a fix for this?

alexmoreno’s picture

alexmoreno commented

http://drupal.org/node/354795#comment-2304414

naxoc’s picture

naxoc commented

This is not an issue for the watchdog_live module, but you can probably find some help here: http://ryansnyder.me/Drupal-Table-Watchdog-is-Marked-as-Crashed-Error

mkoskenk’s picture

mkoskenk commented

FYI, I had the same error and after running

repair table watchdog;

I had access error stating that I don't have permissions to enter my user settings page (even though I am The SuperUser UID1). I had to run also

repair table sessions;

after which things are back to nice and smooth. Kudos for user justchecking (http://drupal.org/node/490530)

Marco Palmero’s picture

Marco Palmero commented

Thanks mkoskenk for he query line.

All I did was to paste this in Run SQL (query) box in phpMyAdmin:

repair table watchdog;

Then clear caches in the Performance page.

Error fixed!

farneville’s picture

farneville commented
Issue tags: +PHP, +table, +phpbb

here is a complete guide how to fix it with screen captures how to fix sessions is marked as crashed and should be repaired

naxoc’s picture

naxoc commented
Issue tags: -PHP, -table, -phpbb

Removing irrelevant tags

chandantyagi’s picture

chandantyagi commented

Thanks mkoskenk,

It works for me.....

urmila26’s picture

urmila26 commented
Version: 5.x-1.1 » 6.x-1.0
Assigned: nagatlakshmi » urmila26

user warning: Table './........./watchdog' is marked as crashed and should be repaired query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'file system', 'The directory %directory is not writable, because it does not have the correct permissions set.', 'a:1:{s:10:\"%directory\";s:26:\"sites/default/files/images\";}', 3, '',