[Phpgroupware-users] Re: More SiteMgr errors (with versioning)

[totschnig . michael]

Ralf Becker <address@hidden> a écrit:

> address@hidden schrieb:
>> "Magnus Nilsson" <address@hidden> a écrit:
>>
>>>I get a new error when I try to access "Manage Archive".
>>>Here it is:
>>>Database error: Invalid SQL: SELECT COUNT(*) AS
>>>cnt,t1.block_id,area,cat_id,page_id,viewable,state FROM phpgw_sitemgr_blocks 
>>>AS
>>>t1,phpgw_sitemgr_content as t2 WHERE t1.block_id=t2.block_id AND ((cat_id = 
>>>9) OR
>>>(cat_id IN (10))) AND state IN (4) GROUP BY t1.block_id
>>>PostgreSQL Error: 1 (ERROR: Attribute t1.area must be GROUPed or used in an
>>>aggregate function )
>
> You only have to add it in the GROUP BY clause. This is SQL standard
> as not adding it there could be ambigous. MySQL silently adds it.

thank you for the suggestion! I commited the change and I think it
should work now with postgres.

Michael