16 Posts
KateD
10 years ago
6
Topic

Hi, newbie here, but enjoying diving into Seblod.

I'm attempting to create a search using the Article Tags field.  This is a clean install of Seblod 3.1.5 and Joomla 3.1.5.  Storage on the Article Tags field was left as the default - Standard-Article-Tags.  I'm unable to complete the search, whether I'm searching a custom content type, or the standard Joomla articles content type.  The error is below.  Can someone please help me decipher how to fix my issue?

Unknown column 't1.tags' in 'where clause' SQL=SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `u259q_cck_core` AS t0 LEFT JOIN `u259q_content` AS t1 ON t1.id = t0.pk LEFT JOIN `u259q_cck_core_types` AS tt ON tt.name = t0.cck WHERE t1.state = 1 AND t1.access IN (1,1,2,3) AND ( t1.publish_up = '0000-00-00 00:00:00' OR t1.publish_up <= '2013-09-05 16:15:42' ) AND ( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >= '2013-09-05 16:15:42' ) AND t0.cck = 'listings' AND t1.tags LIKE '%%' GROUP BY t0.pk ORDER BY t1.title ASC

Note: I'm hoping to be able to search by tags to achieve autocomplete functionality.  Unless there is a better way to achieve this using checkboxes or a multiple select list?

Many thanks,
Kate

Get a Book for SEBLOD
4 Posts
Clément Wam
10 years ago
0
Level 1

Hello Kate.

I have the same issue. Did you find a solution ? Or anyone ?

Thx

16 Posts
KateD
10 years ago
0
Level 1

No, I don't have a solution yet. 

116 Posts
nycxav
9 years ago
0
Level 1

Hi, 

I have the same problem. The column 'tags' doesn't exist in #__content. That's why you get the error message. 

Tags are stored in #__contentitem_tag_map and therefore that's the table that should be queried. 

I think seblod field "Article Tags" is not up to date. 

I'm looking into a solution.

X.

56 Posts
mrits
9 years ago
2
Level 1

Same here. :-(

Please help ;-)

56 Posts
mrits
9 years ago
0
Level 3

works fine :-) 

Thanks a lot

Get a VIP membership