Migration Tool Step 8 – Incorrect integer value

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

Profile photo of Mall Staff 184060.00 $tone April 8, 2016
Public

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.

#1
Profile photo of Mall Staff 184060.00 $tone April 11, 2016
Public

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.

#3

Please login or Register to Submit Answer

Written By

Comments