The mailing list for listmasters using Sympa

[Olivier Salaün <address@concealed>]

Hi Chris,

The SQL command you've run should not be responsible for this problem 
since "included" list members were not assigned the "subscribed" flag.

I rather suppose that the right to subscribe to this list is not 
"closed" and these members were able to subscribe to it. Given their 
subscription date, you should be able to verify this hypothesis by 
checking your log files...

Chris Peck a écrit :
> We upgraded to 5.3.3 about a month ago and one of our largest lists 
> owners (our Alumni Dept) has noticed a problem.  We populate their 
> lists using a text file that we updated nitely by getting the new list 
> of users from their database.  This all works fine, however, there are 
> some addresses that do not get removed from the list when it get's 
> updated from the include file.  They are set as "Sources = subscribed" 
> as opposed to "Sources = filename.txt" when I look at the Review 
> subscribers page.  I am looking for an easy way to remove these people 
> from the mysql db, as there are over 90 lists that are effected.  
>
> The lists is configured as:
> user_data_source include2
>
> include_file /home/sympa/expl/listname/subscriber-list.txt
>
> This may be related to the command that we ran below shortly after the 
> conversion to fix another issue we ran into:
> [...]
> UPDATE subscriber_table SET subscribed_subscriber=1 WHERE 
> ((included_subscriber IS NULL OR included_subscriber!=1) AND 
> (subscribed_subscriber IS NULL OR subscribed_subscriber!=1))