Radicore Forum: Menu and Security » SQL error in mnu_role_taskfield

Home » RADICORE development » Menu and Security » SQL error in mnu_role_taskfield_multi(b).php

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?

Report message to a moderator

[Message index]

		SQL error in mnu_role_taskfield_multi(b).php By: mitjok on Mon, 04 December 2006 06:25
		Re: SQL error in mnu_role_taskfield_multi(b).php By: AJM on Mon, 04 December 2006 09:29

Previous Topic:	Proc as Start Task?
Next Topic:	Access to "Home"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 11 23:38:12 EDT 2025

Total time taken to generate the page: 0.09339 seconds