[Unable To Upgrade 2.8 To 3.0.2]

OK, I just disabled the compatibilty check and the upgrade seems to be successful.

 

thanks

[Unable To Upgrade 2.8 To 3.0.2]

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?

[Unable To Upgrade 2.8 To 3.0.2]

Anyone?

[Unable To Upgrade 2.8 To 3.0.2]

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