View Issue Details

IDProjectCategoryView StatusLast Update
0014170phplist applicationBounce Managementpublic09-11-12 18:48
Reporterflohack 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version2.10.5 
Target Version4.0.xFixed in Version2.11.8 
Summary0014170: consecutive bounces are not counted in presence of multiple RSS msgs with different interval
Descriptionprocessbounces.php:
The SQL for fetching consecutive bounces does not take into account that when a daily and a weekly message exist, the weekly subscribers never get the daily msgs, and so the result of the query shows "not sent" items without bounce id, but they are interpreted as received without error.

The SQL there has to look like:

SELECT * from phplist_usermessage left join phplist_user_message_bounce on (messageid = message and userid = user) where userid=40 AND STATUS='sent' order by entered desc

plz note the added where condition with status...
TagsNo tags attached.

Activities

michiel

09-11-12 18:48

manager   ~0051887

rev 3429