fatal error after updating from 1.3.x to 1.4.2 :(

[NaRvA]

hi all

after update i got blank page with just "Fatal error:" message when trying to reach my gallery
i did all update steps from manual

after manually enabling debug mode i got this:

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

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

please help
best regards
Adam

[Nibbler]

Ensure you did the following

Uploaded the new version of sql/update.sql
Run update.php
That your db user has ALTER priveleges

[PowerMatrixMind]

I have the same problem and my data base user does have "alter" abilities.
Does anyone have any other advice to get rid of that  "fatal error" ?

[kegobeer]

Have you examined the table schema and verified there is indeed a column called 'player'?

[PowerMatrixMind]

I did not have patience in waiting for answer and just did a whole new install with no problems.

[Joachim Müller]

then you must have made something wrong when you installed in the first place. There are users who report that they keep on re-installing when they experience issues. This is an alien concept for me - coppermine is not just a windows app on your desktop, where uninstalling and re-installing can cure the system.
The recommended solution is to re-upload the files and then run ugrade.php. This is not the same as re-installing, and should cure issues from previous buggy installs.

[NaRvA]

hi all

well looks like indeed there was no column "player" in sql table ... i had to add it manually myself

it means that file update.php has some bugs or is just not fully compatible with some older versions of coppermine

greetings
Adam

[Nibbler]

That your db user has ALTER priveleges