bugphpGroupWare - Bugs: bug #3376, Wrong database relation

 
 

You are not allowed to post comments on this tracker with your current authentification level.

bug #3376: Wrong database relation

Submitted by:  Kai Hofmann <powerstat>
Submitted on:  Tue 29 Apr 2003 09:09:26 AM UTC  
 
Item Group: NoneCategory: projects
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: Bettina Gille <ceb>Open/Closed: Open
Component Version: NoneOperating System: None
Reproducibility: NonePlanned 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>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 15 Jul 2004 10:59:39 PM UTCskwashdPlanned ReleaseNone=>0.9.18.000
Wed 30 Apr 2003 12:16:06 AM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup