SLM

Hello, we have completed the update from 5.3.1 to 5.4.1 and now receive the following message when logging in. The e-mail address is active, but no e-mail arrives (not even in the spam folder). How do we get back to the administration area? Is there a workaround for this? ------------------------------------------- Important note about improved password security Recently, the Revive Adserver software has been updated to a new version, which implements a more modern and much safer method of storing passwords. To be able to log in and continue using Revive Adserver you must set a new password first. Check your inbox for a password reset email! A password reset email has been sent to the email address associated with your username. Please open the email, and click the link in it. This will display a screen that enables you to enter your new password. It can take a few minutes before the email arrives. If you don't see the email in your inbox, make sure to also check your spam folder.

We would like to display text links without an image as buttons, like you can do with HTML. Which method is the best for this with Revive?

The problem is solved. The admin_account_id value in the application_variable table was set to a wrong value. After I have set the value back to 1, everything works again.

Hello @andrewatfornax It is definitely not possible to save any settings. Therefore, no statistics are displayed and the settings can not be changed. After several tests I found the following: 1. If I install version 4.0.1 fresh with a new database, all settings can be saved (language etc.). 2. If I copy the data from the old database to the new database, the settings can not be saved anymore. It is therefore not due to wrongly set rights. Which table and which values are responsible for the database to save any settings? And what values are correct?

@andrewatfornax The update I have run again, it was now also completely and without error message executed. Does after update not work yet again: - Banners are not displayed in the ACP - Statistics are not displayed -> All plugins are activated -> Maintenance is set up - Language can not be set

Hi @andrewatfornax There is only one entry in this table. In my opinion at the update at this point should not be asked for the access data at all. I use the previous conf.php, the script would simply continue here.

Revive Adserver is located on a subdomain ads.domain.de My Steps: Old Version 4.0.0 -> Folder renamed New Version uploaded and set to /adserver (wich looks at ads.domain.de) - Start Upgrade - Step 1, copy old ads.domain.de.conf.php in new /var folder - Step 2 - Database password entered - Step 3 - added Path to previous Revive Adserver installation & set data for System Administrator Account - continue -> Get Error: ---------------------------- An error occurred while accessing the database Due to a problem with the database Revive Adserver couldn't retrieve or store data. If this problem is reproducable it might be caused by a bug in Revive Adserver. Please report the following information to the creators of Revive Adserver. Also try to describe the actions that led to this error as clearly as possible. Version: Revive Adserver v4.0.1 PHP/DB: PHP 5.6.29-0+deb8u1 / MySQL 5.5.54-0+deb8u1 Page: /www/admin/install.php Error: Duplicate entry 'xxx' for key 'rv_users_username' Query: INSERT INTO rv_users (contact_name , email_address , username , password , language , default_account_id , date_created , email_updated ) VALUES ('Administrator' , '[email protected]' , 'xxx' , '12237f9088c1417ea56846ff9596cac9' , 'de' , 41 , '2017-02-25 02:37:52' , '2017-02-25 02:37:52' ) $_POST: Array ( [_qf__install-config-form] => [action] => configuration [moreFieldsShown] => 1 [previousPath] => /home/xxx/html/adserver4 [adminName] => xxxx [adminPassword] => xxxxx [adminPassword2] => xx [adminEmail] => [email protected] [adminLanguage] => de [prefsTimezone] => Europe/Berlin [webpathAdmin] => ads.domain.de/www/admin [webpathDelivery] => ads.domain.de/www/delivery [webpathImages] => ads.domain.de/www/images [webpathDeliverySSL] => ads.domain.de/www/delivery [webpathImagesSSL] => ads.domain.de/www/images [storeWebDir] => /home/xxx/html/adserver/www/images [save] => Continue » ) $_GET: Empty ---------------------- -> Now Log on administration area -> Detected Revive Adserver 4.0.1 Revive Adserver is up to date Your Revive Adserver database and file structure are both using the most recent version and therefore no upgrade is required at this time. Please click Continue to proceed to the administration panel. - No banners are displayed in the admin area (preview). - Banners are displayed on managed websites - No statistics are displayed -> What can I do now?

Is it possible to use the adserver in mobile Apps (eg. for Android)? What is there to consider? Does anyone know a good marketer for mobile Ads, preferbly for German-speaking Countries?

Thanks @Eliza0406

How can I set that the banner code only outputs https tags? My pages are only accessible via https. You have to change any banner code manually, which is pretty annoying.

When the script is installed on a subdomain (in the root directory), the upgrade does not work completely. Is there a solution or a guide?

I've installed the plugins manually (menu plugins), although the script has displayed during the installation, it installs the plugins. Now it works. Here, however, it must be an error in the script.

I think that is the reason why it does not work. In the download package lacks several plugins.

As I said, this works not with us.

Hello Jim, the checkbox HTML banner is checked, the option still does not appear when I add banner. The debug.log: Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_account_preference_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table account_preference_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_account_user_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table account_user_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_account_user_permission_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table account_user_permission_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_accounts Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table accounts Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_acls Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table acls Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_acls_channel Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table acls_channel Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_ad_category_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table ad_category_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_ad_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table ad_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_affiliates Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table affiliates Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_affiliates_extra Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table affiliates_extra Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_agency Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table agency Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_application_variable Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table application_variable Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_audit Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table audit Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_banners Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table banners Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_campaigns Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table campaigns Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_campaigns_trackers Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table campaigns_trackers Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_category Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table category Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_channel Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table channel Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_clients Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table clients Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_intermediate_ad Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_intermediate_ad Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_intermediate_ad_connection Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_intermediate_ad_connection Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_intermediate_ad_variable_value Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_intermediate_ad_variable_value Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_raw_ad_click Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_raw_ad_click Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_raw_ad_impression Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_raw_ad_impression Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_raw_ad_request Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_raw_ad_request Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_raw_tracker_impression Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_raw_tracker_impression Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_raw_tracker_variable_value Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_raw_tracker_variable_value Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_summary_ad_hourly Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_summary_ad_hourly Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_summary_ad_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_summary_ad_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_summary_channel_daily Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_summary_channel_daily Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_data_summary_zone_impression_history Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table data_summary_zone_impression_history Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_images Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table images Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_log_maintenance_forecasting Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table log_maintenance_forecasting Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_log_maintenance_priority Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table log_maintenance_priority Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_log_maintenance_statistics Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table log_maintenance_statistics Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_password_recovery Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table password_recovery Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_placement_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table placement_zone_assoc Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_preferences Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table preferences Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_session Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table session Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_targetstats Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table targetstats Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_tracker_append Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table tracker_append Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_trackers Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table trackers Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_userlog Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table userlog Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_users Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table users Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_variable_publisher Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table variable_publisher Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_variables Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table variables Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop table rv_zones Apr 04 16:11:02 +0200 OX-533ebd75e33c5 [ error] Unable to drop the table zones