[Digital Jedi]

Originally Posted by GoBoiano

Hi. I seem to get this problem when one of my members try to post in the forum section, but I tested it on other members accounts and it seems to work for them. His account was the only account that it didn't work for. This error always came up:

Database error in vBulletin 3.8.5:

Invalid SQL:
INSERT IGNORE INTO vb_conquest_comments (nationID, playerID, userID, username, cDate, cState, cText, cIPAdd, cSmilies)
		VALUES ('3', '5', '3', 'Poppin' Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1');

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 'Dragon', '1277150409', 'visible',	'test', '66.188.67.166', '1')' at line 2
Error Number  : 1064
Request Date  : Monday, June 21st 2010 @ 01:00:09 PM
Error Date    : Monday, June 21st 2010 @ 01:00:09 PM
Script        : http://www.goboiano.com/conquest.php?do=comments
Referrer      : http://www.goboiano.com/conquest.php?do=comments
IP Address    : 66.188.67.166
Username      : Poppin' Dragon
Classname     : vB_Database
MySQL Version : 5.0.91-log

It's probably the single quote in his screen name. It's breaking the SQL syntax.