I get the following error when searching for a member to manage their awards:
I x'd out some of the information ....
Code:
Database error in vBulletin x.x.xx:
Invalid SQL:
SELECT award.award_id, award.award_name, award.award_desc, award.award_icon_url, award.award_img_url, award_user.*
FROM cagisf_award_user as award_user
LEFT JOIN cagisf_ award as award USING (award_id)
WHERE award_user.userid = 3837;
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 'as award USING (award_id)
WHERE award_user.userid = 3837' at line 3
Error Number : 1064
Request Date : Monday, December 15th 2014 @ 09:21:41 PM
Error Date : Monday, December 15th 2014 @ 09:21:42 PM
Script : http://www.mysite.com/community/myadmincp/award_user.php?do=edit&u=3837
Referrer : https://www.mysite.com/community/myadmincp/award_user.php?do=search
IP Address : xxx.xxx.xxx.xxx
Username : CAG CheechDogg
Classname : vB_Database
MySQL Version : 5.5.40-36.1