bugphpGroupWare - 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: 

Tue 29 Apr 2003 09:09:26 AM UTC, 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

Kai Hofmann <powerstat>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

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 ReleaseNone 0.9.18.000
2003-04-30 skwashd Assigned toNone None

Back to the top

Copyright © 2024 Free Software Foundation, Inc.
Verbatim copying and distribution of this entire article is permitted in any medium, provided this notice is preserved.
The Levitating, Meditating, Flute-playing Gnu logo is a GNU GPL'ed image provided by the Nevrax Design Team.
Page source code

Powered by Savane 3.13-269c.
Corresponding source code