| SQL error in mnu_role_taskfield_multi(b).php [message #436] |
Mon, 04 December 2006 06:25  |
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?
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
