Certain categories do not show in HikaMarket Frontend

  • Posts: 603
  • Thank you received: 16
  • Hikamarket Multivendor Hikashop Business
5 months 4 days ago #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.

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 22856
  • Thank you received: 3548
  • MODERATOR
5 months 3 days ago #292600

Hello,

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.

Regards,


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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: PeterChain

Please Log in or Create an account to join the conversation.

  • Posts: 603
  • Thank you received: 16
  • Hikamarket Multivendor Hikashop Business
5 months 3 days ago #292601

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 or Create an account to join the conversation.

  • Posts: 22856
  • Thank you received: 3548
  • MODERATOR
5 months 3 days ago #292602

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 & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

Moderators: Obsidev
Time to create page: 0.080 seconds
Powered by Kunena Forum