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.
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.
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.