I think I found a bug in the cat_filter.php function on line 76. I didn't have time to check the forum but I downloaded the latest version.
This is the warning:
HTML Code:
1146 Table '[#database#].categories_description' doesn't exist
in:
[select p2c.categories_id from zc_products p, zc_products_to_categories p2c
INNER JOIN [color="Red"]categories_description[/color] cd ON
(p2c.categories_id=cd.categories_id AND cd.language_id=1 AND cd.categories_description LIKE '%-[#Site_name#]-%')
INNER JOIN categories as c ON
(cd.categories_id=c.categories_id
AND c.categories_status=1)
where p.products_id = '75' and p.products_status = '1'
and p.products_id = p2c.products_id limit 1]
the table in red is the problem. The code in the function file is at line 76 and
PHP Code:
INNER JOIN categories_description cd
should be changed to
PHP Code:
INNER JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd
Same it is with line 80
Thank you for the contribution.
God bless. Amazing Discoveries.
Bookmarks