migrate from php v7.3 to php v8

I’m in the process of updating websites from php 7.3.33 to php 8.0.29.

I’m getting a dreamweaver ‘unidentified error has occurred’ issue when trying to connect/test a database on website running php v8

The actual website pages are all working fine (ie connect to database and display db records correctly), it is just the internal dreamweaver connection when I click ‘test’ within the recordset builder.

When I switch the recordset builder to & from simple & advanced the database tables are all visible (in the drop down menu in simple). The unidentified error only happens when I click ‘test’ within the recordset builder.

I’ve got a dedicated plesk server and can flip between database versions..
When I test using php 7.3.33 database it connects fine
When I change the database to php 8.0.29 I get the dreamweaver error
I do have the option to install v8.1 & v8.2

I’ve got the following webassist files uploaded to the webassist->myqli folder:
rsobj version 2.35
queryobj version 2.25

I’ve been running these WA extension version for the last couple of years:
Data Bridge v2 version: 2.3.5
MySQLi Server Behaviors: version: 1.0.8

I’ve checked to see if any updates are available but I seem to be running the latest versions

I think the issue may be with the files in the _mmServerScripts folder, which are auto generated by dreamweaver (I think) when a connection is made

MMHTTPDB.php v1.2
mysql.php no version number f
WA_DBScript.php v1.0

The server log errors give the following..
AH01071: Got error 'PHP message: PHP Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in /var/www/vhosts/domainname/httpdocs/_mmServerScripts/mysql.php:229\nStack trace:\n#0 /var/www/vhosts/domainname/httpdocs/_mmServerScripts/MMHTTPDB.php(130): MySqlConnection->ExecuteSQL()\n#1 {main}\n thrown in /var/www/vhosts/domainname/httpdocs/_mmServerScripts/mysql.php on line 229'

I have uploaded the _mmServerScript folder files mentioned in the error log.

Do you have an updated version of these files that I can manually replace and upload.

This isn't a particularly urgent help request, but it would be nice to resolve so that I can migrate all my sites to php 8.

Thanks
Nathan

usually the issue is with your Dreamweaver testing server settings. Missing a required www. or https:// or having them when you shouldn't is the most common issue. I'd have to see your site definition to debug it.

Hi Ray, I've tested with and without the www or https://

see private message with server settings details

Thanks
Nathan

Hi Ray

I contacted my hosting company to ask them about the log file error message and they came back to me saying..

that the issue is related to the below PHP function which has been deprecated and fully removed in PHP 8.0.

get_magic_quotes_gpc():

Here is the official PHP documentation stating this below.

https://www.php.net/manual/en/function.get-magic-quotes-gpc.php

more details in private message

Thanks
Nathan

Reinstall the latest version of databridge and I think all references to that function have been removed.

Ok thanks Ray

I did look to see if there was a new version to download.. however the control panel suggested that I was using the latest versions.

I'm using Data Bridge version 2.3.5 installed in March 2020.

In the download centre of my account the current version says version 2.3.5, however it shows a released date on 26 Dec 2021, which to be honest I hadn't noticed or compared to my last download saved date of the extensions.

Likewise, I am using eCart v6.1.3 & MySqli Server Behaviours v1.0.8 they were downloaded and installed in March 2020, however download centre is showing a released date of 26 Dec 2021, I presume these all need reinstalling.

Are they still installed via the DMXzone extension installer ?

Thanks
Nathan

Yes or https://install.anastasiy.com/ I sometimes make small updates without updating the version. I think a reinstall will work.

Thanks Ray, I've got a couple of things on in the next couple of days.. I've also been using DW v20.2 instead of DW v21.3, so I'll do a full swap over and reinstall after the weekend.

I've had 20+ years of using WebAssist and fully appreciate your assistance whenever a tweak is needed !

Quick side extra question.. on my server I have got the option to upgrade to php 8.0.29, 8.1.20 or 8.2.7 (all my sites are currently 7.3.33). To extend the future proof timeframe I was going to go to 8.2.7, would you recommend or not recommend moving to 8.2.7, specifically relating to any known issues with WebAssist software.

Thanks
Nathan

I think you are ok with the latest version of php as long as you install the latest version of the extensions and update to the latest library files.

Hi Ray

The problem still exists when testing database table within dreamweaver. I have updated DW to v2103 (from v20.2) and also all the WA extensions.

It seem to be caused by the default DW file that is generated which including the magic quotes line

Configuration->Connections->Scripts->PHP_MySQL->_mmDBScripts->mysql.php

I have simply commented out the line (line 229) and it works, but I am unsure if this is the best way to go about this.

function ExecuteSQL($aStatement, $MaxRows)
{
// if ( get_magic_quotes_gpc() ) causes DW db test error.
{
$aStatement = stripslashes( $aStatement ) ;
}

Also generated is a MMHTTPDB.php file from DW as well as a WA_DBScript.php (unsure where this is generated from).
The WA_DBScript file include reference to magic quotes

Can you send me copies what your dreamweaver auto generates and I will manually overwrite the files on the server.

Attached in private are copies of the _mmServerScripts folder

Thanks
Nathan