When updating step 7 I get this error:
.PHP Error[8]: unserialize(): Error at offset 0 of 5 bytes
in file /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 1833
#0 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1833): unserialize()
#1 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(2812): Step7Controller->_convertProductOptions()
#2 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1306): Step7Controller->_migrateSalesOrderItem()
#3 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(246): Step7Controller->_migrateSalesOrders()
#4 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(58): Step7Controller->actionRun()
#5 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(28): RunCommand->_migrateData()
#6 unknown(0): RunCommand->actionIndex()
#7 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#8 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#9 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#10 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#11 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#12 /home/jukeboxs/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#13 /home/jukeboxs/public_html/bin/ubdatamigration(4): require_once()
[jukeboxs@mp31 public_html]$
14 answers
Hi there,
.PHP Error[8]: unserialize(): Error at offset 0 of 5 bytes
in file /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 1833
Kindly provide me the admin credentials, ssh credentials and web root path of your M2 instance. I will check further and get back you soon.
Regards,
Mall.
Hi there,
Yes, please pause all your activities at your end. I’m checking in your instance now.
Regards,
Mall.
Hi there,
I have tried run the CLI command: php -f bin/ubdatamigration run --step=7 --mode=update
And i see it working fine: http://i.prntscr.com/JeBe18_gSA61TbuZQL361Q.png
Because your database has big volume of sales data, so i can’t run continue at my end now.
Please help to continue with data migration in the step #7 by run at your end the CLI command: (without mode=update now)
php -f bin/ubdatamigration run --step=7
And tell me know how it goes then.
Regards,
Mall.
Its running now and generates a lot of output. Normally it takes some hours to complete.
Hi there,
Its running now and generates a lot of output.
Yes, i have added more debug code to find the data record which raised the issue as you mentioned.
Normally it takes some hours to complete.
Yes, please continue and tell me know the error message if you get at your end.
Regards,
Mall.
Hello,
Same error. This is the last part of the output:
a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:120:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvYnVpemVuL2pqLWJ1aXplbi9idWlzLWVjYzgyLTEyYXU3LWpqLmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:3:”572″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”8″;}}
a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:144:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvYnVpemVuL2pqLWJ1aXplbi9idWlzLWVjYzgzLXMtMTJheDctNzAyNS1qai10d2VlLXN0dWtzLmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”4703″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”3″;}}
a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:148:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvYWxnZW1lbmUtb25kZXJkZWxlbi9rbm9icy9rbm9icy1wbGFzdGljL2t1bnN0c3RvZi1rbm9wLTQtZi5odG1sP19fX1NJRD1V”;s:7:”product”;s:4:”5976″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:2:”10″;}}
a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:104:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvd2VlcnN0YW5kLTUta29obS0xNS13YXR0Lmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”5125″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”1″;}}
….a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:88:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvaGFha3NsdWl0aW5nLmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”2927″;s:8:”form_key”;s:16:”KJNmPlYSU21OQcnj”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”2″;}}
….a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:104:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcva2V5Ym9hcmQtbGF0Y2gtc29sZW5vaWQuaHRtbD9fX19TSUQ9VQ,,”;s:7:”product”;s:3:”930″;s:8:”form_key”;s:16:”gIgpDhUpcTWdCnwQ”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”1″;}}
….a:2:{s:15:”info_buyRequest”;a:6:{s:4:”uenc”;s:168:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvc2VlYnVyZy1hZnN0YW5kLWJlZGllbmluZy1ncmlqcy5odG1sP19fX1NJRD1VJl9fX2Zyb21fc3RvcmU9ZGVmYXVsdCZfX19zdG9yZT1kZWZhdWx0X25s”;s:7:”product”;s:4:”6892″;s:8:”form_key”;s:16:”H9C4Q0Wtd0d9EPeb”;s:15:”related_product”;s:0:””;s:7:”options”;a:3:{i:7;s:2:”17″;i:8;s:2:”23″;i:9;s:12:”seeburg V200″;}s:3:”qty”;s:1:”1″;}s:7:”options”;a:3:{i:0;a:7:{s:5:”label”;s:12:”Lengte kabel”;s:5:”value”;s:7:”5 meter”;s:11:”print_value”;s:7:”5 meter”;s:9:”option_id”;s:1:”7″;s:11:”option_type”;s:9:”drop_down”;s:12:”option_value”;s:2:”17″;s:11:”custom_view”;b:0;}i:1;a:7:{s:5:”label”;s:14:”Mono of stereo”;s:5:”value”;s:4:”Mono”;s:11:”print_value”;s:4:”Mono”;s:9:”option_id”;s:1:”8″;s:11:”option_type”;s:5:”radio”;s:12:”option_value”;s:2:”23″;s:11:”custom_view”;b:0;}i:2;a:7:{s:5:”label”;s:16:”Uw model jukebox”;s:5:”value”;s:12:”seeburg V200″;s:11:”print_value”;s:12:”seeburg V200″;s:9:”option_id”;s:1:”9″;s:11:”option_type”;s:5:”field”;s:12:”option_value”;s:12:”seeburg V200″;s:11:”custom_view”;b:0;}}}
….false
PHP Error[8]: unserialize(): Error at offset 0 of 5 bytes
in file /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 1835
#0 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1835): unserialize()
#1 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(2814): Step7Controller->_convertProductOptions()
#2 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1306): Step7Controller->_migrateSalesOrderItem()
#3 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(246): Step7Controller->_migrateSalesOrders()
#4 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(58): Step7Controller->actionRun()
#5 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(28): RunCommand->_migrateData()
#6 unknown(0): RunCommand->actionIndex()
#7 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#8 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#9 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#10 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#11 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#12 /home/jukeboxs/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#13 /home/jukeboxs/public_html/bin/ubdatamigration(4): require_once()
Hi there,
I have rechecked and see the issue related to a bad serialize string data in at least once record in value of ‘product_options’ field in the table ‘sales_flat_order_item’
a:2:{s:15:”info_buyRequest”;a:6:{s:4:”uenc”;s:168:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvc2VlYnVyZy1hZnN0YW5kLWJlZGllbmluZy1ncmlqcy5odG1sP19fX1NJRD1VJl9fX2Zyb21fc3RvcmU9ZGVmYXVsdCZfX19zdG9yZT1kZWZhdWx0X25s”;s:7:”product”;s:4:”6892″;s:8:”form_key”;s:16:”H9C4Q0Wtd0d9EPeb”;s:15:”related_product”;s:0:””;s:7:”options”;a:3:{i:7;s:2:”17″;i:8;s:2:”23″;i:9;s:12:”seeburg V200″;}s:3:”qty”;s:1:”1″;}s:7:”options”;a:3:{i:0;a:7:{s:5:”label”;s:12:”Lengte kabel”;s:5:”value”;s:7:”5 meter”;s:11:”print_value”;s:7:”5 meter”;s:9:”option_id”;s:1:”7″;s:11:”option_type”;s:9:”drop_down”;s:12:”option_value”;s:2:”17″;s:11:”custom_view”;b:0;}i:1;a:7:{s:5:”label”;s:14:”Mono of stereo”;s:5:”value”;s:4:”Mono”;s:11:”print_value”;s:4:”Mono”;s:9:”option_id”;s:1:”8″;s:11:”option_type”;s:5:”radio”;s:12:”option_value”;s:2:”23″;s:11:”custom_view”;b:0;}i:2;a:7:{s:5:”label”;s:16:”Uw model jukebox”;s:5:”value”;s:12:”seeburg V200″;s:11:”print_value”;s:12:”seeburg V200″;s:9:”option_id”;s:1:”9″;s:11:”option_type”;s:5:”field”;s:12:”option_value”;s:12:”seeburg V200″;s:11:”custom_view”;b:0;}}}
To continue, you must delete that record in your M1’s database by run SQL command:
Delete From sales_flat_order_item Where product_options Like '%aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvc2VlYnVyZy1hZnN0YW5kLWJlZGllbmluZy1ncmlqcy5odG1sP19fX1NJRD1VJl9fX2Zyb21fc3RvcmU9ZGVmYXVsdCZfX19zdG9yZT1kZWZhdWx0X25s%';
Once done, you could continue with data migration in the step #7 by run CLI command:
php -f bin/ubdatamigration run --step=7
And tell me know how it goes then.
Regards,
Mall.
Strange. This is an old order that processed ok in the previous version.
Anyway I deleted the record and tried again. No luck in a few seconds this error came up:
[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:144:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvYnVpemVuL2pqLWJ1aXplbi9idWlzLWVjYzgzLXMtMTJheDctNzAyNS1qai10d2VlLXN0dWtzLmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”4703″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”3″;}}]
[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:148:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvYWxnZW1lbmUtb25kZXJkZWxlbi9rbm9icy9rbm9icy1wbGFzdGljL2t1bnN0c3RvZi1rbm9wLTQtZi5odG1sP19fX1NJRD1V”;s:7:”product”;s:4:”5976″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:2:”10″;}}]
[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:104:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvd2VlcnN0YW5kLTUta29obS0xNS13YXR0Lmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”5125″;s:8:”form_key”;s:16:”JsOTgk1UKVzMaRVl”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”1″;}}]
….[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:88:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcvaGFha3NsdWl0aW5nLmh0bWw_X19fU0lEPVU,”;s:7:”product”;s:4:”2927″;s:8:”form_key”;s:16:”KJNmPlYSU21OQcnj”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”2″;}}]
….[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:104:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcva2V5Ym9hcmQtbGF0Y2gtc29sZW5vaWQuaHRtbD9fX19TSUQ9VQ,,”;s:7:”product”;s:3:”930″;s:8:”form_key”;s:16:”gIgpDhUpcTWdCnwQ”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”1″;}}]
……..[false]
PHP Error[8]: unserialize(): Error at offset 0 of 5 bytes
in file /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 1835
#0 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1835): unserialize()
#1 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(2814): Step7Controller->_convertProductOptions()
#2 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1306): Step7Controller->_migrateSalesOrderItem()
#3 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(246): Step7Controller->_migrateSalesOrders()
#4 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(58): Step7Controller->actionRun()
#5 /home/jukeboxs/public_html/pub/ub-tool/protected/commands/RunCommand.php(28): RunCommand->_migrateData()
#6 unknown(0): RunCommand->actionIndex()
#7 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#8 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#9 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#10 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#11 /home/jukeboxs/public_html/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#12 /home/jukeboxs/public_html/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#13 /home/jukeboxs/public_html/bin/ubdatamigration(4): require_once()
[jukeboxs@mp31 public_html]$
Deleteing the record also caused an error in Magento 1 displaying the order. It is also not possible anymore to see the invoice nor any other order details. Not a good idea to delete it!
Hi there,
[a:1:{s:15:”info_buyRequest”;a:5:{s:4:”uenc”;s:104:”aHR0cHM6Ly93d3cuanVrZWJveC1yZXZpdmFsLmV1L3N0YWdpbmcva2V5Ym9hcmQtbGF0Y2gtc29sZW5vaWQuaHRtbD9fX19TSUQ9VQ,,”;s:7:”product”;s:3:”930″;s:8:”form_key”;s:16:”gIgpDhUpcTWdCnwQ”;s:15:”related_product”;s:0:””;s:3:”qty”;s:1:”1″;}}]
……..[false]
PHP Error[8]: unserialize(): Error at offset 0 of 5 bytes
As you see that is another case in other record.
Not a good idea to delete it!
But as you see, that value is not standard of serialize string. Let’s pause at your end. I will check further and get back you soon.
Regards,
Mall.
Hi there,
I have checked further in your working and see the root issue because your database has some records has null value of the product_options filed in the table sales_flat_order_item and it’s value was converted to string ‘false’ by our tool in first migration.
And this was raised errors as you see when you rerun data migration with mode update in the step #7.
To handle for this case, I have added more tweak code in step #7 of our tool at: pub/ub-tool/protected/controllers/Step7Controller.php
And now you could continue with data migration in the step #7 of our tool by continue run CLI command:
php -f bin/ubdatamigration run --step=7
Pls: If you have deleted the record in table sales_flat_order_item as my suggesting in reply #8. Please help to revert this record before run continue in the step #7.
Thanks for your understanding.
Regards,
Mall.
Now it did work ok.
Thanks again
Hi there,
Yeah, let’s continue and contact me if you need further assistance.
Regards,
Mall.
