Fatal error, unknown column 'player' after upgrading

[utah]

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

[Nibbler]

It's because the db was not updated properly. Ensure your db user has the ALTER privilege and run update.php.

[utah]

OK, I've checked the ALTER function and this is OK..
After upgrading I'm still suffering with the same problem..

[Nibbler]

Run the query manually instead.

Code Select Expand

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

[jenma]

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!!