The Plesk Email Security dashboard is loading forever or statistics are not updated for the extension;
/var/log/plesk/panel.logthe following error can be found:
PHP Fatal error: Maximum execution time of 600 seconds exceeded in /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Db/Statement/Pdo.php on line 5
emailsecurity database is more than 50 Mb.
The Plesk Email Security bug EXTCERT-3176
- Log in to Plesk.
2. Navigate to Tools & Settings > Plesk Email Security > Server Settings tab.
3. Go to the Advanced settings and decrease the Days number in the Auto-cleanup section to 7:
4. Scroll down and press the Save button.
5. Navigate to Tools & Settings > Scheduled Tasks (Cron jobs) and click Run Now near the /usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php ‘/usr/local/psa/admin/plib/modules/email-security/scripts/update-stats.php’ task:
Warning: this workaround is based on removing the tables
msgrcpt from PES database. All Plesk Email Security statistics will be lost.
Navigate to Tools & Settings > Database Servers.
Press on the button which is highlighted on the screenshot below:
Click emailsecurity database to select it:
Click on the SQL button to open the menu below:
Add the following SQL queries to remove the content of the tables “msgs” and “msgrcpt” and click Go:
TRUNCATE TABLE msgs;
TRUNCATE TABLE msgrcpt;
Run the scheduled task
/usr/local/psa/admin/bin/php -dauto_prepend_file=sdk.php '/usr/local/psa/admin/plib/modules/email-security/scripts/update-stats.phpvia Tools & Settings > Scheduled Tasks (Cron jobs) > Run Now and check if the issue persists after the task was executed.