Cactiusers.org

mactrack report device stauts error ,but can report Total IP's :296

Try this

DROP TABLE IF EXISTS `mac_track_processes`;
CREATE TABLE `mac_track_processes` (
`device_id` int(10) NOT NULL default '0',
`process_id` int(11) NOT NULL default '0',
`status` varchar(20) NOT NULL default 'Queued',
`start_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`device_id`,`process_id`)
) ENGINE=MyISAM ;

Your getting the error because the device_id column doesn't exist.

thanks
but when i use phpmyadmin browse the "mac_track_ips" table,i got this error

how to fix it , thanks again

and also got this error in cacti.log

I am geting the same error


12/14/2006 02:15:19 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "UPDATE `mac_track_ip_ranges` SET ips_max=ips_current, ips_max_date=ips_current_date WHERE ips_current > ips_max"
12/14/2006 02:15:19 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed "SELECT * FROM mac_track_processes WHERE device_id = 0"
12/14/2006 02:15:19 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='-1'"
12/14/2006 02:15:19 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT count(*) FROM mac_track_processes WHERE device_id > 0"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='15'"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='16'"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('15', '17105', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='1'"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('7', '17103', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('6', '17100', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('16', '17107', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('3', '17093', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('2', '17091', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('1', '17088', 'Running', NOW())"
12/14/2006 02:15:15 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('5', '17096', 'Running', NOW())"
12/14/2006 02:15:14 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('-1', '0', 'Running', NOW())"