Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to enable/disable WordPress update email notifications in Plesk?
Answer
To disable or enable notifications via Plesk interface:
-
Go to Tools & settings > Notifications and disable/enable required notifications with the checkboxes:
-
Click OK
-
Login to the Plesk server via SSH
-
Create a Plesk database dump
-
Access Plesk database
-
Run the following commands:
-
Create temporary view
wp
:mysql> create view wp as select distinct module_id from ModuleSettings where name like 'ext-wp-%';
-
Update the
ModuleSettings
table:mysql> update ModuleSettings set value='{"notifyAdmin":false,"notifyResellers":false,"notifyClients":false,"notifyCustomEmail":false,"customEmail":"","message":"<available_updates_text><available_updates_list><installed_updates_text><installed_updates_list><requirements_updates_text><requirements_updates_list>"}' where module_id=(select module_id from wp); \
-
Remove view
wp
:mysql> drop view wp;
-
Comments
5 comments
The SQL-query gives an error that multiple rows were returned:
MariaDB [psa]> update ModuleSettings set value='{"notifyAdmin":false,"notifyResellers":false,"notifyClients":false,"notifyCustomEmail":false,"customEmail":"","message":"<available_updates_text><available_updates_list><installed_updates_text><installed_updates_list><requirements_updates_text><requirements_updates_list>"}' where module_id=(select module_id from wp);
ERROR 1242 (21000): Subquery returns more than 1 row
MariaDB [psa]> select module_id from wp;
+-----------+
| module_id |
+-----------+
| 3 |
| 4 |
+-----------+
2 rows in set (0.00 sec)
MariaDB [psa]> select name from ModuleSettings where name like '%wp%';
+----------------------------------------------+
| name |
+----------------------------------------------+
| ext-wp-toolkit-notification-admin_updates |
| ext-wp-toolkit-notification-client_updates |
| ext-wp-toolkit-notification-reseller_updates |
| wptInstallationId |
| showPricesVAT |
| vatShowPopover |
+----------------------------------------------+
6 rows in set (0.00 sec)
The issue here is that '%wp%' also matches 'showPricesVAT' and 'vatShowPopover'.
Hi R Broersma,
Could you please enlist what components do your Plesk installation has? Does it has some billing component or any specific extension providing such tables?
After following these instructions and turning all Wordpress notifications off, Plesk still sends an email notification every time a Wordpress site is created. Is there a way to shut this email notification off?
Hello Deanna Wallace
Please, check if this or custom notification in event handlers is enabled:
Hello,
is there a way to disable this mails for some customers separately?
I have customers who doesn't want those mails and other who love them.
Haven't found any settings at user settings.
Please sign in to leave a comment.