wojtek

If anyone encounters a problem with SQL implode to table rv_zones or any others, below I left TRIGGER to fix it. DELIMITER $$ CREATE TRIGGER implode_detection_rv_zones BEFORE UPDATE ON rv_zones FOR EACH ROW BEGIN IF OLD.prepend <> NEW.prepend THEN set NEW.prepend = SUBSTRING(NEW.prepend, 1, POSITION('span><script' in NEW.prepend)+4); END IF; END $$ DELIMITER ;

I suspect it is some kind of SQL implode into the database. Have any of you encountered this problem? Ad server is running on AWS.

Hi, I have a problem with imploding some extra date to rv_zones table. I found an extra code - JS script - in to my prepend field in rv_zones. It's a second time when I have come across something like this. Have any of you had to deal with this?

Many thanks, everything now working great.

No, but I don't know where I can change it.

Hi, I have the same problem. We installed SSL certificate and all banner delivery working fine but any site on rserver/www/admin/ show "Blocked loading mixed active content" . Any body know how repair it ? We are currently using Revive Adserver v4.1.3 running on Apache, PHP 5.6.36-1~dotdeb+7.1 and MySQL 5.5.60-0+deb7u1. Mixed Content: The page at 'https://rsv.londynek.net/rserver/www/admin/dashboard.php' was loaded over HTTPS, but requested an insecure stylesheet 'http://rsv.londynek.net/rserver/www/admin/assets/min.php?g=oxp-css-ltr&v=4.1.3'. This request has been blocked; the content must be served over HTTPS. dashboard.php:1 Mixed Content: The page at 'https://rsv.londynek.net/rserver/www/admin/dashboard.php' was loaded over HTTPS, but requested an insecure script 'http://rsv.londynek.net/rserver/www/admin/assets/min.php?g=oxp-js&v=4.1.3'. This request has been blocked; the content must be served over HTTPS. regards, Wojtek