Jump to content

Update Problem 35 Indexes To Add


SLM

Recommended Posts

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?

Link to comment
Share on other sites

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
 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...