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
Support
-
hwdevteam
- Bug Report
- Tuesday, March 01 2022, 09:15 AM
Request Support
Support is currently Offline
Support Availability
Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.
Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.
Guidelines
Before you post: read the documentation and search the forums for an answer to your question.
When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).
Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.
Language: only English
Search Users
Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.