Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support
It is currently Thu Jul 24, 2014 2:23 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: mac_track_interfaces table
PostPosted: Fri Jul 16, 2010 5:33 am 
Offline

Joined: Fri Jul 16, 2010 5:28 am
Posts: 2
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?


Top
 Profile  
 
 Post subject: I resolve my problem!
PostPosted: Fri Jul 16, 2010 6:34 am 
Offline

Joined: Fri Jul 16, 2010 5:28 am
Posts: 2
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 ..


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group