close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

migrate from php v7.3 to php v8

Thread began 6/12/2023 3:18 pm by Nathan69474 | Last modified 7/05/2023 10:30 am by Ray Borduin | 339 views | 10 replies |

Nathan69474

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathan69474

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

see private message with server settings details

Thanks
Nathan

Sign in to reply to this post

Nathan69474

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathan69474

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

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathan69474

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Nathan69474

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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...