1. hwdevteam
  2. Bug Report
  3. Tuesday, March 01 2022, 09:15 AM
getting a SQL query erro using MySql 8.

The error stops when I turn off the socialnetwork plugin.



42000 - SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #24 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxx_joomdev2.Profile.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
........................

/home/ngenorg/public_html/libraries/legacy/error/error.php:200
Call stack
# Function Location
1 () JROOT/libraries/legacy/error/error.php:200
2 JError::raise() JROOT/libraries/legacy/error/error.php:277
3 JError::raiseError() JROOT/plugins/jsn/socialnetwork/socialnetwork.php:228
4 SocialNetwork->__construct() JROOT/plugins/jsn/socialnetwork/socialnetwork.php:259
5 SocialNetwork::getInstance() JROOT/plugins/jsn/socialnetwork/socialnetwork.php:142
6 PlgJsnSocialnetwork->renderBeforeProfile() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
8 JEventDispatcher->trigger() JROOT/templates/t3_bs3_blank/html/com_jsn/profile/social.php:162
9 include() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701
10 Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230
11 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_users/views/profile/view.html.php:106
12 UsersViewProfile->display() JROOT/components/com_jsn/helpers/helper.php:86
13 JsnHelper::getUserProfile() JROOT/components/com_jsn/controller.php:62
14 JsnController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710
15 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jsn/jsn.php:16
16 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
17 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
18 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
19 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
20 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203
21 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
admin Accepted Answer
Admin
Hi,
thanks for report it, this error comes always or when you do something of specific? I have tested in MariaDB with config sql_mode=only_full_group_by but there is not any issue.

Unfortunately to have a environment with MySql 8 we need some time, therefore we are not able to give you a specific answer for now.

Have you tried to disable sql_mode=only_full_group_by in your MySql configuration?
  1. more than a month ago
  2. Bug Report
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.