phpGroupWare - Bugs: bug #3376, Wrong database relation
You are not allowed to post comments on this tracker with your current authentication level.
bug #3376: Wrong database relation
Submitter: | Kai Hofmann <powerstat> | ||
Submitted: | Tue 29 Apr 2003 09:09:26 AM UTC | ||
Category: | projects | Item Group: | None |
Severity: | 3 - Normal | Priority: | 5 - Normal |
Status: | None | Privacy: | Public |
Assigned to: | ceb | Open/Closed: | Open |
Component Version: | None | Operating System: | None |
Reproducibility: | None | Planned Release: | 0.9.18.000 |
Fixed Release: |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
CC list is empty
There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.
Follow 2 latest changes.
Date | Changed by | Updated Field | Previous Value | => | Replaced by |
---|---|---|---|---|---|
2004-07-15 | skwashd | Planned Release | None | 0.9.18.000 | |
2003-04-30 | skwashd | Assigned to | None | None |
Powered by Savane 3.13-caa5.
Corresponding source code
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