[Skip to main content](#vessel-content)

#   Certain categories do not show in HikaMarket Frontend

##

- **[PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")**
- [![PeterChain's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar570.png)](/forum/user/570-peterchain "View PeterChain's Profile") Topic Author
- [ Offline](/forum/user/570-peterchain)

Less More

- Posts: 640
- Thank you received: 16
-
-

8 years 6 months ago [\#292581](#292581) by [PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")  *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#292581 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")* was created by *[PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")*

-- url of the page with the problem -- : hikamarket-test.slotdomains.com
-- HikaShop version -- : 3.4.0
-- HikaMarket version -- : 2.1.1
-- Joomla version -- : 3.8.7
-- PHP version -- : 7.1
-- Browser(s) name and version -- : all

We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.

We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.

We cehcked permissions, we rastered all setting tabs everywhere, no result.

Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.

Please see image attached and hint us on what can be happening.

We'll provide access to the site privately through the contact form.

Thank you.

- [ ![hikamarket-otree-problems.jpg](/forum/attachment/43655) ](/forum/attachment/43655 "...e-problems.jpg") [ ](/forum/attachment/43655?download=1 "...e-problems.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

8 years 6 months ago [\#292600](#292600) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#292600 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")*

Hello,

Please edit the file "administrator/components/com_hikamarket/classes/category.php" and replace the line Code:

$this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category_parent_id ASC, a.category_ordering ASC');

By Code:

$this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category_left ASC');

And it should fix the issue.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")**
- [![PeterChain's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar570.png)](/forum/user/570-peterchain "View PeterChain's Profile") Topic Author
- [ Offline](/forum/user/570-peterchain)

Less More

- Posts: 640
- Thank you received: 16
-
-

8 years 6 months ago [\#292601](#292601) by [PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")  Replied by *[PeterChain](/forum/user/570-peterchain "View PeterChain's Profile")* on topic *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#292601 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")*

Great!

This worked perfectly.

AS this was a test site and not my real production project I would like to know if this is a bug going to be fixed in a next release or is it that there is something wrong in my site / database.

Thank you.

Peter Chain..

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

8 years 6 months ago [\#292602](#292602) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#292602 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")*

Hello,

It is a bug which will be fix in the next release.
It can happen when a child have an ID lesser than its parent ; the category is handle but it can have a side effect in sub categories.
Re-organize the category ordering avoid the bug to happen.

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[SEKME](/forum/user/50233-sekme "View SEKME's Profile")**
- [![SEKME's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/50233-sekme "View SEKME's Profile")
- [ Offline](/forum/user/50233-sekme)

Less More

- Posts: 86
- Thank you received: 3
-
-

7 years 1 month ago [\#311870](#311870) by [SEKME](/forum/user/50233-sekme "View SEKME's Profile")  Replied by *[SEKME](/forum/user/50233-sekme "View SEKME's Profile")* on topic *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#311870 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")*

Hello Jerome,
After updated site to
joomla 3.9.12
HikaShop Business 3.5.1
Hikamarket 2.1.1

I do have issue with caterogy tree ---- the subcategories do not show up : 1. In hikamarket confiuration tab-&gt; market options -&gt; categories options (please see attached image) and 2. In front end vendors panel -&gt; add product -&gt; subcategories do not show up as well. But in back end "add product" sub categories show up as it should. (all print screens attached).

Before update all was well.

I cheched the code you wrote bellow ----&gt;But even if my Hikashop version is newer, the first code line is still in version 3.5.1 ; I tested - changed to second line you suggested, but the issue is not resolved.

*********************************
Please edit the file "administrator/components/com_hikamarket/classes/category.php" and replace the line

$this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category_parent_id ASC, a.category_ordering ASC');
By
$this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category_left ASC');

And it should fix the issue.
*********************************
**Please for help**

- [ ![20191009-hikamarket-issue-category-tree.jpg](/forum/attachment/47911) ](/forum/attachment/47911 "...egory-tree.jpg") [ ](/forum/attachment/47911?download=1 "...egory-tree.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4081
-
- [](http://obsi.dev)
-

7 years 1 month ago [\#311906](#311906) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Certain categories do not show in HikaMarket Frontend](/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend#311906 "-- url of the page with the problem -- : hikamarket-test.slotdomains.com -- HikaShop version -- : 3.4.0 -- HikaMarket version -- : 2.1.1 -- Joomla version -- : 3.8.7 -- PHP version -- : 7.1 -- Browser(s) name and version -- : all  We have a certain category that is not showing grandchildren categories in HikaMarket frontend Otree, but in the HikaShop Backend we see them and can manipulate them.  We tried all sort of movements changing categories, creating news ones, moving form inside to outside and viceversa.  We cehcked permissions, we rastered all setting tabs everywhere, no result.  Nothing changes, all grandchildren categories inside the SAGE category do not show in HikaMarket product list tree, but they do at HikaShop Backend.  Please see image attached and hint us on what can be happening.  We'll provide access to the site privately through the contact form.  Thank you.")*

Hello,

Please open a new forum thread for your issue.
We will require some details and probably an access to see the issue directly (thanks to an access that you could send via the "contact us" form).

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5NDY4OS1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctaW4taGlrYW1hcmtldC1mcm9udGVuZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; 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?

Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile")

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.085 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
