Originally Posted by
apogeerockets
i have the same error. if i figure it out, i'll let you know.
Solution follows (works with zencart 1.3.9, untested in others)
In advanced_search_categories.php
replace
PHP Code:
$select_column_list = '';
for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if (zen_not_null($select_column_list)) {
$select_column_list .= ', ';
}
switch ($column_list_cat[$col]) {
case 'CATEGORY_LIST_NAME':
$select_column_list .= 'cd.categories_name';
break;
case 'CATEGORY_LIST_IMAGE':
$select_column_list .= 'c.categories_image';
break;
}
}
with
PHP Code:
$select_column_list = '';
for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if (zen_not_null($select_column_list)) {
$select_column_list .= '';
}
switch ($column_list_cat[$col]) {
case 'CATEGORY_LIST_NAME':
$select_column_list .= 'cd.categories_name, ';
break;
case 'CATEGORY_LIST_IMAGE':
$select_column_list .= 'c.categories_image, ';
break;
}
}
for some reason the original code is adding an extra comma, and thus the syntax error.
other adjustments i made:
in tpl_modules_advanced_search_categories.php i changed
PHP Code:
$lc_text .= '<img src="images/no_picture.gif" width='.IMAGE_PRODUCT_LISTING_WIDTH.' height='.IMAGE_PRODUCT_LISTING_HEIGHT.'/></a>';
to
PHP Code:
$lc_text .= '<img src="images/no_picture.gif" width='.IMAGE_PRODUCT_LISTING_WIDTH.' /></a>';
because my 'no image' image was getting stretched unproportionally. i also eliminated the IMAGE_PRODUCT_LISTING_HEIGHT from the line below to prevent that from stretching as well. i have all my images to be a uniform width, but don't particularly care if the height varies.
Bookmarks