Search by attributes ignore attributes + error

07.08.2015 17:06
#1
miwok
Joomshopping forum user no avatar
Name: Sand
18.05.2011
Posts: 34
Quote
Search by attributes ignore attributes + error

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
 
07.08.2015 20:52
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: Search by attributes ignore attributes + error

Install Search by Attributes 2.0.3

 
10.08.2015 15:54
#3
miwok
Joomshopping forum user no avatar
Name: Sand
18.05.2011
Posts: 34
Quote
Aw: Search by attributes ignore attributes + error

Error message is gone, but it isn't filtering anything.
It doesn't matter which criteria I use, everything I get all products as result.

 
11.08.2015 07:40
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16517
Quote
Aw: Search by attributes ignore attributes + error

Fixed in Search by Attributes 2.0.4


Letzte Änderung: 11.08.2015 08:09
 
Copyrights MAXXmarketing GmbH. All Rights Reserved