Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: can not create table on install - error message - help!  (Read 2784 times)

0 Members and 1 Guest are viewing this topic.

lilcori

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
can not create table on install - error message - help!
« 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
Logged

Nibbler

  • Guest
Re: can not create table on install - error message - help!
« Reply #1 on: April 09, 2006, 03:34:28 pm »

Check that you have MySQL version 3.23.23 or better
Logged

lilcori

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: can not create table on install - error message - help!
« Reply #2 on: April 09, 2006, 07:22:48 pm »

I have version 3.23.39. 
Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 15 queries.