New Install 1.4.10 Some pages report "Performing Database Updates" New Install 1.4.10 Some pages report "Performing Database Updates"
 

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]

Main Menu

New Install 1.4.10 Some pages report "Performing Database Updates"

Started by Hojo4654261, December 06, 2006, 06:16:52 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Hojo4654261

I just completed a brand new installation of Coppermine 1.4.10

Unix/Apache 2.0
PHP 4.4.4
MySQL 4.1.21
Imagemagick 6.0.7

Installation went smoothly (realtively speaking)

After install I created a test category and album and uploaded one picture... so far so good.

Problem time...

When I click on any of the following links: "Last uploads" "Last comments" "Most viewed" "Top rated" "My favorites"

I get a page that starts like this:

Performing Database Updates
CREATE TABLE IF NOT EXISTS cpg1410_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'   OK
CREATE TABLE IF NOT EXISTS cpg1410_filetypes ( extension char(7) NOT NULL default '', mime char(30) default NULL, content char(15) default NULL, KEY extension (extension) ) TYPE=MyISAM COMMENT='Used to store the file extensions'   OK
ALTER TABLE `cpg1410_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` )   Already Done
ALTER TABLE `cpg1410_filetypes` ADD `player` VARCHAR( 5 )    Already Done
INSERT INTO cpg1410_filetypes VALUES ('jpg', 'image/jpg', 'image', '')   Already Done
INSERT INTO cpg1410_filetypes VALUES ('jpeg', 'image/jpeg', 'image', '')   Already Done



and ends like this:

ALTER TABLE `cpg1410_pictures` CHANGE `mtime` `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'   OK
ALTER TABLE `cpg1410_albums` CHANGE `description` `description` TEXT NOT NULL   OK
Upgrade completed

It's recommended to check your file versions if you just upgraded from an older version of coppermine.
If you didn't (or you don't want to check), you can go to your gallery's start page

When I check my version I get 243 files that check out, no problems.
When I got to my gallery start page it works fine.

Where is my problem? Why does it keep upgrading these files when they are already up to date?


Nibbler

Re-upload the script, you have probably corrupted the files during upload.