#1 – The Problem

Ever since January 1st, 2011 (when the new year rolled in), Plesk servers that have Watchdog installed have started giving errors on the crons. Administrators receiving these cron error emails will see something like this:

#####################################################
Cron Daemon <root@vps.server.com>
to root@vps.server.com

date Sat, Jan 1, 2011 at 12:15 AM
subject Cron <root@vps> /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats day

ERROR: WDExc
Error occurred while processing database query: 'MySQL query failed: You  have an error in your SQL syntax; check the manual that corresponds to  your MySQL server version for the right syntax to use near 'group by  service_id, type, round(unix_timestamp(time) / 200, More >