View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0015247||phpList 3 application||Campaign Send Process||public||20-03-09 20:30||21-06-18 14:05|
|Priority||normal||Severity||minor||Reproducibility||unable to reproduce|
|Summary||0015247: Same message sent multiple times to same users|
|Description||A 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:|
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 Information||This 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.
||CORRECTION: I pasted the wrong link for karlmikaze's report. The correct link is: http://forums.phplist.com/viewtopic.php?p=33163#33163|
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
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.
||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.|