Jump to content

Upgrading To Revive Adserver 3.2.1


Recommended Posts

Im getting this error message when I run upgrade:

  1. - database integrity check detected problems with the database
  2. - 2 indexes to remove
  3. - 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?

Link to comment
Share on other sites

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.

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...