[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 
>>>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.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]