VHCS2 2.4.7.1 to ISPCP 1.0.0

[Yick]

Hi, I've got a problem upgrading VHCS2 to ISPCP.

here is the error message i receive at the end of the # perl ./ispcp-setup

ERROR: External command '/usr/bin/mysql --host="localhost" --user="root" --pass="xxxxx" < /tmp/db.sql 1>/tmp/db.sql.stdout 2>/tmp/db.sql.stderr' returned '1' status !


in the db.sql.stderr here is the content :

ERROR 1064 at line 1: 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 'CHARACTER SET utf8 COLLATE utf8_unicode_ci' at line 1

i thought that could come from locales ? :o but i have not clue how to fix that.. so if someone can help.

V.

[RatS]

What's your mySQL version?

[Yick]

(07-23-2009 08:29 AM)RatS Wrote:  What's your mySQL version?

that's what "pma" tells me...

MySQL 4.0.24_Debian-10sarge2-log sur le serveur localhost
and
MySQL 4.1.11-Debian_4sarge7-log sur le serveur localhost (on another server)

(i'm surprised it says "sarge" ...maybe that's the problem..;i though it was etch)

[RatS]

Code:

CHARACTER SET utf8 COLLATE utf8_unicode_ci

is part of MySQL 5.0 not 4.0. Before you start updating, better install the required files. Have you followed the INSTALL-File in docs-Folder?