Various issues with migration

Resolved dev
(@devksec)

4 years, 4 months ago

Hello,

We’ve had a large number of issues when moving a subsite to standalone installation. The store is a woocommerce store and most of the plugins settings were lost and had to be reconfigured.

Currently we have the following unresolved issues:
1. Woocommerce orders are unlinked to user accounts (When viewing an order the user account is not associated)

Plugins which settings were lost or not working:
1. Wordfence – Had to be reset/lost settings & license
2. Ithemes security – Had to be reset/lost settings
3. Total cache – Setting corrupted and caused errors, had to be reset
4. WP DB Cleaner pro – Lost cleaning schedules and license
5. Yoast SEO – lost license
6. WP Activity log – Setting corrupted and caused errors, had to be uninstalled/reinstalled and clean settings
7. Kirki customiser – had to be uninstalled/reinstalled as fonts were lost
8. Compliaz – had to be resetup
9. Media cloud – Freemius broke and got stuck in setup loop. Uninstalled re-installed
10. Mycrypto Checkout – broke account setup. Uninstalled re-installed
11. wp-lister – Lost account settings (had to be refreshed)
12. automatic plugin updates – update settings would not save and were lost. Uninstalled re-installed
14. Login No captcha recaptcha – SQL error causing deadlock SELECT * FROMwp_optionsWHEREoption_name= 'login_nocaptcha_working';

The most important one is the woocommerce orders. The rest we have resolved manually.

Any help would be appreciated.

Viewing 12 replies - 31 through 42 (of 42 total)

← 1 2 3

Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

Here is the multisite compatible version of the hotfix script.

This works exactly like the standalone version except that it is multisite compatible. You need super admin rights to execute this and should be activated on the target subsite (not network activated) where you need to do the adjustment.

Make sure to backup your dB before doing this and enable WP debugging. We tested this one here and works great. Thanks!

Thread Starter dev
(@devksec)

4 years, 3 months ago

Just managed to run this on the site and it has worked, thanks again 🙂

Will be doing the future migrations soon with the latest version (inc fix) so should be resolved now.

Anymore issues and I’ll report back here.

Thread Starter dev
(@devksec)

4 years, 3 months ago

So we’ve migrated another store with the latest pro version of the plugin. Customers cannot see the orders within their order history however they are assigned within the order details.

Has something been missed with the pro version or is there something else that needs aligning for it to appear in their account?

Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

Hi dev, thanks for the feedback. Since you are referring to plugin PRO version – can you please send us the details on our PRO support channel so we can continue there. We are not allowed to support PRO versions here in this forum.

You can send us some screenshots on where to see this issue and how to reproduce it. The latest version should be able to migrate the order details history. Thanks.

Thread Starter dev
(@devksec)

4 years, 3 months ago

Update

We’ve had it confirmed with the multisite-patch run store as well. The order in WC order details shows the correct customer being assigned yet its not in their order history.

This order has come in after the patch was run. It seems like order history has just broken and not working.

This migration was done with the free one then patched.

Thread Starter dev
(@devksec)

4 years, 3 months ago

I’m unable to replicate it with a manually made new order however.

Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

As an update – we are going to release version 1.4.9 tomorrow. This includes the latest WC related migration fixes (including the beta fixes). For now -it would be best to hold off the migrations until version 1.4.9 is ready.

I suggest that once this is released – please re-migrate the original package using 1.4.9 and check if you still have the issue. Also double check if the source site does not have this issue – otherwise the issue will carry over to the target site.

Once the source site does not have the issue and you have the issue only after migration using version 1.4.9 – let’s continue the discussion on the opened ticket you have in our system. Please let me know and we will then request more details on the issue. thanks!

Thread Starter dev
(@devksec)

4 years, 3 months ago

Hello,

Theses sites are already live so cannot be re-migrated over. The source site did not have this issue at all.

There 2 woocommerce sites that we were migrating. Both of which are now completed and we need to fix these issues.

What needs to be updating code wise/cause of the issue ?

Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

Thanks, I see that’s fine. I’m trying to understand the issue. Can you please sample an affected user with an order and take note of a order post ID? And then once you have the post ID – can you please check the value of meta key _customer_user in post meta table for that corresponding post ID order?

This customer_user meta value should match with the migrated user ID. Otherwise the order history won’t be displayed correctly in user My Account -> Orders . Does the user ID match?

Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

The fix for the customer order history issue (orders not appearing in customer accounts after migration) was already added in version Prime Mover 1.4.8 (current release – both free and pro versions). If the site is migrated with Prime Mover 1.4.7 – a hotfix script was added to fix this (which you have successfully run already). So it’s strange you still have this issue.

You can also try clearing your site cache (either using a plugin or built-in cache) provided by the host. And see if it clears. It’s possible that a host uses some persistent cache that is not cleared after migration.

If you are referring to a new/different issue – please help me understand and describe the issue in details by showing some screenshots or examples. Thanks! 🙂
Thread Starter dev
(@devksec)

4 years, 3 months ago
Hello,

— About the migration patch fixed instance

The _customer_user is correctly matched with the right customer and POST ID in those tables.

I’ve checked 2 orders from the same customer and they’re both ok. However they’re still not able to see any of their order history.

Creating new orders is ok, just pre-migration ones.

Does WC require any other metadata or info for order history ? I’m not sure what is a miss.

The issue is customers pre-migration cannot see any of their order history. They seem ok from the WC admin and also DB side.
- This reply was modified 4 years, 3 months ago by dev.
Plugin Author Codexonics
(@codexonics)

4 years, 3 months ago

As far as we know it by looking at the WC code – it’s only dependent on _customer_user. This is what they use to query orders belonging to that specific user. We cannot reproduce this scenario in our end if the customer order association is correct but it won’t appear in order history.

It would be hard to debug this without getting real data. If you like us to debug this one, you can install this debug plugin in the affected site or a clone of a site (in your test site). Enable WP_DEBUG and WP_DEBUG_LOG to true. Logged-in as affected customer (or you can use the user switching plugin).

And then go to My Account -> Orders and view the order history. The debug plugin automatically generates debug.log output to wp-content directory. Please send it to us here. Once generated – please deactivate the plugin.

We will take a look at the data and analyze why the order history won’t show the orders even if the dB side is fine.

Viewing 12 replies - 31 through 42 (of 42 total)

← 1 2 3

The topic ‘Various issues with migration’ is closed to new replies.