Certain categories do not show in HikaMarket Frontend

  • Posts: 634
  • Thank you received: 16
  • Hikashop Business
5 years 10 months 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: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 10 months 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: 634
  • Thank you received: 16
  • Hikashop Business
5 years 10 months 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: 25994
  • Thank you received: 4004
  • MODERATOR
5 years 10 months 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.

  • Posts: 84
  • Thank you received: 2
4 years 5 months ago #311870

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

Attachments:

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
4 years 5 months ago #311906

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 & 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.073 seconds
Powered by Kunena Forum