| Intex |
01-09-2005 03:28 PM |
Abe - It looks like it's because the queries didn't run properly to me. I tried running one of the ones from the install file directly in phpadmin:
Code:
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)");
Produced the following error:
Code:
Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 9
STR: ->
SQL: $DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)")
SQL-query :
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES ('post_thanks_on_off', 'post_thanks','1','1', 'yesno', 10, 0, 0)")
MySQL said:
#1064 - 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 '$DB_site->query("INSERT INTO " . TABLE_PREFIX . "setting VALUES
All the queries where the syntax is using 'INSERT INTO' produce the same problem and these are all related to the settings. The other queries which ALTER tables, such as the 'user' and 'post' run successfully and they're working because it's tracking the amount of thank you's someone has.
Can you see what's wrong with the syntax? I'm running 3.0.1 and mySQL 3.23.49. |
More Information