CODEWITHSUNDEEP
phpmysqlmagentomagmimagento-1.8
dasmikko
dasmikko

Reputation: 706

Magmi Import SQL import, works on local server

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.

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

Upvotes: 0

Views: 871

Answers (2)

dasmikko
dasmikko

Reputation: 706

Found the problem!

When I use category_ids like: 4,35,5 it gives me the error.

But! If I just use a single number, no error!

Upvotes: 0

Malachy
Malachy

Reputation: 1590

MAGMI is a fantastic piece of software. I have great admiration for the coder who created it.

I don't know for sure but I think the issue is to do with the websites column or lack of it.

Re-read some of the info here about specifying website: http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Tier_price_importer

When I use MAGMI for csv import I have a website column but I set it to _MAGMI_IGNORE_ but for your example I think you might need to list the website codes explicitly - worth a try I think and this issue may be related to Magento 1.8

Upvotes: 2

Related Questions