fresh installed version "search by attributes" 2.0.2
if in joomshopping/options/addons/addon search extended the switch "Suche nach Code abhängig Attribut" is off,
search function ingnores attributes.
If I set it on, I get these error:
1054 - Unknown column 'jt.tag_name' in 'where clause' SQL=SELECT count(distinct prod.product_id) FROM `n37jc_jshopping_products` AS prod LEFT JOIN `n37jc_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `n37jc_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `n37jc_jshopping_products_attr` AS pattr ON prod.product_id = pattr.product_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,2,3,6) AND cat.access IN (1,1,2,3,6) AND ((LOWER(prod.`name_de-DE`) LIKE '%%' OR LOWER(prod.`short_description_de-DE`) LIKE '%%' OR LOWER(prod.`description_de-DE`) LIKE '%%' OR LOWER(prod.`product_ean`) LIKE '%%')) OR ( jt.tag_name LIKE '%%' AND prod.product_publish = '1' AND cat.category_publish='1') AND prod.`product_id`=0 OR (prod.product_publish = '1' AND cat.category_publish='1' AND pattr.ean LIKE '%%' )
btw: at same time I installed commercial version "tags" 1.0.4
Joomla: 3.4.3
JoomShopping: 4.10.3
PHP: 5.5.11
MySQL: 5.0.11
Website Url: offline
JoomShopping: 4.10.3
PHP: 5.5.11
MySQL: 5.0.11
Website Url: offline