Serendipity Forums

If I tried to upgrade database I got something similar
[quote]#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 '{PREFIX}authors ADD right_publish INT( 1 ) DEFAULT '1'' at li[/quote]
it isn't matter which level of upgrade since 0.6.3 i'm using for - everytime syntax error appears. MySQL 4.0.20 (upgraded on my provider).

You aren't trying to run the SQL file manually, right?

s9y does so for you and replaces {PREFIX} with the right prefix. If you do that manually, you need to replace it with 'serendipity_' or whatever your DB prefix is.