
10-13-2010, 06:02 PM
|
|
|
Join Date: May 2005
Posts: 211
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I keep getting this error, any ideas?
Quote:
Database error in vBulletin 4.0.6:
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 >= 1284404340
AND donate.time <= 1286909940
GROUP BY userid,(donate.amount < 0);
MySQL Error : Unknown column 'donate.postid' in 'where clause'
Error Number : 1054
Request Date : Wednesday, October 13th 2010 @ 08:00:20 PM
Error Date : Wednesday, October 13th 2010 @ 08:00:21 PM
Script : xxxxxxxxxxxxxxx/kbankadmin.php?do=salary
Referrer : xxxxxxxxxxxxxxxxxxxxxxx/admincp/kbankadmin.php?do=salary
IP Address : xxxxxxxxxxxxxxxxxxxxxxxxxxx
Username : Dr. Fragmaster
Classname : vB_Database
MySQL Version : 5.1.33-community
|
|