Error message : I can't create user

alcide Gaston Posted in Technical Support 8 years ago

Hi everybody !

I just installed OSSN, everythings is ok but i have one big problem : i can't create some new users.

I have this message :

exception 'OssnDatabaseException' with message 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ossn.ossn_users.time_created' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT DATE_FORMAT(FROM_UNIXTIME(time_created), '%Y') AS year, DATE_FORMAT(FROM_UNIXTIME(time_created) , '%m') AS month, COUNT(guid) AS total FROM ossn_users WHERE(time_created > 0) GROUP by DATE_FORMAT(FROM_UNIXTIME(time_created) , '%Y%m') ; ' in C:wamp64wwwossnclassesOssnDatabase.php:77 Stack trace: #0 C:wamp64wwwossnclassesOssnDatabase.php(175): OssnDatabase->execute() #1 C:wamp64wwwossnclassesOssnUser.php(950): OssnDatabase->select(Array, true) #2 C:wamp64wwwossnsystempluginsdefaultjavascriptsdynamicadmindashboardusersusers.php(13): OssnUser->countByYearMonth() #3 C:wamp64wwwossnlibrariesossn.lib.views.php(27): include('C:\wamp64\www\o...') #4 C:wamp64wwwossnlibrariesossn.lib.views.php(50): ossn_include('C:/wamp64/www/o...', Array) #5 C:wamp64wwwossnlibrariesossn.lib.plugins.php(75): ossn_view('system/plugins/...', Array) #6 C:wamp64wwwossnsystempluginsdefaultpagesadministratorcontentsdashboard.php(156): ossn_plugin_view('javascripts/dyn...') #7 C:wamp64wwwossnlibrariesossn.lib.views.php(27): include('C:\wamp64\www\o...') #8 C:wamp64wwwossnlibrariesossn.lib.views.php(50): ossn_include('C:/wamp64/www/o...', Array) #9 C:wamp64wwwossnlibrariesossn.lib.plugins.php(75): ossn_view('system/plugins/...', Array) #10 C:wamp64wwwossnlibrariesossn.lib.admin.php(204): ossn_plugin_view('pages/administr...') #11 [internal function]: ossn_administrator_pagehandler(Array, 'administrator') #12 C:wamp64wwwossnlibrariesossn.lib.page.php(67): call_user_func('ossn_administra...', Array, 'administrator') #13 C:wamp64wwwossnindex.php(21): ossn_load_page('administrator', false) #14 {main}

Anyone can help me to solve this problem ?

Thanks a lot.

Replies
Indonesian Arsalan Shah Replied 8 years ago

It seems your server isn't configured correctly, you need to disable only_full_group_by in your sql database settings.