Problem updating coppermine

[schive24]

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!

[ron4mac]

Begin by trying this:
Check that dbserver in include/config.inc.php is set to just localhost
Then try running update.php again.

[schive24]

Thanks for the quick reply.  Yes, it is set to 'localhost'

[ron4mac]

You could try this upgrade method:
https://forum.coppermine-gallery.net/index.php/topic,79013.msg383037.html#msg383037

[schive24]

I tried running that script and this is what I get:

"The extension providing ZipArchive is not available"

[ron4mac]

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.

[schive24]

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?

[ron4mac]

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?

[schive24]

Yes, I would love you to take a look at it.  I PM'd you the login credentials.

[ron4mac]

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.

[schive24]

Ok... so how do I go from 1.6 back to 1.4 to start over?

[ron4mac]

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.

[ron4mac]

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