Jump to content
Gregory

Upgrade From 3.1.0 To 3.2.0

Recommended Posts

We are not able to upgrade from 3.1.0 to 3.2.0 due to some DB error. Can anyone make a suggestion? thanks!
 
 
=========================================================================
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: .../openx_new/etc/changes/schema_tables_core_619.xml
schema definition from cache TRUE
successfully parsed the schema
schema name: openads
schema version: 619
schema status: final
running integrity check
comparing database openx320 with schema .../openx_new/etc/changes/schema_tables_core_619.xml
 
#! error getting database definition getTableConstraintDefinition  <--- this seems to be she show stopper.
 
table is missing: account_preference_assoc
table is missing: account_user_assoc
table is missing: account_user_permission_assoc
table is missing: accounts
table is missing: acls
table is missing: acls_channel
table is missing: ad_category_assoc
table is missing: ad_zone_assoc
table is missing: affiliates
table is missing: affiliates_extra
table is missing: agency
table is missing: application_variable
table is missing: audit
table is missing: banners
table is missing: campaigns
table is missing: campaigns_trackers
table is missing: category
table is missing: channel
table is missing: clients
table is missing: data_intermediate_ad
table is missing: data_intermediate_ad_connection
table is missing: data_intermediate_ad_variable_value
table is missing: data_raw_ad_click
table is missing: data_raw_ad_impression
table is missing: data_raw_ad_request
table is missing: data_raw_tracker_impression
table is missing: data_raw_tracker_variable_value
table is missing: data_summary_ad_hourly
table is missing: data_summary_ad_zone_assoc
table is missing: data_summary_channel_daily
table is missing: data_summary_zone_impression_history
table is missing: images
table is missing: log_maintenance_forecasting
table is missing: log_maintenance_priority
table is missing: log_maintenance_statistics
table is missing: password_recovery
table is missing: placement_zone_assoc
table is missing: preferences
table is missing: session
table is missing: targetstats
table is missing: tracker_append
table is missing: trackers
table is missing: userlog
table is missing: users
table is missing: variable_publisher
table is missing: variables
table is missing: zones
to version: 619
timing: constructive
target database: openx320
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
task found: doAddTable__account_preference_assoc
#! table ox_account_preference_assoc already exists in database openx320
#! database integrity check could not complete due to problems
 
 
 

Share this post


Link to post
Share on other sites

Is there something we missed in the procedure to get help?

The upgrade seems to be ignoring our table prefix. Then later it states the table with the table prefix exists and it can't create the table. Very ambiguous.

 

Thanks

Share this post


Link to post
Share on other sites

SQL code to correct errors in the database:

ALTER TABLE `{prefix}_banners_ox_adsense` DROP INDEX `{prefix}_banners_ox_adsense_pkey`;
ALTER TABLE `{prefix}_banners_ox_adsense` ADD PRIMARY KEY (`bannerid`);

After that, the update runs without errors.

Share this post


Link to post
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...