Support

Home Forums Event Espresso Premium Migration to 4.6 and restore to 4.4.10

Migration to 4.6 and restore to 4.4.10

Posted: February 11, 2015 at 3:38 pm

Viewing 4 reply threads


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

  • Support Staff

February 11, 2015 at 6:06 pm

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

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

  • Support Staff

February 12, 2015 at 9:05 am

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

Many thanks.
It works!

Viewing 4 reply threads

The support post ‘Migration to 4.6 and restore to 4.4.10’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso