By chicomtl on

site is HARDTIMES.CA

When i log on as as a guest i get this message. I heard it was white spaces in the php files but someone else told me it was the data base.

Warning: Can't open file: 'watchdog.MYI'. (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', 'Can't open file: 'watchdog.MYI'. (errno: 145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'user', 'Session closed for <em>hardtimes</em>.', 0, '', 'http://hardtimes.ca/logout', 'http://hardtimes.ca/', '66.212.252.115', 1215716835) in /mounted-storage/home45c/sub006/sc33112-IRXD/hardtimes.ca/includes/database.mysql.inc on line 172.', 2, '', 'http://hardtimes.ca/logout', 'http://hardtimes.ca/', '66.212.252.1 in /mounted-storage/home45c/sub006/sc33112-IRXD/hardtimes.ca/includes/database.mysql.inc on line 172

Warning: Can't open file: 'watchdog.MYI'. (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at /mounted-storage/home45c/sub006/sc33112-IRXD/hardtimes.ca/includes/database.mysql.inc:172) in /mounted-storage/home45c/sub006/sc33112-IRXD/hardtimes.ca/includes/common.inc on line 309.', 2, '', 'http://hardtimes.ca/logout', 'http://hardtimes.ca/', '66.212.252.115', 1215716835) in /mounted-storage/home45c/sub006/sc33112-IRXD/hardtimes.ca/includes/database.mysql.inc on line 172

original post
http://drupal.org/node/280131

someone posted this as the solution:

his is somewhat serious and not directly a Drupal problem. The message "Can't open file: 'cache_page.MYI'" probably means your MySQL database has been corrupted. I've had this problem on a number of occasions, generally when my 25-dollar recycled server in my basement suffers a power failure.

You regularly back up your database, right?

Well, neither do I. Fortunately, neither the cache_page table nor the watchdog table contain critical information, If those tables have been mangled, you can -- AFTER FIRST MAKING A BACKUP! -- drop those tables and recreate them.

I have several Drupal installations on my server, so I deal with this problem by copying the structure -- and not the data -- from a good image.

how much would this set me back

⋅ Categories: Drupal 5.x

Comments

kenuck’s picture

kenuck commented

Yes , your 'watchdog.MYI' file is corrupted.

Best thing to do is to replace the table.
1. backup your database
2. drop the watchdog table
3. import a new 'watchdog' table (probably empty one) from another installation.

you'll need to do this via mysql commandline or phpmyadmin NOT through drupal.

cheers

-----------------------------------------
http://www.netrift.com
http://rlisting.netriftsolutions.com - Drupal Real Estate Module for Drupal 5
http://ulisting.netriftsolutions.com - Drupal Real Estate Module for Drupal 6

czarphanguye’s picture

czarphanguye commented

I'll take care of this issue for you for $49.99. djpeterman@gmail.com

chicomtl’s picture

chicomtl commented

email you about doing the job.

thanks for all those who gave me input but i don't even know how to read those messages php, stupid.

much love

chico

kbahey’s picture

kbahey commented

Using phpmyadmin from your control panel, just truncate the table, and a new one will be created.
--
Drupal performance tuning, development, customization and consulting: 2bits.com, Inc.
Personal blog: Baheyeldin.com.

--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba

wilson98’s picture

wilson98 commented

same things happened to me, my solution is delete the table and restore it from backup, it works.