The mailing list for listmasters using Sympa

[Chris Peck <address@concealed>]

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:

Hi Chris,

The problem you describe makes me think that the subscribers entries in the database (in subscriber_table) might have an empty 'subscrbed_subscriber' field, whereas it should be set to '1'. If this is the problem, then you should run the following SQL command provided here http://www.sympa.org/wiki/faq/database#problems_with_include2_list_members

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))

thanks,

chris