wojtek
-
Posts
6 -
Joined
-
Last visited
Posts posted by wojtek
-
-
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
Revive - implode to rv_zones
in For Developers
Posted
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 ;