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.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 /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): ossn_include('/var/www/html/o...', Array) #5 /var/www/html/ossn/libraries/ossn.lib.plugins.php(75): ossn_view('/var/www/html/o...', Array) #6 /var/www/html/ossn/system/plugins/default/pages/administrator/contents/dashboard.php(156): ossn_plugin_view('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): ossn_include('/var/www/html/o...', Array) #9 /var/www/html/ossn/libraries/ossn.lib.plugins.php(75): ossn_view('/var/www/html/o...', Array) #10 /var/www/html/ossn/libraries/ossn.lib.admin.php(204): ossn_plugin_view('pages/administr...') #11 /var/www/html/ossn/libraries/ossn.lib.page.php(67): ossn_administrator_pagehandler(Array, 'administrator') #12 /var/www/html/ossn/index.php(21): ossn_load_page('administrator', Array) #13 {main}
Thank you very much. Followed the article and this command worked:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Due to the many requests in the past for additonal features and components we have decided to develope a premium version. Features like Hashtags, Videos, Polls, Events, Stories, Link Preview, etc included in it.
$199 (Life Time)