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

#   certain categories do not show up in Hikamarket backend and frontend

##

- **[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") Topic Author
- [ Offline](/forum/user/50233-sekme)

Less More

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

7 years 1 month ago [\#312021](#312021) by [SEKME](/forum/user/50233-sekme "View SEKME's Profile")  *[certain categories do not show up in Hikamarket backend and frontend](/forum/22-market-bug-report/898483-certain-categories-do-not-show-up-in-hikamarket-backend-and-frontend#312021 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.2  Hello Jerome, After updated site to joomla 3.9.12. and to php to 7.2 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 &quot;add product&quot; sub categories show up as it should. (all printscreens attached).  Before update all was well.  I cheched the code you wrote in ----&gt; code lines below---&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.  &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please edit the file &quot;administrator/components/com&#95;hikamarket/classes/category.php&quot; and replace the line  $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;parent&#95;id ASC, a.category&#95;ordering ASC'); By $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;left ASC');  And it should fix the issue. &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please for help")* was created by *[SEKME](/forum/user/50233-sekme "View SEKME's Profile")*

-- HikaShop version -- : 3.5.1
-- Joomla version -- : 3.9.12
-- PHP version -- : 7.2

Hello Jerome,
After updated site to joomla 3.9.12.
and to php to 7.2
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 printscreens attached).

Before update all was well.

I cheched the code you wrote in [ Certain categories do not show in HikaMarket Frontendtopic](https://www.hikashop.com/forum/22-market-bug-report/894689-certain-categories-do-not-show-in-hikamarket-frontend.html#311906) ----&gt; code lines below---&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&#95;2019-10-14.jpg](/forum/attachment/47929) ](/forum/attachment/47929 "...2019-10-14.jpg") [ ](/forum/attachment/47929?download=1 "...2019-10-14.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5ODQ4My1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctdXAtaW4taGlrYW1hcmtldC1iYWNrZW5kLWFuZC1mcm9udGVuZD90bXBsPW1hcmtkb3du) 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 [\#312089](#312089) 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 up in Hikamarket backend and frontend](/forum/22-market-bug-report/898483-certain-categories-do-not-show-up-in-hikamarket-backend-and-frontend#312089 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.2  Hello Jerome, After updated site to joomla 3.9.12. and to php to 7.2 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 &quot;add product&quot; sub categories show up as it should. (all printscreens attached).  Before update all was well.  I cheched the code you wrote in ----&gt; code lines below---&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.  &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please edit the file &quot;administrator/components/com&#95;hikamarket/classes/category.php&quot; and replace the line  $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;parent&#95;id ASC, a.category&#95;ordering ASC'); By $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;left ASC');  And it should fix the issue. &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please for help")*

Hello,

The patch your mentioned is in the latest version of HIkaMarket (the 3.0.2).
From which version did you update ?

Regards,

---

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

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5ODQ4My1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctdXAtaW4taGlrYW1hcmtldC1iYWNrZW5kLWFuZC1mcm9udGVuZD90bXBsPW1hcmtkb3du) 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") Topic Author
- [ Offline](/forum/user/50233-sekme)

Less More

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

7 years 1 month ago [\#312097](#312097) 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 up in Hikamarket backend and frontend](/forum/22-market-bug-report/898483-certain-categories-do-not-show-up-in-hikamarket-backend-and-frontend#312097 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.2  Hello Jerome, After updated site to joomla 3.9.12. and to php to 7.2 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 &quot;add product&quot; sub categories show up as it should. (all printscreens attached).  Before update all was well.  I cheched the code you wrote in ----&gt; code lines below---&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.  &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please edit the file &quot;administrator/components/com&#95;hikamarket/classes/category.php&quot; and replace the line  $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;parent&#95;id ASC, a.category&#95;ordering ASC'); By $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;left ASC');  And it should fix the issue. &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please for help")*

Hi, Jerome,
My hikamarket is 2.1.1

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5ODQ4My1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctdXAtaW4taGlrYW1hcmtldC1iYWNrZW5kLWFuZC1mcm9udGVuZD90bXBsPW1hcmtkb3du) 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 [\#312150](#312150) 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 up in Hikamarket backend and frontend](/forum/22-market-bug-report/898483-certain-categories-do-not-show-up-in-hikamarket-backend-and-frontend#312150 "-- HikaShop version -- : 3.5.1 -- Joomla version -- : 3.9.12 -- PHP version -- : 7.2  Hello Jerome, After updated site to joomla 3.9.12. and to php to 7.2 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 &quot;add product&quot; sub categories show up as it should. (all printscreens attached).  Before update all was well.  I cheched the code you wrote in ----&gt; code lines below---&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.  &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please edit the file &quot;administrator/components/com&#95;hikamarket/classes/category.php&quot; and replace the line  $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;parent&#95;id ASC, a.category&#95;ordering ASC'); By $this-&gt;db-&gt;setQuery($select . $table . $where . ' ORDER BY a.category&#95;left ASC');  And it should fix the issue. &#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42; Please for help")*

Hello,

There are 228 modified files between HikaMarket 2.1.1 and HikaMarket 3.0.2, including the HikaMarket category helper which handle the display of the namebox.
I don't know the version of HikaMarket that you got before the update (that you were talking about) ; but please understand that we can only provide patches and bug fixes for the latest version of HikaMarket.

If you found the same issue in our demo website (which using the latest version of HikaMarket), we can investigate since we have a way to see and reproduce the issue.
But I am not able to see that issue in my test websites. I can't say if you have an old and fixed bug, if you have a display issue, a bug with AdminTools (or similar) or if you have issues with your Hikashop categories and you need to repair them.

Regards,

---

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

The following user(s) said Thank You: [SEKME](/forum/user/50233-sekme "View SEKME's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5ODQ4My1jZXJ0YWluLWNhdGVnb3JpZXMtZG8tbm90LXNob3ctdXAtaW4taGlrYW1hcmtldC1iYWNrZW5kLWFuZC1mcm9udGVuZD90bXBsPW1hcmtkb3du) 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.097 seconds

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