[David Coutts]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it\'s off','canviewclosed','6,5,7','What usergroups can view the board even if it\'s closed (seperate with a comma)','','3')

Is there anything wrong with that? Because when I try to go Query the DB, it says the following, basically that I have a Syntax Error, and seeing as I'm hopeless at whatever that is, I can't tell what's wrong with it.

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,1,'What usergroups can view the board while it's off','canviewclosed','6,5,7','What usergroups can view the board even if it's closed (seperate with a comma)','','3')

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 off','canviewclosed','6,5,7','What usergroups can view the bo

mysql error number: 1064