Demande #5301
Nettoyer les abonnements des domaines HS
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
History
Updated by François Poulain over 2 years 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)
Updated by François Poulain over 2 years 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
Updated by François Poulain over 2 years ago
- Related to Demande #5278: Nettoyer les abonnements openmailbox added