phplist

NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1


View Issue Details Jump to Notes ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0015416phplist applicationBounce Managementpublic25-02-10 13:5309-11-12 19:03
Reporterrolan 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version2.10.10 
Target Version4.0.xFixed in Version2.11.8 
Summary0015416: "bounce count" on view bounces page does not fully correlate with listed bounces
DescriptionThe bounce count takes a full count of the rows in the bounces table,
however the bounces show below only show bounces where status != "unidentified bounce".

below is a patch for bounces.php.

Note: This will slow the bounces.php script to a crawl when there are a large number of bounces in the table. It is recommended that a index be added to the status column.

mysql query: create index statusindex on phplist_bounce (status(10));

This will speed a number of things up significantly.


@@ -33,7 +33,7 @@
 }

 # view bounces
-$count = Sql_Query(sprintf('select count(*) from %s',$tables["bounce"]));
+$count = Sql_Query(sprintf('select count(*) from %s where status != "unidentified bounce"',$tables["bounce"]));
 $totalres = Sql_fetch_Row($count);
 $total = $totalres[0];
 $find_url = '';

TagsNo tags attached.
Attached Files

- Relationships

-  Notes
(0051888)
michiel (manager)
09-11-12 19:03

rev 3430


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker