Joomla Extensions Club 20,483 posts

[byoonico Friend byoonicoJoin date: March 2014Posts: 11Downloads:0Uploads:3 Thanks: 2]

#195982

Hello, I have another problem, when I use the search field to look for something it shows me an error:

“SQL=SELECT COUNT(TM.ITEM_ID) AS NUM_ITEMS, CONCAT_WS(‘_’, `TYPE`, `ASSET_ID`, `OPTION_ID`, `LABELS`) AS TKEY FROM QX9JV_JAK2FILTER_TAXONOMY T INNER JOIN QX9JV_JAK2FILTER_TAXONOMY_MAP TM ON TM.NODE_ID = T.ID WHERE TM.ITEM_ID IN ( SELECT I.ID FROM QX9JV_K2_ITEMS AS I RIGHT JOIN QX9JV_K2_CATEGORIES AS C ON C.ID = I.CATID WHERE I.PUBLISHED = 1 AND I.ACCESS IN(1,1) AND I.TRASH = 0 AND C.PUBLISHED = 1 AND C.ACCESS IN(1,1) AND C.TRASH = 0 AND ( I.PUBLISH_UP = ‘0000-00-00 00:00:00’ OR I.PUBLISH_UP <= ‘2014-03-20 15:43:22’ ) AND ( I.PUBLISH_DOWN = ‘0000-00-00 00:00:00’ OR I.PUBLISH_DOWN >= ‘2014-03-20 15:43:22’ ) AND MATCH(I.TITLE, I.INTROTEXT, I.`FULLTEXT`, I.IMAGE_CAPTION, I.IMAGE_CREDITS, I.VIDEO_CAPTION, I.VIDEO_CREDITS, I.METADESC, I.METAKEY) AGAINST (‘””‘ IN BOOLEAN MODE) ) GROUP BY TKEY”

---

Attachments:

1. 

[ekhymosis06 Friend ekhymosis06Join date: March 2014Posts: 42Downloads:0Uploads:8 Thanks: 21 Thanked: 1 times in 1 posts]

#527534

I have the same error… could you fix it?

[byoonico Friend byoonicoJoin date: March 2014Posts: 11Downloads:0Uploads:3 Thanks: 2]

#527535

Not yet :/

Waiting for someone could help us

[ekhymosis06 Friend ekhymosis06Join date: March 2014Posts: 42Downloads:0Uploads:8 Thanks: 21 Thanked: 1 times in 1 posts]

#527538

I find the solution! 🙂

Check this.

http://www.joomlart.com/forums/topic/error-1214-when-trying-to-filter-after-keyword/

This solved the problem.

1 user says Thank You to ekhymosis06 for this useful post

1. JA Developer

[byoonico Friend byoonicoJoin date: March 2014Posts: 11Downloads:0Uploads:3 Thanks: 2]

#527539

Great! but are you sure is the same error?

[ekhymosis06 Friend ekhymosis06Join date: March 2014Posts: 42Downloads:0Uploads:8 Thanks: 21 Thanked: 1 times in 1 posts]

#527545

Make a backup of your database and try it…

[byoonico Friend byoonicoJoin date: March 2014Posts: 11Downloads:0Uploads:3 Thanks: 2]

#527573

I couldnt do it, Could you explain me step by step please?
sorry

[Thanh Nguyen Viet Friend Thanh Nguyen VietJoin date: September 2014Posts: 1461Downloads:0Uploads:44 Thanked: 258 times in 217 posts]

#528158

@ byoonico,

Please PM me your hosting control panel credentials, I’ll help you to resolve this issue.

[Author]

Posts