View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015416||phpList 3 application||Bounce Management||public||25-02-10 13:53||09-11-12 19:03|
|Fixed in Version||2.11.8|
|Summary||0015416: "bounce count" on view bounces page does not fully correlate with listed bounces|
|Description||The 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;
$find_url = '';
|Tags||No tags attached.|