+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: VHCS2 2.4.7.1 to ISPCP 1.0.0 (/thread-7280.html)
VHCS2 2.4.7.1 to ISPCP 1.0.0 - Yick - 07-22-2009 11:22 PM
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.
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0 - RatS - 07-23-2009 08:29 AM
What's your mySQL version?
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0 - Yick - 07-23-2009 03:52 PM
(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)
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0 - RatS - 07-23-2009 04:04 PM
Code:
CHARACTER SET utf8 COLLATE utf8_unicode_ciis 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?