Losing DB connection when upgrading to php 7

[BryanHix]

This issue was raised, and solved in a closed April 2016 thread: http://fabrikar.com/forums/index.php?threads/issue-with-php-7-x.43892/#post-224768.

After checking everything (I think) mentioned in the above post, Fabrik still doesn't connect to the DB.

• Joomla 3.5.1 Global Configuration set to MySQLi
• Reinstalled Fabrik version 3.5
• php7 + Joomla works for all pages except Fabrik pages

Thanks in advance for any guidance to solve this.

Bryan

 

[troester]

What is the exact error message? (the thread you mention is about MySQL/MySQLi support, not connecting to the DB)

I assume you have to edit your Fabrik connection and set the correct DB params (password).

 

[BryanHix]

troester, thanks for the help.

Error Message:
Unable to connect to the Database: This driver is unsupported in PHP 7, please use the MySQLi or PDO MySQL driver instead.

After changing back to php ver 5.6.25, all five connections showing successful. When implementing php ver 7.0.10, the above message shows and I have no access to the Fabrik component in Joomla, and no access to Fabrik pages on the website. (Ex.: lifemartialartscenter.com/library/shop-local).

Again, thank you for your help.

Bryan

 

[BryanHix]

Well, the site with PHP 7 is now working. However, the component "Home" page doesn't. Not a big deal.

A previous post suggested turning on Joomla's global settings Debug system, then turning it off. Seems to have worked (minus the Fabrik component home page.) Here's the link:
http://fabrikar.com/forums/index.ph...his-driver-is-unsupported-in-php-7-try.43721/

By the way, the component Home page gives the message "an error has occured. 0 Class 'SimplePie' not found." I just choose one of the links from the Fabrik dropdown list, and they display correctly.

Bryan

 

[cheesegrits]

Hmmm, SimplePie should be there. I've added an explicit jimport() for it ...

https://github.com/Fabrik/fabrik/commit/d00516d842e3d89f78f59980337b0472cd1df8e8

For the MySQL thing, what driver do you have selected in Joomla's global settings?

We don't control the driver setting, that comes from J!. And the MySQL driver isn't supported in PHP 7, so you have to make sure you have either MySQLi or PDO selected.

I'm running PHP 7 locally, with no problems.

-- hugh

 

[BryanHix]

Hugh, MySQLi is chosen in database settings.

My "home.php" file, SimplePie reference starting line 84:

{
$rssDoc = new SimplePie();
$rssDoc->set_feed_url('http://feeds.feedburner.com/fabrik');
$rssDoc->set_cache_duration(86400);
$rssDoc->init();
}

Search function in file shows no other coding for SimplePie. This looks different than the coding in the file from your link.

Bryan

 

[cheesegrits]

I just committed that, to see if that will fix the "Class 'SimplePie' not found" error you are getting.

Next time you do a github update, or next time we build a new release, it'll pick that fix up.

-- hugh

 

[BryanHix]

Would you suggest I go ahead and update that one file, or maybe the whole component from github?

 

[cheesegrits]

We don't usually recommend cherry picking files, but if you are running a recent github / release, that file should be OK.

-- hugh

 

[BryanHix]

While not a programmer, I know better than my question. It's fine as-is, will wait until the next update.

Hugh, thank you very much for your help.

Bryan