[Skip to main content](#vessel-content) # Filter & Pagination Bug ## - **[Karloz](/forum/user/3250-karloz "View Karloz's Profile")** - [![Karloz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3250-karloz "View Karloz's Profile") Topic Author - [ Offline](/forum/user/3250-karloz) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago - 14 years 11 months ago [\#29958](#29958) by [Karloz](/forum/user/3250-karloz "View Karloz's Profile") *[Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#29958 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* was created by *[Karloz](/forum/user/3250-karloz "View Karloz's Profile")* Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz Last edit: 14 years 11 months ago by [Karloz](/forum/user/3250-karloz "View Karloz's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 11 months ago [\#29974](#29974) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#29974 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* Hi, Could you give a link to that page so that we can have a look at the problem ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Karloz](/forum/user/3250-karloz "View Karloz's Profile")** - [![Karloz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3250-karloz "View Karloz's Profile") Topic Author - [ Offline](/forum/user/3250-karloz) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago [\#30033](#30033) by [Karloz](/forum/user/3250-karloz "View Karloz's Profile") Replied by *[Karloz](/forum/user/3250-karloz "View Karloz's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30033 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* Hi, For example here: [ new.ufolabz.net/index.php?option=com\_hik...hno&Itemid=9&lang=en](http://new.ufolabz.net/index.php?option=com_hikashop&ctrl=category&task=listing&cid=12&name=acid-b-techno&Itemid=9&lang=en) when you are on the 3rd page and then filter, no product appears ... if you are on the 1st or 2nd , its ok , because it always stays on the same page Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Karloz](/forum/user/3250-karloz "View Karloz's Profile")** - [![Karloz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3250-karloz "View Karloz's Profile") Topic Author - [ Offline](/forum/user/3250-karloz) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago [\#30037](#30037) by [Karloz](/forum/user/3250-karloz "View Karloz's Profile") Replied by *[Karloz](/forum/user/3250-karloz "View Karloz's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30037 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* Btw by what is handled the filter items order ? Because as you can see the order is changing in each category... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 11 months ago [\#30199](#30199) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30199 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* Hi, Thank you for that. I was indeed able to reproduce the problem and fixed it on our end. The modification being extensive, you can either wait for next release and display all the products on one page for the time being or contact us via our contact form to request a pre version install package that you could use to update the files and get that problem fixed on your website. For your second question I would need more information. Could you do a screenshot of the options of your filter ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Karloz](/forum/user/3250-karloz "View Karloz's Profile")** - [![Karloz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3250-karloz "View Karloz's Profile") Topic Author - [ Offline](/forum/user/3250-karloz) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago - 14 years 11 months ago [\#30428](#30428) by [Karloz](/forum/user/3250-karloz "View Karloz's Profile") Replied by *[Karloz](/forum/user/3250-karloz "View Karloz's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30428 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* hello, thats great news! i must also thank you, for your great extension and all the fish ! ![:-)](/media/kunena/emoticons/3.png ":-)") regarding my second question, screenshot of filter settings is attached. ( what hadles the filter items order ? they are changing, once "new" is first, but in another category "second hand" is first etc... ) ( [ new.ufolabz.net/index.php?option=com\_hik...hno&Itemid=9&lang=en](http://new.ufolabz.net/index.php?option=com_hikashop&ctrl=category&task=listing&cid=12&name=acid-b-techno&Itemid=9&lang=en) ) maybe it would be useful to put something like "filter items order" into filter bakcend settings, for manufacturers, and laso others, alphabeticaly, order, id, ... , ? [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/filter.png) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/filter.png "[img") - [ ![filter.png](/forum/attachment/2092) ](/forum/attachment/2092 "filter.png") [ ](/forum/attachment/2092?download=1 "filter.png") Last edit: 14 years 11 months ago by [Karloz](/forum/user/3250-karloz "View Karloz's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 11 months ago [\#30439](#30439) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30439 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* Hi, You can change the line: $query='SELECT * FROM '.hikashop_table('category').' AS a '.$left.' WHERE category_parent_id='.$parentCat.' '.$optionElement.''; to: $query='SELECT * FROM '.hikashop_table('category').' AS a '.$left.' WHERE category_parent_id='.$parentCat.' '.$optionElement.'ORDER BY a.category_ordering ASC'; in the file administrator/components/com_hikashop/classes/filter.php and that will always order the categories based on their ordering. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Karloz](/forum/user/3250-karloz "View Karloz's Profile")** - [![Karloz's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/3250-karloz "View Karloz's Profile") Topic Author - [ Offline](/forum/user/3250-karloz) Less More - Posts: 45 - Thank you received: 0 - - 14 years 11 months ago - 14 years 11 months ago [\#30470](#30470) by [Karloz](/forum/user/3250-karloz "View Karloz's Profile") Replied by *[Karloz](/forum/user/3250-karloz "View Karloz's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30470 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* again thanks a much ! please i would have one more thing, please is it possible to add a "reset" button next to the "select" button in filter section for reset filter settings somehow ? i believe its just a piece of code, unfortunately i'm unable to reproduce it. in my case i found it useful, since there will be a more options to filter, based on various sources and because the filter options always stands selected (which i good indeed), so there would be an easy option to deselect all filter options and have full category listing via one click. best regards Last edit: 14 years 11 months ago by [Karloz](/forum/user/3250-karloz "View Karloz's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 14 years 11 months ago [\#30484](#30484) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Filter & Pagination Bug](/forum/3-bug-report/29958-filter-pagination-bug#30484 "Hi Nicolas, I have already mentioned in another thread that i have found a little bug with filtering & pagination, but here is some more info about: When i have for example... Category "Music" - 20 products inside Category "New" - 15 prods Category "2hand" - 5 prods All 20 prods belongs to "Music" category and also to one of "New" or "2hand" When i browse category "Music" which contains all products and pagination is for ex. 5 products per page then when i am on the 2nd (3rd / 4th) page and then i filter "2hand" no products appear. When i'm on the first page of all products, filter goes well. That means i can't be on a page# which is more then filtered results have and use filter, because no products appear then. Best Regards, Karloz")* There is no reset filter button option so you won't be able to do it easily for now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8yOTk1OC1maWx0ZXItcGFnaW5hdGlvbi1idWc/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.066 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)