Well, I got the new file, but I got another present with it. It must be my birthday.
Quote:
Database error in vBulletin 3.5.0 Release Candidate 1:
Invalid SQL:
SELECT COUNT(p.postid) AS total
,p.userid
,u.username
,u.joindate
FROM
post AS p
LEFT JOIN
user as u
ON
u.userid = p.userid
WHERE
p.dateline > 1122854400
AND
p.dateline < 1125446400
ORDER BY
total DESC
GROUP BY
userid
LIMIT
10;
MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY
userid
LIMIT
10' at line 17
Error Number : 1064
Date : Monday, August 8th 2005 @ 05:32:22 PM
Script : http://www.bearfacts2.com/boards/activity.php?$session[sessionurl]
Referrer :
IP Address :
Username : Boofo
Classname : vb_database
|