#1064 - You have an error in your SQL syntax.

Having trouble installing serendipity?
Post Reply
piotr

#1064 - You have an error in your SQL syntax.

Post by piotr »

Hello everyone:

While trying to execute the db.sql file I'm getting the following message:

MySQL said: Documentation

#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 (
username varchar(20) default null,
pass

I'm running MySQL 4.0.21-standard.

What should I do then? RTFMySQLM? Change the sytax manually? Search for another version of the db.sql file? Upgrade/downgrade MySQL? Switch to PGSQL? I would appreciate every idea.

Respect to all forum users - Piotr.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: #1064 - You have an error in your SQL syntax.

Post by garvinhicking »

Don'T execute the db.sql file manually. Use the Serendipity installer, it does all that automatically. Just open http://yourhost/serendipity/ and everything will be automatic from there on.

It's all easier than you're thinking :)

Best regards,
Garvin
# 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/
Post Reply