Recently i experienced this issue and thought of blogging it.
we were using adodb for database abstraction and had enabled logging.
The error that was given by adodb was like
"LOGSQL Insert Failed : insert into adodb_logsql ..." i have not put the entire SQL there and "Incorrect key file for table yyy.MYI; try to repair it". yyy is a fictional table name.

In this case the server was running linux and the file system had a 2GB limit for a file.

if you get an error like below
UID of script "/var/www/index.php" is smaller than min_uid

then chown "/var/www/index.php" to a user, who lies below the current user who owns the file and check.

The first thing i do with a new Linux installation is , setup multimedia
Mplayer is now in the “main” repository. so just do an

apt-get install mplayer

For win32 codecs and libdvdcss2 (which is needed to play DVDs) ,put the following entry in sources list.