| akanevsky |
10-05-2009 07:27 PM |
Quote:
Originally Posted by yucklawyers
(Post 1892266)
I've had this running a while now. It appears to gather the correct data and report it correctly, but every so often, I get a database error. My forum serves 1000's of downloads a day, and this 'duplicate' error repeats itself on different downloads only once every couple of days.
Anyway, here's the error.
Database error in vBulletin 3.7.5:
Invalid SQL:
INSERT INTO attachmentviewslog (attachmentid, userid, dateline)
VALUES (543935, 4925, 1254175184);
MySQL Error : Duplicate entry '543935-4925' for key 1
Error Number : 1062
Request Date : Monday, September 28th 2009 @ 10:59:44 PM
Error Date : Monday, September 28th 2009 @ 10:59:44 PM
Script : <removed>attachment.php?attachmentid=543935&d=1253 894644
Referrer : <removed>showthread.php?t=35888
IP Address : <removed>
Username : <removed>
Classname : vB_Database
MySQL Version :
|
Please try to uninstall this hack and re-install it again, and see if the problem disappears (you will lose the stats). Alternately, you could try repairing / optimizing the database tables from vBulletin admincp - it could be that there is something wrong with the indexes. |
More Information