[SOLVED] ERROR: SQL Exec Failed "INSERT INTO mac_track_

[mdurand]

hello all,

i installed Mac Track and when i look at my cacti.log file i can see many errors like:

08/02/2006 09:46:21 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "INSERT INTO mac_track_processes (device_id, process_id, status, start_date) VALUES ('1', '6884', 'Running', NOW())"

08/02/2006 09:46:23 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "SELECT COUNT(*) FROM mac_track_processes WHERE device_id <> '0'"

08/02/2006 09:46:25 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "DELETE FROM mac_track_processes WHERE device_id='-1'"

i would like to known if i am the only one to have this problem
so if you have this problem just tell me

[TheWitness]

Please run the database_update.php script and see if these problems continue.

TheWitness

[mdurand]

thanks
now i don't have this ERROR anymore

[exy123]

Hey I am still getting the SQL EXEC error after running the php update script from the command line , any other possible things I may try ?

[SyxPak]

Ran script.

Got this output:

root@tribble:/usr/share/cacti/site/plugins/mactrack # php database_upgrade.php
000000000010001100000000000000011100
Updating Device Types in Devices Table. Please be patient.

Warning: Invalid argument supplied for foreach() in /usr/share/cacti/site/plugins/mactrack/database_upgrade.php on line 71

[ehelm]

I've got the same issue... mactrack 0.0.1b.
When I run 'php database_upgrade.php', I get a bunch of CMDPHP: Poller[0] ERROR: SQL Exec Failed "ALTER TABLE errors. And of course, the same 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" error still exists.

Anything I can try or do different?

/Eric

[TheWitness]

Please use the version in SVN. It will provide significantly more joy.

Although, I have not finished it, it works and upgrades just fine and has a lot less bugs.

TheWitness

See the Cacti Web site for SVN instructions. It's something like:

svn://csv.cacti.net/var/svnroot/cacti_plugins

[ehelm]

I did put on the SVN version earlier today, and it did fix my issue. Oh what joy it has provided in the short amount of time. Great work! Thanks.