Error when going to administrator page

Vicky Bagwalla Posted in Technical Support 7 years ago

Anyone know what can be done about this:

OssnDatabaseException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ossndb.ossnusers.timecreated' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sqlmode=onlyfullgroupby SELECT DATEFORMAT(FROMUNIXTIME(timecreated), '%Y') AS year, DATEFORMAT(FROMUNIXTIME(timecreated) , '%m') AS month, COUNT(guid) AS total FROM ossnusers WHERE(timecreated > 0) GROUP by DATEFORMAT(FROMUNIXTIME(timecreated) , '%Y%m') ; in /var/www/html/ossn/classes/OssnDatabase.php:77 Stack trace: #0 /var/www/html/ossn/classes/OssnDatabase.php(175): OssnDatabase->execute() #1 /var/www/html/ossn/classes/OssnUser.php(949): OssnDatabase->select(Array, true) #2 /var/www/html/ossn/system/plugins/default/javascripts/dynamic/admin/dashboard/users/users.php(13): OssnUser->countByYearMonth() #3 /var/www/html/ossn/libraries/ossn.lib.views.php(27): include('/var/www/html/o...') #4 /var/www/html/ossn/libraries/ossn.lib.views.php(50): ossninclude('/var/www/html/o...', Array) #5 /var/www/html/ossn/libraries/ossn.lib.plugins.php(75): ossnview('/var/www/html/o...', Array) #6 /var/www/html/ossn/system/plugins/default/pages/administrator/contents/dashboard.php(156): ossnpluginview('javascripts/dyn...') #7 /var/www/html/ossn/libraries/ossn.lib.views.php(27): include('/var/www/html/o...') #8 /var/www/html/ossn/libraries/ossn.lib.views.php(50): ossninclude('/var/www/html/o...', Array) #9 /var/www/html/ossn/libraries/ossn.lib.plugins.php(75): ossnview('/var/www/html/o...', Array) #10 /var/www/html/ossn/libraries/ossn.lib.admin.php(204): ossnpluginview('pages/administr...') #11 /var/www/html/ossn/libraries/ossn.lib.page.php(67): ossnadministratorpagehandler(Array, 'administrator') #12 /var/www/html/ossn/index.php(21): ossnload_page('administrator', Array) #13 {main}

Replies
Catalan Vicky Bagwalla Replied 7 years ago

Thank you very much. Followed the article and this command worked:

SET GLOBAL sqlmode=(SELECT REPLACE(@@sqlmode,'ONLYFULLGROUP_BY',''));