Search Generic Field problem

[ghost]

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

Seblod 3.9.1 Joomla 3.6.2

[klas]

Confirmed with Seblod 3.10., still here.

[Hertak]

Still, I have the issue when try search on "user_groups" see 1054 Unknown column 't2.groups' 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 #__users AS t2 ON t2.id = t0.pk LEFT JOIN #__cck_store_item_users AS t3 ON t3.id = t0.pk LEFT JOIN #__content AS t4 ON t4.id = t0.pkb LEFT JOIN #__user_usergroup_map AS t1 ON t1.user_id = t2.id LEFT JOIN #__cck_core_types AS tt ON tt.name = t0.cck WHERE t4.state = 1 AND t4.access IN (1,1,2,3,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40) AND ( t4.publish_up = '0000-00-00 00:00:00' OR t4.publish_up <= '2017-03-01 20:51' ) AND ( t4.publish_down = '0000-00-00 00:00:00' OR t4.publish_down >= '2017-03-01 20:51' ) AND t0.cck = 'user' AND (((t2.email LIKE '%belgrano%')) OR ((t3.first_name LIKE '%belgrano%')) OR ((t2.groups LIKE '%belgrano%')) OR ((t3.last_name LIKE '%belgrano%')) OR ((t2.name LIKE '%belgrano%'))) AND t2.block IN (0,1) AND t1.group_id != 8 ORDER BY t2.name ASC LIMIT 25

[klas]

usergroups uses user objects, I belive you can't search across different objects.

[Hertak]

Perfect i think are a problem not only for this i make a select with proper format Name=2 for example in articles work fine but in users work a time but stop of working and i don´t understand why i think on this problem sorry

[ghost]

Confirmed with Seblod 3.10.0, still here.

[webchun]

Is this issue already fixed? I'm using seblod 3.16.3 and issue persist

[ghost]

Is this issue already fixed? I'm using seblod 3.16.3 and issue persist

not fixed, still here.

Search Generic field try get data from COLUMN 't1.tags' from table #__content, but there is no such column! Joomla stores the tags in table #__tags. I think working solution somewhere in Article Tags Field...

[mrperformer]

SEBLOD 3.18.2 - still persist