The error persists.
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT *, COUNT(playerID) as count FROM rank_events AS rank_events
LEFT JOIN rank_categories AS rank_categories USING(categoryID)
LEFT JOIN rank_scores AS rank_scores USING(eventID)
WHERE rank_events.eventID = '1';
MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Sunday, March 22nd 2009 @ 01:24:19 AM
Error Date : Sunday, March 22nd 2009 @ 01:24:19 AM
Script : http://*/forum/ranking.php?do=event&eid=1
Referrer : http://*/forum/ranking.php?do=event&eid=1
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.45-Debian_1ubuntu3.3-log