mac_track_interfaces table

Support questions about the MAC Track plugin

Moderators: Developers, Moderators

Post Reply
osipov
Posts: 2
Joined: Fri Jul 16, 2010 5:28 am

mac_track_interfaces table

Post by osipov »

Sorry for my english! In cacti log i have "PM - CMDPHP: Poller[0] ERROR: 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=3'"

When i execute this in mysql: "ERROR 1054 (42S22): Unknown column 'inBound' in 'field list'"

where can i found description of mac_track_interfaces table?
osipov
Posts: 2
Joined: Fri Jul 16, 2010 5:28 am

I resolve my problem!

Post by osipov »

In file setup.php? i found this:
"if (!mactrack_db_column_exists("mac_track_interfaces", "sysUptime")) {
db_execute("ALTER TABLE mac_track_interfaces ADD COLUMN ..."

I do this by hands ..
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests