Zetemot Posted June 10, 2016 Share Posted June 10, 2016 Hi i am a newbie of Prestashop i am trying to connect my Bindcommerce accout to my Prestashop testing site. So to try how it works I complete all the essentials steps, and everything works fine ( configuration import, download products etc..) but when i try to upload products from Bindcommerce to Prestashop i receive this error Query Reference 0012 kind=1 --- 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 'and id_node=3393 and id_contest=2288 and kind="1" and bindcommerce_reference_cod' at line 1 >> select * from jos_app_prestashop_reference where id_shop= and id_node=3393 and id_contest=2288 and kind="1" and bindcommerce_reference_code="0012" Can someone please help me solve this?! I don't know very well the SQL :/ Link to comment Share on other sites More sharing options...
musicmaster Posted June 14, 2016 Share Posted June 14, 2016 The error is quite clear. Look at "where id_shop= and " and you see that it doesn't have a value for id_shop. As I am not familiar with what you are doing I can't help you further. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now