I'm having some trouble getting those sql queries to work. I get a syntax error message for each:
Quote:
SQL-query : [Edit]
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'Help Forum\',\'HELPforum\',\'1\',\'The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)\',\'\',\'15\')
MySQL said:
You have an error in your SQL syntax near '\'Help Forum\',\'HELPforum\',\'2\',\'The forumid of the forum that you want the ' at line 1
|
Quote:
SQL-query : [Edit]
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'User Question Answered\',\'HELPdone\',\'<i>[Answered]</i> \',\'The name of the prefix for thread where the user has been helped!\',\'\',\'16\')
MySQL said:
You have an error in your SQL syntax near '\'User Question Answered\',\'HELPdone\',\'<i>[Answered]</i> \',\'The name o' at line 1
|
Quote:
SQL-query : [Edit]
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'User Question Unanswered\',\'HELPundone\',\'<i>[Un-Answered]</i> \',\'The name of the prefix for the thread where the user is awaiting help!\',\'\',\'17\')
MySQL said:
You have an error in your SQL syntax near '\'User Question Unanswered\',\'HELPundone\',\'<i>[Un-Answered]</i> \',\'The' at line 1
|
Quote:
SQL-query : [Edit]
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'Help Thread Status\',\'HELPopen\',\'0\',\'Close that particular thread once help is provided?\',\'yesno\',\'18\')
MySQL said:
You have an error in your SQL syntax near '\'Help Thread Status\',\'HELPopen\',\'0\',\'Close that particular thread once he' at line 1
|
Quote:
SQL-query : [Edit]
ALTER TABLE thread ADD helpoption smallint(6) NOT NULL DEFAULT \'0\'
MySQL said:
You have an error in your SQL syntax near '\'0\'' at line 1
|
Any help would be appreciated. I'm new when it comes to mysql so I don't really know what to do.
|