I used this one smooth and help my board alot with no problem ,but today when i notice that the thead didn't count when people view , i ran the cron job theadview in schedules and i got this error :
Database error in vBulletin 3.0.7:
Invalid SQL: INSERT INTO threadviewsaggregate SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
mysql error: Duplicate entry '40' for key 1
mysql error number: 1062
Date: Tuesday 28th of June 2005 08:09:36 PM
Script:
http://xx.com/forum/admincp/cronadmi...ncron&cronid=2
Referer:
http://xx.com/forum/admincp/index.php?
anyone got any idea why i got this and how to fix ,thank in advance . I used to run the threadview before and nerver got this error . before this error, i didn't restore db or install anything .