Re: [Phpgroupware-users] Some problems with the Projects Module

[Michal Samek]

Hi,
I remember that I have the same problem with my php application, there
are some differencies in handling grouped select statement between some
versions of postgresql. What version are you running? Can you try to
modify the source code and include the field num within GROUP BY field
list? 


On Pá, 2002-12-06 at 15:32, Ruben Lopez wrote:
> Hi, 
> 
> When trying to get statistics by user (user statistics) the following error
>  shows up:
> 
> Database error: Invalid SQL: SELECT title,num,phpgw_p_projects.id as id FROM
> phpgw_p_projects JOIN  phpgw_p_hours ON phpgw_p_hours.employee='3' GROUP BY
> title,phpgw_p_projects.id
>     
> PostgreSQL Error: 1 (ERROR: Attribute phpgw_p_projects.num must be GROUPed or
> used in an aggregate function )
> 
> File: /var/www/html/phpgroupware/projects/inc/class.sostatistics.inc.php
> Line: 78
> 
>  Session halted. 
> 
>  how can I solve it?
> 
> 
> -------
> RUBEN DARIO LOPEZ A.
> Ingeniero de Operaciones
> Ubiquando Ltda.
> 
> 

-- 
Michal Samek <address@hidden>