Quote:
Originally Posted by Phalynx
It would be good to see that SQL Error, please post it here.
|
Bellow is the error:
Code:
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT
COUNT(response) AS countevents
FROM eventattendance
INNER JOIN event ON event.eventid = eventattendance.eventid
WHERE response='Yes' AND userid=1
AND event.dateline > 315532800;
MySQL Error : Column 'userid' in where clause is ambiguous
Error Number : 1052
Request Date : Wednesday, March 14th 2012 @ 04:27:30 AM
Error Date : Wednesday, March 14th 2012 @ 04:27:31 AM
Script : /xperience_admin.php?do=xperience_admin_recount_xp
Referrer : /xperience_admin.php?do=recount
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.92-log