
01-16-2005, 06:25 PM
|
 |
|
|
Join Date: Dec 2002
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
OK, maybe someone can figure this out.
My phrases and templates are all in there. However, when I add a quote directly to the quotes.php page, I get this response:
Quote:
Database error in vBulletin 3.0.5:
Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('this is a test submission to get this working again.', 'xxxxx', 1, )
mysql error: You have an error in your SQL syntax near ')
' at line 2
mysql error number: 1064
Date: Sunday 16th of January 2005 12:15:45 PM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxxx
IP Address:xxxxxxxxxxx
|
It's trying to call to $vboptions[moderatequotes], which is in quotes.php.
The quotes are all still in the database; the upgrade did not affect them.
Should we reinsert the sql queries like this:
Quote:
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)
|
instead of what's called for in the instructions:
Quote:
INSERT INTO " . TABLE_PREFIX . "setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)
|
Anyone have any idea?
|