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(*), a.`id`, a.`title`, a.`access`, a.`introtext` AS article_intro, a.`fulltext` AS article_full, a.`state` AS published, a.`created`, a.`modified`, a.`ordering`, b.`id` AS section_id, b.`title` AS section_name, c.`id` AS category_id, c.`title` AS category_name, d.`id` AS user_id, d.`name` AS user_name, d.`username` AS user_username FROM `jpx1597_content` AS a LEFT JOIN `jpx1597_sections` AS b ON a.`sectionid` = b.`id` LEFT JOIN `jpx1597_categories` AS c ON a.`catid` = c.`id` LEFT JOIN `jpx1597_users` AS d ON a.`created_by` = d.`id` WHERE a.`state` = 1 AND a.`access` <= 2 AND a.`created_by` = 62 AND b.`published` = 1 AND b.`access` <= 2 AND c.`published` = 1 AND c.`access` <= 2 Call stack # Function Location 1 JSite->dispatch() /var/www/index.php:68 2 JComponentHelper->renderComponent() /var/www/includes/application.php:124 3 require_once() /var/www/libraries/joomla/application/component/helper.php:162 4 userProfile() /var/www/components/com_comprofiler/comprofiler.php:284 5 HTML_comprofiler::userProfile() /var/www/components/com_comprofiler/comprofiler.php:670 6 CBuser->getProfileView() /var/www/components/com_comprofiler/comprofiler.html.php:434 7 cbTabs->getViewTabs() /var/www/administrator/components/com_comprofiler/plugin.foundation.php:1115 8 cbTabs->generateViewTabsContent() /var/www/administrator/components/com_comprofiler/comprofiler.class.php:3395 9 cbTabs->_callTabPlugin() /var/www/administrator/components/com_comprofiler/comprofiler.class.php:3340 10 cbPluginHandler->call() /var/www/administrator/components/com_comprofiler/comprofiler.class.php:4112 11 call_user_func_array() /var/www/administrator/components/com_comprofiler/plugin.class.php:582 12 cbarticlesTab->getDisplayTab() 13 cbarticlesModel->getArticlesTotal() /var/www/components/com_comprofiler/plugin/user/plug_cbarticles/tab.cbarticles.php:33 14 CBdatabase->loadResult() /var/www/components/com_comprofiler/plugin/user/plug_cbarticles/models/joomla15.php:66 15 JDatabaseMySQL->loadResult() /var/www/administrator/components/com_comprofiler/library/cb/cb.database.php:733 16 JDatabaseMySQL->query() /var/www/libraries/joomla/database/database/mysql.php:355 17 JError->raiseError() /var/www/libraries/joomla/database/database/mysql.php:231 18 JError->raise() /var/www/libraries/joomla/error/error.php:171 19 JException->__construct() /var/www/libraries/joomla/error/error.php:136