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.
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.