Project

General

Profile

Demande #5301

Nettoyer les abonnements des domaines HS

Added by François Poulain 8 months ago. Updated 7 months ago.

Status:
Fermé
Priority:
Normale
Category:
-
Target version:
Start date:
04/01/2021
Due date:
% Done:

0%

Estimated time:
Difficulté:
2 Facile

Description

On a voila.fr et ifrance.com qui viennent pourrir nos queues mails. Je procède au nettoyage de dtc et de sympa. Cf #5278 pour la méthode.


Related issues

Related to Admins - Demande #5278: Nettoyer les abonnements openmailboxFermé03/13/2021

Actions

History

#1

Updated by François Poulain 8 months ago

MariaDB [sympa]> delete from subscriber_table where user_subscriber like "%@voila.fr";
Query OK, 54 rows affected (0.301 sec)

MariaDB [sympa]> delete from subscriber_table where user_subscriber like "%@ifrance.com";
Query OK, 73 rows affected (0.036 sec)
#2

Updated by François Poulain 8 months ago

MariaDB [gdtc]> update person set email = "" where email like '%@voila.fr';
Query OK, 4 rows affected (0.056 sec)
Rows matched: 4  Changed: 4  Warnings: 0

MariaDB [gdtc]> update entity set email = "" where email like '%@voila.fr';
Query OK, 0 rows affected (0.013 sec)
Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [gdtc]> update person set email = "" where email like '%@ifrance.com';
Query OK, 0 rows affected (0.052 sec)
Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [gdtc]> update entity set email = "" where email like '%@ifrance.com';
Query OK, 0 rows affected (0.007 sec)
Rows matched: 0  Changed: 0  Warnings: 0

#3

Updated by François Poulain 8 months ago

  • Related to Demande #5278: Nettoyer les abonnements openmailbox added
#4

Updated by François Poulain 8 months ago

  • Status changed from Nouveau to Résolu
#5

Updated by Christian P. Momon 8 months ago

  • Assignee set to François Poulain
#6

Updated by Quentin Gibeaux 7 months ago

  • Status changed from Résolu to Fermé

Also available in: Atom PDF