I have been using Magmi for a long time, and had issues with it so far, but now I'm trying to do a CSV import with Magmi, and for some reason it throws this SQL error, and have no idea how to fix it.
- Magento: 1.8.1.0
- PHP: 5.3.3-7+squeeze18
- MySQL: 5.1.73
- MySQLi: 5.1.73
The error:
1 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 - DELETE FROM catalog_product_entity_tier_price WHERE entity_id=? AND customer_group_id IN (?) AND website_id IN ()
2 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 - ERROR ON RECORD #1