SLM Posted February 6, 2014 Report Share Posted February 6, 2014 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 - database integrity check detected problems with the database - 35 indexes to add NOT OK -> What is to do? Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted February 7, 2014 Report Share Posted February 7, 2014 Please check the log files in the var folder of your revive installation. Quote Link to comment Share on other sites More sharing options...
SLM Posted February 8, 2014 Author Report Share Posted February 8, 2014 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 Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted February 8, 2014 Report Share Posted February 8, 2014 Do the tables have any indexes? What's their names? Does the database user have all the required permissions? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.