viper357
Customer
Hi, I received this database error today when using a members name with an apostrophe and an s, the members name is Anita but I typed out @Anita's, I assume this is what caused the database error, if you could please confirm, thanks. I'm not sure if it's caused by your mod or not because it mentions tapatalk and usertag in there, even though I wasn't using tapatalk, I was using my laptop.
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT
user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN tapatalk_users AS tt_user ON (user.userid = tt_user.userid AND tt_user.tag = 1)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE user.username IN ('George','Anita's');
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')' at line 9
Error Number : 1064
Request Date : Tuesday, November 6th 2012 @ 04:30:49 AM
Error Date : Tuesday, November 6th 2012 @ 04:30:49 AM
Script : Marine Aquariums South Africa
Referrer : Durban Reefers Nov/Dec - Marine Aquariums South Africa
IP Address : *****
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.65-cll
Database error in vBulletin 3.8.5:
Invalid SQL:
SELECT
user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN tapatalk_users AS tt_user ON (user.userid = tt_user.userid AND tt_user.tag = 1)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE user.username IN ('George','Anita's');
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')' at line 9
Error Number : 1064
Request Date : Tuesday, November 6th 2012 @ 04:30:49 AM
Error Date : Tuesday, November 6th 2012 @ 04:30:49 AM
Script : Marine Aquariums South Africa
Referrer : Durban Reefers Nov/Dec - Marine Aquariums South Africa
IP Address : *****
Username : viper357
Classname : vB_Database
MySQL Version : 5.1.65-cll
