MySQL – Change 1,000 Joomla User Receive System Emails To No
Problem: Client had accidentally set all User’s Receive System Emails to YES. Receive System Emails are for Super Users/Webmaster only – not for 1,000 members. Solution: Use phpMyAdmin to select and confirm that all 1,000 Joomla Users whose Receive System Emails are set to sendMail=1 (1=Yes) SELECT * FROM `xxxx_users` WHERE sendemail=1 Then, update all Receive System Emails from…