|
BikePort
|
June 10, 2018 at 9:41 am
Hi
I have EE 3 on my “old” site. Setting up a new site, and havee bought EE 4 now.
Want to export all data from EE3 and import in in EE4 in the new site/server.
Any “how to”?
|
|
BikePort
|
June 10, 2018 at 10:42 am
Another problem with this issue:
I have EE 3-1-15-p installed om my old site/server.
But I cant upgrade it to the latest EE 3, which I now have learn must be done first. How can I get this version upgraded?
|
|
Tony
|
June 11, 2018 at 3:04 am
Hi there,
I have EE 3-1-15-p installed om my old site/server.
But I cant upgrade it to the latest EE 3, which I now have learn must be done first. How can I get this version upgraded?
You can download a copy of 3.1.37.13 HERE.
We don’t’ currently have a how-to that will guide you through this but you will need to install the above version of EE3 to update the database tables to the latest version before moving forward (create a database backup of your site right now before doing the above, just to be safe).
Is it only the EE data you want to bring over to the new site, not the current site’s posts etc?
Is the new site on a new domain?
|
|
BikePort
|
June 11, 2018 at 3:41 am
Ok, so the procedure is like this if I understand you correctly?:
1: Deactivate 3.1.15 from the original site (the plugin data will not be lost?)
2: Install 3.1.37 on the original site so that the db tables are updated
3: Upgrade to 4.x (lastest version) on the original site
4: Install 4.x on the new site (on another host and url, but will be directed to the same domain after we are done)
5: Copy the db from the original site and import to the new site (in phpMyadmin?)
Please correct me if this is not correct before I move foreward
|
|
Tony
|
June 11, 2018 at 4:04 am
Whilst you could do that, it’s not how I would recommend doing it.
It depends on what details you want to copy over to the new site which is why I asked above, are you keeping all of the current posts etc or do you just want the EE data on the new site?
Why are you updating the ‘old’ site? Personally, I wouldn’t touch the old site’s data now, simply copy the ‘old’ sites DB to the new one (again how you do this depends on what data you want but you could use something like WP Migrate DB rather than phpMyAdmin to copy the tables), install EE3 on the new site so that you update the new site’s DB to EE3 3.1.37, de-activate and delete it from the new site again and install EE4 to migrate the data over on the new site.
That way you always have the old site as it was just in case you need it.
EE3 uses custom tables, you can copy those tables to any other DB and activate EE4 there, it will detect the tables and migrate the data over on that site. But, something to be mindful of is EE4 uses custom post types within the WP post table AND its own tables, meaning that once you’ve migrated from EE3 to EE4 it’s MUCH more difficult to only pull specific data from database to another.
So here are the steps I would follow.
1. Export the database from the old site as is, however you prefer to do this but you can not simply use phpMyAdmin to export the tables and import them into the new site as it may well have serialized objects/arrays which will need to be updated correctly.
2. Import the tables into the new site, assuming you are copying everything over this is easy enough but will need the domain references updated in the DB (you can’t do this with a simple search and replace).
3. On the NEW site install and activate EE3.1.37, then deactivate it again (no, you will not lose any data when deactivating/deleting the Event Espresso plugins).
4. Install EE4 on the NEW site and run through the migration process (it will detect you had EE3 on that site and offer to migrate the data over).
5. Customize/update/fix whatever you want to do on the new site and continue as you would.
|
|
BikePort
|
June 21, 2018 at 5:54 pm
I have tried your 1-5 step now 4 times and I never get the migration process to show up. I use WP migrate Db pro to move the tables over and they work fine on v EE3.1.37 after activating the plugin, but when deativating (or even deleting it as I have also tried) and installing EE¤, there is no mograte process to see. Please advice on how to fix this
|
|
Tony
|
June 22, 2018 at 3:10 am
Has EE4 ever been activated on the site before? The migration process will only happen the first time EE4 is activated, at the point there’s 2 options, 1 to migrate and another to start EE4 fresh, both of those options save an option to the database to prevent EE4 migrating again.
Assuming you are now working on the dev site, not live:
If you activate EE4 and go to:
Event Espresso -> Maintenance -> System information
Under ‘ee_activation_history’ what does it show there?
If EE4 has been activated previously we can reset it to start again, it should then pick up the EE3 tables and run the migration again. Before that, just to confirm, there’s nothing in EE4 on that site you need to keep, correct?
|
|
BikePort
|
June 23, 2018 at 4:25 am
Yes, since I hvae tried this 4 times now, EE4 has been activated before. And yes, I`m working on the dev-site.
ee_activation_history:
4.9.45.decaf
2017-09-01 11:48:43
4.9.62.decaf
2018-06-10 13:52:56
4.9.62.p
2018-06-10 15:04:17
2018-06-10 17:13:30
2018-06-11 14:19:30
2018-06-11 14:19:31
2018-06-16 08:40:16
3.1.37.12.L
unknown-date
And there is nothing in EE¤ at this point
|
|
Tony
|
June 23, 2018 at 5:30 am
Yeah EE4 was activated back in 2017 so it would have offered the migration then (if ee3 was used before then) and the option to start fresh used then or if EE4 was activated and then the site switched to EE3 the option still shows that ee4 had been active and prevents the migration.
You’ll need to reset EE4 to do the migration.
On the dev site go to Event Espresso -> Maintenance -> Reset/Delete Data
First try the ‘Reset Event Espresso Tables’ option.
If the migration option doesn’t show then, you’ll need to use the ‘Permanently Delete All Event Espresso Data’ option.
It should show the migration option then.
|
|
BikePort
|
June 23, 2018 at 6:12 am
Had to permanently delete all EE data to force migration option toi show up. Got a rather extensive list of missing registrations in the first part of the migration. Here are a couple of examples:
“Could not find new registrations for old attendee 1 when creating answer {“id”:”1″,”registration_id”:”4ec3624f0dd842.37946564″,”attendee_id”:”1″,”question_id”:”1″,”answer”:”Elizabeth”}”
“Could not find primary attendee’s new transaction. Current attendee is: {“id”:”21″,”registration_id”:”4ec54cb9f0ced1.41282964″,”lname”:”Kobber\u00f8s”,”fname”:”Elizabeth”,”address”:””,”address2″:””,”city”:”Vikhammer”,”state”:””,”zip”:””,”country_id”:””,”organization_name”:””,”vat_number”:null,”email”:”elizabeth@bikeport.no”,”phone”:”92082072″,”date”:”2011-11-17 19:04:41″,”payment”:””,”payment_status”:”Completed”,”txn_type”:””,”txn_id”:null,”amount_pd”:”2990.00″,”total_cost”:”0.00″,”price_option”:”RR ACR 27-29 juli 2012″,”coupon_code”:””,”quantity”:”1″,”payment_date”:”0″,”event_id”:”4″,”event_time”:”08:00″,”end_time”:”19:00″,”start_date”:”2012-07-27″,”end_date”:”2012-07-29″,”attendee_session”:”f81433cc35f4103cbb834142ad7d558f”,”transaction_details”:null,”pre_approve”:”1″,”checked_in”:”0″,”checked_in_quantity”:”0″,”hashSalt”:null,”is_primary”:”0″,”orig_price”:”0.00″,”final_price”:”0.00″}, we think the 3.1 primary attendee for it has id 0, but there’s no 4.1 transaction for that primary attendee id.”
Any reason why these where not succsessfylly migrated?
|
|
Josh
|
June 25, 2018 at 8:45 am
Usually that will happen if those attendee records had been deleted while Event Espresso 3 was still active, where the answers to the registration form questions were left behind without the attendee record. The answers to registration form questions and attendee records are stored in separate database tables.
|
