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

News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

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