19 Posts
greenmar
8 years ago
3
Topic

I create field Search Generic type, add "art_tags" field in list and got a error 1054 when search:

Unknown column 't2.tags' in 'where clause' SQL=SELECT t0.id AS pid,t0.pk AS pk,t0.pkb AS pkb,t0.parent_id AS parent,t0.author_id AS author,t0.cck AS cck,t0.storage_location AS loc,tt.id AS type_id,tt.alias AS type_alias FROM `#__cck_core` AS t0 LEFT JOIN `#__cck_store_form_theme` AS t1 ON t1.id = t0.pk LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t2.state = 1 AND t2.access IN (1,1,2,3,6) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2016-09-26 14:30' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2016-09-26 14:30' ) AND t0.cck = 'theme' AND ((t1.theme_favorite = '850' OR t1.theme_favorite LIKE '850,%' OR t1.theme_favorite LIKE '%,850,%' OR t1.theme_favorite LIKE '%,850')) AND (t2.tags LIKE '%ужин%') ORDER BY t2.title ASC LIMIT 25
Get a Book for SEBLOD
4229 Posts
Kadministrator
8 years ago
1
Level 1

If not already, update to the latest Seblod version. If error is still there after update please report it on the github tracker.

https://github.com/Octopoos/SEBLOD/issues

19 Posts
greenmar
8 years ago
0
Level 2

Seblod 3.9.1.

Joomla 3.6.2.

I did issue on github https://github.com/Octopoos/SEBLOD/issues/273

118 Posts
webchun
6 years ago
0
Level 1

@greenmar Have you been able to solve this problem? I'm using seblod 3.16.3 + joomla 3.8.10 and the problem still exist

Get a VIP membership