[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #3376] Wrong database relation
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #3376] Wrong database relation |
Date: |
Tue, 29 Apr 2003 20:16:07 -0400 |
=================== BUG #3376: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3376&group_id=509
Changes by: Dave Hall <address@hidden>
Date: Wed 04/30/2003 at 10:16 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Assigned to | None | ceb
=================== BUG #3376: FULL BUG SNAPSHOT ===================
Submitted by: powerstat Project: phpGroupWare
Submitted on: Tue 04/29/2003 at 19:09
Category: projects Bug Group: None
Severity: 5 - Major Priority: Normal
Resolution: None Assigned to: ceb
Status: Open Component Version: None
Platform Version: None Reproducibility: None
Summary: Wrong database relation
Original Submission: This join statement is wrong - there is no connection
between the two tables - should be:
"phpgw_p_projects.id = join phpgw_p_hours.project_id WHERE "
$this->db->query("SELECT title,num,phpgw_p_projects.id
as id FROM phpgw_p_projects $join phpgw_p_hours ON "
.
"phpgw_p_hours.employee='" . $account_id . "' GROUP BY
title,num,phpgw_p_projects.id",__LINE__,__FILE__);
./projects/inc/class.sostatistics.inc.php
No Followups Have Been Posted
CC list is empty
No files currently attached
For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3376&group_id=509