certain categories do not show up in Hikamarket backend and frontend

-- 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-> 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 printscreens attached).

Before update all was well.

I cheched the code you wrote in Certain categories do not show in HikaMarket Frontendtopic ----> code lines below--->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

Hi, Jerome,
My hikamarket is 2.1.1