View Issue Details

IDProjectCategoryView StatusLast Update
0015416phplist applicationBounce Managementpublic09-11-12 19:03
Reporterrolan 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
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.

Activities

michiel

09-11-12 19:03

manager   ~0051888

rev 3430