Different issues

[TheWitness]

The first column is "work in progress", see THold 0.41 for examples. The second is not a column at all. I am using left alignment, pretty sure.

TheWitness

[TheWitness]

Interfaces tab is also incomplete. I need to extract that from another "unpublished" plugin.

TheWitness

[rinkey]

i upgrade the cacti from 0.86j to 0.87e, and mactrack from 1.0 to 2.0.
but when i finished to upgrade, the mactrack had the same problem like the issue number4.
i had already done
#php database_upgrade.php -d
besides, i don't know the function of the file "mactrack.sql.0.0.1" in mactrack1.0 .
whether i need to import "mactrack.sql.0.0.1" to the cactidb.
please help me. thanks!

[TheWitness]

Goto Plugin Management. That should upgrade the plugin. You may also run the database_upgrade.php script. However, that is supposed to be automatic when you goto Plugin Managment.

[zoemu]

Hi Witness:

I haven't been here for awhile, I move all my cacti install from windows to Ubuntu Linux, everything is working fine except for Mactrack ....I'm getting this UPDATE/INSERT ERROR. Sorry for the lenght of this


Thanks....


LA

Code: Select all

A DB Exec Failed!, Error:'1054', SQL:"UPDATE mac_track_interfaces SET inBound=(int_ifHCInOctets*8)/(ifHighSpeed*10000), outBound=(int_ifHCOutOctets*8)/(ifHighSpeed*10000) WHERE ifHighSpeed>0 AND ifName NOT LIKE 'Vl%' AND device_id=1'  
11/04/2011 11:45:14 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1054', SQL:"INSERT INTO mac_track_interfaces (site_id, device_id, sysUptime, ifIndex, ifType, ifName, ifAlias, linkPort, vlan_id, vlan_name, vlan_trunk_status, ifSpeed, ifHighSpeed, ifDuplex, ifDescr, ifMtu, ifPhysAddress, ifAdminStatus, ifOperStatus, ifLastChange, ifInOctets, ifOutOctets, ifHCInOctets, ifHCOutOctets, ifInNUcastPkts, ifOutNUcastPkts, ifInUcastPkts, ifOutUcastPkts, ifInDiscards, ifInErrors, ifInUnknownProtos, ifOutDiscards, ifOutErrors, int_ifInOctets, int_ifOutOctets, int_ifHCInOctets, int_ifHCOutOctets, int_ifInNUcastPkts, int_ifOutNUcastPkts, int_ifInUcastPkts, int_ifOutUcastPkts, int_ifInDiscards, int_ifInErrors, int_ifInUnknownProtos, int_ifOutDiscards, int_ifOutErrors, int_discards_present, int_errors_present, last_down_time, last_up_time, stateChanges, present) VALUES ('1', '1', '170967778', '1', '6', 'Port1', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 01 on unit 1', '1500', '00:1C:C5:18:1D:1D', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '2', '6', 'Port2', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 02 on unit 1', '1500', '00:1C:C5:18:1D:1E', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '3', '6', 'Port3', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 03 on unit 1', '1500', '00:1C:C5:18:1D:1F', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '4', '6', 'Port4', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 04 on unit 1', '1500', '00:1C:C5:18:1D:20', '1', '1', '154650114', '0', '983266984', '0', '983262881', '0', '9177508', '0', '275943', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '5', '6', 'Port5', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 05 on unit 1', '1500', '00:1C:C5:18:1D:21', '1', '1', '154650122', '1263344038', '2979353350', '5558260380', '2979339538', '5341', '9172165', '17335983', '16325574', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '6', '6', 'Port6', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 06 on unit 1', '1500', '00:1C:C5:18:1D:22', '1', '1', '9154456', '0', '997575447', '0', '997571344', '0', '9211160', '0', '333223', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '7', '6', 'Port7', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 07 on unit 1', '1500', '00:1C:C5:18:1D:23', '1', '1', '9160358', '0', '997575041', '0', '997570938', '0', '9211160', '0', '333223', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '8', '6', 'Port8', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 08 on unit 1', '1500', '00:1C:C5:18:1D:24', '1', '1', '154493122', '47988226', '1024021868', '47987873', '1024017765', '87597', '9180810', '170204', '505572', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '9', '6', 'Port9', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 09 on unit 1', '1500', '00:1C:C5:18:1D:25', '1', '1', '154492832', '69883296', '1227927482', '69883296', '1227923379', '88234', '9194160', '322670', '707728', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '10', '6', 'Port10', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 10 on unit 1', '1500', '00:1C:C5:18:1D:26', '1', '1', '154492924', '1635641002', '3367913636', '1635632777', '3367878329', '96214', '9309424', '7152678', '7781210', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '11', '6', 'Port11', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 11 on unit 1', '1500', '00:1C:C5:18:1D:27', '1', '1', '154492837', '968626083', '2963000591', '968626015', '2962996250', '121526', '9233407', '4205897', '5098307', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '12', '6', 'Port12', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 12 on unit 1', '1500', '00:1C:C5:18:1D:28', '1', '1', '154493057', '3029498559', '3143519499', '3029496306', '7438480632', '199351', '9437161', '6735709', '8563751', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '13', '6', 'Port13', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 13 on unit 1', '1500', '00:1C:C5:18:1D:29', '1', '1', '154492841', '1287220126', '2677161011', '1287219641', '2677155895', '195066', '9443355', '3258320', '3783346', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '14', '6', 'Port14', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 14 on unit 1', '1500', '00:1C:C5:18:1D:2A', '1', '1', '154492300', '1181050687', '2167821848', '1181050687', '2167817387', '18422', '9553564', '10316798', '10598947', '0', '110', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '15', '6', 'Port15', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 15 on unit 1', '1500', '00:1C:C5:18:1D:2B', '1', '1', '154492846', '55895978', '1032260103', '55895978', '1032256000', '87601', '9180848', '206860', '543052', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '16', '6', 'Port16', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 16 on unit 1', '1500', '00:1C:C5:18:1D:2C', '1', '1', '3379', '1374932122', '2192587057', '5669878000', '15077457184', '25964', '9185133', '29560294', '32109762', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '17', '6', 'Port17', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 17 on unit 1', '1500', '00:1C:C5:18:1D:2D', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '18', '6', 'Port18', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 18 on unit 1', '1500', '00:1C:C5:18:1D:2E', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '19', '6', 'Port19', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 19 on unit 1', '1500', '00:1C:C5:18:1D:2F', '1', '1', '154492536', '47980314', '1024334677', '47979587', '1024330642', '87594', '9180887', '171135', '507732', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '20', '6', 'Port20', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 20 on unit 1', '1500', '00:1C:C5:18:1D:30', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '21', '6', 'Port21', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 21 on unit 1', '1500', '00:1C:C5:18:1D:31', '1', '1', '154649247', '3415811313', '941495550', '89314045105', '39595920867', '357939', '8820891', '162620641', '140644822', '170809', '1', '170809', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '22', '6', 'Port22', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 22 on unit 1', '1500', '00:1C:C5:18:1D:32', '1', '1', '157', '107483939', '1119406261', '107483653', '1119402444', '148768', '9109480', '442086', '1164112', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '23', '6', 'Port23', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 23 on unit 1', '1500', '00:1C:C5:18:1D:33', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '24', '6', 'Port24', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 24 on unit 1', '1500', '00:1C:C5:18:1D:34', '1', '1', '2154', '2574782921', '3011551306', '36934267591', '67434932215', '2764644', '7951014', '115127038', '128975755', '38021', '0', '38021', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '25', '6', 'Port25', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 25 on unit 1', '1500', '00:1C:C5:18:1D:35', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '26', '6', 'Port26', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 26 on unit 1', '1500', '00:1C:C5:18:1D:36', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '27', '6', 'Port27', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 27 on unit 1', '1500', '00:1C:C5:18:1D:37', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '28', '6', 'Port28', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 28 on unit 1', '1500', '00:1C:C5:18:1D:38', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '29', '6', 'Port29', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 29 on unit 1', '1500', '00:1C:C5:18:1D:39', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '30', '6', 'Port30', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 30 on unit 1', '1500', '00:1C:C5:18:1D:3A', '1', '1', '9140701', '0', '997576405', '0', '997571809', '0', '9211176', '0', '333223', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '31', '6', 'Port31', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 31 on unit 1', '1500', '00:1C:C5:18:1D:3B', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '32', '6', 'Port32', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 32 on unit 1', '1500', '00:1C:C5:18:1D:3C', '1', '1', '154492854', '1105112250', '2399655784', '1105112250', '2399651188', '93580', '9248673', '3318267', '3995995', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '33', '6', 'Port33', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 33 on unit 1', '1500', '00:1C:C5:18:1D:3D', '1', '1', '154693659', '686399155', '2806241072', '686398917', '2806235812', '128638', '9485421', '2470580', '3155369', '0', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '34', '6', 'Port34', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 34 on unit 1', '1500', '00:1C:C5:18:1D:3E', '1', '1', '154492859', '583129920', '3087794103', '583129856', '3087788953', '95395', '9305130', '2185441', '2995561', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '35', '6', 'Port35', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 35 on unit 1', '1500', '00:1C:C5:18:1D:3F', '1', '1', '154493196', '1872844868', '307961384', '1872843332', '4602920910', '115865', '9500707', '13059065', '13898257', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '36', '6', 'Port36', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 36 on unit 1', '1500', '00:1C:C5:18:1D:40', '1', '1', '154492542', '1221028550', '3607837781', '1221028061', '3607833321', '96864', '9324442', '5734460', '6959901', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '37', '6', 'Port37', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 37 on unit 1', '1500', '00:1C:C5:18:1D:41', '1', '1', '169441024', '868312438', '4058264580', '868303097', '4058251932', '8758', '2454993', '3153353', '4453603', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '38', '6', 'Port38', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 38 on unit 1', '1500', '00:1C:C5:18:1D:42', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '39', '6', 'Port39', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 39 on unit 1', '1500', '00:1C:C5:18:1D:43', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '40', '6', 'Port40', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 40 on unit 1', '1500', '00:1C:C5:18:1D:44', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '41', '6', 'Port41', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 41 on unit 1', '1500', '00:1C:C5:18:1D:45', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '42', '6', 'Port42', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 42 on unit 1', '1500', '00:1C:C5:18:1D:46', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '43', '6', 'Port43', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 43 on unit 1', '1500', '00:1C:C5:18:1D:47', '1', '0', '109978355', '78130', '259575', '78130', '259575', '288', '1380', '476', '363', '5', '0', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '44', '6', 'Port44', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 44 on unit 1', '1500', '00:1C:C5:18:1D:48', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '45', '6', 'Port45', '', '', '', '', '', '100000000', '100', '3', 'RMON Port 45 on unit 1', '1500', '00:1C:C5:18:1D:49', '1', '1', '154659347', '45925836', '1003486934', '45925836', '1003483756', '87185', '9148539', '142759', '421800', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '46', '6', 'Port46', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 46 on unit 1', '1500', '00:1C:C5:18:1D:4A', '1', '1', '154652682', '171722811', '2278315507', '171722747', '2278312265', '39119', '9139657', '1665986', '2492518', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '47', '6', 'Port47', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 47 on unit 1', '1500', '00:1C:C5:18:1D:4B', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '2011-11-04 11:45:14', '0', '0', '1'),('1', '1', '170967778', '48', '6', 'Port48', '', '', '', '', '', '1000000000', '1000', '3', 'RMON Port 48 on unit 1', '1500', '00:1C:C5:18:1D:4C', '1', '1', '2228', '986128058', '355207010', '5281093022', '4650173646', '6817522', '29563', '22454420', '22234333', '5401', '0', '5401', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '481', '33', 'Port481', '', '', '', '', '', '0', '0', '', 'Console Port', '0', '00:00:00:00:00:00', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '1001', '1', 'Port1001', '', '1', '', '', '', '0', '0', '', 'VLAN 00001', '0', '00:1C:C5:18:1D:1C', '1', '1', '19', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1'),('1', '1', '170967778', '1007', '1', 'Port1007', '', '', '', '', '', '0', '0', '', 'VLAN 00007', '0', '00:1C:C5:18:1D:1C', '1', '1', '19', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '2011-11-04 11:45:14', '0', '1') ON DUPLICATE KEY UPDATE sysUptime=VALUES(sysUptime), ifType=VALUES(ifType), ifName=VALUES(ifName), ifAlias=VALUES(ifAlias), linkPort=VALUES(linkPort), vlan_id=VALUES(vlan_id), vlan_name=VALUES(vlan_name), vlan_trunk_status=VALUES(vlan_trunk_status), ifSpeed=VALUES(ifSpeed), ifHighSpeed=VALUES(ifHighSpeed), ifDuplex=VALUES(ifDuplex), ifDescr=VALUES(ifDescr), ifMtu=VALUES(ifMtu), ifPhysAddress=VALUES(ifPhysAddress), ifAdminStatus=VALUES(ifAdminStatus), ifOperStatus=VALUES(ifOperStatus), ifLastChange=VALUES(ifLastChange), ifInOctets=VALUES(ifInOctets), ifOutOctets=VALUES(ifOutOctets), ifHCInOctets=VALUES(ifHCInOctets), ifHCOutOctets=VALUES(ifHCOutOctets), ifInNUcastPkts=VALUES(ifInNUcastPkts), ifOutNUcastPkts=VALUES(ifOutNUcastPkts), ifInUcastPkts=VALUES(ifInUcastPkts), ifOutUcastPkts=VALUES(ifOutUcastPkts), ifInDiscards=VALUES(ifInDiscards), ifInErrors=VALUES(ifInErrors), ifInUnknownProtos=VALUES(ifInUnknownProtos), ifOutDiscards=VALUES(ifOutDiscards), ifOutErrors=VALUES(ifOutErrors), int_ifInOctets=VALUES(int_ifInOctets), int_ifOutOctets=VALUES(int_ifOutOctets), int_ifHCInOctets=VALUES(int_ifHCInOctets), int_ifHCOutOctets=VALUES(int_ifHCOutOctets), int_ifInNUcastPkts=VALUES(int_ifInNUcastPkts), int_ifOutNUcastPkts=VALUES(int_ifOutNUcastPkts), int_ifInUcastPkts=VALUES(int_ifInUcastPkts), int_ifOutUcastPkts=VALUES(int_ifOutUcastPkts), int_ifInDiscards=VALUES(int_ifInDiscards), int_ifInErrors=VALUES(int_ifInErrors), int_ifInUnknownProtos=VALUES(int_ifInUnknownProtos), int_ifOutDiscards=VALUES(int_ifOutDiscards), int_ifOutErrors=VALUES(int_ifOutErrors), int_discards_present=VALUES(int_discards_present), int_errors_present=VALUES(int_errors_present), last_down_time=VALUES(last_down_time), last_up_time=VALUES(last_up_time), stateChanges=VALUES(stateChanges), present='1''  

[TheWitness]

Open a MySQL command windows and paste that command into it. Then compare the missing column to the default schema. Add that column using an ALTER statement. If you open setup.php you will find lot's of examples.

TheWitness

[zoemu]

I've done that already and I have corrected the tables.

But I'm Now getting this error.

Code: Select all

11/04/2011 01:36:53 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1054', SQL:"SELECT DISTINCT gt.* FROM graph_templates AS gt INNER JOIN graph_local AS gl ON gl.graph_template_id=gt.id INNER JOIN mac_track_devices AS mtd ON mtd.host_id=graph_local.host_id ORDER BY gt.name"  

thanks

[TheWitness]

Run that one from the command line and paste the response. You are obviously not fully upgraded.