chan0019s Posted June 23, 2015 Report Posted June 23, 2015 Im getting this error message when I run upgrade: - database integrity check detected problems with the database - 2 indexes to remove - 2 indexes to ad Here is the install.log ========================================================================= 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 Revive Adserver installation... schema file found: /home/rogerb/public_html/adserver/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 rogerb_open791 with schema /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con index missing from table: data_summary_zone_impression_history.operation_interval_id 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 to version: 613 timing: constructive target database: rogerb_open791 table prefix: ox_ successfully initialised DB Upgrade verifying/creating constructive tasklist task found: doRemoveIndex__data_intermediate_ad_variable_value__data_intermediate_ad_ task found: doRemoveIndex__data_summary_zone_impression_history__operation_interval_i task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id #! database integrity check detected problems with the database #! 2 indexes to remove #! 2 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 Revive Adserver installation... schema file found: /home/rogerb/public_html/adserver/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 rogerb_open791 with schema /home/rogerb/public_html/adserver/etc/changes/schema_tables_core_613.xml index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con index missing from table: data_summary_zone_impression_history.operation_interval_id 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 to version: 613 timing: constructive target database: rogerb_open791 table prefix: ox_ successfully initialised DB Upgrade verifying/creating constructive tasklist task found: doRemoveIndex__data_intermediate_ad_variable_value__data_intermediate_ad_ task found: doRemoveIndex__data_summary_zone_impression_history__operation_interval_i task found: doAddIndex__data_intermediate_ad_variable_value__data_intermediate_ad_con task found: doAddIndex__data_summary_zone_impression_history__operation_interval_id #! database integrity check detected problems with the database #! 2 indexes to remove #! 2 indexes to add Starting file-check for plugins... Finished file-check for plugins How can I proceed and complete the upgrade process? Quote
Erik Geurts Posted June 23, 2015 Report Posted June 23, 2015 This means you made a change to the setup of your database (indices in this case), which makes the upgrade wizard realize this is not the "original" database layout and thus it can't continue. You should removed the added indices, then you can try again. Quote
chan0019s Posted June 23, 2015 Author Report Posted June 23, 2015 Can you tell me what are those indices? Quote
andrewatfornax Posted June 24, 2015 Report Posted June 24, 2015 So, this is what the database schema should be if your version of Revive Adserver is saying that you're running schema version 613: https://github.com/revive-adserver/revive-adserver/blob/master/etc/changes/schema_tables_core_613.xml So, when it says something like: index missing from table: data_intermediate_ad_variable_value.data_intermediate_ad_con I would be looking here for the full table definition: https://github.com/revive-adserver/revive-adserver/blob/master/etc/changes/schema_tables_core_613.xml#L2404 And then scrolling down to here, where the indexes for that table are defined: https://github.com/revive-adserver/revive-adserver/blob/master/etc/changes/schema_tables_core_613.xml#L2790 Hopefully, that's reasonably clear, and you can see the 6 indexes that this table has, and you can compare that with your database to see what's been added/removed. Quote
chan0019s Posted June 27, 2015 Author Report Posted June 27, 2015 Okay, thank you very much for your replies.. Quote
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.