Getting this error @ step 8, any ideeas?
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'Q뮪' for column 'remote_ip_long' at row 1. The SQL statement executed was: INSERT INTO `rating_option_vote` (`option_id`, `remote_ip_long`, `customer_id`, `entity_pk_value`, `rating_id`, `percent`, `value`, `vote_id`, `remote_ip`, `review_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)
3 answers
Hi Pelle Andersson,
Can you provide me more information about your working?
What version of this tool you are using? Where did you download it?
That issue because Magento 2 was has some new rules in database table `rating_option_vote`
and you have some bad data in the table `rating_option_vote` with `remote_ip_long` column. (Incorrect integer value: ‘Q뮪’ for column ‘remote_ip_long’)
See more new changes in Magento2:
- Magento 1: http://i.imgur.com/zv6wrLk.png
- Magento 2: http://i.imgur.com/xk9rQco.png
To solve that issue, let open your Magento 1 database and run below SQL:
UPDATE `rating_option_vote` SET `remote_ip_long` = 0;
and press the ‘Reset’ button and restart the migration on this step.
and let’s me know how it goes.
Regards,
Mall.
Hi Mall,
Using the latest version from https://github.com/ubertheme/module-ubdatamigration/archive/v1.0.4.zip
Please let me test your changes later, and then get back to you again.
Thanks for your help, much appreciated!
Hi Pelle Andersson,
Yes, let’s contact me if you need further assistance!
In case you want to use our service, let’s submit at: https://www.ubertheme.com/magento-custom-services/
Best Regards,
Mall.
