Print Page - can not create table on install - error message

Title: can not create table on install - error message - help!
Post by: lilcori on April 09, 2006, 06:20:13 AM

I am at a loss with this and hope someone can help me. The whole MySQL is a new thing to me so can someone tell me what this error message means and how to fix it so I can continue with the install?

mySQL Error: You have an error in your SQL syntax near 'IF NOT EXISTS cpg143_sessions ( session_id varchar(40) NOT NULL default '', ' at line 23 on query ' CREATE TABLE IF NOT EXISTS cpg143_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''

Thank you,
lilcori

Title: Re: can not create table on install - error message - help!
Post by: Nibbler on April 09, 2006, 03:34:28 PM

Check that you have MySQL version 3.23.23 or better

Title: Re: can not create table on install - error message - help!
Post by: lilcori on April 09, 2006, 07:22:48 PM

I have version 3.23.39.

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: lilcori on April 09, 2006, 06:20:13 AM