Is this your own server?  That's a server setup issue. See how to configure the hosts file for localhost.

So apparently the issue is to not use localhost but 127.0.0.1

I am not a fan of this. It seems like a workaround.

So I have had no success. I just tried a fresh install and of coppermine and I am getting the same result.

The following errors were encountered and need to be corrected first:
Could not create a MySQLi connection, please check the MySQLi details entered
Database error: No such file or directory

When I use the command line from the server I have no problem logging in as the user and see the db and the tables.

If you have your old files, rename the folder that was your theme with modifications (water_drop?) to something else and copy it into your CPG themes folder.
Follow these guide lines for your custom theme (which you should have done in the beginning instead of modifying a CPG included theme directly). You should then be able to select your custom theme and have all your modifications back.

OK, thanks. In my case it's quite a process, but I'll save the files from the previous version and update as I can later in the fall.

Thank you.

Not really. There are a lot of changes required to get PHP7 to work. So far better to update your custom theme to work with the latest release, which in most cases is not too much effort.

Thanks for that ron .. however I just lost all of the changes and tweaks I had made to my theme, which were more than substantial. Bummer. I guess I didn't realise that simply upgraded everything.

I do have a backup on my host server, but don't even know how to begin resolving this now. If I restore to my previous version, is there a simple way to fix the error without upgrading to a new cpg that will require me spending hours trying to re-configure my theme etc?

Thanks

Please see this post https://forum.coppermine-gallery.net/index.php/topic,80403.0/topicseen.html

Hello,

Looking to fix my gallery as now it says:


Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /home/tamiafan/public_html/jojo-levesque.net/gallery/include/functions.inc.php:183 Stack trace: #0 /home/tamiafan/public_html/jojo-levesque.net/gallery/include/init.inc.php(171): cpg_db_connect() #1 /home/tamiafan/public_html/jojo-levesque.net/gallery/index.php(26): require('/home/tamiafan/...') #2 {main} thrown in /home/tamiafan/public_html/jojo-levesque.net/gallery/include/functions.inc.php on line 183

http://jojo-levesque.net/gallery. How do I fix it?

Your host has changed the default PHP version to 7.x.  The quick fix is to get them to change it back to version 5.6

It appears you were running CPG 1.5.46 ... so you could easily and quickly upgrade it using this method.