[Phpgroupware-users] Some problems with the Projects Module

[Ruben Lopez]

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.