Chris2013 Posted August 27, 2014 Share Posted August 27, 2014 (edited) Hi In the back office when I change the disply order of the attribute group(not attribute) the order of the attribute group changes in the back office as well as in the database base (0,1,2,3,4,5 and so on) which is good, however they still show in the default order (which I assume is the date of when the attribute was made or the ID number) in the store. I have looked at the blocklayered.php and line 2052 seems to be where it's at with this GROUP BY `type`, id_value ORDER BY position ASC' but for some reason it isnt picking up the postion of the group but using the group ID instead. /* Get the filters for the current category */ $filters = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM '._DB_PREFIX_.'layered_category WHERE id_category = '.(int)$id_parent.' AND id_shop = '.$id_shop.' GROUP BY `type`, id_value ORDER BY position ASC' ); Anyone have an idea on what to try Chris Edited August 27, 2014 by Chris2013 (see edit history) Link to comment Share on other sites More sharing options...
Chris2013 Posted August 28, 2014 Author Share Posted August 28, 2014 No one else got this problem? Link to comment Share on other sites More sharing options...
Chris2013 Posted August 31, 2014 Author Share Posted August 31, 2014 (edited) Still trying to work how to correct this bug to get them to show in their position and not in their ID value I Don't normally throw in the towel on glitches but getting close to doing so, the only other soluition I can think of is go into myphpadmin and edit the attribute ID's to the order I require them, bit of a task though. If anyone else has a solution it'll be welcome I have attached a picture that may help show what i'm on about. Edited August 31, 2014 by Chris2013 (see edit history) Link to comment Share on other sites More sharing options...
Chris2013 Posted September 4, 2014 Author Share Posted September 4, 2014 (edited) Looks like it off to myphpadmin to change the id's of the atrribute group to get them in the order I want them Edited September 4, 2014 by Chris2013 (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts