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