18/05/2016

CATEGORY Menu Of TABLEAU Zencart Template Not working

By snorlaxprime

TABLEAU template is great design by Numinix, however there is a bug when you add a new Category, the menu didn’t show up in the Main menu for some reason.

To fix this do the following:

Open the following file from your ZenCart Installation:
Includes/templates/tableau/templates/tpl_modules_categories_tabs.php

Locate the following code (line22 on my clients site)
categories_tab_query = "SELECT c.categories_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION . " cd," . TABLE_HIDE_CATEGORIES . " cde WHERE c.categories_id = cd.categories_id AND c.parent_id= '0' AND cd.language_id='" . (int)$_SESSION['languages_id'] . "' AND c.categories_status='1' ORDER BY c.sort_order, cd.categories_name;";
replace it with this
$categories_tab_query = "SELECT c.categories_id, cd.categories_name FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION . " cd WHERE c.categories_id = cd.categories_id AND c.parent_id= '0' AND cd.language_id='" . (int)$_SESSION['languages_id'] . "' AND c.categories_status='1' ORDER BY c.sort_order, cd.categories_name;";