[Solved]: cant upgrade from 1.2.1 to 1.3

[erikas]

http://erikas.hakeris.lt

Warning: Undefined index: user_group_list in /home/erikas/www/include/init.inc.php on line 273
Fatal error :
There was an error while processing a database

[jack]

Have you ran the update.php file?

[erikas]

sure 

Have you ran the update.php file?

[erikas]

clear install is working fine (erikas.hakeris.lt/test), but upgrade dont

Have you ran the update.php file?

[jack]

The error you are getting indicates that your databse is still in the format for 1.2

Running update.php will fix that.

[erikas]

updade.php it did not help, I said that  :-\\


Any more advices?

The error you are getting indicates that your databse is still in the format for 1.2

Running update.php will fix that.

[Casper]

Then are you sure you updated all files, including those in the sql directory?

[erikas]

yes, all and made directory "edit" in the albums dir, and chmod and....

dont know what to do how to upgrade gallery whithout loosing the albums
now gallery is restored and running on cpg 1.2.1 again...

Then are you sure you updated all files, including those in the sql directory?

[sillygoat2]

I am having the same problem.  I too have updated all the files except for config.inc.php and my albums directory, and have put in the edit folder.  I have run the update.php file with no luck.  Anybody have any ideas?

Thanks

[hyperion]

If either of you have scrrenshot software, provide a screenshot of the update.php programs output. (The list of things it says it has done.)

[Casper]

Are you getting any error message?

What exactly happened when you ran the upgrade.php?  Did you get a page telling you things had been done? 

Can you give a link?

[sillygoat2]

Yes, i get the same error discussed earlier.  Update.php says that everythign is "already done"
http://gavin.keiners.com/update.php

Thanks for any help you might be able to provide.

[jack]

Hmm .. all the additional '\' characters in there don't look right to me. Could be one of the PHP magic_quotes settings crewing things up.
I'll look into this closer later on tonight.

[Casper]

If you have access to the database, can you go into the config table, and turn the debug on?

[erikas]

this is a copy of update.php - http://erikas.hakeris.lt/upgrade.htm

and then error message:

***********
Warning: Undefined index: user_group_list in /home/erikas/www/include/init.inc.php on line 273
Fatal error :
There was an error while processing a database
***********

Are you getting any error message?

What exactly happened when you ran the upgrade.php?  Did you get a page telling you things had been done?  

Can you give a link?

[sillygoat2]

Well, I turned on debug, here's the output:

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

mySQL error: Table 'sillygoat2.cpg11d_filetypes' doesn't exist

it can be viewed at http://gavin.keiners.com

I turned magic quotes off, that didn't seem to help

[jack]

@erikas: Can you ensure that the MySQL user in user for Coppermine has CREATE, ALTER, INSERT and DROP drivileges on the database

[sillygoat2]

After turning off magic quotes and running update about 2 or 3 more times, it finally worked.
The output did work when it finally quit inserting the extra /'s.

Thanks a bunch for your help

[Jon]

I'm having the same problem.  After I did the upgrade it said that everything had already been done, then when I click the link to continue it goes to the gallery and says critical error: There was an error while processing a database query.  Is there a fix for this, or how should I revert to 1.2.1?

Thanks.

[Casper]

Please turn on debug mode (you may have to do this in the database if you cannot browse to config.php) and post here the debug report.