Hello,
I'm afraid that your issue is not related with HikaMarket at all ; but only to HikaShop.
Here the patch for the HikaShop product view file :
$query = 'SELECT b.* '.
' FROM '.hikashop_table('product_category').' AS a '.
' LEFT JOIN '.hikashop_table('category').' AS b ON a.category_id = b.category_id '.
' WHERE a.product_id = '.(int)$element->product_id.
' ORDER BY a.product_category_id ASC';
By
$query = 'SELECT b.* '.
' FROM '.hikashop_table('product_category').' AS a '.
' LEFT JOIN '.hikashop_table('category').' AS b ON a.category_id = b.category_id '.
' WHERE a.product_id = '.(($element->product_type == 'variant' && !empty($element->product_parent_id)) ? (int)$element->product_parent_id : (int)$element->product_id).
' ORDER BY a.product_category_id ASC';
Do not reply to this topic ; if you have any more question regarding that issue, you have to create a new thread in the HikaShop section of the forum.
Thank you for your understanding.
Regards,