Website: Photographerswithdisabilities.org
Host: IPage
Coppermine version 1.5x has been running OK with the host PHP set to 5.3. IPage have advised me, as I was having problems with website updates, to upgrade coppermine to run on their highest version of PHP which is 7.4
I have uploaded the latest Coppermine version cpg1.6x (PHP 8.?) and overwritten all the Coppermine files in the folder weebly/photo, with the exception of the albums folder and the file anycontent.php, which I renamed in the upload.
With the PHP set at 7.4 I ran the update script photographerswithdisabilities.org/photo/update.php and got the following error message
Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /hermes/bosnacweb08/bosnacweb08ax/b368/ipg.photographerswithd1/weebly/photo/include/functions.inc.php:183 Stack trace: #0 /hermes/bosnacweb08/bosnacweb08ax/b368/ipg.photographerswithd1/weebly/photo/include/init.inc.php(171): cpg_db_connect() #1 /hermes/bosnacweb08/bosnacweb08ax/b368/ipg.photographerswithd1/weebly/photo/update.php(23): include_once('/hermes/bosnacw...') #2 {main} thrown in /hermes/bosnacweb08/bosnacweb08ax/b368/ipg.photographerswithd1/weebly/photo/include/functions.inc.php on line 183
I changed the PHP to 5.3 and ran the updater again and got this message
Fatal error: Call to a member function numRows() on a non-object in /hermes/bosnacweb08/bosnacweb08ax/b368/ipg.photographerswithd1/weebly/photo/bridge/udb_base.inc.php on line 360
I contacted IPage support and had the foloowing reply
Hello Paul,
Thank you for getting back to us. I’m Alwyn looking into the website issue. I understand it is important the website display all the pages correctly.
From the case notes, I understand the gallery page images are not displaying with higher PHP versions at: https://photographerswithdisabilities.org/photo/
I have accessed the gallery page and was able to replicate the ‘Fatal Error’ message with higher PHP versions.
The issue is caused by the MySQL connection function used in the PHP versions. The older PHP versions were using the connection function as ‘mysql_connect()’. This function is upgraded in the higher PHP versions PHP 7.0 and above.
The updated connection function is ‘mysqli_connect()’. Therefore any applications/websites using the PHP version 7.0 and above should have updated connection functions.
Currently, the ‘Coppermine’ application is still using the old connection function. This is the reason it works only on lower PHP versions. I understand you tried to update the application. However, it appears the ‘Coppermine’ application is still using the old connection function for the database.
I’m afraid this is the reason the gallery page displays the error message with higher PHP versions 7.0 and above.
To fix this issue, the database connection function has to be updated from ‘mysql_connect()’ to ‘mysqli_connect()’ in the ‘Coppermine’ application.
It is advisable to contact the support team of the ‘Coppermine’ application for help in getting this upgraded. Alternatively, if they ask to update any other settings from our server end to make this work, please reply back to this email with relevant information. We are happy to help you.
Alternatively, you can try creating a new page on Weebly and use the gallery/image options available in the Weebly editor and upload the images. Once that is done, please verify if that is working as expected. Later you may remove/delete the old gallery page.
Please feel free to reach out in case of additional questions. We are happy to help.
Regards,
Alwyn D
Escalated SupportHelp please
Best regards
Paul