View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0014170||phplist application||Bounce Management||public||17-04-08 08:57||09-11-12 18:48|
|Target Version||4.0.x||Fixed in Version||2.11.8|
|Summary||0014170: 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...
|Tags||No tags attached.|