The mailing list for listmasters using Sympa

[Mark Sallee <address@concealed>]

Posting the solution... Found the right query in mysql:

# Display list of bounce scores >= 0 and not yet set to nomail
select
list_subscriber,user_subscriber,bounce_score_subscriber,reception_subscriber,visibility_subscriber
from subscriber_table where bounce_score_subscriber >= 0 and
reception_subscriber != "nomail";

# The big update to set all bounces to "nomail":
update subscriber_table set
reception_subscriber="nomail",visibility_subscriber="conceal" where
(bounce_score_subscriber >= 0 AND reception_subscriber != "nomail");

This just worked for several thousand records.

Mark Sallee


On 1/9/10 7:57 AM, Muhammed Sameer wrote:
> Hey,
>
> Get a list of the bouncing subscribers and manually fire a DB query to set 
> the reception mode to 'nomail'
>
> Regards,
> Muhammed Sameer
>
> --- On Mon, 1/4/10, address@concealed <address@concealed> wrote:
>
>   
>> From: address@concealed <address@concealed>
>> Subject: [sympa-users] How to remove bouncing addresses from lists?
>> To: address@concealed
>> Date: Monday, January 4, 2010, 11:35 AM
>> Want to do something like:
>> set all bouncing
>> addresses for list to "NOMAIL", or unsubscribe them. 
>>