[Not working: Important note about improved password security]

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.

[Format text links]

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?

[Upgrading from 4.0.0 to 4.0.1 getting error - No Stats, No Bannerpreview in ACP]

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.

[Upgrading from 4.0.0 to 4.0.1 getting error - No Stats, No Bannerpreview in ACP]

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?

[Upgrading from 4.0.0 to 4.0.1 getting error - No Stats, No Bannerpreview in ACP]

@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

[Upgrading from 4.0.0 to 4.0.1 getting error - No Stats, No Bannerpreview in ACP]

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.

 

 

 

[Upgrading from 4.0.0 to 4.0.1 getting error - No Stats, No Bannerpreview in ACP]

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?

 

[Mobile (native) Apps]

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?

[Only Https-Tags]

Thanks @Eliza0406

[Only Https-Tags]

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.

[Upgrade On Subdomain Fails]

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?

[Add Html Banner Option Disappered With Our New Install]

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.

[Add Html Banner Option Disappered With Our New Install]

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

[Add Html Banner Option Disappered With Our New Install]

As I said, this works not with us.

[Add Html Banner Option Disappered With Our New Install]

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

[Add Html Banner Option Disappered With Our New Install]

We have the same problem. If I install the new version 3.0.3 (not upgrade OpenX installation), lack the ability to add HTML banner:

 

 

 

 

 

 

 

In addition, the version does not contain any default plugins like openx 2.8.11

[Update Problem 35 Indexes To Add]

The install.log:

 

 

 

Starting file-check for plugins...
Finished file-check for plugins
=========================================================================
Attempting to detect an existing Openads (aka. phpAdsNew) installation...
PAN not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation...
MMM v0.1 not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation...
MMM v0.3 not detected
Attempting to detect an existing OpenX installation...
schema file found: /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 613
schema status: final
running integrity check
comparing database openxdb with schema /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
index missing from table: data_intermediate_ad.zone_id_date_time
index missing from table: data_intermediate_ad.date_time
index missing from table: data_intermediate_ad.interval_start
index missing from table: data_intermediate_ad_connection.tracker_date_time
index missing from table: data_intermediate_ad_connection.tracker_id
index missing from table: data_intermediate_ad_connection.ad_id
index missing from table: data_intermediate_ad_connection.zone_id
index missing from table: data_intermediate_ad_connection.viewer_id
index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con
index missing from table: data_intermediate_ad_variable_value.tracker_variable_id
index missing from table: data_intermediate_ad_variable_value.tracker_value
index missing from table: data_summary_ad_hourly.zone_id_date_time
index missing from table: data_summary_ad_zone_assoc.expired
index missing from table: data_summary_ad_zone_assoc.interval_start
index missing from table: data_summary_ad_zone_assoc.interval_end
index missing from table: data_summary_ad_zone_assoc.ad_id
index missing from table: data_summary_ad_zone_assoc.zone_id
index missing from table: data_summary_channel_daily.day
index missing from table: data_summary_channel_daily.channel_id
index missing from table: data_summary_channel_daily.zone_id
index missing from table: data_summary_zone_impression_history.operation_interval_id
index missing from table: data_summary_zone_impression_history.zone_id
index missing from table: password_recovery.recovery_id
index missing from table: placement_zone_assoc.placement_id
index missing from table: placement_zone_assoc.zone_id
index missing from table: preferences.preference_name
index missing from table: preferences.account_type
index missing from table: tracker_append.tracker_id
index missing from table: trackers.clientid
index missing from table: users.username
index missing from table: users.sso_user_id
index missing from table: variables.is_unique
index missing from table: variables.trackerid
index missing from table: zones.zonenameid
index missing from table: zones.affiliateid
table is not part of schema: banner_vast_element
table is not part of schema: data_bkt_a
table is not part of schema: data_bkt_a_var
table is not part of schema: data_bkt_c
table is not part of schema: data_bkt_m
table is not part of schema: data_bkt_r
table is not part of schema: data_bkt_vast_e
table is not part of schema: database_action
table is not part of schema: stats_vast
table is not part of schema: upgrade_action
table is not part of schema: z_19a5279687f04ba5
table is not part of schema: z_3b3287e5f27bc114
table is not part of schema: z_4714146cd50ce97c
table is not part of schema: z_642b5e59f335b6f7
table is not part of schema: z_9662801c5c110bd0
table is not part of schema: z_9ef8a9240ce05434
table is not part of schema: z_9f5d00920d45fd82
table is not part of schema: z_a1bee7bf11d131a9
table is not part of schema: z_a1d6439d689f056c
table is not part of schema: z_ab33caee1218ccc3
table is not part of schema: z_d9df481e4bc7b50e
table is not part of schema: z_e0549adc597f9cf1
table is not part of schema: z_e569315fa00f462c
to version: 613
timing: constructive
target database: openxdb
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
task found: doAddIndex__data_intermediate_ad__zone_id_date_time
task found: doAddIndex__data_intermediate_ad__date_time
task found: doAddIndex__data_intermediate_ad__interval_start
task found: doAddIndex__data_intermediate_ad_connection__tracker_date_time
task found: doAddIndex__data_intermediate_ad_connection__tracker_id
task found: doAddIndex__data_intermediate_ad_connection__ad_id
task found: doAddIndex__data_intermediate_ad_connection__zone_id
task found: doAddIndex__data_intermediate_ad_connection__viewer_id
task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_variable_id
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_value
task found: doAddIndex__data_summary_ad_hourly__zone_id_date_time
task found: doAddIndex__data_summary_ad_zone_assoc__expired
task found: doAddIndex__data_summary_ad_zone_assoc__interval_start
task found: doAddIndex__data_summary_ad_zone_assoc__interval_end
task found: doAddIndex__data_summary_ad_zone_assoc__ad_id
task found: doAddIndex__data_summary_ad_zone_assoc__zone_id
task found: doAddIndex__data_summary_channel_daily__day
task found: doAddIndex__data_summary_channel_daily__channel_id
task found: doAddIndex__data_summary_channel_daily__zone_id
task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id
task found: doAddIndex__data_summary_zone_impression_history__zone_id
task found: doAddIndex__password_recovery__recovery_id
task found: doAddIndex__placement_zone_assoc__placement_id
task found: doAddIndex__placement_zone_assoc__zone_id
task found: doAddIndex__preferences__preference_name
task found: doAddIndex__preferences__account_type
task found: doAddIndex__tracker_append__tracker_id
task found: doAddIndex__trackers__clientid
task found: doAddIndex__users__username
task found: doAddIndex__users__sso_user_id
task found: doAddIndex__variables__is_unique
task found: doAddIndex__variables__trackerid
task found: doAddIndex__zones__zonenameid
task found: doAddIndex__zones__affiliateid
#! database integrity check detected problems with the database
#! 35 indexes to add
Starting file-check for plugins...
Finished file-check for plugins
Starting file-check for plugins...
Finished file-check for plugins
Starting file-check for plugins...
Finished file-check for plugins
Starting file-check for plugins...
Finished file-check for plugins
=========================================================================
Attempting to detect an existing Openads (aka. phpAdsNew) installation...
PAN not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation...
MMM v0.1 not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation...
MMM v0.3 not detected
Attempting to detect an existing OpenX installation...
schema file found: /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 613
schema status: final
running integrity check
comparing database openxdb with schema /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
index missing from table: data_intermediate_ad.zone_id_date_time
index missing from table: data_intermediate_ad.date_time
index missing from table: data_intermediate_ad.interval_start
index missing from table: data_intermediate_ad_connection.tracker_date_time
index missing from table: data_intermediate_ad_connection.tracker_id
index missing from table: data_intermediate_ad_connection.ad_id
index missing from table: data_intermediate_ad_connection.zone_id
index missing from table: data_intermediate_ad_connection.viewer_id
index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con
index missing from table: data_intermediate_ad_variable_value.tracker_variable_id
index missing from table: data_intermediate_ad_variable_value.tracker_value
index missing from table: data_summary_ad_hourly.zone_id_date_time
index missing from table: data_summary_ad_zone_assoc.expired
index missing from table: data_summary_ad_zone_assoc.interval_start
index missing from table: data_summary_ad_zone_assoc.interval_end
index missing from table: data_summary_ad_zone_assoc.ad_id
index missing from table: data_summary_ad_zone_assoc.zone_id
index missing from table: data_summary_channel_daily.day
index missing from table: data_summary_channel_daily.channel_id
index missing from table: data_summary_channel_daily.zone_id
index missing from table: data_summary_zone_impression_history.operation_interval_id
index missing from table: data_summary_zone_impression_history.zone_id
index missing from table: password_recovery.recovery_id
index missing from table: placement_zone_assoc.placement_id
index missing from table: placement_zone_assoc.zone_id
index missing from table: preferences.preference_name
index missing from table: preferences.account_type
index missing from table: tracker_append.tracker_id
index missing from table: trackers.clientid
index missing from table: users.username
index missing from table: users.sso_user_id
index missing from table: variables.is_unique
index missing from table: variables.trackerid
index missing from table: zones.zonenameid
index missing from table: zones.affiliateid
table is not part of schema: banner_vast_element
table is not part of schema: data_bkt_a
table is not part of schema: data_bkt_a_var
table is not part of schema: data_bkt_c
table is not part of schema: data_bkt_m
table is not part of schema: data_bkt_r
table is not part of schema: data_bkt_vast_e
table is not part of schema: database_action
table is not part of schema: stats_vast
table is not part of schema: upgrade_action
table is not part of schema: z_19a5279687f04ba5
table is not part of schema: z_3b3287e5f27bc114
table is not part of schema: z_4714146cd50ce97c
table is not part of schema: z_642b5e59f335b6f7
table is not part of schema: z_9662801c5c110bd0
table is not part of schema: z_9ef8a9240ce05434
table is not part of schema: z_9f5d00920d45fd82
table is not part of schema: z_a1bee7bf11d131a9
table is not part of schema: z_a1d6439d689f056c
table is not part of schema: z_ab33caee1218ccc3
table is not part of schema: z_d9df481e4bc7b50e
table is not part of schema: z_e0549adc597f9cf1
table is not part of schema: z_e569315fa00f462c
to version: 613
timing: constructive
target database: openxdb
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
task found: doAddIndex__data_intermediate_ad__zone_id_date_time
task found: doAddIndex__data_intermediate_ad__date_time
task found: doAddIndex__data_intermediate_ad__interval_start
task found: doAddIndex__data_intermediate_ad_connection__tracker_date_time
task found: doAddIndex__data_intermediate_ad_connection__tracker_id
task found: doAddIndex__data_intermediate_ad_connection__ad_id
task found: doAddIndex__data_intermediate_ad_connection__zone_id
task found: doAddIndex__data_intermediate_ad_connection__viewer_id
task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_variable_id
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_value
task found: doAddIndex__data_summary_ad_hourly__zone_id_date_time
task found: doAddIndex__data_summary_ad_zone_assoc__expired
task found: doAddIndex__data_summary_ad_zone_assoc__interval_start
task found: doAddIndex__data_summary_ad_zone_assoc__interval_end
task found: doAddIndex__data_summary_ad_zone_assoc__ad_id
task found: doAddIndex__data_summary_ad_zone_assoc__zone_id
task found: doAddIndex__data_summary_channel_daily__day
task found: doAddIndex__data_summary_channel_daily__channel_id
task found: doAddIndex__data_summary_channel_daily__zone_id
task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id
task found: doAddIndex__data_summary_zone_impression_history__zone_id
task found: doAddIndex__password_recovery__recovery_id
task found: doAddIndex__placement_zone_assoc__placement_id
task found: doAddIndex__placement_zone_assoc__zone_id
task found: doAddIndex__preferences__preference_name
task found: doAddIndex__preferences__account_type
task found: doAddIndex__tracker_append__tracker_id
task found: doAddIndex__trackers__clientid
task found: doAddIndex__users__username
task found: doAddIndex__users__sso_user_id
task found: doAddIndex__variables__is_unique
task found: doAddIndex__variables__trackerid
task found: doAddIndex__zones__zonenameid
task found: doAddIndex__zones__affiliateid
#! database integrity check detected problems with the database
#! 35 indexes to add
Starting file-check for plugins...
Finished file-check for plugins
=========================================================================
Attempting to detect an existing Openads (aka. phpAdsNew) installation...
PAN not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.1) installation...
MMM v0.1 not detected
Attempting to detect an existing Openads (aka. Max Media Manager 0.3) installation...
MMM v0.3 not detected
Attempting to detect an existing OpenX installation...
schema file found: /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 613
schema status: final
running integrity check
comparing database openxdb with schema /var/www/vhosts/xxxxxxxxx/subdomains/ad2/httpdocs/etc/changes/schema_tables_core_613.xml
index missing from table: data_intermediate_ad.zone_id_date_time
index missing from table: data_intermediate_ad.date_time
index missing from table: data_intermediate_ad.interval_start
index missing from table: data_intermediate_ad_connection.tracker_date_time
index missing from table: data_intermediate_ad_connection.tracker_id
index missing from table: data_intermediate_ad_connection.ad_id
index missing from table: data_intermediate_ad_connection.zone_id
index missing from table: data_intermediate_ad_connection.viewer_id
index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con
index missing from table: data_intermediate_ad_variable_value.tracker_variable_id
index missing from table: data_intermediate_ad_variable_value.tracker_value
index missing from table: data_summary_ad_hourly.zone_id_date_time
index missing from table: data_summary_ad_zone_assoc.expired
index missing from table: data_summary_ad_zone_assoc.interval_start
index missing from table: data_summary_ad_zone_assoc.interval_end
index missing from table: data_summary_ad_zone_assoc.ad_id
index missing from table: data_summary_ad_zone_assoc.zone_id
index missing from table: data_summary_channel_daily.day
index missing from table: data_summary_channel_daily.channel_id
index missing from table: data_summary_channel_daily.zone_id
index missing from table: data_summary_zone_impression_history.operation_interval_id
index missing from table: data_summary_zone_impression_history.zone_id
index missing from table: password_recovery.recovery_id
index missing from table: placement_zone_assoc.placement_id
index missing from table: placement_zone_assoc.zone_id
index missing from table: preferences.preference_name
index missing from table: preferences.account_type
index missing from table: tracker_append.tracker_id
index missing from table: trackers.clientid
index missing from table: users.username
index missing from table: users.sso_user_id
index missing from table: variables.is_unique
index missing from table: variables.trackerid
index missing from table: zones.zonenameid
index missing from table: zones.affiliateid
table is not part of schema: banner_vast_element
table is not part of schema: data_bkt_a
table is not part of schema: data_bkt_a_var
table is not part of schema: data_bkt_c
table is not part of schema: data_bkt_m
table is not part of schema: data_bkt_r
table is not part of schema: data_bkt_vast_e
table is not part of schema: database_action
table is not part of schema: stats_vast
table is not part of schema: upgrade_action
table is not part of schema: z_19a5279687f04ba5
table is not part of schema: z_3b3287e5f27bc114
table is not part of schema: z_4714146cd50ce97c
table is not part of schema: z_642b5e59f335b6f7
table is not part of schema: z_9662801c5c110bd0
table is not part of schema: z_9ef8a9240ce05434
table is not part of schema: z_9f5d00920d45fd82
table is not part of schema: z_a1bee7bf11d131a9
table is not part of schema: z_a1d6439d689f056c
table is not part of schema: z_ab33caee1218ccc3
table is not part of schema: z_d9df481e4bc7b50e
table is not part of schema: z_e0549adc597f9cf1
table is not part of schema: z_e569315fa00f462c
to version: 613
timing: constructive
target database: openxdb
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
task found: doAddIndex__data_intermediate_ad__zone_id_date_time
task found: doAddIndex__data_intermediate_ad__date_time
task found: doAddIndex__data_intermediate_ad__interval_start
task found: doAddIndex__data_intermediate_ad_connection__tracker_date_time
task found: doAddIndex__data_intermediate_ad_connection__tracker_id
task found: doAddIndex__data_intermediate_ad_connection__ad_id
task found: doAddIndex__data_intermediate_ad_connection__zone_id
task found: doAddIndex__data_intermediate_ad_connection__viewer_id
task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_variable_id
task found: doAddIndex__data_intermediate_ad_variable_value__tracker_value
task found: doAddIndex__data_summary_ad_hourly__zone_id_date_time
task found: doAddIndex__data_summary_ad_zone_assoc__expired
task found: doAddIndex__data_summary_ad_zone_assoc__interval_start
task found: doAddIndex__data_summary_ad_zone_assoc__interval_end
task found: doAddIndex__data_summary_ad_zone_assoc__ad_id
task found: doAddIndex__data_summary_ad_zone_assoc__zone_id
task found: doAddIndex__data_summary_channel_daily__day
task found: doAddIndex__data_summary_channel_daily__channel_id
task found: doAddIndex__data_summary_channel_daily__zone_id
task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id
task found: doAddIndex__data_summary_zone_impression_history__zone_id
task found: doAddIndex__password_recovery__recovery_id
task found: doAddIndex__placement_zone_assoc__placement_id
task found: doAddIndex__placement_zone_assoc__zone_id
task found: doAddIndex__preferences__preference_name
task found: doAddIndex__preferences__account_type
task found: doAddIndex__tracker_append__tracker_id
task found: doAddIndex__trackers__clientid
task found: doAddIndex__users__username
task found: doAddIndex__users__sso_user_id
task found: doAddIndex__variables__is_unique
task found: doAddIndex__variables__trackerid
task found: doAddIndex__zones__zonenameid
task found: doAddIndex__zones__affiliateid
#! database integrity check detected problems with the database
#! 35 indexes to add
 

[Update Problem 35 Indexes To Add]

Previous version - 1 error

• Errors were found when detecting previous installations of Revive Adserver

  We have detected integrity issues with your database. This means that the layout of your database differs from what we expect it to be. This could be due to customization of your database.

Check name Current value Status application

1. - database integrity check detected problems with the database
2. - 35 indexes to add

NOT OK  

 

 

 

-> What is to do?

[Banners In Jquery Mobile Does Not Work Correctly]

Thank you Chinnu,

 

When installing (Plugins) I get this error message:

 

Failed to read contents of zip file /tmp/phpRFiMrm
The uploaded file did not pass security check
The uploaded file juplo-openx-0.2.1-0-g1a5c6ae.zip was not unpacked

[Banners In Jquery Mobile Does Not Work Correctly]

Revive banner tags do not or only partially function in jquery mobile applications (such as for smartphones). It is complicated to explain what happened here. Substituting for example, the javascript banner tags, overlay the banner partly all sides, so that one no longer comes to the menu.

Does anyone have experience with this?