The mailing list for listmasters using Sympa

[Olivier Salaün - CRU <address@concealed>]

Annie Simeau wrote:

Nick Holden a écrit :

Since upgrading my sympa, and moving it to a new server (probably not a good combination of events) I have problems with some of my lists.

Now using Sympa 5.1,  on some lists, some of the subscribers cannot be unsubscribed - on listing the subscribed addresses, under 'sources' they have no entry at all. Others have the word 'subscribed', and a check box to allow them to be deleted from the list.

It appears as though these other addresses have been added to the list in some other way, but I do not use any include methods, only direct subscription to each list.

Can I update the sympa database table to set the subscribed_subscriber field to 1 - if I do, will that allow the addresses to all be handled normally? And will it cause any other problem
    

I solved the problem by a MySQL  modification (Is your database MySQL ?)
UPDATE `subscriber_table` SET `subscribed_subscriber` = '1'  WHERE `subscribed_subscriber` IS NULL;

At this time  it's working fine
I don't recommend running this query because it will set included list members as subscribers, which can be very problematic if one has lists based on LDAP/SQL data sources !!

Actually the database should have been updated automatically while moving to Sympa 5.1. If it didn't, here is the SQL query to run :

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