[Phpgroupware-tracker] [Bug #734] sql error when watching user statistics

[nobody]

=================== BUG #734: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=734&group_id=509

Submitted by: beoe                      Project: phpGroupWare                   
Submitted on: 2002-Jun-23 15:46
Category:  projects                     Bug Group:  0.9.14 RC3                  
Severity:  5 - Major                    Priority:  Normal                       
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Platform Version:  Linux - RedHat       
Reproducibility:  Every Time            

Summary:  sql error when watching user statistics

Original Submission:  Click on 'Job List' and then on 'User statistics'.  By 
choosing a user I get the following error message:

-------- start Error message -----------
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='12' 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.
--------- end Error message --------------------

after changing the SQL statement to group by num as well, it works for me.  
patch included.



No Followups Have Been Posted


File Attachments
****************

-------------------------------------------------------
Date: 2002-Jun-23 15:46  Name: sql_patch.diff  Size: 0KB   By: beoe
patch for sql syntax
http://savannah.gnu.org/bugs/download.php?group_id=509&bug_id=734&bug_file_id=40


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=734&group_id=509