Tasslhof Posted April 11, 2016 Share Posted April 11, 2016 i have unexpected error on my shop I read several threads on this topic but I didn’t find a solution I think it is some kind of data base error, when uploading an product image ( only there ), if anybody have any ideas I would greatly appreciate it. JSON.parse: unexpected character at line 1 column 1 of the JSON data Response from FIREBUG <div class="alert alert-danger"> <button type="button" class="close" data-dismiss="alert">×</button> Column 'id_product' in where clause is ambiguous<br /><br /><pre> SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 94 AND image_shop.`cover`= 1 LIMIT 1</pre> </div> Link to comment Share on other sites More sharing options...
Tasslhof Posted April 11, 2016 Author Share Posted April 11, 2016 right now i am pretty sure it is a data base error, if I upload old data base every ting works perfectly, anybody know how to solve it. Link to comment Share on other sites More sharing options...
tuk66 Posted April 11, 2016 Share Posted April 11, 2016 It is the wrong SQL query. Try to find it and modify to WHERE i.`id_product` = 94 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