Support > cpg1.5 upgrading

Problems updating 1.4.27 to 1.5.4 or something else

(1/1)

Partypapst2:
Hello,
wenn i tried to update my coppermine gallery i had one problem. When i tried to start update.php the screen said: Something is wrong or you install coppermine for the first time and it takes me to the install screen. There i do the process up to point 8 and then it will end with the following:

--- Quote ---MySQL error: 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 on query ' CREATE TABLE cpg15x_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''
--- End quote ---

Someone an idea why the update.php doesn't work and is it possible to "reinstall" over the old coppermine version so that over 600 albums are not lost?

ron4mac:
You should be upgrading from 1.4.x to 1.5.48

Follow the directions: https://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_any

Partypapst2:
Same Problem... Can't update... only new installation. I have 664 albums, don't wanna lose them.

ron4mac:
If you will PM me with your cPanel login, I will try to help you.

Navigation

[0] Message Index