cjblade54
Joined: 04 Mar 2008
Posts: 24
|
 Posted: Tue May 13, 2008 2:55 pm Post subject: Vendor Macs Error |
 |
|
When i add Vendor Macs I get following message:
| Quote: | | Notice: Undefined index: mactrack_vendormacs.php:edit in /usr/share/cacti/lib/functions.php on line 1634 |
Anyone knows how to fix it?
I checked my Cacti log and it shows:
| Quote: |
05/13/2008 04:33:08 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(mac_track_devices.device_id) FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%') AND (mac_track_devices.snmp_status=3 AND mac_track_devices.disabled = ''))"
05/13/2008 04:33:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_devices.site_id, mac_track_sites.site_name, mac_track_devices.device_id, mac_track_devices.device_name, mac_track_devices.notes, mac_track_devices.hostname, mac_track_devices.snmp_readstring, mac_track_devices.snmp_readstrings, mac_track_devices.snmp_version, mac_track_devices.snmp_port, mac_track_devices.snmp_timeout, mac_track_devices.snmp_retries, mac_track_devices.snmp_status, mac_track_devices.ignorePorts, mac_track_devices.disabled, mac_track_devices.scan_type, mac_track_devices.ips_total, mac_track_devices.ports_total, mac_track_devices.ports_active, mac_track_devices.ports_trunk, mac_track_devices.macs_active, mac_track_devices.last_rundate, mac_track_devices.last_runmessage, mac_track_devices.last_runduration FROM mac_track_sites RIGHT JOIN mac_track_devices ON mac_track_devices.site_id = mac_track_sites.site_id WHERE ((mac_track_devices.hostname like '%%%%' OR mac_track_devices.device_name like '%%%%' OR mac_track_devices.notes like '%%%%') AND (mac_track_devices.snmp_status=3 AND mac_track_devices.disabled = '')) ORDER BY site_name ASC LIMIT 0,30"
05/13/2008 04:33:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT mac_track_devices.device_type_id, mac_track_device_types.description, mac_track_device_types.sysDescr_match FROM mac_track_device_types RIGHT JOIN mac_track_devices ON (mac_track_device_types.device_type_id = mac_track_devices.device_type_id) ORDER BY mac_track_device_types.description;"
05/13/2008 04:33:08 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select site_id,site_name from mac_track_sites order by site_name"
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(mac_track_device_types.device_type_id) FROM mac_track_device_types"
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_device_types ORDER BY description ASC LIMIT 0,30"
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT vendor from mac_track_device_types ORDER BY vendor"
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_standard_arp_table', '2')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('Not Applicable - Hub/Switch', '2')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_foundry_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_procurve_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_norbay_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_IOS_dot1dTpFdbEntry_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_catalyst_dot1dTpFdbEntry_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_repeater_rev4_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_cabletron_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_generic_wireless_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_generic_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('get_generic_dot1q_switch_ports', '1')'
05/13/2008 04:33:07 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"REPLACE INTO mac_track_scanning_functions (scanning_function, type) VALUES ('Not Applicable - Router', 1)'
05/13/2008 04:33:05 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_oui_database "
05/13/2008 04:33:05 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_oui_database ORDER BY vendor_mac ASC LIMIT 0,7"
05/13/2008 04:33:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_macauth "
05/13/2008 04:33:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_macauth ORDER BY mac_address ASC LIMIT 0,30"
05/13/2008 04:32:59 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT count(*) FROM (mac_track_macwatch "
05/13/2008 04:32:59 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_macwatch ORDER BY name ASC LIMIT 0,30"
05/13/2008 04:30:10 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"delete from mac_track_processes where start_date < '2008-05-13 16:10:10''
05/13/2008 04:25:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select scan_date from mac_track_scan_dates order by scan_date desc"
05/13/2008 04:25:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT vlan_id, vlan_name FROM mac_track_vlans ORDER BY vlan_name ASC"
05/13/2008 04:25:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
05/13/2008 04:25:38 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select site_id,site_name from mac_track_sites order by site_name"
05/13/2008 04:25:34 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(mac_track_sites.site_id) FROM mac_track_sites "
05/13/2008 04:25:34 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_sites.site_id, mac_track_sites.site_name, mac_track_sites.total_devices, mac_track_sites.total_device_errors, mac_track_sites.total_macs, mac_track_sites.total_ips, mac_track_sites.total_oper_ports, mac_track_sites.total_user_ports FROM mac_track_sites ORDER BY site_name ASC LIMIT 0,30"
05/13/2008 04:25:34 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_device_types WHERE device_type_id = '-1'"
05/13/2008 04:25:32 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_macauth "
05/13/2008 04:25:32 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_macauth ORDER BY mac_address ASC LIMIT 0,30"
05/13/2008 04:25:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT count(*) FROM (mac_track_macwatch "
05/13/2008 04:25:31 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_macwatch ORDER BY name ASC LIMIT 0,30"
05/13/2008 04:25:29 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_oui_database "
05/13/2008 04:25:29 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * FROM mac_track_oui_database ORDER BY vendor_mac ASC LIMIT 0,7"
05/13/2008 04:25:22 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:22 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' GROUP BY last_rundate ORDER BY last_rundate DESC;"
05/13/2008 04:25:22 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id='0'"
05/13/2008 04:25:22 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_processes.process_id, mac_track_devices.device_name, mac_track_processes.device_id, mac_track_processes.start_date FROM mac_track_devices INNER JOIN mac_track_processes ON (mac_track_devices.device_id = mac_track_processes.device_id) WHERE mac_track_processes.device_id != '0'"
05/13/2008 04:25:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' GROUP BY last_rundate ORDER BY last_rundate DESC;"
05/13/2008 04:25:21 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id='0'"
05/13/2008 04:25:21 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_processes.process_id, mac_track_devices.device_name, mac_track_processes.device_id, mac_track_processes.start_date FROM mac_track_devices INNER JOIN mac_track_processes ON (mac_track_devices.device_id = mac_track_processes.device_id) WHERE mac_track_processes.device_id != '0'"
05/13/2008 04:25:15 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:15 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:25:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT last_rundate, COUNT(last_rundate) AS devices FROM mac_track_devices WHERE disabled = '' GROUP BY last_rundate ORDER BY last_rundate DESC;"
05/13/2008 04:25:15 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT COUNT(*) FROM mac_track_processes WHERE device_id='0'"
05/13/2008 04:25:15 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT mac_track_processes.process_id, mac_track_devices.device_name, mac_track_processes.device_id, mac_track_processes.start_date FROM mac_track_devices INNER JOIN mac_track_processes ON (mac_track_devices.device_id = mac_track_processes.device_id) WHERE mac_track_processes.device_id != '0'"
05/13/2008 04:25:13 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"delete from mac_track_processes where start_date < '2008-05-13 16:05:13''
05/13/2008 04:24:55 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select scan_date from mac_track_scan_dates order by scan_date desc"
05/13/2008 04:24:55 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT DISTINCT vlan_id, vlan_name FROM mac_track_vlans ORDER BY vlan_name ASC"
05/13/2008 04:24:55 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT device_id, device_name, hostname FROM mac_track_devices ORDER BY device_name"
05/13/2008 04:24:55 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"select site_id,site_name from mac_track_sites order by site_name"
05/13/2008 04:20:12 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"delete from mac_track_processes where start_date < '2008-05-13 16:00:12''
05/13/2008 04:15:44 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
05/13/2008 04:15:44 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1146', SQL:"SELECT count(*) FROM mac_track_devices"
|
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
