Re: [Phpgroupware-developers] comics module

[Michael Dean]

The SQL should be more like

select count(*) from phpgw_comic_data

The order by clause is invalid in the context of an aggregate function.

On Thu, 2002-04-18 at 13:57, Brian Johnson wrote:
> I know it's a minor issue, but when I upgraded to 0.9.14RC3 my comics
> stopped working
> 
> I get:
> Warning: limit() is no longer used, use limit_query()Database error: Invalid
> SQL: select count(*) from phpgw_comic_data order by data_title asc
> PostgreSQL Error: 1 (ERROR: Attribute phpgw_comic_data.data_title must be
> GROUPed or used in an aggregate function )
> Session halted.
-- 
Michael L. Dean
Double Choco Latte - http://dcl.sourceforge.net/
GNU Enterprise     - http://www.gnuenterprise.org/