Jump to content
adam.fischer@wisible.sk

Unable To Upgrade 2.8 To 3.0.2

Recommended Posts

Hi,

 

I am trying to upgrade my openx to newset version. 

 

On link /www/admin/install.php aplication is returning error Fatal error: Cannot use object of type MDB2_Error as array in /home/foo/htdocs/newRevive/lib/pear/MDB2/Driver/Reverse/mysql.php on line 100

 

after commenting that line out I can see the install wizard, but receving error 

application

  1. - database integrity check detected problems with the database
  2. - 279 fields to change

 

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 OpenX installation...
schema file found: /home/foo/htdocs/newRevive/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 Ads_mama with schema /home/foo/htdocs/newRevive/etc/changes/schema_tables_core_613.xml
column definition does not match: accounts.account_type
column definition does not match: acls.logical
column definition does not match: acls_channel.logical
column definition does not match: ad_category_assoc.ad_category_assoc_id
column definition does not match: affiliates.name
column definition does not match: affiliates_extra.city
column definition does not match: agency.name
column definition does not match: application_variable.name
column definition does not match: audit.context
column definition does not match: banners.filename
column definition does not match: campaigns.campaignname
column definition does not match: campaigns_trackers.status
column definition does not match: category.category_id
column definition does not match: channel.name
column definition does not match: clients.clientname
column definition does not match: data_intermediate_ad.operation_interval
column definition does not match: data_intermediate_ad_connection.server_raw_ip
column definition does not match: data_intermediate_ad_variable_value.value
column definition does not match: data_raw_ad_click.viewer_id
column definition does not match: data_raw_ad_impression.viewer_id
column definition does not match: data_raw_ad_request.viewer_id
column definition does not match: data_raw_tracker_impression.server_raw_ip
column definition does not match: data_raw_tracker_variable_value.server_raw_ip
column definition does not match: data_summary_ad_hourly.ad_id
column definition does not match: data_summary_ad_zone_assoc.operation_interval
column definition does not match: data_summary_channel_daily.channel_id
column definition does not match: data_summary_zone_impression_history.operation_interval
column definition does not match: images.filename
column definition does not match: log_maintenance_priority.run_type
column definition does not match: password_recovery.user_type
column definition does not match: preferences.preference_name
column definition does not match: session.sessionid
column definition does not match: trackers.trackername
column definition does not match: users.contact_name
column definition does not match: variables.variableid
column definition does not match: zones.zonename
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: ext_market_advertiser
table is not part of schema: ext_market_assoc_data
table is not part of schema: ext_market_campaign_pref
table is not part of schema: ext_market_general_pref
table is not part of schema: ext_market_plugin_variable
table is not part of schema: ext_market_setting
table is not part of schema: ext_market_stats
table is not part of schema: ext_market_web_stats
table is not part of schema: ext_market_website_pref
table is not part of schema: stats_vast
table is not part of schema: upgrade_action
to version: 613
timing: constructive
target database: Ads_mama
table prefix: ox_
successfully initialised DB Upgrade
verifying/creating constructive tasklist
checking field: ox_accounts account_type
found field account_type
checking field: ox_accounts account_name
found field account_name
checking field: ox_accounts m2m_password
found field m2m_password
checking field: ox_accounts m2m_ticket
found field m2m_ticket
checking field: ox_acls logical
found field logical
checking field: ox_acls type
found field type
checking field: ox_acls comparison
found field comparison
checking field: ox_acls executionorder
found field executionorder
checking field: ox_acls_channel logical
found field logical
checking field: ox_acls_channel type
found field type
checking field: ox_acls_channel comparison
found field comparison
checking field: ox_acls_channel executionorder
found field executionorder
checking field: ox_ad_category_assoc ad_category_assoc_id
found field ad_category_assoc_id
checking field: ox_ad_category_assoc category_id
found field category_id
checking field: ox_ad_category_assoc ad_id
found field ad_id
checking field: ox_affiliates name
found field name
checking field: ox_affiliates mnemonic
found field mnemonic
checking field: ox_affiliates contact
found field contact
checking field: ox_affiliates email
found field email
checking field: ox_affiliates website
found field website
checking field: ox_affiliates oac_country_code
found field oac_country_code
checking field: ox_affiliates_extra city
found field city
checking field: ox_affiliates_extra postcode
found field postcode
checking field: ox_affiliates_extra country
found field country
checking field: ox_affiliates_extra phone
found field phone
checking field: ox_affiliates_extra fax
found field fax
checking field: ox_affiliates_extra account_contact
found field account_contact
checking field: ox_affiliates_extra payee_name
found field payee_name
checking field: ox_affiliates_extra tax_id
found field tax_id
checking field: ox_affiliates_extra mode_of_payment
found field mode_of_payment
checking field: ox_affiliates_extra currency
found field currency
checking field: ox_affiliates_extra category
found field category
checking field: ox_affiliates_extra help_file
found field help_file
checking field: ox_agency name
found field name
checking field: ox_agency contact
found field contact
checking field: ox_agency email
found field email
checking field: ox_agency logout_url
found field logout_url
checking field: ox_application_variable name
found field name
checking field: ox_audit context
found field context
checking field: ox_audit username
found field username
checking field: ox_banners filename
found field filename
checking field: ox_banners imageurl
found field imageurl
checking field: ox_banners target
found field target
checking field: ox_banners alt
found field alt
checking field: ox_banners statustext
found field statustext
checking field: ox_banners description
found field description
checking field: ox_banners adserver
found field adserver
checking field: ox_banners alt_filename
found field alt_filename
checking field: ox_banners alt_imageurl
found field alt_imageurl
checking field: ox_banners keyword
found field keyword
checking field: ox_banners ext_bannertype
found field ext_bannertype
checking field: ox_campaigns campaignname
found field campaignname
checking field: ox_campaigns revenue
found field revenue
checking field: ox_campaigns ecpm
found field ecpm
checking field: ox_campaigns_trackers status
found field status
checking field: ox_category category_id
found field category_id
checking field: ox_category name
found field name
checking field: ox_channel name
found field name
checking field: ox_channel description
found field description
checking field: ox_clients clientname
found field clientname
checking field: ox_clients contact
found field contact
checking field: ox_clients email
found field email
checking field: ox_data_intermediate_ad operation_interval
found field operation_interval
checking field: ox_data_intermediate_ad operation_interval_id
found field operation_interval_id
checking field: ox_data_intermediate_ad ad_id
found field ad_id
checking field: ox_data_intermediate_ad creative_id
found field creative_id
checking field: ox_data_intermediate_ad zone_id
found field zone_id
checking field: ox_data_intermediate_ad requests
found field requests
checking field: ox_data_intermediate_ad impressions
found field impressions
checking field: ox_data_intermediate_ad clicks
found field clicks
checking field: ox_data_intermediate_ad conversions
found field conversions
checking field: ox_data_intermediate_ad total_basket_value
found field total_basket_value
checking field: ox_data_intermediate_ad_connection server_raw_ip
found field server_raw_ip
checking field: ox_data_intermediate_ad_connection viewer_id
found field viewer_id
checking field: ox_data_intermediate_ad_connection viewer_session_id
found field viewer_session_id
checking field: ox_data_intermediate_ad_connection tracker_id
found field tracker_id
checking field: ox_data_intermediate_ad_connection ad_id
found field ad_id
checking field: ox_data_intermediate_ad_connection creative_id
found field creative_id
checking field: ox_data_intermediate_ad_connection zone_id
found field zone_id
checking field: ox_data_intermediate_ad_connection tracker_channel
found field tracker_channel
checking field: ox_data_intermediate_ad_connection connection_channel
found field connection_channel
checking field: ox_data_intermediate_ad_connection tracker_channel_ids
found field tracker_channel_ids
checking field: ox_data_intermediate_ad_connection connection_channel_ids
found field connection_channel_ids
checking field: ox_data_intermediate_ad_connection tracker_language
found field tracker_language
checking field: ox_data_intermediate_ad_connection connection_language
found field connection_language
checking field: ox_data_intermediate_ad_connection tracker_ip_address
found field tracker_ip_address
checking field: ox_data_intermediate_ad_connection connection_ip_address
found field connection_ip_address
checking field: ox_data_intermediate_ad_connection tracker_host_name
found field tracker_host_name
checking field: ox_data_intermediate_ad_connection connection_host_name
found field connection_host_name
checking field: ox_data_intermediate_ad_connection tracker_country
found field tracker_country
checking field: ox_data_intermediate_ad_connection connection_country
found field connection_country
checking field: ox_data_intermediate_ad_connection tracker_https
found field tracker_https
checking field: ox_data_intermediate_ad_connection connection_https
found field connection_https
checking field: ox_data_intermediate_ad_connection tracker_domain
found field tracker_domain
checking field: ox_data_intermediate_ad_connection connection_domain
found field connection_domain
checking field: ox_data_intermediate_ad_connection tracker_page
found field tracker_page
checking field: ox_data_intermediate_ad_connection connection_page
found field connection_page
checking field: ox_data_intermediate_ad_connection tracker_query
found field tracker_query
checking field: ox_data_intermediate_ad_connection connection_query
found field connection_query
checking field: ox_data_intermediate_ad_connection tracker_referer
found field tracker_referer
checking field: ox_data_intermediate_ad_connection connection_referer
found field connection_referer
checking field: ox_data_intermediate_ad_connection tracker_search_term
found field tracker_search_term
checking field: ox_data_intermediate_ad_connection connection_search_term
found field connection_search_term
checking field: ox_data_intermediate_ad_connection tracker_user_agent
found field tracker_user_agent
checking field: ox_data_intermediate_ad_connection connection_user_agent
found field connection_user_agent
checking field: ox_data_intermediate_ad_connection tracker_os
found field tracker_os
checking field: ox_data_intermediate_ad_connection connection_os
found field connection_os
checking field: ox_data_intermediate_ad_connection tracker_browser
found field tracker_browser
checking field: ox_data_intermediate_ad_connection connection_browser
found field connection_browser
checking field: ox_data_intermediate_ad_connection connection_action
found field connection_action
checking field: ox_data_intermediate_ad_connection connection_window
found field connection_window
checking field: ox_data_intermediate_ad_connection connection_status
found field connection_status
checking field: ox_data_intermediate_ad_variable_value value
found field value
checking field: ox_data_raw_ad_click viewer_id
found field viewer_id
checking field: ox_data_raw_ad_click viewer_session_id
found field viewer_session_id
checking field: ox_data_raw_ad_click ad_id
found field ad_id
checking field: ox_data_raw_ad_click creative_id
found field creative_id
checking field: ox_data_raw_ad_click zone_id
found field zone_id
checking field: ox_data_raw_ad_click channel
found field channel
checking field: ox_data_raw_ad_click channel_ids
found field channel_ids
checking field: ox_data_raw_ad_click language
found field language
checking field: ox_data_raw_ad_click ip_address
found field ip_address
checking field: ox_data_raw_ad_click host_name
found field host_name
checking field: ox_data_raw_ad_click country
found field country
checking field: ox_data_raw_ad_click domain
found field domain
checking field: ox_data_raw_ad_click page
found field page
checking field: ox_data_raw_ad_click query
found field query
checking field: ox_data_raw_ad_click referer
found field referer
checking field: ox_data_raw_ad_click search_term
found field search_term
checking field: ox_data_raw_ad_click user_agent
found field user_agent
checking field: ox_data_raw_ad_click os
found field os
checking field: ox_data_raw_ad_click browser
found field browser
checking field: ox_data_raw_ad_click geo_region
found field geo_region
checking field: ox_data_raw_ad_click geo_city
found field geo_city
checking field: ox_data_raw_ad_click geo_postal_code
found field geo_postal_code
checking field: ox_data_raw_ad_click geo_latitude
found field geo_latitude
checking field: ox_data_raw_ad_click geo_longitude
found field geo_longitude
checking field: ox_data_raw_ad_click geo_dma_code
found field geo_dma_code
checking field: ox_data_raw_ad_click geo_area_code
found field geo_area_code
checking field: ox_data_raw_ad_click geo_organisation
found field geo_organisation
checking field: ox_data_raw_ad_click geo_netspeed
found field geo_netspeed
checking field: ox_data_raw_ad_click geo_continent
found field geo_continent
checking field: ox_data_raw_ad_impression viewer_id
found field viewer_id
checking field: ox_data_raw_ad_impression viewer_session_id
found field viewer_session_id
checking field: ox_data_raw_ad_impression ad_id
found field ad_id
checking field: ox_data_raw_ad_impression creative_id
found field creative_id
checking field: ox_data_raw_ad_impression zone_id
found field zone_id
checking field: ox_data_raw_ad_impression channel
found field channel
checking field: ox_data_raw_ad_impression channel_ids
found field channel_ids
checking field: ox_data_raw_ad_impression language
found field language
checking field: ox_data_raw_ad_impression ip_address
found field ip_address
checking field: ox_data_raw_ad_impression host_name
found field host_name
checking field: ox_data_raw_ad_impression country
found field country
checking field: ox_data_raw_ad_impression domain
found field domain
checking field: ox_data_raw_ad_impression page
found field page
checking field: ox_data_raw_ad_impression query
found field query
checking field: ox_data_raw_ad_impression referer
found field referer
checking field: ox_data_raw_ad_impression search_term
found field search_term
checking field: ox_data_raw_ad_impression user_agent
found field user_agent
checking field: ox_data_raw_ad_impression os
found field os
checking field: ox_data_raw_ad_impression browser
found field browser
checking field: ox_data_raw_ad_impression geo_region
found field geo_region
checking field: ox_data_raw_ad_impression geo_city
found field geo_city
checking field: ox_data_raw_ad_impression geo_postal_code
found field geo_postal_code
checking field: ox_data_raw_ad_impression geo_latitude
found field geo_latitude
checking field: ox_data_raw_ad_impression geo_longitude
found field geo_longitude
checking field: ox_data_raw_ad_impression geo_dma_code
found field geo_dma_code
checking field: ox_data_raw_ad_impression geo_area_code
found field geo_area_code
checking field: ox_data_raw_ad_impression geo_organisation
found field geo_organisation
checking field: ox_data_raw_ad_impression geo_netspeed
found field geo_netspeed
checking field: ox_data_raw_ad_impression geo_continent
found field geo_continent
checking field: ox_data_raw_ad_request viewer_id
found field viewer_id
checking field: ox_data_raw_ad_request viewer_session_id
found field viewer_session_id
checking field: ox_data_raw_ad_request ad_id
found field ad_id
checking field: ox_data_raw_ad_request creative_id
found field creative_id
checking field: ox_data_raw_ad_request zone_id
found field zone_id
checking field: ox_data_raw_ad_request channel
found field channel
checking field: ox_data_raw_ad_request channel_ids
found field channel_ids
checking field: ox_data_raw_ad_request language
found field language
checking field: ox_data_raw_ad_request ip_address
found field ip_address
checking field: ox_data_raw_ad_request host_name
found field host_name
checking field: ox_data_raw_ad_request domain
found field domain
checking field: ox_data_raw_ad_request page
found field page
checking field: ox_data_raw_ad_request query
found field query
checking field: ox_data_raw_ad_request referer
found field referer
checking field: ox_data_raw_ad_request search_term
found field search_term
checking field: ox_data_raw_ad_request user_agent
found field user_agent
checking field: ox_data_raw_ad_request os
found field os
checking field: ox_data_raw_ad_request browser
found field browser
checking field: ox_data_raw_tracker_impression server_raw_ip
found field server_raw_ip
checking field: ox_data_raw_tracker_impression viewer_id
found field viewer_id
checking field: ox_data_raw_tracker_impression viewer_session_id
found field viewer_session_id
checking field: ox_data_raw_tracker_impression tracker_id
found field tracker_id
checking field: ox_data_raw_tracker_impression channel
found field channel
checking field: ox_data_raw_tracker_impression channel_ids
found field channel_ids
checking field: ox_data_raw_tracker_impression language
found field language
checking field: ox_data_raw_tracker_impression ip_address
found field ip_address
checking field: ox_data_raw_tracker_impression host_name
found field host_name
checking field: ox_data_raw_tracker_impression country
found field country
checking field: ox_data_raw_tracker_impression https
found field https
checking field: ox_data_raw_tracker_impression domain
found field domain
checking field: ox_data_raw_tracker_impression page
found field page
checking field: ox_data_raw_tracker_impression query
found field query
checking field: ox_data_raw_tracker_impression referer
found field referer
checking field: ox_data_raw_tracker_impression search_term
found field search_term
checking field: ox_data_raw_tracker_impression user_agent
found field user_agent
checking field: ox_data_raw_tracker_impression os
found field os
checking field: ox_data_raw_tracker_impression browser
found field browser
checking field: ox_data_raw_tracker_impression max_https
found field max_https
checking field: ox_data_raw_tracker_impression geo_region
found field geo_region
checking field: ox_data_raw_tracker_impression geo_city
found field geo_city
checking field: ox_data_raw_tracker_impression geo_postal_code
found field geo_postal_code
checking field: ox_data_raw_tracker_impression geo_latitude
found field geo_latitude
checking field: ox_data_raw_tracker_impression geo_longitude
found field geo_longitude
checking field: ox_data_raw_tracker_impression geo_dma_code
found field geo_dma_code
checking field: ox_data_raw_tracker_impression geo_area_code
found field geo_area_code
checking field: ox_data_raw_tracker_impression geo_organisation
found field geo_organisation
checking field: ox_data_raw_tracker_impression geo_netspeed
found field geo_netspeed
checking field: ox_data_raw_tracker_impression geo_continent
found field geo_continent
checking field: ox_data_raw_tracker_variable_value server_raw_ip
found field server_raw_ip
checking field: ox_data_raw_tracker_variable_value value
found field value
checking field: ox_data_summary_ad_hourly ad_id
found field ad_id
checking field: ox_data_summary_ad_hourly creative_id
found field creative_id
checking field: ox_data_summary_ad_hourly zone_id
found field zone_id
checking field: ox_data_summary_ad_hourly requests
found field requests
checking field: ox_data_summary_ad_hourly impressions
found field impressions
checking field: ox_data_summary_ad_hourly clicks
found field clicks
checking field: ox_data_summary_ad_hourly conversions
found field conversions
checking field: ox_data_summary_ad_hourly total_basket_value
found field total_basket_value
checking field: ox_data_summary_ad_hourly total_revenue
found field total_revenue
checking field: ox_data_summary_ad_hourly total_cost
found field total_cost
checking field: ox_data_summary_ad_hourly total_techcost
found field total_techcost
checking field: ox_data_summary_ad_zone_assoc operation_interval
found field operation_interval
checking field: ox_data_summary_ad_zone_assoc operation_interval_id
found field operation_interval_id
checking field: ox_data_summary_ad_zone_assoc ad_id
found field ad_id
checking field: ox_data_summary_ad_zone_assoc zone_id
found field zone_id
checking field: ox_data_summary_ad_zone_assoc required_impressions
found field required_impressions
checking field: ox_data_summary_ad_zone_assoc requested_impressions
found field requested_impressions
checking field: ox_data_summary_ad_zone_assoc created_by
found field created_by
checking field: ox_data_summary_ad_zone_assoc expired_by
found field expired_by
checking field: ox_data_summary_channel_daily channel_id
found field channel_id
checking field: ox_data_summary_channel_daily zone_id
found field zone_id
checking field: ox_data_summary_channel_daily forecast_impressions
found field forecast_impressions
checking field: ox_data_summary_channel_daily actual_impressions
found field actual_impressions
checking field: ox_data_summary_zone_impression_history operation_interval
found field operation_interval
checking field: ox_data_summary_zone_impression_history operation_interval_id
found field operation_interval_id
checking field: ox_data_summary_zone_impression_history zone_id
found field zone_id
checking field: ox_data_summary_zone_impression_history forecast_impressions
found field forecast_impressions
checking field: ox_data_summary_zone_impression_history actual_impressions
found field actual_impressions
checking field: ox_images filename
found field filename
checking field: ox_images contents
found field contents
checking field: ox_log_maintenance_priority run_type
found field run_type
checking field: ox_password_recovery user_type
found field user_type
checking field: ox_password_recovery recovery_id
found field recovery_id
checking field: ox_preferences preference_name
found field preference_name
checking field: ox_preferences account_type
found field account_type
checking field: ox_session sessionid
found field sessionid
checking field: ox_trackers trackername
found field trackername
checking field: ox_trackers description
found field description
checking field: ox_trackers status
found field status
checking field: ox_trackers type
found field type
checking field: ox_users contact_name
found field contact_name
checking field: ox_users email_address
found field email_address
checking field: ox_users username
found field username
checking field: ox_users password
found field password
checking field: ox_users language
found field language
checking field: ox_variables variableid
found field variableid
checking field: ox_variables name
found field name
checking field: ox_variables description
found field description
checking field: ox_variables reject_if_empty
found field reject_if_empty
checking field: ox_variables variablecode
found field variablecode
checking field: ox_zones zonename
found field zonename
checking field: ox_zones description
found field description
checking field: ox_zones cost
found field cost
checking field: ox_zones cost_variable_id
found field cost_variable_id
checking field: ox_zones technology_cost
found field technology_cost
checking field: ox_zones rate
found field rate
checking field: ox_zones pricing
found field pricing
checking field: ox_zones ext_adselection
found field ext_adselection
#! database integrity check detected problems with the database
#! 279 fields to change
 

 

any ideas?

 

thank you

Share this post


Link to post
Share on other sites

On link /www/admin/install.php aplication is returning error Fatal error: Cannot use object of type MDB2_Error as array in /home/foo/htdocs/newRevive/lib/pear/MDB2/Driver/Reverse/mysql.php on line 100

 

Rather than commenting it out, try to var_dump the content and see what error you've got.

Share this post


Link to post
Share on other sites

It also looks to me like at some point in the past, you have managed to install OpenX twice into the one database?

 

So, if you look in your database, for example, do you see both a table called "acls" and one called "ox_acls"? (It looks like all the OpenX tables are duplicated, from the above error - each being there with and without an ox_ prefix.)

 

This is likely to cause all kinds of issues and confusion for the upgrade system! If you're able to make sure you have a good clean backup of your database, and then figure out which tables are valid, and remove the invalid ones, that would possibly help with some of the errors above.

Share this post


Link to post
Share on other sites

Hi,

 

sorry for the late reply. 

 

Rather than commenting it out, try to var_dump the content and see what error you've got.

 

$db->datatype->mapNativeDatatype($column) returned this

 

[error_message_prefix] =>   [mode] => 1   [level] => 1024  
 => -6   [message] => MDB2 Error: not supported   [userinfo] => _mapNativeDatatype: [Error message: unknown database attribute type: varbinary]   [Last executed query: SHOW COLUMNS FROM `ox_accounts` LIKE 'account_type']   [Native code: 0]

 

 

It also looks to me like at some point in the past, you have managed to install OpenX twice into the one database?

 

So, if you look in your database, for example, do you see both a table called "acls" and one called "ox_acls"? (It looks like all the OpenX tables are duplicated, from the above error - each being there with and without an ox_ prefix.)

 

This is likely to cause all kinds of issues and confusion for the upgrade system! If you're able to make sure you have a good clean backup of your database, and then figure out which tables are valid, and remove the invalid ones, that would possibly help with some of the errors above.

 

Sadly I didn`t managed this installation until recently, but there are no duplcites in my DB as far as I can see.

 

Any sugestions how to save this install?

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