forum.coppermine-gallery.net

Support => cpg1.6.x Support => cpg1.6 upgrading => Topic started by: schive24 on May 13, 2019, 03:02:36 pm

Title: Problem updating coppermine
Post by: schive24 on May 13, 2019, 03:02:36 pm: Hello all. Hoping someone can point me in the right direction. My old version of coppermine stopped working, so I installed the latest (1.6) version by uploading all of the new files via FTP, but when I go to the update.php file in the web browser, I get the following fatal error:

Fatal error: Uncaught Error: Call to a member function numRows() on boolean in /home2/bigbenne/public_html/photos/bridge/udb_base.inc.php:356 Stack trace: #0 /home2/bigbenne/public_html/photos/bridge/udb_base.inc.php(99): core_udb->get_user_data(3, Array, 3) #1 /home2/bigbenne/public_html/photos/include/init.inc.php(255): core_udb->authenticate() #2 /home2/bigbenne/public_html/photos/update.php(26): include_once('/home2/bigbenne...') #3 {main} thrown in /home2/bigbenne/public_html/photos/bridge/udb_base.inc.php on line 356

Attached are my PHP settings in cPanel. any help would be much appreciated!
Title: Re: Problem updating coppermine
Post by: ron4mac on May 13, 2019, 03:31:51 pm: Begin by trying this:
Check that dbserver in include/config.inc.php is set to just localhost
Then try running update.php again.
Title: Re: Problem updating coppermine
Post by: schive24 on May 13, 2019, 03:57:58 pm: Thanks for the quick reply. Yes, it is set to 'localhost'
Title: Re: Problem updating coppermine
Post by: ron4mac on May 13, 2019, 04:25:39 pm: You could try this upgrade method:
https://forum.coppermine-gallery.net/index.php/topic,79013.msg383037.html#msg383037
Title: Re: Problem updating coppermine
Post by: schive24 on May 13, 2019, 10:40:14 pm: I tried running that script and this is what I get:

"The extension providing ZipArchive is not available"
Title: Re: Problem updating coppermine
Post by: ron4mac on May 14, 2019, 03:48:54 am: Referencing your CPanel PHP settings above ...

If you could select PHP 7.1, that would be better than 7.0
Enable zip ( and enabling imagick would be beneficial, too )

Try the cpg_installer_stub again.
Title: Re: Problem updating coppermine
Post by: schive24 on May 14, 2019, 01:38:31 pm: Ok, I was able to run the script and I now have a functioning version of coppermine installed, but now all of my albums are missing... The images are still on the server, but I guess the database information got erased?

Fortunately, I did a database dump before the update, so I have the only mysql file. Any suggestions on how to restore the albums?
Title: Re: Problem updating coppermine
Post by: ron4mac on May 14, 2019, 03:40:45 pm: There is no reason for you to have lost anything. Did you choose to upgrade the current gallery and was it a 1.5.20+ gallery?
If your database information in include/config.inc.php was okay, it should have upgraded with no issue.
Do you need hands-on help sorting this out?
Link to site?
Title: Re: Problem updating coppermine
Post by: schive24 on May 15, 2019, 03:04:03 am: Yes, I would love you to take a look at it. I PM'd you the login credentials.
Title: Re: Problem updating coppermine
Post by: ron4mac on May 15, 2019, 05:44:55 am: It would appear that you were running a CPG 1.4.x gallery. You can not upgrade directly from 1.4 to 1.6 ... you will need to upgrade to CPG 1.5 first.
https://documentation.coppermine-gallery.net/en/upgrading.htm#upgrade_any

You will need to set your PHP version back to 5.6 to be able to do that. Once you have upgraded to 1.5.x, you can upgrade to 1.6.x using the cpg_installer_stub that you already tried. Then you can set your php version to 7.1.
Title: Re: Problem updating coppermine
Post by: schive24 on May 15, 2019, 02:13:32 pm: Ok... so how do I go from 1.6 back to 1.4 to start over?
Title: Re: Problem updating coppermine
Post by: ron4mac on May 15, 2019, 04:04:19 pm: Quote from: schive24 on May 15, 2019, 02:13:32 pm
Ok... so how do I go from 1.6 back to 1.4 to start over?

I will help you. Will try to do it within a day or two.
Title: Re: Problem updating coppermine
Post by: ron4mac on May 15, 2019, 09:02:14 pm: Quote from: ron4mac on May 15, 2019, 04:04:19 pm
I will help you. Will try to do it within a day or two.

I had some time sooner than I expected. Your site is running CPG 1.6.06 with PHP 7.1