[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: nobody
Subject: [Phpgroupware-tracker] [Bug #734] sql error when watching user statistics
Date: Wed, 09 Apr 2003 18:28:31 -0400

=================== BUG #734: LATEST MODIFICATIONS ==================

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, as id FROM 
phpgw_p_projects  JOIN  phpgw_p_hours ON phpgw_p_hours.employee='12' GROUP BY 
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/
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;bug_id=734&amp;bug_file_id=40

For detailed info, follow this link:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]