View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0016627||phpList 3 application||Campaign Send Process||public||23-05-12 07:30||21-06-18 13:01|
|Summary||0016627: phplist_message.userselection too short|
|Description||When you use advanced criteria it puts an SQL statement into phplist_message.userselection; the column type is text. However if you have a lot of users in the system the SQL statement can be longer that the size of the column (65535). Changing the column type to longtext fixes this.|
|Steps To Reproduce||Put over 25K users in the system; make a message with advanced criteris and then attempt to send it.|
which version do you use?
the column change is a workaround for now, but the functionality should change and it shouldn't store such a long list in the DB. Instead the selection should be recalculated.