jorr17 Posted February 11, 2014 Share Posted February 11, 2014 Hi, We have a slight problem in Prestashop. When we click on the "Best Sellers" hyper-link, it throws up an error and moves to a page with all the info. Below is what it comes up explaining the error, and then underneath that is a whole lot of HTML scripting. Would anyone have an idea about this error and how to fix it? "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 '16,17,18,19,20,21,22,23,24,25,26,27,28,29) GROUP BY product_shop.id_product ' at line 29" Thanks, jorr17 Link to comment Share on other sites More sharing options...
Dh42 Posted February 11, 2014 Share Posted February 11, 2014 What version of mysql is your shot running? What version of Prestashop are you running, what version of the best sellers module are you running? Link to comment Share on other sites More sharing options...
jorr17 Posted February 11, 2014 Author Share Posted February 11, 2014 (edited) Hi Dh42, The Prestashop version that we are using is: Version 1.5.6.1 The Best-Selling products version we are using is: Version 1 mysql informaiton found below.... Database information MySQL version: 5.1.72-cll MySQL engine: InnoDB Tables prefix: ps_ PHP version: 5.4.23 Any other information required? Thanks for your help, jorr17 Edited February 11, 2014 by jorr17 (see edit history) Link to comment Share on other sites More sharing options...
Dh42 Posted February 11, 2014 Share Posted February 11, 2014 Hmmm, The first thing i would do is try to update the module to the latest version from github. Link to comment Share on other sites More sharing options...
jorr17 Posted February 11, 2014 Author Share Posted February 11, 2014 (edited) Is this the Best Sellers module that we update? It never said anything about updating in the module area..... Or do we go to there website and update it/ download a new one? Cause the one we are using is made by Prestashop.... Edited February 11, 2014 by jorr17 (see edit history) Link to comment Share on other sites More sharing options...
Dh42 Posted February 11, 2014 Share Posted February 11, 2014 Right, I would download the individual files from github and replace them, just that one module. Link to comment Share on other sites More sharing options...
jorr17 Posted February 11, 2014 Author Share Posted February 11, 2014 Do you have the specific link to the one that we need to download? Thanks Link to comment Share on other sites More sharing options...
J.Sahu Posted February 11, 2014 Share Posted February 11, 2014 Here is the link https://github.com/PrestaShop/PrestaShop-1.5/tree/master/modules/blockbestsellers. Just download and replace each file and see what happens. Link to comment Share on other sites More sharing options...
jorr17 Posted February 13, 2014 Author Share Posted February 13, 2014 (edited) Hi J.Sahu, In regards to those files, how do I install it into prestashop as a new module? Is there a file where I can just download the full file of the block? Thanks, jorr17 Edited February 13, 2014 by jorr17 (see edit history) Link to comment Share on other sites More sharing options...
J.Sahu Posted February 13, 2014 Share Posted February 13, 2014 (edited) No for that specific tree you can't download or you can download in a any other way. What I did is copied the whole code of each file on e by one and pasted in the file respectively. If You want I can do it for you. Best practice is uninstall that module and replace the files or file contents with new one. Edited February 13, 2014 by J.Sahu (see edit history) Link to comment Share on other sites More sharing options...
jorr17 Posted February 21, 2014 Author Share Posted February 21, 2014 Thanks for that J. Sahu. But my project manager and I have both decided that we would like to keep using the Prestashop module instead of using one from a different site. I have tried multiple times to contact the Prestashop Support team but they don't seem to be replying. Any idea how I could have this problem fixed? Thanks jorr17 Link to comment Share on other sites More sharing options...
Dh42 Posted February 21, 2014 Share Posted February 21, 2014 The one from the github is the official prestashop module. It is just the new updated files that have not been compiled into a release yet. As far as contacting Prestashop about the issue, you really have two choices. You can submit a bug on the bug tracker if you are using the current version. Or you can buy a support package. 1 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