Search by attributes ignore attributes + error

07.08.2015 17:06
#1
miwok
Joomshopping forum user no avatar
Name: Sand
18.05.2011
Сообщения: 50
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25922
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
Сообщения: 50
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
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Сообщения: 25922
Quote
Aw: Search by attributes ignore attributes + error

Fixed in Search by Attributes 2.0.4


Последнее изменение: 11.08.2015 08:09
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.