Hello,
I have to migrate from Magento CE 1.9.1.1 to Magento CE 2.2.8 fresh install. I’m using your extension in version 3.1.8. I followed all steps in you file readme.
I started the wizard from the backend but when I select all categories and click on “Next step” I receive the following error:
Error 500
unserialize(): Error at offset 49145 of 49151 bytes
and I cannot to go to next step and try che migration. I have nginx installed with PHP-FPM 7.1 but nothing in Nginx’s error log.
How to solve?
6 answers
Hi Raffaele,
I am sorry for replying to you a bit late as we’ve just been back from our weekend.
Error 500
unserialize(): Error at offset 49145 of 49151 bytes
I have checked your instance and saw that issue occurred after you saved the settings in Step #3 of our module. The root cause of this issue was that your M1 database had a big volume of Attributes: Attribute Groups (789), Product Attributes (7912) and the current settings of ‘setting_data’ field in the table ‘ub_migrate_step’ couldn’t handle for that data volume.
I did help to change the setting for that field in your M2 database by running the following SQL: https://prnt.sc/r3cnqk
ALTER TABLE `ub_migrate_step` CHANGE `setting_data` `setting_data` LONGBLOB NULL DEFAULT NULL COMMENT 'Settings Data';
And the issue has been solved. Now you can continue with the settings in step #3 and other steps of our module: https://prnt.sc/r3crsm
Meanwhile, I saw the current M2 ver.2.2.8 and our UB Data Migration Pro ver.3.1.8 in your instance, you should consider to upgrade your M2 and use the latest Pro ver.3.2.3 as soon as possible.
Regards,
Mall.
Hi there,
Please provide me information about your instance:
+ Admin credentials of your M2 site
+ SSH credentials and let’s me know path to your M2 folder
+ phpMyadmin of your M2 database
I will help to check further and get back you then.
Regards,
Mall.
Hi Mall,
sure. Give me your email address. I have to sent you the SSH keys (we don’t use password). I don’t have phpMyAdmin but you can use Adminer if you prefer a web interface instead of using mysql from cli.
Hi Raffaele,
You can mark your reply private here, then it’s safe to share your site credentials in that private reply. Only you and our technical team can access.
Alternatively, you can send over to our email info (at) ubertheme.com.
Regards,
Ubertheme team
Hello,
I sent you an email with all connection details 🙂
Hello Mall,
nice job!
I’m using UB Data Migration Pro ver.3.1.8 cause I need to migrate from Magento 1.9.9.1 to Magento 2.8.8. I cannot migrate to later versions at moment ’cause not all installed extensions supports Magento > ver.2.8.8
Regards
