PHP has not loaded the MySQL Extension

[Ryan G]

We just updated to PHP 7.3 and now I am getting the follow error upon attempting to load our ad server: https://ads.autoconversion.net/

 

A fatal error occurred Revive Adserver can't connect to the database. Because of this it isn't possible to use the administrator interface. The delivery of banners might also be affected. Possible reasons for the problem are: <ul> <li>The database server isn't functioning at the moment</li> <li>The location of the database server has changed</li> <li>The username or password used to contact the database server are not correct</li> <li>PHP has not loaded the MySQL Extension</li> </ul>

I have verified the db location has not changed and that the un / pw are correct, which leads me to the fourth possibility in the list: PHP has not loaded the MySql extension. 

The support rep I chatted with at Hostgator says that their admins did a check and this should not be the cause of the issue. 

Not sure where to look from here so hoping somebody here might now. Any insight would be appreciated.

 

[Ryan G]

Found this article: https://stackoverflow.com/questions/8225198/phpmyadmin-the-mysql-extension-is-missing

'extension=mysql.so' was not in my php.ini file so I added it. 

No beans.

[andrewatfornax]

Hi @Ryan G,

What version of PHP did you upgrade from?

Was it a version before PHP 7?

I think that PHP 7+ needs to use the mysqli extension, so you'd have to ensure that's in place in PHP, and then update your Revive Adserver configuration to use mysqli, rather than mysqli.

[Ryan G]

@andrewatfornax we had updated from PHP v5.4.

I was able to resolve the issue by upgrading to the latest version of Revive, which led to this plugin issue which I was able to resolve.

Now that we are on the lest version of Revive, everything is up and running, except I am not able to obtain the Invocation Code. See this thread: