Dependency Graph

Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
0016627phpList 3 applicationCampaign Send Processpublic21-06-18 14:01
Reporterneil.benn Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
PlatformLinuxOSUbuntu 
Summary0016627: phplist_message.userselection too short
DescriptionWhen 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 ReproducePut over 25K users in the system; make a message with advanced criteris and then attempt to send it.
Tagsplugin-development

Relationships

related to 0016587 new Requeue doesn't send msg to new users 

Activities

michiel

23-05-12 11:42

administrator   ~0051599


which version do you use?

neil.benn

23-05-12 11:48

reporter   ~0051600

Veriosn 2.10.18

michiel

23-05-12 12:31

administrator   ~0051603


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.