I have been using Links SQL for some months without problems. But now, jump.cgi stops working. The following error has occured:

Software error:

DBSQL (17761): Fatal Error: Unable to execute query: DELETE FROM Hits_Track WHERE TO_DAYS(NOW()) - TO_DAYS(created) > 2.
Reason: Incorrect key file for table: 'Hits_Track'. Try to repair it at
/usr/local/apache/html-pages/danny/cgi-bin/jump.cgi line 72

Well, I have checked the mySQL libraries and didn't found any error. I have reinstalled Links SQL in a test directory and everything went fine. So, what have I to do?!?

Thanks in advance,
Danny

Did you check your MySQL tables?

If you are on a virtual server, ask your ISP to do it.

Sounds like you may have a corrupt index file.

Hi,

this problem was discussed some weeks ago, I should use the search function next time before opening a new thread :-)

http://www.gossamer-threads.com/...ew=&sb=&vc=1

With this documentation I could solve the problem within some minutes.

Greeetings from Germany,
Danny

If that worked, it was probably a corrupt index file, and the drop/create table can work. The Hits_Track table takes a lot of abuse, so it's the most likely to become corrupt in a multi-user environment (virtual/shared servers, etc).

If you have telnet ability, and access to your own MySQL (Dedicated server) you can run isamcheck on the files, and see what the errors are, and fix them.

Hi pugdog,

what is isamcheck and where can I get it? Yes, it's my own dedicated server. I searched for this keyword at mysql.com and found no documents.

Bye,
Danny

look in the .../mysql/bin subdirectory.

When I'm tired I type too fast, and this keyboard is too small for my hands...

the file is : isamchk

and you can find the instructions for it at http://www.mysql.org