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

[nobody]

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

Changes by: Bettina Gille <address@hidden>
Date: Wed 04/09/2003 at 22:28 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | ceb




=================== BUG #734: FULL BUG SNAPSHOT ===================


Submitted by: beoe                    Project: phpGroupWare                 
Submitted on: Sun 06/23/2002 at 15:46
Category:  projects                   Bug Group:  0.9.14 RC3                
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  None                     Assigned to:  ceb                     
Status:  Open                         Component Version:  None              
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


CC list is empty


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

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


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