bugphpGroupWare - Bugs: bug #3380, accounts table is not needed in...

 
 

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

bug #3380: accounts table is not needed in query - /news_admin/website/export.php

Submitted by:  Kai Hofmann <powerstat>
Submitted on:  Tue 29 Apr 2003 09:13:23 AM UTC  
 
Item Group: SVN trunk (dev code)Category: 136(Error - Not Found)
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: NoneOpen/Closed: Closed
Component Version: NoneOperating System: None
Reproducibility: NonePlanned Release: None
Fixed Release: 

Sun 04 May 2003 06:16:58 AM UTC, comment #1:

This has been fixed in CVS and should be available in the next
release.

Dave Hall <skwashd>
Project Administrator
Tue 29 Apr 2003 09:13:23 AM UTC, original submission:

Using the accounts table here is useless because there is no connection between these two tables (missing where) - so the join produces a lot of overhead!!!

$db->query("select * from phpgw_news,accounts where news_status='Active' order by news_date "
./news_admin/website/export.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 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sun 04 May 2003 06:16:58 AM UTCskwashdStatusNone=>(Error - Not Found)
  Open/ClosedOpen=>(Error - Not Found)
Wed 30 Apr 2003 12:42:35 AM UTCskwashdSummaryWrong SQL select uses accounts table=>

Back to the top


Powered by Savane 3.1-cleanup1