FWIW: The click_track table is _very_ susceptible to damage, as it's virtually always open, and is the most often written to and read table in the system. It suffers through both reads and writes, as well as deletes in the normal course of operations. No other table, (except now perhaps the sessions table) does the same thing.

Corruption to this table, often means a server error has occured, a reboot was done without proper shutdown, or soemthing else "crashed" in some way.

You might use this as a sign to BACKUP and keep backups of your data files.

BTW... the additional tracking tables some of my plugins install (as well as tracking tables other people's plugins may install) would also be subject to this sort of problem. Most of my tracking tables are based on the click tracks table, although the newer ones attempted to alter the clicktracks table to allow additional types of "hits", rather than adding new tables. Point is -- any "open" tables, especially active ones -- are susceptable to [index] damage if there is a hard server event [crash].


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.