coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: utah on March 21, 2006, 08:46:56 PM

Title: Fatal error, unknown column 'player' after upgrading
Post by: utah on March 21, 2006, 08:46:56 PM
Hey there,

www.77photography.nl/coppermine

Damn, I'm in trouble.. Tried to upgrade from 1.33 both this happened..

After running the upgrade, the following appeared on the screen!
Does this have something to do with CHMOD?

While executing query "SELECT extension, mime, content, player FROM cpg133_filetypes;" on 0

mySQL error: Unknown column 'player' in 'field list'

Best regards,

Jasper
Title: Re: Fatal error, unknown column 'player' after upgrading
Post by: Nibbler on March 22, 2006, 12:25:07 AM
It's because the db was not updated properly. Ensure your db user has the ALTER privilege and run update.php.
Title: Re: Fatal error, unknown column 'player' after upgrading
Post by: utah on March 26, 2006, 11:02:16 AM
OK, I've checked the ALTER function and this is OK..
After upgrading I'm still suffering with the same problem..
Title: Re: Fatal error, unknown column 'player' after upgrading
Post by: Nibbler on March 26, 2006, 02:39:44 PM
Run the query manually instead.

ALTER TABLE `cpg133_filetypes` ADD `player` VARCHAR( 5 )
Title: Re: Fatal error, unknown column 'player' after upgrading
Post by: jenma on September 17, 2006, 12:13:48 PM
Please help.  I'm running into the same problem while updating from cpg1.3.0 to 1.4.9.

When I tried to manually add "player" but I get the following error:

SQL query:

ALTER TABLE `cpg130_filetypes` ADD `player` VARCHAR( 5 )

MySQL said: 

#1062 - Duplicate entry 'mid' for key 1

When I click on browse, here's the message:

SQL query: 

SELECT *
FROM `cpg130_filetypes`
WHERE CONCAT_WS( "-", 5 ) = "mid"
ORDER BY 5
LIMIT 0 , 30

MySQL said: 

#1054 - Unknown column '5' in 'order clause'

Please help!!