V
Vincent.H
Guest
Happy new year to everyone,
My Panel has started 2011 with a bug... on pack-syststats.
Received theses alerts via mail :
Cron <root@**> /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month
And the same thing for year, day, week...
It seems that the mysql query is incorrect (syntax error) :
select service_id, type, unix_timestamp(min(time)) as min_time, unix_timestamp(max(time)) as max_time, avg(value) as avg
from module_watchdog_sys_stat where
group by service_id, type, round(unix_timestamp(time) / 7200, 0) having count(value) > 1 limit 10000
"where " is unnecessary here...
Is any update expected ?
Regards,
Vincent
My Panel has started 2011 with a bug... on pack-syststats.
Received theses alerts via mail :
Cron <root@**> /usr/local/psa/libexec/modules/watchdog/cp/pack-sysstats month
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'
0: wdlib.php:1089
wd__db_query(string 'select service_id, type, unix_timestamp(min(time)) as min_time, unix_timestamp(max(time)) as max_time, avg(value) as avg
from module_watchdog_sys_stat where
group by service_id, type, round(unix_timestamp(time) / 7200, 0) having count(value) > 1 limit 10000;')
1: pack-sysstats:63
pack_statistics(integer '7200', boolean false, boolean false)
2: pack-sysstats:44
And the same thing for year, day, week...
It seems that the mysql query is incorrect (syntax error) :
select service_id, type, unix_timestamp(min(time)) as min_time, unix_timestamp(max(time)) as max_time, avg(value) as avg
from module_watchdog_sys_stat where
group by service_id, type, round(unix_timestamp(time) / 7200, 0) having count(value) > 1 limit 10000
"where " is unnecessary here...
Is any update expected ?
Regards,
Vincent