Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Menu and Security » SQL error in mnu_role_taskfield_multi(b).php
SQL error in mnu_role_taskfield_multi(b).php [message #436] Mon, 04 December 2006 06:25 Go to previous message
mitjok is currently offline  mitjok
Messages: 6
Registered: June 2006
Junior Member
RADICORE v1.17.0 issues sql error on Postgres v8.1.3. while trying to restrict access to a field by role (task: mnu_role_taskfield(multi)b):

Fatal Error: pg_query() [function.pg-query]: Query failed: ERROR: 42803: column "mnu_role.global_access" must appear in the GROUP BY clause or be used in an aggregate function LOCATION: check_ungrouped_columns_walker, parse_agg.c:330 (# 256).

SQL query: SELECT count(*) FROM mnu_role LEFT JOIN mnu_task ON (mnu_task.task_id=mnu_role.start_task_id) WHERE mnu_role.role_id='LIMITED' HAVING global_access='N'

Should the content of the $outer_sql_having be moved to $outer_sql_where?

Read Message
Read Message
Previous Topic: Proc as Start Task?
Next Topic: Access to "Home"
Goto Forum:

Current Time: Wed Jan 26 02:57:44 EST 2022

Total time taken to generate the page: 0.01089 seconds