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://coppermine-gallery.com/forum/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 ) ;
pls help me my site is offline because of this
how could i do the update with mysqldumper?
Don't use alpha or beta versions in a production environment. In your particular case: upgrade your mySQL version.
why do you think that could cause my problems?
(i will warm my host)