phpgroupware-tracker
[Top][All Lists]
Advanced

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

[Phpgroupware-tracker] [Bug #1163] error for postgresql query


From: nobody
Subject: [Phpgroupware-tracker] [Bug #1163] error for postgresql query
Date: Mon, 09 Sep 2002 16:00:56 -0400

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

Changes by: Bettina Gille <address@hidden>
Date: 2002-Sep-09 20:00 (GMT)

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




=================== BUG #1163: FULL BUG SNAPSHOT ===================


Submitted by: lance                     Project: phpGroupWare                   
Submitted on: 2002-Sep-09 14:27
Category:  projects                     Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  Normal                       
Resolution:  None                       Assigned to:  ceb                       
Status:  Open                           Platform Version:  None                 
Reproducibility:  Every Time            

Summary:  error for postgresql query

Original Submission:  SQL error when looking user stats.

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='9' 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: /home/httpd/lab/phpgroupware/projects/inc/class.sostatistics.inc.php
Line: 78



No Followups Have Been Posted




No files currently attached


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




reply via email to

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