Hey guys!
Been using the Downloads mod since the very beginning but unfortunately, I just encountered a huge database error. When someone tries to download a file, a new browser page opens and the following error is displayed:
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT time
FROM dl_downloads
WHERE (`userid`=1
OR `clientip`='xxx.xxx.xxx.xx')
ORDER BY `time` DESC LIMIT 0,1;
MySQL Error : Table 'dl_downloads' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Tuesday, June 30th 2009 @ 05:47:32 PM
Error Date : Tuesday, June 30th 2009 @ 05:47:33 PM
Script : http://url/downloads.php?do=file&id=2032&act=down
Referrer : http://url/downloads.php?do=file&id=2032
IP Address : not important
Username : not important
Classname : vB_Database
MySQL Version : 5.0.77-community
Can anyone please tell me what the error is about and how to solve it? Please note that I already followed the advise of the MySQL Error but repairing the table didn't solve it. MyPHPAdmin said that the table is already uptodate.
Thank you in advance for your reply. Please consider this message urgent because this mod is by far the most important feature of my site and being without it really cripples the site.
Regards,
Bozza