News:

CPG Release 1.6.31
Minor maintenance release
Clean up remaining remnants of the .net CPG website
Improved installer_stub compatibility with various server configurations

Main Menu

Recent posts

#1
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by 406man - Today at 09:09:03 AM
It's useful to be able to see the web site. The lower part of the gallery home page has a large table containing the album categories :  https://www.funivie.org/funigallery/

For example, "Revolving cableway system"s and "automatic hooking ropeway systems".  Creating this table with the album and picture totals requires a very large number of database accesses and will be contributing to the high server load. I suggest temporarily disabling the display of this table to see how much the load decreases. If it makes a worthwhile difference you have confirmed that there will be an improvement when implementing a lower impact alternative. Or maybe it will make little difference.
#2
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by ron4mac - Today at 03:51:52 AM
Does aruba.it allow you to have more than one database user? If it does, you might try having one user for Wordpress access and a different one for CPG access. Since aruba.it has a strict cap of 9 concurrent connections by the same user, it wouldn't take too much for bots hitting both the Wordpress and CPG pages to occasionally run into that limit. Regardless of the caching plugin, every CPG access requires at least one database access. You might look into whether there is a Wordpress cache that is more total, requiring no database access. Failing all else, you might have to consider a more robust hosting plan.
#3
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by mdafun - Yesterday at 09:18:13 AM
https://www.funivie.org/cantieri/
https://www.funivie.org/funigallery/
the cache is enabled, folder is writable and I can see the html files, so it works.

But every so often – not every day – the script is inundated with requests that overload the database. This happens every 3–4 days.
Files are all updated
#4
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by phill104 - November 13, 2026, 05:30:40 PM
I would also suggest comparing your file system with a vanilla copy of coppermind just in case you cave been compromised somehow.
#5
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by 406man - November 12, 2026, 07:59:46 PM
I appreciate the site has gone off line but if there's a way of showing us its home page we may be able to suggest some changes, in a similar way to the dialogue for this site a few years back:

https://coppermine-gallery.com/forum/index.php/topic,80732.msg390374.html
#6
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by ron4mac - November 09, 2026, 04:12:44 PM
Make sure with the theme_cache plugin that you have activated it for your theme by creating a writeable 'cache' folder in your theme directory.
Can you provide any links?
#7
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by mdafun - November 08, 2026, 01:31:02 PM
I've also tried making countless changes to the code using ChatGPT (searches restricted to registered users, other changes to the .htaccess file) but without resolving anything.
#8
cpg1.6 miscellaneous / Re: Coppermine db overloading ...
Last post by mdafun - November 08, 2026, 01:29:43 PM
I can confirm this major issue; it's probably due to AI bots, that in the last year are incredible increasing.

Although I've installed the Theme Cache (theme_cache) plugin: v1.1 and restricted the display of full-size photos to registered users only, I'm still getting the following errors:
Fri, 06 Nov 26 22:23:45 +0100 – Unable to connect to database: 1226: User 'XYZ' has exceeded the 'max_user_connections' resource (current value: 9)

This is becoming a huge problem because it brings the whole site to a standstill. I've actually had to buy a second database just for the three Coppermine galleries I have on the site, but I remain convinced that there's some sort of vulnerability through which attackers or bots are managing to run queries even without being logged in.
Otherwise, there's no explanation for the problem – the album views are all cached?!?
#9
cpg1.6 miscellaneous / Re: BBcode limitations in gall...
Last post by phill104 - November 06, 2026, 08:52:21 PM
I'll update the plugin page when I get home from holiday
#10
cpg1.6 miscellaneous / Re: BBcode limitations in gall...
Last post by ron4mac - November 04, 2026, 03:31:03 PM
Quote from: phill104 on November 04, 2026, 01:00:55 AMI have added [centre] to the plugin, see attached below.
Nice, Phill!