Try searching with the standard Joomla! search with debug ON.I am getting:500 - JDatabaseMySQL::query: 1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is
illegal if there is no GROUP BY clause SQL=SELECT COUNT(id) as counter,
userName, userID, commentEmail FROM jos_k2_comments WHERE userID > 0
AND published = 1 LIMIT 0, 5Using MySQLi
MySQL 5.0.45PHP 5.2.6Apache/2.2.3 (CentOS)When debug is turned off, the search does not return any results.

I'm having exactly the same problem. Any solutions yet?

No k2 results on normal mode, and this errorwith debug ON

JDatabaseMySQL::query: 1210 - Incorrect arguments to MATCH SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, tags.name as tag, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM jos_k2_items AS i INNER JOIN jos_k2_categories AS c ON c.id=i.catid AND c.access <= 18 LEFT JOIN jos_k2_tags_xref tags_xref ON tags_xref.itemID = i.id LEFT JOIN jos_k2_tags tags ON tags.id = tags_xref.tagID WHERE MATCH(i.title, i.introtext, i.`fulltext`,tags.name,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('clara') AND i.trash = 0 AND i.published = 1 AND i.access <= 1 AND c.published = 1 AND c.access <= 1 AND c.trash = 0 GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

I'm using:

Joomla 1.5.15
MySQL 5.1.30
PHP 5.2.9
Apache 2.2.11


Fernando P said:I'm having exactly the same problem. Any solutions yet?
No k2 results on normal mode, and this errorwith debug ON

JDatabaseMySQL::query: 1210 - Incorrect arguments to MATCH SQL=SELECT i.title AS title, i.metadesc, i.metakey, c.name as section, i.image_caption, i.image_credits, i.video_caption, i.video_credits, i.extra_fields_search, tags.name as tag, i.created, CONCAT(i.introtext, i.fulltext) AS text, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM jos_k2_items AS i INNER JOIN jos_k2_categories AS c ON c.id=i.catid AND c.access <= 18 LEFT JOIN jos_k2_tags_xref tags_xref ON tags_xref.itemID = i.id LEFT JOIN jos_k2_tags tags ON tags.id = tags_xref.tagID WHERE MATCH(i.title, i.introtext, i.`fulltext`,tags.name,i.extra_fields_search,i.image_caption,i.image_credits,i.video_caption,i.video_credits,i.metadesc,i.metakey) AGAINST ('clara') AND i.trash = 0 AND i.published = 1 AND i.access <= 1 AND c.published = 1 AND c.access <= 1 AND c.trash = 0 GROUP BY i.id ORDER BY i.created DESC LIMIT 0, 50

Hi. OK found the bug. Go to K2 search plugin and set "Enable searching in tags" to "No". This way search will work again. This parameter will be removed from the plugin. Thank you all for reporting this issue to us.

I ran a test at K2Joom.com with Enable searching in tags to YES.

My page: Project E-Store Part 2 has tags in it.
I then search using keywords such as part 2 and it finds the item.

It would also be great to know how to set the page correctly when no results are found.
For example a search at K2Koom.com for K2_content shows no result, but also not any header to say Search produced no results. Where can I modify that?

Thanks.



I then set searching in tags to NO.
Clear cache
Search the same words and the item is still displayed.

Seems to have no effect for me.

Hi, I want search plugin to work with "Enable searching in tags"

Lefteris Kavadas said:Hi. OK found the bug. Go to K2 search plugin and set "Enable searching in tags" to "No". This way search will work again. This parameter will be removed from the plugin. Thank you all for reporting this issue to us.

At the K2 Search Plugin I can only find "Search Limit" (50) - no other parameters?

Here is a screen shot of my K2 Search Plugin



Pomba said:

At the K2 Search Plugin I can only find "Search Limit" (50) - no other parameters?

I find that very wierd. I have the exact same as your screenshot - minus the Tag-searching-opinion. =o

K2Joom said:Here is a screen shot of my K2 Search Plugin

Pomba said:

At the K2 Search Plugin I can only find "Search Limit" (50) - no other parameters?

Which version of K2 are you running?

Pomba said:I find that very wierd. I have the exact same as your screenshot - minus the Tag-searching-opinion. =o
K2Joom said:Here is a screen shot of my K2 Search Plugin

Pomba said:

At the K2 Search Plugin I can only find "Search Limit" (50) - no other parameters?