WATCHDOG error
Hi, i am new to Drupal, and i have some big problems with the Watchdog Module. The first things is that i cant see it in the modules section or the administer panel.. is this common?
Other thing is this that i receive these messages very often:
Warning: Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed\nquery: SELECT DISTINCT(type) FROM watchdog ORDER BY type in /home/titicis8/public_html/includes/database.mysql.inc on line 172.', 2, '', 'http://inkaterra.com/en/admin/logs/watchdog', 'http://inkaterra.com/en/admin/logs/settings', '200.121.77.74', 1187639655) in /home/titicis8/public_html/includes/database.mysql.inc on line 172
Warning: Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed\nquery: SELECT COUNT(*) FROM watchdog w INNER JOIN users u ON w.uid = u.uid in /home/titicis8/public_html/includes/database.mysql.inc on line 172.', 2, '', 'http://inkaterra.com/en/admin/logs/watchdog', 'http://inkaterra.com/en/admin/logs/settings', '200.121.77.74', 1187639655) in /home/titicis8/public_html/includes/database.mysql.inc on line 172
Warning: Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Table './titicis8_drupal/watchdog' is marked as crashed and last (automatic?) repair failed\nquery: SELECT w.wid, w.uid, w.severity, w.type, w.timestamp, w.message, w.link, u.name FROM watchdog w INNER JOIN users u ON w.uid = u.uid ORDER BY w.wid DESC LIMIT 0, 50 in /home/titicis8/public_html/includes/database.mysql.inc on line 172.', 2, '', 'http://inkaterra.com/en/admin/logs/watchdog', 'http://inkaterra.com/en/admin/logs/settings', '200.121.77.74', 1187639655) in /home/titicis8/public_html/includes/database.mysql.inc on line 172
I have read some messages talking about the same.. one says that i must repair the table (i try but i get this error):
titicis8_drupal.watchdog repair info Found block that points outside data file at 15972...
titicis8_drupal.watchdog repair info Found block that points outside data file at 15974...
titicis8_drupal.watchdog repair error Not enough memory for blob at 1599328 (need 942878...
titicis8_drupal.watchdog repair info Found block that points outside data file at 15972...
titicis8_drupal.watchdog repair info Found block that points outside data file at 15974...
titicis8_drupal.watchdog repair error Not enough memory for blob at 1599328 (need 942878...
titicis8_drupal.watchdog repair status Operation failed
Im very worried about this issue. My website is working, but i dont know what to do.
Did i must drop the table and create one from 0 ? anyone have the watchdog data to recreate the table?
Is there and archive to clean? Where is the Log? in the database or in a File?
Any ideas how to fix this?
Thanks,
Hawkthalas
(no title)
Instead of dropping the table, first try to empty it (truncate). If you need to drop it, you can find its structure in /modules/system/system.install
The watchdog module is usually "hidden" in a collapsed section of /admin/build/modules with all the "required" core modules.
Hey buddy, thx, all is
Hey buddy, thx, all is working fine now. You made my day. =D
(no title)
A problem with the watchdog table is that it can grow really large fast, hundreds of MB with all the queries executed on a live site, if Drupal's cron.php does not run regularly to trim it.
this is right
find all on www.novo.ws
Table './titicis8_drupal/watchdog' is
Watchdog Problem also
I am not getting any information in any of my items on my Logs area.
The WatchDog module is in my core - required modules.
My CRON runs once a day. Asked for info to be stored for a week.
Every page has no info.
I am not getting any error messages.
Everything else is generally working fine.
have you
since you are not displaying anything, some options:
- set the logs to show cron runs, then run cron manually (the status page is a good place to do this)
- toggle the logs off/on (seems silly, i know)
- check the server logs (web, php, mysql) for indications of problems
- one of the things that the OP referred to was a db/table repair (if the log indicate a need); one such reference is here
- the first comment in this thread has a subsequent suggestion if a repair does not work or is not indicated (truncate/empty the table, not drop)