can not create table on install - error message - help! can not create table on install - error message - help!
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

can not create table on install - error message - help!

Started by lilcori, April 09, 2006, 06:20:13 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lilcori

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

Nibbler

Check that you have MySQL version 3.23.23 or better

lilcori