1 reply to this topic

[Lazajk]

After update to jbZoo 2.1.3 module JBZOO Search List generating error:

 

Error: 1054 - Unknown column 'tIndex.e_itemname_s' in 'field list' SQL=SELECT tIndex.e_itemname_s AS value, tIndex.e_itemname_s AS text, COUNT(tIndex.e_itemname_s) AS count FROM alp_zoo_item AS tItem INNER JOIN alp_zoo_jbzoo_index_pompy_wirowe AS tIndex ON tIndex.item_id = tItem.id LEFT JOIN alp_zoo_category_item AS tCategoryItem ON tCategoryItem.item_id = tItem.id WHERE tItem.access IN (1,5) AND tItem.state = '1' AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2014-06-08 07:49:14') AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2014-06-08 07:49:14') AND tItem.searchable = '1' AND tItem.type = 'pompy-wirowe' AND tItem.application_id = '1' AND tIndex.e_itemname_s <> "" AND tIndex.e_itemname_s IS NOT NULL AND tCategoryItem.category_id = '2' GROUP BY tIndex.e_itemname_s

 

DB was re-indexed and cleaned.

 

Joomla: 3.3.0     JBZoo: 2.1.3 Pro     Zoo: 3.1.6     WidgetKit: 1.4.8

[SmetDenis]

Hello,

Please, can you show me configuraions (and positions) of module JBZoo Search List where you have the error.

Thanks.