jacograaff Posted September 30, 2015 Share Posted September 30, 2015 After 1.6.0.12 -> 1.6.1.1 upgrade everything works - front end shows correct products BUT the backoffice page for products shows duplicate and tipple entries for some products. When I delete one of the duplicate entries in the backoffice list view all is gone - the query might be returning multiple results for same entry.. As you can see in the attached image the backoffice shows 40 product the database only shows 30 (same in front-end) Link to comment Share on other sites More sharing options...
NemoPS Posted September 30, 2015 Share Posted September 30, 2015 Did you use multishop? I'd check product_shop as well in terms of db tables Link to comment Share on other sites More sharing options...
jacograaff Posted September 30, 2015 Author Share Posted September 30, 2015 Solved... it had to do with an extension/module I purchased I guessed it could be something to do with this module The developer was again very quick to answer and I am impressed by his support Virtual Product Combinations with Associated File http://addons.prestashop.com/en/administration-tools-prestashop-modules/18561-virtual-products-with-combinations.html New changes had to be made to a file ----------------------------------------------------------------------- open your controllers/admin/AdminProductsController.php file and find rows: $this->_use_found_rows = false; $this->_group = ''; And replace it on follow: $this->_use_found_rows = true; $this->_group = 'GROUP BY '.$alias.'.id_product'; ------------------------------------------------------------------------ --- my review on this module --- First - The developers were extremely helpful and quick to assist in getting this working after I applied all the changes from the documentation and it did not work. They even logged into my system and made changes themselves. Backwards and forwards discussions followed as I temporarily allowed secure access to a limited set of files/folders as requested. I was impressed. An upgrade from v1.6.0.12 to v.1.6.1.1 caused duplicate entries to show in the backoffice - I guessed it could be something to do with this module The developer was again very quick to answer (I purchased this 6 months ago) The workflow to use this extension is not the best - but acceptable - e.g. you have to save the new combination -- which closes the combination form and then have to go back into the combination form before you see the dialogue that allows you to add a virtual product to the specific combinationrnrnBut for the price this is acceptable Install was painful and took some time - the documentation did not have all the necessary changes Also there are some changes on the core which will break on updates as happened going from v1.6.0.12 to v1.6.1.1 I again have to stress that the developer was very quick in replying with an answer that solved the issue I am thus satisfied since the cost of the module and time I had to spend is far less then it would have taken me to develop it myself or source the development out 2 Link to comment Share on other sites More sharing options...
Kogkalidis Posted December 1, 2017 Share Posted December 1, 2017 That patch with GROUP BY worked like a charm! Thank you for your helpful guideline Link to comment Share on other sites More sharing options...
Dawn Posted August 31, 2021 Share Posted August 31, 2021 Hi! same problem here but with PS 1.7...in that version this lines not exists. Any solution? Thanks! 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