dasifred Posted July 5, 2015 Share Posted July 5, 2015 (edited) Hello, After installing a new theme (purchased on addons prestashop ), I am unable to create products , here is the error message : Bad SQL Query Unknown column ' image_shop.id_product ' in ' on clause ' thank you for your help. Edited July 5, 2015 by dasifred (see edit history) 1 Link to comment Share on other sites More sharing options...
shacker Posted July 10, 2015 Share Posted July 10, 2015 looks like the database dont have these fields. you can try to check if these field exists in hte image table, or contact the developer t osolve it Link to comment Share on other sites More sharing options...
maxrm40 Posted July 28, 2015 Share Posted July 28, 2015 https://github.com/PrestaShop/PrestaShop/blob/1.6/install-dev/upgrade/sql/1.6.1.0.sql#L91 you have to add a line to your sql easy to do 1 Link to comment Share on other sites More sharing options...
brady Posted July 29, 2015 Share Posted July 29, 2015 (edited) https://github.com/PrestaShop/PrestaShop/blob/1.6/install-dev/upgrade/sql/1.6.1.0.sql#L91 you have to add a line to your sql easy to do Maybe easy for you. It would be good to explain how you add such a line, step by step, since the link you refer to doesn't explain how to 'alter' the table. My recommendation is to not use the 1-Click Upgrade since it crashed my cart big time going from 1.6.0.5 to 1.6.1. You would think that such a increment upgrade would be a snap (Wordpress upgrades are just that, a snap!). Not PrestraShop upgrades. The developers of the 1-Click Module for PrestaShop haven't got upgrades worked out yet with the 1-Click module. They do warn you and so I agree with all the warnings and will never do a 1-Click again. Edited July 29, 2015 by brady (see edit history) Link to comment Share on other sites More sharing options...
brady Posted July 29, 2015 Share Posted July 29, 2015 Ok. After pouring over MySQL I figured it out. Not for the faint of heart. Fixed that one. But my shopping cart is still a disaster. Many of the images are not loading. Back to work. Link to comment Share on other sites More sharing options...
shacker Posted July 29, 2015 Share Posted July 29, 2015 maybe you need to install the theme again with the theme installer Link to comment Share on other sites More sharing options...
The Owl Posted August 3, 2015 Share Posted August 3, 2015 Ok. After pouring over MySQL I figured it out. Not for the faint of heart. Fixed that one. But my shopping cart is still a disaster. Many of the images are not loading. Back to work. How did you do this? Could you explain as I am having the same issue currently? Link to comment Share on other sites More sharing options...
shacker Posted August 3, 2015 Share Posted August 3, 2015 install the themplate again and create the image format. after that you need to regenerate the images 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