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

Events

Search Events...
No events found.

User Error: Query Error:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.im.parent_id' 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)
1 include/library/phpfox/error/error.class.php : 91   trigger_error("Query Error:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.im.parent_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", 256)
2 include/library/phpfox/database/driver/mysql.class.php : 187   Phpfox_Error::trigger("Query Error:Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'voiceand_community.im.parent_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by", 256)
3 include/library/phpfox/database/driver/mysql.class.php : 577   Phpfox_Database_Driver_Mysql->query("SELECT im.parent_id, ib.user_id AS is_blocked_user, ls.im_status,ls.last_activity, u.status, 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_friend AS f JOIN phpfox_user AS u ON(u.user_id = f.friend_user_id) JOIN phpfox_log_session AS ls ON(ls.user_id = f.friend_user_id AND ls.im_hide = 0) LEFT JOIN phpfox_user_blocked AS ib ON((ib.user_id = f.friend_user_id AND ib.block_user_id = 0) OR (ib.user_id = 0 AND ib.block_user_id = f.friend_user_id)) LEFT JOIN phpfox_im AS im ON(im.user_id = u.user_id) WHERE f.user_id = 0 AND u.im_hide != 1 GROUP BY u.user_id ORDER BY u.full_name ASC /* OO Query */", Resource id #37)
4 include/library/phpfox/database/dba.class.php : 126   Phpfox_Database_Driver_Mysql->_getRows("SELECT im.parent_id, ib.user_id AS is_blocked_user, ls.im_status,ls.last_activity, u.status, 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_friend AS f JOIN phpfox_user AS u ON(u.user_id = f.friend_user_id) JOIN phpfox_log_session AS ls ON(ls.user_id = f.friend_user_id AND ls.im_hide = 0) LEFT JOIN phpfox_user_blocked AS ib ON((ib.user_id = f.friend_user_id AND ib.block_user_id = 0) OR (ib.user_id = 0 AND ib.block_user_id = f.friend_user_id)) LEFT JOIN phpfox_im AS im ON(im.user_id = u.user_id) WHERE f.user_id = 0 AND u.im_hide != 1 GROUP BY u.user_id ORDER BY u.full_name ASC /* OO Query */", TRUE, Resource id #37)
5 include/library/phpfox/database/dba.class.php : 530   Phpfox_Database_Dba->getSlaveRows("SELECT im.parent_id, ib.user_id AS is_blocked_user, ls.im_status,ls.last_activity, u.status, 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_friend AS f JOIN phpfox_user AS u ON(u.user_id = f.friend_user_id) JOIN phpfox_log_session AS ls ON(ls.user_id = f.friend_user_id AND ls.im_hide = 0) LEFT JOIN phpfox_user_blocked AS ib ON((ib.user_id = f.friend_user_id AND ib.block_user_id = 0) OR (ib.user_id = 0 AND ib.block_user_id = f.friend_user_id)) LEFT JOIN phpfox_im AS im ON(im.user_id = u.user_id) WHERE f.user_id = 0 AND u.im_hide != 1 GROUP BY u.user_id ORDER BY u.full_name ASC /* OO Query */")
6 module/im/include/service/im.class.php : 180   Phpfox_Database_Dba->execute("getSlaveRows")
7 module/im/include/component/block/footer.class.php : 62   Im_Service_Im->getOnlineFriends(0, Array(1))
8 include/library/phpfox/module/module.class.php : 808   Im_Component_Block_Footer->process()
9 include/library/phpfox/phpfox/phpfox.class.php : 351   Phpfox_Module->getComponent("im.footer", Array(0), "block", FALSE)
10 file/cache/template/core_template_default_block_template-footer.html.php.php : 17   Phpfox::getBlock("im.footer", Array(0))
11 include/library/phpfox/template/template.class.php : 2770   require("file/cache/template/core_template_default_block_template-footer.html.php.php")
12 include/library/phpfox/template/template.class.php : 2239   Phpfox_Template->_getFromCache("module/core/template/default/block/template-footer.html.php")
13 include/library/phpfox/module/module.class.php : 851   Phpfox_Template->getTemplate("core.block.template-footer")
14 include/library/phpfox/phpfox/phpfox.class.php : 351   Phpfox_Module->getComponent("core.template-footer", Array(0), "block", FALSE)
15 file/cache/template/frontend_cosmic_template_template.html.php.php : 183   Phpfox::getBlock("core.template-footer")
16 include/library/phpfox/template/template.class.php : 2770   require("file/cache/template/frontend_cosmic_template_template.html.php.php")
17 include/library/phpfox/template/template.class.php : 1987   Phpfox_Template->_getFromCache("theme/frontend/cosmic/template/template.html.php")
18 include/library/phpfox/phpfox/phpfox.class.php : 1307   Phpfox_Template->getLayout("template")
19 index.php : 42   Phpfox::run()