[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-tracker] [Bug #3380] accounts table is not needed in query

From: nobody
Subject: [Phpgroupware-tracker] [Bug #3380] accounts table is not needed in query - /news_admin/website/export.php
Date: Tue, 29 Apr 2003 20:42:35 -0400

=================== BUG #3380: LATEST MODIFICATIONS ==================

Changes by: Dave Hall <address@hidden>
Date: Wed 04/30/2003 at 10:42 (Australia/Melbourne)

            What     | Removed                   | Added
             Summary | Wrong SQL select uses accounts table | accounts table is 
not needed in query - /news_admin/website/export.php 

=================== 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:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  None                

Summary:  accounts table is not needed in query - 

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 "

No Followups Have Been Posted

CC list is empty

No files currently attached

For detailed info, follow this link:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]