MySQL installation error

[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?

[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

[ruijt]

Tnx for that!