By ghavican on

In the past couple of days, my statistics module seems to have stopped functioning. I no longer logs any entries. I've tried disabling it and then reabling it. I've tried disabling throttle. Nothing seems to get it working again. I'm using Drupal 5.13.

My cron jobs are running fine as the other items (such as news aggregator refresh) are functioning fine.

When I try to run the cron.php manually, It gives me the following error:

Warning: Can't open file: 'hdr_watchdog.MYI'. (errno: 145)

I've tried searching for such a file on the system, but nothing exists.

I could really use some help in resolving this because I depend on the statistics for determining what users and/or what sections of the website may need to be throttled, etc.

Greg

⋅ Categories: Drupal 5.x

Comments

ghavican’s picture

ghavican commented

Does anybody have any ideas what so ever regarding this issue? I could really use some help.

vm’s picture

vm commented

That is no drupal file. Matter of fact http://www.google.com/search?hl=en&q=hdr_watchdog.MYI

only shows this thread in entire google.

Thats the best I can do for you considering there seems to be no way to research the error or the file.

LiquidWeb’s picture

LiquidWeb commented

MYI extension is for mysql database index files so try to fix watchdog table

ghavican’s picture

ghavican commented

How do you fix the watchdog table? MySQL shows it always in use so you can't do anything to it.

Greg

LiquidWeb’s picture

LiquidWeb commented

I don't know exactly but If you have root access just delete data files for watchdog file.

And ofcourse do it after backup

ghavican’s picture

ghavican commented

I was able to resolve the issue. I had to purge the records from both the watchdog table and another table using PHPMyAdmin and the select the affected tables and run repair on them. I ran repair twice before reenabling the statistics module.

Greg