Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. I've successfully upgraded to v5.02 without any problem. So this issue no longer applies to me. Cheers to everyone who chimed in with help. Thank you.
  3. Is it possible to do something with this query ? Waiting for table level lock | INSERT INTO rv_data_bkt_r (interval_start, creative_id, zone_id, count) VALUES ('2019-11-22 14:50:00', '0', '45', '1') ON DUPLICATE KEY UPDATE count = count + 1 BTW is it ok to drop old data from this table ? because I have almost 600k row there, for 1 year already. mysql> select count(*) from rv_data_bkt_r; +----------+ | count(*) | +----------+ | 549006 | +----------+ 1 row in set (0.32 sec) mysql> select count(*) from rv_data_bkt_m; +----------+ | count(*) | +----------+ | 145879 | +----------+ 1 row in set (0.00 sec)
  4. Hey there, I'm facing an issue with creating a new campaign for existing advertiser. https://prnt.sc/q0m8my (screenshot). Maybe you know what could be wrong? When I click on "add new campaign" tab a self-refresh happens. Looking forward for your advices.
  5. I had tried using the filepath /home/myacct/public_html/revive in earlier attempts with the same results. Tried it again but the sme problem finding the plugin XML files. Any other suggestions would be appreciated.
  6. Yesterday
  7. We have updated from RV 4.2.1 now to 5.0.2 (upgrading to 5.0 was not working due to the bugs already described). The upgrade to 5.0.2 worked fine now (no Errors) however, the data base ist still stamped to v4.2.1 "Sie nutzen derzeit Revive Adserver v5.0.2 (warning: database is stamped as v4.2.1) laufend auf nginx 1.10.3, PHP 7.0.33-0ubuntu0.16.04.7 und MySQL 5.7.28-0ubuntu0.16.04.2". In the mainatainance wizard the interface asks to upgrade to Version 5.0.2 because we do not have the latest Version ... In the install log of previous Version we receive this: openads_upgrade_5.0.0-beta-rc1.xml 4.2.1 5.0.0-beta-rc1 2019-11-21 17:12:53 Restbestandteil: 1 Logfiles: openads_upgrade_5.0.0-beta-rc1_2019_11_21_05_12_53.log upgrade_openX3rdPartyServers 1.3.1 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:06 Restbestandteil: 1 Logfiles: plugins.log ox3rdPartyServers_version_stamp_1.5.0 1.3.1 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:06 Restbestandteil: 1 Logfiles: ox3rdPartyServers_upgrade.log upgrade_openXVideoAds 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: plugins.log vastInlineBannerTypeHtml_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: vastInlineBannerTypeHtml_upgrade.log vastOverlayBannerTypeHtml_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: vastOverlayBannerTypeHtml_upgrade.log oxLogVast_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: oxLogVast_upgrade.log vastServeVideoPlayer_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: vastServeVideoPlayer_upgrade.log videoReport_version_stamp_1.12.0 1.11.9 1.12.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:09 Restbestandteil: 1 Logfiles: videoReport_upgrade.log upgrade_openXReports 1.5.5 1.6.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:13 Restbestandteil: 1 Logfiles: plugins.log oxReportsStandard_version_stamp_1.6.0 1.5.5 1.6.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:12 Restbestandteil: 1 Logfiles: oxReportsStandard_upgrade.log oxReportsAdmin_version_stamp_1.6.0 1.5.4 1.6.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:12 Restbestandteil: 1 Logfiles: oxReportsAdmin_upgrade.log uninstall_openXMaxMindGeoIP 1.3.10 --- 2019-11-21 16:13:15 Restbestandteil: 1 Logfiles: plugins.log uninstall_oxMaxMindGeoIP 1.3.10 --- 2019-11-21 16:13:15 Restbestandteil: 1 Logfiles: plugins.log upgrade_openXInvocationTags 1.4.7 1.5.1 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:18 Restbestandteil: 1 Logfiles: plugins.log oxInvocationTags_version_stamp_1.5.1 1.4.7 1.5.1 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:18 Restbestandteil: 1 Logfiles: oxInvocationTags_upgrade.log upgrade_openXDeliveryLog 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: plugins.log oxDeliveryDataPrepare_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: oxDeliveryDataPrepare_upgrade.log oxLogClick_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: oxLogClick_upgrade.log oxLogConversion_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: oxLogConversion_upgrade.log oxLogImpression_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: oxLogImpression_upgrade.log oxLogRequest_version_stamp_1.5.0 1.1.2 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:22 Restbestandteil: 1 Logfiles: oxLogRequest_upgrade.log upgrade_openXDeliveryLimitations 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:26 Restbestandteil: 1 Logfiles: plugins.log Client_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:26 Restbestandteil: 1 Logfiles: Client_upgrade.log Geo_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:26 Restbestandteil: 1 Logfiles: Geo_upgrade.log Site_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:26 Restbestandteil: 1 Logfiles: Site_upgrade.log Time_version_stamp_5.0.3 2.2.1 5.0.3 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:26 Restbestandteil: 1 Logfiles: Time_upgrade.log upgrade_openXDeliveryCacheStore 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:29 Restbestandteil: 1 Logfiles: plugins.log oxCacheFile_version_stamp_1.5.0 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:29 Restbestandteil: 1 Logfiles: oxCacheFile_upgrade.log oxMemcached_version_stamp_1.5.0 1.2.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:29 Restbestandteil: 1 Logfiles: oxMemcached_upgrade.log upgrade_openXBannerTypes 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:32 Restbestandteil: 1 Logfiles: plugins.log oxHtml_version_stamp_1.5.0 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:32 Restbestandteil: 1 Logfiles: oxHtml_upgrade.log oxText_version_stamp_1.5.0 1.3.0 1.5.0 UPGRADE ABGESCHLOSSEN 2019-11-21 16:13:32 Restbestandteil: 1 Logfiles: oxText_upgrade.log install_reviveMaxMindGeoIP2 --- 1.0.4 2019-11-21 16:13:41 Restbestandteil: 1 Logfiles: plugins.log install_rvMaxMindGeoIP2 --- 1.0.4 2019-11-21 16:13:41 Restbestandteil: 1 Logfiles: plugins.log install_rvMaxMindGeoIP2Maintenance --- 1.0.4 2019-11-21 16:13:41 Restbestandteil: 1 Logfiles: plugins.log Despite my initial thought that the update worked fine and just the DB Version was not stamped correctly, I have no realized that no Banners work anymore: all banners got the "last update" timestamp "01.01.2000 00:00:01"; clicking on the banner details page in the admin interface opens a white page. seems, interface is not able to load banner details. we have rolled back now to 4.2.1 version again.
  8. I am confused about the new geopip feature from RV 5.0 and above and the required maxmind database. Example: We are primarily targeting European countries (Country Level e.g. Spain, Germany) occassionally targeting zip-Codes in Europe (Germany only) and very rarely countries outside Europe (USA only) Based on the example I am wondering … Do we need to buy the country AND city database or would it be enough to buy the city database only, assuming city level covers country level as well? Does the city database also cover European zip-Codes? At the Revive blog https://www.revive-adserver.com/blog/new-geotargeting-plugin-in-revive-adserver-v5-an-overview/ it quotes that zip targeting is available in the US/Canada area only, however, on MaxMind it says that the GeoIP2 City database covers postal codes worldwide: https://www.maxmind.com/en/geoip2-city - is there a mistake in the Revive blog, on MaxMind's Website or both are correct and Revive Adserver just does not support European zip-Code targeting? MaxMind offers a cheaper City database by (selected) continent only. Assuming we are only targeting European zip Codes and European countries, is that continent-limited City database also supported by Revive Adserver? Details: https://www.maxmind.com/en/geoip2-city-database-by-continent How does automatic database update work? Is there any documentation available? Do we need to enter username/password of our MaxMind account / subscription to Revive adserver (said this we obviously need to have a subscription at MaxMind) and the rest is done by the daily maintenance script? Manuel
  9. Last week
  10. The Revive Adserver team announces the immediate availability of Revive Adserver v5.0.2. We are pleased to announce the release of version 5.0.2 of the Revive Adserver software. This new version fixes a number of bugs and issues that were reported after the recent releases of version 5.0.0 and 5.0.1. Here is a list of the issues that have been fixed in Revive Adserver v5.0.2: A warning message was always showing in the delivery rules screen, incorrectly indicating there was a mismatch with the cached delivery rules. Delivery rule targeting countries were not working. Midnight maintenance triggered an error when the GeoIP2 plugin tried to download the file updates. Full release notes for v5.0.2 can be found on our Github page. We encourage our users to upgrade to the new version 5.0.2 as soon as possible, so that they can benefit the most from the new functionality of Revive v5. Download, install and upgrade Revive Adserver v5.0.2 is available for download now. Once downloaded, please refer to the instructions for Installations of Revive Adserver or for Upgrading Revive Adserver. Make sure that the server(s) being used meet(s) the minimum technical requirements. Community contributions The continued development of Revive Adserver is being sponsored by community members, either financially or in the form of code contributions. We’re very grateful for the support we’ve received. If you would like to contribute to our project, please consider becoming a patron on Patreon.com. Another way to contribute to our project, is by using the Revive Adserver Hosted edition. The post Revive Adserver v5.0.2 released appeared first on Revive Adserver. View the full article
  11. Hello, I try to install new version of Revive Adserver 5.0.1 but in the last step I got some errors about problem of installation some of plugins. This is my application stack: OS: CentOS 7.7 DB: PostgreSQL 10 PHP 7.3.11 All database table are created into database, and in the end of the process I have information that "Your Revive Adserver installation is complete." but there are some exceptions as in image below: https://imgur.com/zqjMk9z Hello, I try to install new version of Revive Adserver 5.0.1 but in the last step I got some errors about problem of installation some of plugins. This is my application stack: OS: CentOS 7.7 DB: PostgreSQL 10 PHP 7.3.11 All database table are created into database, and in the end of the process I have information that "Your Revive Adserver installation is complete." but there are some exceptions as in image below: https://imgur.com/zqjMk9z text: Installation of plugin "reviveMaxMindGeoIP2" failed: Server returned: 0 Installation of plugin "openXVideoAds" failed: Server returned: 0 Installation of plugin "openXDeliveryLog" failed: Server returned: 0 Installation of plugin "openXInvocationTags" failed: Server returned: 0 Installation of plugin "openXDeliveryCacheStore" failed: Server returned: 0 Installation of plugin "openXReports" failed: Server returned: 0 Installation of plugin "openX3rdPartyServers" failed: Server returned: 0 Installation of plugin "openXDeliveryLimitations" failed: Server returned: 0 Installation of plugin "openXBannerTypes" failed: Server returned: 0 When I click "Continue" I'm redirect to main application page, but without styling (there is white page with some raw links) not everything works as excpected. SELinux is off on the server, application works on apache WWW server (as a apache user). The apache user have write/read permissions to the application directory. Please help me, what is wrong with it. How to solve this problem?
  12. Hi Can you tell me what negative impact anonymising the visitor's IP has? I've read that it's used for geo location and for recording conversions and preventing duplicates. Presumably an anonymised IP doesn't affect geo location, but does it affect the ability to identify duplicate conversions? Does it have any other negative effect? TIA Jamie
  13. I am new to revive adserver I want to create my own Plugin. Please help me Out
  14. Hi I have loaded a zone with Google Adsense and then set another zone with other ads to be chained to the Adsense zone in case Adsense does not show any ads. However when Adsense does not show any ads it just leaves a white space, it does not fill it with an ad from the chained zone. Please can you help to solve this. Thanks
  15. Earlier
  16. Hello, do you plan MySQL 8.x support in near future? If so, when it could be released? We'd be very grateful if you do. 🙂 Thank you in advance for your response, you're doing a great job. Best regards, Dom
  17. I contacted the plugin owners.. it seems a problem related to the plugin itself: we are aware that this plugin stopped working with Revive Adserver v5.0.x. Since this is one of our free plugins, we have not given it as much priority as the plugins for our paying customers. However, we do expect to get around to fixing this in the near future, and at that time it will be announced on our blog.
  18. Ezh

    Carousel banners

    Maybe it is doable now as well?
  19. Hello, i've upgraded to version 5.0.1 (with not few problems), now this plugin ( adserverplugins.com/magic-geo-macros) that i uses to show some flags geographically, no longer work, the images are broken (404). Also, under my banners inside the admin panel, i find this message: The cached delivery rules DO NOT AGREE with the delivery rules shown below Please hit save changes to update the cached delivery rules .. i know this is a bug that will be fixed, so my big concern now is the magic-geo-macros plugin which cause a big issue on my homepage. I spent almost a day with this errors, please someone can help me with this? I found this in my logs: Nov 14 01:41:05 +0000 OX-5dccb0b13333f [ info] Sync: No update on line 247 of /lib/RV/Sync.php on line 45 of /www/admin/maintenance-updates-js.php Nov 14 01:47:32 +0000 OX-5dccb2347e503 [ warning] AP_MagicGeo->convert: include(/plugins//deliveryLimitations/Geo/data/res-iso3166.inc.php): failed to open stream: No such file or directory on line 113 of /lib/max/ErrorHandler.php on line 105 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 105 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 64 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 15 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 702 of /lib/max/Delivery/common.php on line 190 of /lib/max/Delivery/adRender.php on line 34 of /www/admin/banner-htmlpreview.php Nov 14 01:47:32 +0000 OX-5dccb2347e503 [ warning] AP_MagicGeo->convert: include(): Failed opening '/plugins//deliveryLimitations/Geo/data/res-iso3166.inc.php' for inclusion (include_path='/lib/pear:/lib:.:/opt/cpanel/ea-php73/root/usr/share/pear') on line 113 of /lib/max/ErrorHandler.php on line 105 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 105 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 64 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 15 of /plugins/deliveryAdRender/apMagicGeo/apMagicGeo.delivery.php on line 702 of /lib/max/Delivery/common.php on line 190 of /lib/max/Delivery/adRender.php on line 34 of /www/admin/banner-htmlpreview.php Nov 14 01:48:15 +0000 OX-5dccb25f64e36 [ warning] Smarty->display: count(): Parameter must be an array or an object that implements Countable on line 113 of /lib/max/ErrorHandler.php on line 96 of /var/templates_compiled/%%26^260^26060475%%plugin-group-view.html.php on line 1260 of /lib/smarty/Smarty.class.php on line 1106 of /lib/smarty/Smarty.class.php on line 196 of /lib/OA/Admin/Template.php on line 315 of /www/admin/plugin-index.php&quot
  20. Hm. I can see statistic now, but I don't understand what was the problem. But I have a statistic gap , is it possible to recalculate statistic ? I can see data in rv_data_bkt_m table
  21. This is a bug. Fix has been made and will be released shortly. https://github.com/revive-adserver/revive-adserver/issues/1123
  22. Same problem here after a clean install, also the warning: WARNING: The cached delivery rules DO NOT AGREE with the delivery rules shown belowPlease hit save changes to update the cached delivery rules.
  23. Same problem here, also the option to select Countries are vanished, please let me know if someone understand the issue
  24. I have moved DB server server from one ip to another, and changed the conf.php to the new ip, but after that I don't have updated statistic, although Scheduled maintenance is running correctly. and mysql> SELECT * FROM rv_data_bkt_m order by interval_start desc limit 20; +---------------------+-------------+---------+-------+ | interval_start | creative_id | zone_id | count | +---------------------+-------------+---------+-------+ | 2019-11-12 20:35:00 | 820 | 9 | 6 | | 2019-11-12 20:35:00 | 735 | 36 | 15252 | | 2019-11-12 20:35:00 | 734 | 36 | 14984 | | 2019-11-12 20:35:00 | 733 | 47 | 254 | | 2019-11-12 20:35:00 | 723 | 43 | 16 | | 2019-11-12 20:35:00 | 722 | 48 | 61 | | 2019-11-12 20:35:00 | 718 | 47 | 203 | | 2019-11-12 20:35:00 | 717 | 47 | 271 | | 2019-11-12 20:35:00 | 716 | 47 | 214 | | 2019-11-12 20:35:00 | 712 | 43 | 62 | | 2019-11-12 20:35:00 | 711 | 43 | 45 | | 2019-11-12 20:35:00 | 710 | 43 | 41 | | 2019-11-12 20:35:00 | 709 | 43 | 55 | | 2019-11-12 20:35:00 | 707 | 47 | 269 | | 2019-11-12 20:35:00 | 705 | 10 | 2055 | | 2019-11-12 20:35:00 | 705 | 9 | 1965 | | 2019-11-12 20:35:00 | 704 | 10 | 1976 | | 2019-11-12 20:35:00 | 704 | 9 | 2100 | | 2019-11-12 20:35:00 | 703 | 10 | 2028 | | 2019-11-12 20:35:00 | 703 | 9 | 2052 | +---------------------+-------------+---------+-------+ 20 rows in set (0.00 sec) What else can I check ? I have already checked https://documentation.revive-adserver.com/display/DOCS/No+Statistics
  25. Hi, It could be a good idea to Differentiate active banners from inactive banners. Example by color icon or coler text. Thanks.
  26. Hi, I have the database from a previous installation on my server. How do install revive on that server and use that database without the script asking me to enter database details and install again? Regards, Geoff
  27. Thanks Scott001 for your suggestion. I added this to my revive folder so i can just execute it to set the necessary permissions. ```permissions.sh (0777) #!/bin/bash # https://forum.revive-adserver.com/topic/4922-what-files-what-permissions/?do=findComment&comment=12596 chmod -R a+w var chmod -R 444 var/*.conf.php chmod -R a+w var/plugins/ chmod -R a+w var/templates_compiled/ chmod -R a+w www/images/ chmod -R a+w www/admin/plugins/ # However, when I protect the files below, some of which contain passwords to my database, the software throws the permission warnings. chmod -R 644 var/cache/*.php chmod -R 644 var/cache/*.php.meta ```
  28. Is There a workaround to this error: timeout The PHP function set_time_limit() has been disabled and max_execution_time is set to 60 which may cause problems with functionality such as maintenance I am on shared hosting so the php.ini cannot be changed.
  29. Hello, I have a very specific use case for VAST ads and have signed up for the revive hosted edition. I need to show my own inventory of video ads using VAST on my membership website. It is wordpress based and using FV Player to show all the videos and their FV VAST plugin. I need a VAST url for this to work. My end goal is to be able to show the video ads pre roll, mid roll (every 10 minutes - they are 30 minute videos), and post roll. I have created a test campaign and banner with my inline video but am having a difficult time getting the proper VAST URL to provide for my FV Player to pull the ads in. Every test I do does not work and the console returns an error. I can't find much documentation on this and the best I can come up with is this for my VAST URL https://servedby.revive-adserver.net/fc.php?script=bannerTypeHtml:vastInlineBannerTypeHtml:vastInlineHtml&format=vast&nz=1&zones=pre-roll%3D2313 - however it does not work. Any help would be greatly appreciated.
  1. Load more activity


×
×
  • Create New...