Page 1 of 1

MySQL installation error

Posted: Wed Mar 30, 2005 10:30 pm
by ruijt
Hi, I'm trying to import the db.sql into the database I created.
I used it on another site with the phpmyadmin tool and it worked perfect but I'm installing it now on another site and I get the following error when importing the tables:

Error1064 - You have an error in your SQL syntax near '{PREFIX}authors (realname vachar(255) NOT NULL default ", username vachar(' at line 1

Can somebody please help me?

Re: MySQL installation error

Posted: Thu Mar 31, 2005 2:33 pm
by garvinhicking
You never were able to import the db.sql code by hand, that must be an error. We use some replacings in that file, so the db.sql is not anywhere near SQL standard.

You cannot manually import it. I suggest you to just install Serendipity, it inserts the sql code automatically. :)

Regards,
Garvin

Got it!

Posted: Fri Apr 01, 2005 12:37 am
by ruijt
Tnx for that!