в css/css_тема/includes/subcategorys.php
$q = db_query("SELECT categoryID, name, hurl, products_count,picture FROM ".CATEGORIES_TABLE." WHERE enabled=1 and parent='".$categoryID."' ORDER BY ".CONF_SORT_CATEGORY." ".CONF_SORT_CATEGORY_BY);
$result = array();
while ($row = db_assoc_q($q))
{
if ($row['hurl'] != "" && CONF_CHPU) {$row['hurl'] = REDIRECT_CATALOG."/".$row['hurl'];} else {$row['hurl'] = "index.php?categoryID=".$row['categoryID'];}
if (!$row['picture'] || !file_exists('./products_pictures/'.$row['picture']) ) $row['picture']='';
$result[] = $row;
}
меняешь на
$q = db_query("SELECT categoryID, name, hurl, products_count, picture FROM ".CATEGORIES_TABLE." WHERE enabled=1 and parent='".$categoryID."' ORDER BY ".CONF_SORT_CATEGORY." ".CONF_SORT_CATEGORY_BY) or die (db_error());
$result = array();
while ($row = db_fetch_row($q))
{
if ($row[2] != "" && CONF_CHPU) {$row[2] = REDIRECT_CATALOG."/".$row[2];} else {$row[2] = "index.php?categoryID=".$row[0];}
$result[] = $row;
}
$smarty->assign("subcategories_to_be_shown",$result);
$smarty->assign("subcategories_to_be_shown",$result);
должно получится...