Print

[michaelchenx]

Hi, I'm new to CPG...
I was trying to install the cpg14x in RedHat Linux 9, but met some problem. I'm using PHP5.2.5, mysql5.1.7 and ImageMagick installed. When I go to install page, fill all the blanks, then click Let's Go!; it shows a ERROR. The error message is followed:
The following errors were encountered and need to be corrected first:

mySQL Error: 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 'TYPE=MyISAM COMMENT='Used to store sessions'' at line 7 on query ' CREATE TABLE IF NOT EXISTS cpg14x_sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions''


What's the problem with it?
Thanks!

[pitzerwm]

I have a similar problem, my error message is:

mySQL Error: CREATE command denied to user 'MYNAME'@'98.130.2.32' for table 'cpg14x_sessions' on query ' CREATE TABLE IF NOT EXISTS cpg14x_sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions''

[Nibbler]

That's a bug in MySQL 5.1.7 apparently. You need to update. Current MySQL 5.1 is 5.1.38

[pitzerwm]

That's a bug in MySQL 5.1.7 apparently. You need to update. Current MySQL 5.1 is 5.1.38

Is this for me or the other guy or both?

[Nibbler]

The original poster. Your issue is unrelated - start your own thread.