coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upgrading => Topic started by: NaRvA on November 28, 2005, 11:14:13 AM

Title: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: NaRvA on November 28, 2005, 11:14:13 AM
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
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: Nibbler on November 28, 2005, 06:10:00 PM
Ensure you did the following

Uploaded the new version of sql/update.sql
Run update.php
That your db user has ALTER priveleges
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: PowerMatrixMind on November 29, 2005, 02:09:37 AM
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" ?
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: kegobeer on November 29, 2005, 03:49:34 AM
Have you examined the table schema and verified there is indeed a column called 'player'?
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: PowerMatrixMind on November 29, 2005, 07:14:09 AM
I did not have patience in waiting for answer and just did a whole new install with no problems. :)
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: Joachim Müller on November 29, 2005, 09:45:11 AM
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.
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: NaRvA on December 06, 2005, 09:03:49 AM
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
Title: Re: fatal error after updating from 1.3.x to 1.4.2 :(
Post by: Nibbler on December 06, 2005, 11:21:26 AM
Quote from: Nibbler on November 28, 2005, 06:10:00 PM
That your db user has ALTER priveleges