[anotherHOLiC]

Hi mrpaint, I'm sorry if someone has already brought this up, but I got this error today while running a the default query in the Salary Center in the Admin CP...

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT
SUBSTR(donate.comment,LOCATE('"',donate.comment,19 ) + 1,LOCATE('"',donate.comment,LOCATE('"',donate.comm ent,19) + 1) - (LOCATE('"',comment,19) + 1)) AS userid
,COUNT(*) AS count
,SUM(donate.amount) AS total
FROM `kbank_donations` AS donate
WHERE donate.postid LIKE 'p%'
AND donate.from = 0
AND donate.time >= 1272407460
AND donate.time <= 1274999460
GROUP BY userid,(donate.amount < 0);

MySQL Error : Unknown column 'donate.postid' in 'where clause'
Error Number : 1054
Request Date : Thursday, May 27th 2010 @ 11:31:14 PM
Error Date : Thursday, May 27th 2010 @ 11:31:14 PM
Script : xxxxxxx/admincp/kbankadmin.php?do=salary
Referrer : xxxxxxx/admincp/kbankadmin.php?do=salary
IP Address : xxx.xxx.xxx.xxx
Username : xxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.90-community-log