[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-users] Re: More SiteMgr errors (with versioning)
From: |
totschnig . michael |
Subject: |
[Phpgroupware-users] Re: More SiteMgr errors (with versioning) |
Date: |
Tue, 03 Jun 2003 12:24:29 -0400 |
User-agent: |
Gnus/5.090008 (Oort Gnus v0.08) XEmacs/21.4 (Common Lisp, i386-redhat-linux) |
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