Links SQL has been working wonderfully for me until today, now when I click on any links I get this error:

DBSQL (3441): Fatal Error: Unable to execute query: DELETE FROM Hits_Track WHERE TO_DAYS(NOW()) - TO_DAYS(created) > 2. Reason: Can't open file: 'Hits_Track.MYD'. (errno: 145) at /home/httpd/cgi-bin/jump.cgi line 138

I am assuming there is a problem with my Hits_Track table in the database.

Is there a way to repair it?
I have REM'ed out line 138 of my jump.cgi and which is:
$db->do ("DELETE FROM Hits_Track WHERE TO_DAYS(NOW()) - TO_DAYS(created) > 2");
Now atleast things will work.

any help is greatly appreciated.


Rene Rodriguez

The Hitstrack table is very susceptable to damage due to server problems. If your ISP can run the repair utility, the quick way to fix it is to just dump the database structure using mysqlman to your screen, copying it, deleting the Hits_Track table, then pasting the the structure back into the SQL monitor.

It will make the new table and the new index files, etc.

All you lose is your duplicate hit prevention for 24-48 hours.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://LinkSQL.com/FAQ

I ran:
myisamchk -r -q Hits_Track
and it fixed the problem.
but when running myisamchk to check tables I did come accross another problem in my Search_Log table, this one is not as crutial but is still a problem.
It seem that when I use the admin.cgi to purge keyword searches it is deleting the records but not the rows.
for example: My table shows 10 rows with data but 3000 rows that do not have any data at all.
For now i am just using: mysql> DELETE FROM Search_Log To clear the table to I can figure out what is wrong.

any suggestions?

Rene Rodriguez