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 next 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?

Re: SQL error in mnu_role_taskfield_multi(b).php [message #437 is a reply to message #436] Mon, 04 December 2006 09:29 Go to previous message
AJM is currently offline  AJM
Messages: 2275
Registered: April 2006
Location: Surrey, UK
Senior Member
Attached is an updated version of mnu_role_taskfield_multi(b).php which should fix the problem.

The tricky part is that PostgreSQL and MySQL require slightly different syntax, so I have to find out which DBMS is being used to that I can provide the correct statement.

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

Current Time: Fri Dec 03 17:30:07 EST 2021

Total time taken to generate the page: 0.01203 seconds