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

Re: SQL error in mnu_role_taskfield_multi(b).php [message #437 is a reply to message #436]

Mon, 04 December 2006 09:29

AJM
Messages: 2363
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.

Attachment: mnu_role_taskfield_multi(b).php
(Size: 1.79KB, Downloaded 1389 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 03 03:00:32 EST 2024

Total time taken to generate the page: 0.01076 seconds