Syntax error during Step 8 wishlist migration

Hello,
I’m running into an error in step 8 with the handy new wishlist migration.

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND code = 'product_qty_' LIMIT 1' at line 1. The SQL statement executed was: SELECT * FROM `wishlist_item_option` `t` WHERE wishlist_item_id = 6 AND product_id =  AND code = 'product_qty_' LIMIT 1

I took a look at the DB data and do not see any obvious issues. If you have any recommendations, I’d appreciate it. I’m excited to move the huge number of wishlists our customers have.
Thanks!

1 answer

Profile photo of Mall Staff 167790.00 $tone June 29, 2021
Public

Hi Taber,

I’m running into an error in step 8 with the handy new wishlist migration.

The issue you mentioned related to a data record in the table ‘wishlist_item_option’ which has the relation with a product in ‘catalog_product_entity’, but this product no longer exists in this table.

Did you delete any migrated product in M2 after the first migration? Or did you run delta migration for all products in Step #5 before you performed the delta migration in Step #8?
 
Regards,
Mall.
 

#1

Please login or Register to Submit Answer

Written By

Comments