[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: Tue 10/14/2003 at 12:33 (GMT)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed




=================== 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:  Fixed                    Assigned to:  ceb                     
Status:  Closed                       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

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/