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: MSQ Error syntax  (Read 3753 times)

0 Members and 1 Guest are viewing this topic.

lunaclems

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
MSQ Error syntax
« on: November 10, 2014, 10:17:48 pm »

Hello

I tried to install a second coppermine gallery with new sql table and user and I have this error message:

erreur MySQL : 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 albums'' at line 22 dans la requête ' CREATE TABLE cpg15_albums ( aid int(11) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, visibility int(11) NOT NULL default '0', uploads enum('YES','NO') NOT NULL default 'NO', comments enum('YES','NO') NOT NULL default 'YES', votes enum('YES','NO') NOT NULL default 'YES', pos int(11) NOT NULL default '0', category int(11) NOT NULL default '0', owner int(11) NOT NULL DEFAULT '1', thumb int(11) NOT NULL default '0', keyword VARCHAR( 50 ), alb_password VARCHAR( 32 ), alb_password_hint TEXT, moderator_group INT NOT NULL default 0, alb_hits INT( 10 ) NOT NULL default 0, PRIMARY KEY (aid), KEY alb_category (category), KEY `moderator_group` (`moderator_group`), KEY `visibility` (`visibility`) ) TYPE=MyISAM COMMENT='Used to store albums''

Is somebody can help?

Thanks
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: MSQ Error syntax
« Reply #1 on: November 13, 2014, 08:20:37 pm »

Please download the latest Coppermine package from our download section (currently cpg1.5.34). That query has been changed 4 years ago.
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 19 queries.