[Phpgroupware-tracker] [Bug #3380] accounts table is not needed in query - /news_admin/website/export.php

[nobody]

=================== BUG #3380: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3380&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Sun 05/04/2003 at 16:16 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
This has been fixed in CVS and should be available in the next
release.



=================== BUG #3380: FULL BUG SNAPSHOT ===================


Submitted by: powerstat               Project: phpGroupWare                 
Submitted on: Tue 04/29/2003 at 19:13
Category:  news_admin                 Bug Group:  devel cvs                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  Fixed                    Assigned to:  None                    
Status:  Closed                       Component Version:  None              
Platform Version:  None               Reproducibility:  None                

Summary:  accounts table is not needed in query - 
/news_admin/website/export.php 

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


Follow-up Comments
*******************

-------------------------------------------------------
Date: Sun 05/04/2003 at 16:16       By: skwashd
This has been fixed in CVS and should be available in the next
release.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3380&group_id=509