When customer tries to see statistics from watchdog, an error message appears
Internal error: failed to adjust system time in accordance with daylight savings time change.
Also Watchdog’s cron job reports the error
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) / 7200, 0) having count(va’ at line 3′
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) / 7200, 0) having count(va’ at line 3′
To resolve this issue.
Unzip Parallels Plesk Panel version pack-sysstats and replace the file located in /usr/local/psa/libexec/modules/watchdog/cp/
http://kb.parallels.com/Attachments/14807/Attachments/pack-sysstats-for-9.5-10.zip
Unzip Parallels Plesk Panel version stats-graph and replace the file located in /usr/local/psa/admin/htdocs/modules/watchdog/
http://kb.parallels.com/Attachments/14807/Attachments/stats-graph-for-9.zip
Reference: http://parallels.com/
Leave a Reply
You must be logged in to post a comment.
