View Issue Details

IDProjectCategoryView StatusLast Update
0014170phpList 3 applicationBounce Managementpublic09-11-12 18:48
Reporterflohack Assigned To 
Status resolvedResolutionfixed 
Product Version2.10.5 
Fixed in Version2.11.8 
Summary0014170: consecutive bounces are not counted in presence of multiple RSS msgs with different interval
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.



09-11-12 18:48

administrator   ~0051887

rev 3429