Hello,
I’ve this error at step 7 :
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe pr├
¿s de ‘S DAY’ LIMIT 1′ ├á la ligne 1. The SQL statement executed was: SELECT * FROM `salesrule_coupon` `t` WHERE code = ‘DAD’S DAY’ LI
MIT 1
this is the line of my salesrule_coupon table :
133
3
DAD’S DAY
100000
0
1
2017-06-19 00:00:00
1
2013-08-02 13:52:30
0
and the error in step 8 :
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘l?’ 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`, `remote_ip`, `review_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6,
:yp7, :yp8)
thanks in advance
12 answers
Hi there,
¿s de ‘S DAY’ LIMIT 1′ ├á la ligne 1. The SQL statement executed was: SELECT * FROM `salesrule_coupon` `t` WHERE code = ‘DAD’S DAY’ LI
That issue because your database has some special characters in the value of ‘code‘ field in the table salesrule_coupon. To handle that case, you could do following steps:
Step 1: Open the php file at path: pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code line:
$coupon2 = Mage2SalesruleCoupon::model()->find("code = '{$coupon->code}'");
and replace it by code lines:
$code2 = addslashes($coupon->code);
$coupon2 = Mage2SalesruleCoupon::model()->find("code = '{$code2}'");
Step 2: Once done, you can continue with data migration in the step #7.
And tell me know how it goes.
Regards,
Mall.
I’ve done the changes and the error is still here :/
Hi there
I’ve done the changes and the error is still here :/
So, let’s provide me the ssh credentials and web root path of your Magento2. I will check further and reply you more later.
Regards,
Mall.
I’ve solved it bu deleting the ‘ in the name of the coupon in the table, the error of the step 8 it’s because i need to do the step 7 before ?
Hi there,
I’ve solved it bu deleting the ‘ in the name of the coupon in the table, the error of the step 8 it’s because i need to do the step 7 before ?
Yes, let’s finish data migration in the step #7 and then, you can continue in step #8 of our tool.
And contact me if you need further assistance.
Regards,
Mall.
Step 7 ok now i’ve run the step 8 and i’ve this error
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘l?’ 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`, `remote_ip`, `review_id`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6,
:yp7, :yp8)
Hi there,
1366 Incorrect integer value: ‘l?’ for column
‘remote_ip_long’ at row 1. The SQL statement executed was: INSERT INTO `rating_option_vote`
That issue because your database has some records with bad data in the table rating_option_vote . Some records has bad value of field named remote_ip_long. You should clean these records from your Magento1 database. And then, you can continue in the step #8 of our tool.
Regards,
Mall.
There are some records i’ve in remote_ip_long :
4d9acc02
d980bf4d
they look all the same, no ? or ! or whatever only letters and numbers
What i need to do to solve this ?
The problem is that in magento 1.9.2.3 remote_ip_long it’s a varint and in magento 2.1.3 it’s a bigint how to solve this ?
It’s work good thx