[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 ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3380&group_id=509
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 -
/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
No Followups Have Been Posted
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [Bug #3380] accounts table is not needed in query - /news_admin/website/export.php,
nobody <=