Error step 7 and 8

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

Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

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.
 

#1
Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

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.

#3
Profile photo of cdpi404 660.00 $tone July 20, 2017
Public

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 ?

#4
Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

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.

#5
Profile photo of cdpi404 660.00 $tone July 20, 2017
Public

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)

#6
Profile photo of Mall Staff 184060.00 $tone July 20, 2017
Public

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.

#7
Profile photo of cdpi404 660.00 $tone July 20, 2017
Public

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

#8

Please login or Register to Submit Answer

Written By

Comments