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).
MySQL syntax error
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: MySQL syntax error
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.
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.
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/