View Issue Details

IDProjectCategoryView StatusLast Update
0015247phpList 3 applicationCampaign Send Processpublic21-06-18 14:05
Reporterh2b2 Assigned To 
PrioritynormalSeverityminorReproducibilityunable to reproduce
Status newResolutionopen 
Product Version2.10.7 
Summary0015247: Same message sent multiple times to same users
DescriptionA number of phplist users reported that phplist sends messages multiple times to the same users, even though the repetition feature was disabled. Users also reported that old messages where resent to the same users. This issue was reported for different phplist version, ranging from v2.10.5 to 2.10.7:
http://forums.phplist.com/viewtopic.php?p=58346#58346
http://forums.phplist.com/viewtopic.php?p=58358#58358
http://forums.phplist.com/viewtopic.php?p=57941#57941
http://forums.phplist.com/viewtopic.php?p=33126#33126
http://forums.phplist.com/viewtopic.php?p=33974#33974

The most coherent report is from karlmikaze (http://forums.phplist.com/viewtopic.php?p=60803#60803) and occurred after a phplist upgrade combined with a MySQL upgrade. He notes the following: "check to make sure that the new DB contains right values in the "sent" column! This was not the case during our first try, the fields were "NULL" - so the system sent them out over again."

Additional InformationThis issue may be hard to reproduce since most reports do not provide enough info to get a clear picture. Still, considering its importance and its continuous re-occurrence every once in a while, I think it might warrant a closer look by the development team.

karlmikaze's suggestion that something may go wrong during upgrades of the database tables seems to be the best lead for now.

It might therefore be useful to specifically check the usermessage table's status field (and other relevant database table fields) for valid values during the upgrade process, and include this added functionality in the dbcheck function.
Tagsneedinfo

Activities

h2b2

20-03-09 20:38

manager   ~0050572

CORRECTION: I pasted the wrong link for karlmikaze's report. The correct link is: http://forums.phplist.com/viewtopic.php?p=33163#33163

michiel

23-03-09 14:55

administrator   ~0050583


yes, this does need a closer look. I think that it might be best if upgrade sets all values in the usermessage table to sent

michiel

20-04-10 13:45

administrator   ~0050949

this is too complex to fit into a "bugfix release". It's hard to replicate, as it seems to involve upgrading from Mysql 4 to 5.

kangs

22-06-12 18:12

reporter   ~0051685

Even I'm having similar issue, my distribution list users are getting OLD messages than the NEW one. PHP List is very easy and intuitive TOOL. But people are complaining for getting old messages.