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: upgrade timeout  (Read 3271 times)

0 Members and 1 Guest are viewing this topic.

spuri

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 37
upgrade timeout
« on: July 01, 2006, 04:16:13 pm »

This is not the first time when i run into upgrade problems
When I run update.php it stops before end (see pic)
When I load phpmyadmin / update.sql i get The connection was reset msg
[when i tested load of phpmyadmin / update.sql on localhost i get this error
ALTER TABLE `CPG_filetypes` DROP INDEX `EXTENSION` ,
ADD PRIMARY KEY ( `extension` ) ;

MySQL said: Documentation
#1091 - Can't DROP 'EXTENSION'; check that column/key exists
]

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fkepfeltoltes.hu%2F060701%2Fcpg_timeout_www.kepfeltoltes.hu_.jpg&hash=a25c1a95bd02c1ba23134ac2fb13503b0a5c0064)

MySQL - 4.1.2-alpha-nt
PHP-Version: 4.3.11 Speicher: 16 MB   Max Execution Time: 30 sec.

how could i solve? (yes export from server, import on localhost, update, than load back to server I do not want this because of char problems - i had ? instead of é on localhost )

mysqldumper:
Sql: ALTER TABLE `CPG_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` );
Erweiterte Inserts: 0
unknown SQL-Command: ALTER TABLE `CPG_filetypes` ADD `player` VARCHAR( 5 ) ;
« Last Edit: July 02, 2006, 04:40:56 pm by spuri »
Logged
"What is the difference between genius and stupidity? Genius has limits." Albert Einstein.

spuri

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 37
Re: upgrade timeout
« Reply #1 on: July 03, 2006, 08:18:58 pm »

pls help me my site is offline because of this
how could i do the update with mysqldumper?
Logged
"What is the difference between genius and stupidity? Genius has limits." Albert Einstein.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: upgrade timeout
« Reply #2 on: July 04, 2006, 08:29:44 am »

Don't use alpha or beta versions in a production environment. In your particular case: upgrade your mySQL version.
Logged

spuri

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 37
Re: upgrade timeout
« Reply #3 on: July 04, 2006, 10:38:08 am »

why do you think that could cause my problems?
(i will warm my host)
Logged
"What is the difference between genius and stupidity? Genius has limits." Albert Einstein.
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 16 queries.