Current time: 11-14-2024, 09:39 AM Hello There, Guest! (LoginRegister)


Post Reply 
VHCS2 2.4.7.1 to ISPCP 1.0.0
Author Message
Yick Offline
Newbie
*

Posts: 5
Joined: Aug 2007
Reputation: 0
Post: #1
Question VHCS2 2.4.7.1 to ISPCP 1.0.0
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.
07-22-2009 11:22 PM
Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #2
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0
What's your mySQL version?
07-23-2009 08:29 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Yick Offline
Newbie
*

Posts: 5
Joined: Aug 2007
Reputation: 0
Post: #3
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0
(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)
(This post was last modified: 07-23-2009 03:54 PM by Yick.)
07-23-2009 03:52 PM
Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #4
RE: VHCS2 2.4.7.1 to ISPCP 1.0.0
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?
07-23-2009 04:04 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)