I had this working for some time now but suddenly members can't request an award. If you click on "request award", the page refreshes and nothing happens.
Then if I try to ISSUE an award from the admin panel, I get the following error.
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT userid, username
FROM user
WHERE username = 'Sleeperhawk's Mechanic';
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 's Mechanic'' at line 3
Error Number : 1064
Request Date : Wednesday, September 17th 2008 @ 09:53:41 PM
Error Date : Wednesday, September 17th 2008 @ 09:53:41 PM
Script : http://www.mysite.org/forum/admincp/award.php?do=dogiveaward
Referrer : http://www.mysite.org/forum/admincp/award.php?do=awardusers&award_id=1
IP Address : 72.69.93.240
Username : admin
Classname : vB_Database
MySQL Version : 5.0.51a-community