MYSQL to MYSQLI extensions in PHP connectors, etc. ???

[Mateo]

Hi All,

Anybody solved this or have a work around for using 5.7 mysql and php db connectors in NO15? Getting fatal errors as the few ADO* objects need to be updated to MYSQLI, etc...

Anybody solve this issue with or without NO support team?

Thanks, M.

[chuckj]

You need to install the MySQL ODBC connector.

I have it here: http://www.beyondfusion.com/html/links.php

[Mateo]

Thanks for replies..

To better explain, I have site with all pages generate .php suffix files to hosting company public/html directory.

I use php dB connector and interators on few pages that worked fine on NO8 ... I now get the attached when trying to display a MySQL table on php webpage? Redacted my dB connection for privacy.







Ph

[chuckj]

I know for a fact the built-in PHP functions in Fusion work fine with PHP 5.6.x. I know they don't work with PHP 7. The database connection code produced by Fusion isn't supported in PHP 7 and above. Along with the corresponding database functions.

I've offered to assist NetObjects to update the code, but haven't received a reply.

I may rewrite the relevant code in the near future and make it available on my web site. Time permitting.

Your host probably still supports older version of PHP. Rollback to one that works with Fusion generated code for the time being.

[Mateo]

Thanks Chuck. That is exactly the issue, host is running php 7 I will check into the rollback option...

I imagine in time NO would have to address if they want keep the product moving forward? something like choose pre or post php 7 ..... I am updating my own php code to the new extensions, Mysqli, etc....

Cheers!

[chuckj]

I've personally never used the built-in database capability in Fusion, having been doing PHP programming myself for a number of years.

The incompatibility with PHP 7 didn't get on my radar right away.

There's also an issue with JRE 1.8 not supporting database connections locally. You need to also have 1.7.x installed and choose it in application settings.

All of this should be relatively easy to fix in a future version of Fusion.

[Mateo]

The trick for Fusion peeps is to deal with transition for Users ... Good news, I can roll back php version for now, but at some point the scale will be tipping to lastest extensions ... I’ll keep a watch for Fusion update

Thanks all,
Cheers!