Antonio Venneri
February 11, 2015 at 3:38 pm
Hi, last week I tried to migrate to 4.6 and after notice there is something not translated (I’ve read the post related to missing translation) I decide to come back to 4.4.10p
I restored the plugin and ALL the *esp* tables. I forgot to restore the wp_options table.
I’ve seen in the maintenance information and system information tab I have a “property” called ee_migration_history the report the migration to 4.5 and 4.6.
In raw data I have:
(
[ee_version] => 4.4.10.p
[ee_activation_history] => Array
(
[4.4.10.p] => Array
(
[0] => 2015-02-11 21:33:49
)
)
but in the section below I have:
[ee_migration_history] => Array
(
[Core.4.5.0] => Array
(
[_migrating] => 0
[_migration_stages] => Array
(
[0] => Array
(
[_old_table] => wp_esp_ticket
[_extra_where_sql] =>
[_records_to_migrate] => 33
[_records_migrated] => 33
[_status] => status_completed
[_pretty_name] => Ticket
[_errors] => Array
(
)
[class] => EE_DMS_4_5_0_update_wp_user_for_tickets
)
[1] => Array
(
[_old_table] => wp_esp_price
[_extra_where_sql] =>
[_records_to_migrate] => 35
[_records_migrated] => 35
[_status] => status_completed
[_pretty_name] => Prezzi
[_errors] => Array
(
)
[class] => EE_DMS_4_5_0_update_wp_user_for_prices
)
[2] => Array
(
[_old_table] => wp_esp_price_type
[_extra_where_sql] =>
[_records_to_migrate] => 7
[_records_migrated] => 7
[_status] => status_completed
[_pretty_name] => Tipo Tariffe
[_errors] => Array
(
)
[class] => EE_DMS_4_5_0_update_wp_user_for_price_types
)
[3] => Array
(
[_old_table] => wp_esp_question_group
[_extra_where_sql] =>
[_records_to_migrate] => 3
[_records_migrated] => 3
[_status] => status_completed
[_pretty_name] => Gruppi di Domande
[_errors] => Array
(
)
[class] => EE_DMS_4_5_0_update_wp_user_for_question_groups
)
[4] => Array
(
[_records_to_migrate] => 1
[_records_migrated] => 1
[_status] => status_completed
[_pretty_name] => Update Invoice Gateway Settings
[_errors] => Array
(
)
[class] => EE_DMS_4_5_0_invoice_settings
)
)
[_schema_changes_before_migration_ran] => 1
[_schema_changes_after_migration_ran] => 1
[_feedback_message] => Migrati 1 record con successo durante Update Invoice Gateway Settings<br>Migrati 3 record con successo durante Gruppi di Domande<br>Migrati 7 record con successo durante Tipo Tariffe<br>Migrati 18 record con successo durante Prezzi
[_priority] => 10
[_records_to_migrate] => 79
[_records_migrated] => 79
[_status] => status_completed
[_pretty_name] => Data Migration to Event Espresso 4.5.0.P
[_errors] => Array
(
)
[class] => EE_DMS_Core_4_5_0
)
[Core.4.6.0] => Array
(
[_migrating] => 1
[_migration_stages] => Array
(
[0] => Array
(
[_new_table_name] => wp_esp_payment_method
[_extra_meta_table_name] => wp_esp_extra_meta
[_currency_table_name] => wp_esp_currency
[_currency_payment_method_table_name] => wp_esp_currency_payment_method
[_gateway_we_know_to_migrate] => Array
(
[0] => Aim
[1] => Bank
[2] => Check
[3] => Invoice
[4] => Mijireh
[5] => Paypal_Pro
[6] => Paypal_Standard
)
[_records_to_migrate] => 7
[_records_migrated] => 7
[_status] => status_completed
[_pretty_name] => Gateways
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_gateways
)
[1] => Array
(
[_currency_table_name] => wp_esp_currency
[_currency_payment_method_table_name] => wp_esp_currency_payment_method
[_payment_method_table_name] => wp_esp_payment_method
[_gateway_currencies] => Array
(
[Aim] => Array
(
[0] => AUD
[1] => USD
[2] => CAD
[3] => EUR
[4] => GBP
[5] => NZD
)
[Bank] => all
[Check] => all
[Invoice] => all
[Mijireh] => all
[Paypal_Pro] => Array
(
[0] => USD
[1] => GBP
[2] => CAD
[3] => AUD
[4] => BRL
[5] => CHF
[6] => CZK
[7] => DKK
[8] => EUR
[9] => HKD
[10] => HUF
[11] => ILS
[12] => JPY
[13] => MXN
[14] => MYR
[15] => NOK
[16] => NZD
[17] => PHP
[18] => PLN
[19] => SEK
[20] => SGD
[21] => THB
[22] => TRY
[23] => TWD
)
[Paypal_Standard] => Array
(
[0] => USD
[1] => GBP
[2] => CAD
[3] => AUD
[4] => BRL
[5] => CHF
[6] => CZK
[7] => DKK
[8] => EUR
[9] => HKD
[10] => HUF
[11] => ILS
[12] => JPY
[13] => MXN
[14] => MYR
[15] => NOK
[16] => NZD
[17] => PHP
[18] => PLN
[19] => SEK
[20] => SGD
[21] => THB
[22] => TRY
[23] => TWD
)
)
[_records_to_migrate] => 662
[_records_migrated] => 662
[_status] => status_completed
[_pretty_name] => Payment Method Currencies
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_payment_method_currencies
)
[2] => Array
(
[_question_type_conversions] => Array
(
[MULTIPLE] => CHECKBOX
[SINGLE] => RADIO_BTN
)
[_old_table] => wp_esp_question
[_extra_where_sql] => WHERE QST_type IN ('MULTIPLE', 'SINGLE', 'CHECKBOX', 'RADIO_BTN')
[_records_to_migrate] => 0
[_records_migrated] => 0
[_status] => status_completed
[_pretty_name] => Question Types
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_question_types
)
[3] => Array
(
[_old_table] => wp_esp_question
[_extra_where_sql] => WHERE QST_system = 'country'
[_records_to_migrate] => 1
[_records_migrated] => 1
[_status] => status_completed
[_pretty_name] => Stato - Domanda di Sistema
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_country_system_question
)
[4] => Array
(
[_old_table] => wp_esp_question
[_extra_where_sql] => WHERE QST_system = 'state'
[_records_to_migrate] => 1
[_records_migrated] => 1
[_status] => status_completed
[_pretty_name] => State - System Question
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_state_system_question
)
[5] => Array
(
[_old_table] => wp_postmeta
[_extra_where_sql] => WHERE meta_key LIKE 'billing_info_%'
[_records_to_migrate] => 0
[_records_migrated] => 0
[_status] => status_completed
[_pretty_name] => Billing Info
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_billing_info
)
[6] => Array
(
[_transaction_table] => wp_esp_transaction
[_payment_method_table] => wp_esp_payment_method
[_old_table] => wp_esp_extra_meta
[_extra_where_sql] => WHERE EXM_key = 'gateway' AND EXM_type = 'Transaction'
[_records_to_migrate] => 0
[_records_migrated] => 0
[_status] => status_completed
[_pretty_name] => Transaction Payment Method Relations
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_transactions
)
[7] => Array
(
[_payment_method_table] => wp_esp_payment_method
[_old_table] => wp_esp_payment
[_extra_where_sql] =>
[_records_to_migrate] => 0
[_records_migrated] => 0
[_status] => status_completed
[_pretty_name] => Payment-Payment Method Relations
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_payments
)
[8] => Array
(
[_records_to_migrate] => 1
[_records_migrated] => 1
[_status] => status_completed
[_pretty_name] => Update Invoice Settings
[_errors] => Array
(
)
[class] => EE_DMS_4_6_0_invoice_settings
)
)
[_schema_changes_before_migration_ran] => 1
[_schema_changes_after_migration_ran] => 1
[_feedback_message] => Migrati 1 record con successo durante Update Invoice Settings<br>Migrati 0 record con successo durante Payment-Payment Method Relations<br>Migrati 0 record con successo durante Transaction Payment Method Relations<br>Migrati 0 record con successo durante Billing Info<br>Migrati 1 record con successo durante State - System Question<br>Migrati 1 record con successo durante Stato - Domanda di Sistema<br>Migrati 0 record con successo durante Question Types<br>Migrati 19 record con successo durante Payment Method Currencies
[_priority] => 10
[_records_to_migrate] => 672
[_records_migrated] => 672
[_status] => status_completed
[_pretty_name] => Data Migration to Event Espresso 4.6.0.P
[_errors] => Array
(
)
[class] => EE_DMS_Core_4_6_0
)
)
Josh
February 11, 2015 at 6:06 pm
Add New Note to this Reply
Hi there,
Since you forgot to restore the wp_options table, what you could do is go in to phpmyadmin and look in your wp_options table for the option records that start with the names “ee_data_migration” then you remove the one for 4.6.
Antonio Venneri
February 12, 2015 at 8:13 am
Add New Note to this Reply
Excellent, i will try in my dev environment.
I noticed that there is a parameter in ee_data_migration_current_db_state referring to new realease.
Should i remove or change something?
a:6:{s:4:"Core";s:7:"4.6.5.p";s:21:"Events_Table_Template";s:7:"1.3.2.p";s:14:"Social_Buttons";s:5:"1.0.p";s:8:"Calendar";s:7:"3.2.1.p";s:13:"Grid_Template";s:7:"1.2.1.p";s:9:"MailChimp";s:7:"2.1.1.p";}
Josh
February 12, 2015 at 9:05 am
Add New Note to this Reply
So that’s serialized data, which means you need to be very careful editing it.
A less error-prone way to make the edit would be to find the same array in your backup’s options table and restore that value in full.
Antonio Venneri
February 18, 2015 at 5:52 am
Add New Note to this Reply
Many thanks.
It works!