scott001

I am running Revive 5.2.1 with v5.5.5-10.3.30-MariaDB and don't see any issues. What issues are you having? You didn't really describe your issue. Also, I have strict mode off.

It looks like you can change strict mode according to this site:
https://www.phoca.cz/documents/50-phoca/625-strict-standards-non-static-method
Are you running the IPB update via your Admin ACP? If so, there should be error messages if there is an issue.

Thank you for sharing!! Just to clarify, on line 3436 I added this:
$imageTag = "$clickTag<img src='".htmlspecialchars($imageUrl, ENT_QUOTES)."' width='$width' height='$height' alt='$alt' title='$alt' loading='lazy' border='0'$imgStatus />$clickTagEnd";
Revive coders...are you listening? This is an extremely simple solution to speeding up serving banners with your software, can you please add this to the source code?
 

Hi,
For those interested in performance, after modifying asyncspc.php and adding native loading=lazy (supported in Chrome/FF) to the $imageTag I gained 3-4 points in Google Pagespeed Insights.
When scrolling down the Revive banners are loaded well before they appear in the viewport.
Hope this helps
Tim

https://www.reviveconsultant.com/articles/what-to-do-when-you-suspect-your-openx-source-system-has-been-hacked/ may be of assistance here.

Ok, it might take me a week or so, but I'll get it together...

Ultimately I fixed this, and it was caused, apparently, by an advertiser that I created years ago. Re-creating the advertiser and ads solved the issue.

Hi @scott001,
I had a call with our database guru on the team today, and he tells me that Revive Adserver sets non-strict mode as soon as it connects to MariaDB, so, Revive Adserver should be compatible with MariaDB 10.2 with its strict mode enabled.

Here is what I found. My cronjob, which worked fine for years like this:
0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php >/dev/null 2>&1
suddenly, at least to me anyway, needed to be like this:
0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php localhost >/dev/null 2>&1
The mysql restarts may have been just a coincidence, and my server auto-updated and installed a new version of cpanel or something else, but something changes and now I must include "localhost" in the cronjob.
I hope this helps someone else!

That did the trick, thank you. So I could not find a way to edit the DB settings withing the admin area, but did change it directly in the config file from "mysql" to "mysqli".
l can now get into admin, and it looks like the stats are updating. Thank you!

I am running a cpanel apache mysql configuration. Under the latest cpanel you can run PHP per site, so you could set this in your control panel and run PHP 7 on your site. In my case, I wanted it to run within a directory, so I added this to the root .htaccess file for my Revivie Adserver site:
<IfModule mime_module>
AddType application/x-httpd-ea-php70 .php .php7 .phtml
</IfModule> 
 
I then edited the main configuration file from:
[database]
type=mysql
 
To:
[database]
type=mysqli

Currently my server is running PHP 5.6.30 as the default, but PHP 7 is also installed. I am trying to force Rvive Adserver to run under PHP 7, and I've tried adding this code to a new .htaccess file in the root ad server's directory, in my case it is /adserv :
<IfModule mime_module>
AddType application/x-httpd-ea-php70 .php .php7 .phtml
</IfModule>
This configuration works fine for a forum which I have in a different directory on the same domain, but is not working for Revive Adserver--the ads stop running. Am I putting this file in the correct location, the root for Ad Server, or should it go somewhere else, for example /var ?
It is possible that I don't have some required extension installed for PHP 7 that is needed for Revive, is there a list somewhere of those?
Any help would be appreciated.

Ok, so there is no support here...