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!
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''
That's a bug in MySQL 5.1.7 apparently. You need to update. Current MySQL 5.1 is 5.1.38
QuoteThat'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?
The original poster. Your issue is unrelated - start your own thread.