Syslog v1.21 FIXED

[smilerza]

Hello,

I've just upgraded to 1.21 from 1.20 and getting loads of errors in the cacti log file. It appears some tables are missing namely: syslog_alarm_log and syslog_statistics. I have checked the database and indeed they are not there.

I've then checked the syslog.sql from the 1.21 file and the tables are not there either.

Here's an excerpt from the cacti.log:

04/15/2011 12:15:11 PM - SYSTEM SYSLOG STATS:Time:0.18 Deletes:0 Incoming:4 Removes:0 XFers:4 Alerts:0 Alarms:0 Reports:0
04/15/2011 12:15:11 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `syslog`.`syslog_alarm_log` WHERE logtime<'2011-03-16 11:15:11''
04/15/2011 12:15:11 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"DELETE FROM `syslog`.`syslog_statistics` WHERE insert_time<'2011-03-16 11:15:11''
04/15/2011 12:15:11 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO `syslog`.`syslog_statistics` (host_id, facility_id, priority_id, insert_time, records) SELECT host_id, facility_id, priority_id, NOW(), sum(records) AS records FROM (SELECT host_id, facility_id, priority_id, count(*) AS records FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=31 GROUP BY host_id, priority_id, facility_id) AS merge GROUP BY host_id, priority_id, facility_id'

[smilerza]

In the end I re-installed the plug-in which then re-created the tables.