[Top][All Lists]
[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