Certain categories do not show in HikaMarket Frontend

-- 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..

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-> market options -> categories options (please see attached image) and 2. In front end vendors panel -> add product -> 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 ---->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->db->setQuery($select . $table . $where . ' ORDER BY a.category_parent_id ASC, a.category_ordering ASC');
By
$this->db->setQuery($select . $table . $where . ' ORDER BY a.category_left ASC');

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