Sign Up
Voice And Studio - The fastest growing media professionals' network in the world.

User Error: Query Error:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.s.last_activity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - include/library/phpfox/error/error.class.php (91)
include/library/phpfox/error/error.class.php : 91   trigger_error("Query Error:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.s.last_activity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", 256)
include/library/phpfox/database/driver/mysql.class.php : 187   Phpfox_Error::trigger("Query Error:Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.s.last_activity' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", 256)
include/library/phpfox/database/driver/mysql.class.php : 577   Phpfox_Database_Driver_Mysql->query("SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity FROM phpfox_log_session AS s JOIN phpfox_user AS u ON(u.user_id = s.user_id) WHERE s.is_forum = 1 AND s.last_activity > '1537431989' GROUP BY u.user_id ORDER BY s.last_activity LIMIT 20 /* OO Query */", Resource id #37)
include/library/phpfox/database/dba.class.php : 126   Phpfox_Database_Driver_Mysql->_getRows("SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity FROM phpfox_log_session AS s JOIN phpfox_user AS u ON(u.user_id = s.user_id) WHERE s.is_forum = 1 AND s.last_activity > '1537431989' GROUP BY u.user_id ORDER BY s.last_activity LIMIT 20 /* OO Query */", TRUE, Resource id #37)
include/library/phpfox/database/dba.class.php : 530   Phpfox_Database_Dba->getSlaveRows("SELECT u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity FROM phpfox_log_session AS s JOIN phpfox_user AS u ON(u.user_id = s.user_id) WHERE s.is_forum = 1 AND s.last_activity > '1537431989' GROUP BY u.user_id ORDER BY s.last_activity LIMIT 20 /* OO Query */")
module/log/include/service/session.class.php : 284   Phpfox_Database_Dba->execute("getSlaveRows")
module/log/include/component/block/active-users.class.php : 33   Log_Service_Session->getActiveUsers(Array(1))
include/library/phpfox/module/module.class.php : 808   Log_Component_Block_Active_Users->process()
include/library/phpfox/phpfox/phpfox.class.php : 351   Phpfox_Module->getComponent("log.active-users", Array(0), "block", FALSE)
10 file/cache/template/frontend_cosmic_template_template.html.php.php : 116   Phpfox::getBlock("log.active-users")
11 include/library/phpfox/template/template.class.php : 2770   require("file/cache/template/frontend_cosmic_template_template.html.php.php")
12 include/library/phpfox/template/template.class.php : 1987   Phpfox_Template->_getFromCache("theme/frontend/cosmic/template/template.html.php")
13 include/library/phpfox/phpfox/phpfox.class.php : 1307   Phpfox_Template->getLayout("template")
14 index.php : 42   Phpfox::run()