I'm using the query path processor and when I try to run an import I get this error:

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 ' 'name2', 'name3', 'name4', 'name5', 'name6' at line 1

Nothing shows up in my log.

Comments

Jooblay.net’s picture

Do your have feeds tamper and your mapping set correctly... :) Double check to make sure you mapping is correct and you have 1 unique value ticked in you feed import.

revanshu’s picture

Component: Feeds Import » Code
Issue summary: View changes

hello I am getting the same error
I am using feeds_tamper for importing taxonomy terms with multiple terms associated.
I have mapped it to the term name. Still i am getting the same error and no data is imported.
have you solve this problem @jmickela

Mizpah’s picture

Unsure if this is the same issue ? https://drupal.org/node/2271393 (currently in the XPath queue)

This is an XML import, using XPath XML Parser. The title field is marked as unique (incidentally I would prefer to mark the ITEM ID as unique, but that option is not available (field is a text field).

How can I see the entirety of the SQL query ?

AROOJ.SHAH’s picture

Title: I get "Syntax error or access violation: 1064 You have an error in your SQL syntax" when I try to run a user import. » 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 '4)' at line 1