DW2014 / WA MySQLi / php v7.3 database connection problems

Can you help, I’m having problems connecting to php7 databases within dreamweaver

DW & Server structure..
I’m still using DW2014.1 - I didn’t upgrade to DW CC in 2016/7 following warnings that the WA extension manager no longer worked (advise was to use DMXzone manager) and also that server behaviours on latest DW version was not available. I have also got some DMXzone extensions (bootstrap & slideshows) so using their extension manager shouldn’t be a problem, but the lack of server behaviours in latest versions of DW has prevented me from upgrading.

I’ve got a deadicated Plesk server (with only my sites on it, so it's configured to how I want it, not to how host co says), I have just upgraded from Plesk v12 to Plesk Onyx which allows me to switch between php database versions. I currently have about 15 sites all using php5.3, Onyx allows me to upgrade to php7.3. Which is what I am now trying to do.

The problem..
On a test domain I have got a database successfully loaded to server, when I set the database to php5.3 I can connect via DW server behaviours panel and the WA mysqli extension, however when I then switch the domain to php7.3 in DW I get the error which others seem to have encountered.. "Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions."

When I look on the server file manager, the folder: _mmServerScripts/ it has the following files MMHTTPDB.php mysql.php and WA_DBScript.php
I know that the server has everything setup as when I switch between php versions it works/connects when using v5.3 but not to v7.3.

So the problem would seem to be a Dreamweaver & php version7.3 issue and I probably need update files for the _mmServerScripts folder.


Extensions used..
I have been using WA extension since 2004 and have currently got WA Designer v1.2, Data Bridge 1.2.2 & eCart v6.1 installed.
I've been using the WA mysqli extension (v103) for the last 4-5 years for no problems
I've notice in my WebAssist admin area that the current version of MySQLi is 1.0.8 (Released: June 14, 2019)
Is 1.0.8 compatible with DW2014.1 or do I need to also upgrade to the latest version of DW CC

Plus I also noticed in that Data Bridge v2 says supports php7

I’ve read through the forum but can’t see the exact answer, as majority seem to say.. it now works after reinstalling various extensions

I want to upgrade all my sites to php7.3. Is there a fix using my existing extensions and version of DW or do I need to purchase/install Data Bridge v2 to get DW connectivity to php7.3. I will also need temporary connectivity to php5.3 whilst I migrate my sites upwards.

Thanks
Nathan

Our DataBridge v2 extension adds all of the server behaviors back to Dreamweaver, so you can comfortably upgrade without worry.

You would need to update to DataBridge v2 to update any sites to php7.

Most likely the issue you are having with connecting to your database is a problem with your testing server settings in Dreamweaver. Check to make sure the server URL is correct and isn't being rewritten (https and www. should be there if the site redirects to those versions)

Thanks Ray.

So if I've got this correct.. DataBridge v2 will give me back server behaviour panels - so my historical reason for not upgrading to the latest DW cc version can now be forgotten.

In order to connect to php7.3 regardless of what version of DW used (2014 or latest), I need DataBridge v2, as somewhere in the coding there is updated php7.3 compatibility. DW & DB v1 are just not capable of connecting to php7.3.

And your No 1 recommendation would be to upgrade both DW and WA-DB if I want to use the latest php version


I don't think the connection problems is with the testing server settings, because when I change the database to php5.3 it connects.

In testing the DW connections I have experimented using every combination for the testing server settings
http://www.domainname.co.uk http://domainname.co.uk https://www.domainname.co.uk https://domainname.co.uk

When using php5.3 all 4 combinations connect, but using php7.3 all four give the module not installed error message in DW.

Also as part of my overhaul of my sites I have also installed ssl certificates (Let's Encript), all done within the Plesk environment which allow me to set 301 http to https redirects. Again I have tested the 4 http/https/www options with and without the ssl/301 redirects in place.

Thanks
Nathan

Yes, if you upgrade to php7 without DataBridge v2 installed then Dreamweaver won't be able to connect to your database. You will need to create MySQLi connections to work with php7.

Thanks Ray, for your help with this, as always the help from yourselves is excellent. I've just updated my DW etc and am in process of upgrading WA software.

Our best price is 50% off. I need to charge something for upgrades in order to afford to continue to give quality support.

Thanks for you help Ray, I've upgraded to DBv2 and I can connect to php 7.3 databases.

It did take a several attempts though.

I think there was a general caching issue within DW and my computer.

On the first site I tested: From within a MySQLi recordset whenever I clicked test I got the your php server doesn't have the module installed error message. After around a dozen or so attempts what seemed to force fix the error was clicking into the Query Builder advanced section within the WA recordset builder. This seemed to have the effect of pushing the updated _mmServerScripts/MMHTTPDB.php and _mmServerScripts/mysql.php files onto the server.

On the second site I tested, everything connected first time.

I was on the verge of messaging in and asking you to do a remote access to help me fix it but then it connected.

Thanks
Nathan

You may have just had to go to: Site->Advanced->Remove Connection Scripts.

It may have taken a while for it to update the scripts automatically and it wouldn't work until the new ones were uploaded.

This post has been deleted.