Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data migration from 1.7.0.2 eav_entity_attribute IN sql syntax error

‎08-05-2020 02:25 AM
‎08-05-2020 02:25 AM

Data migration from 1.7.0.2 eav_entity_attribute IN sql syntax error

Hi,

 

I'm trying to migrate from magento 1.7.0.2 to magento 2.3.5 but I have an error: 

[2020-08-05 09:16:44][INFO][mode: data][stage: data migration][step: EAV Step]: started
100% [============================] Remaining Time: < 1 sec
In Mysql.php line 110:

  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 ')) ORDER BY `entity_attribute_id` ASC
   LIMIT 50000' at line 1, query was: SELECT `eav_entity_attribute`.* FROM `eav_entity_attribute` WHERE (`entity_attribute_id` >= 0) AND (attribute_id IN ()) ORDER BY `entity_attribute_id` ASC
   LIMIT 50000


In Mysql.php line 91:

  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 ')) ORDER BY `entity_attribute_id` ASC
   LIMIT 50000' at line 1

From what I understand, the "attribute_id IN" parameter does not contain any value in parentheses.

 

This causes the error. Anyone have any idea how to fix it?

 

Thank you.

 

Best regards

 

Antonio Pizzuti

01bit srls

 

 

0 Kudos
Reply