PHP Error[8]: unserialize(): Error at offset 205 o

Answered

Public

jukebox-revival asked October 30, 2017

Hello,

I get this error in step 7 of the migration:
…………………………………………………………………..PHP Error[8]: unserialize(): Error at offset 205 of 769 bytes
in file /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php at line 1817
#0 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1817): unserialize()
#1 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(2700): Step7Controller->_convertProductOptions()
#2 /home/jukeboxs/public_html/pub/ub-tool/protected/controllers/Step7Controller.php(1294): 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()

UB Data Migration Pro

3 answers

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 31, 2017

Public

Hi jukebox-revival,

I get this error in step 7 of the migration:
…………………………………………………………………..PHP Error[8]: unserialize(): Error at offset 205 of 769 bytes

Let’s provide me the admin credentials, ssh credentials and web root path of your Magento2 instance.
I will check further and help you out.
Regards,
Mall.

Vote Up

Vote Down

Mall ⋅ Staff ⋅184060.00 $tone October 31, 2017

Public

Hi there,

I get this error in step 7 of the migration:
…………………………………………………………………..PHP Error[8]: unserialize(): Error at offset 205 of 769 bytes

I have checked your instance and added some tweak codes to debug in the step #7 of our tool. I found the root of issue as per this screenshot: https://prnt.sc/h489kz
This issue was because the table named ‘sales_flat_order_item’ in your Magento1’s database has at least one record with the value of the ‘product_options’ field which was not a standard Serialized string (the record with item_id = 196004). This caused the issue as you saw.
To solve that, you must exclude or remove that value. You could make that to Null value by running the following SQL command (Please make sure you backup your M1’s database before running the command):

Update sales_flat_order_item Set product_options = NULL where item_id = 196004;

Once done, you could continue with data migration in the step #7 of our tool using the CLI command:
php -f bin/ubdatamigration run --step=7
And let me know how it goes then.
Regards,
Mall.