SQL ERRORS

tbaror · Joined: 05 Jun 2006 Posts: 49

Hello,

i have just done new fresh install of MACTRACK, when i am trying to add device or site i am getting sql errors as follows below.

please advice.
Thanks in advanced.

********************sql error******************

07/03/2007 04:40:13 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "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 '%%%%'))"
07/03/2007 04:40:13 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed "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 '%%%%')) ORDER BY site_name ASC LIMIT 0,30"

streaker69 · Posted: Tue Jul 03, 2007 8:52 am Post subject:

Did you import the mactrack sql file?

tbaror · Joined: 05 Jun 2006 Posts: 49

yes i did import it to cacti db

TheWitness · Posted: Tue Jul 03, 2007 11:39 am Post subject:

What version of MacTrack? Are you sure you have those tables?

TheWitness

streaker69 · Posted: Tue Jul 03, 2007 6:03 pm Post subject: Re: SQL ERRORS

tbaror · Joined: 05 Jun 2006 Posts: 49

Hi,

i am using MySql gui tools quey browser, under cacti browser the tables seems to exist.
thanks

TheWitness · Posted: Wed Jul 04, 2007 3:28 am Post subject:

Please answer the other component of my question. Also, did you run the database_upgrade.php script?

TheWitness

tbaror · Joined: 05 Jun 2006 Posts: 49

HI,

You right i didnt run database_upgrade.php, now its runing.
another question do i need to replace the files under patch folder?

Thanks

TheWitness · Posted: Thu Jul 05, 2007 12:15 pm Post subject:

Depends on your Plugin Architecture version.

TheWitness

apperrault · Posted: Thu Jul 05, 2007 12:23 pm Post subject:

Witness,
I am having some problems with the MacTrack version in the SVN. I have imported the SQL script, i have run the

TheWitness · Posted: Thu Jul 05, 2007 12:54 pm Post subject:

Edit lib/config.php and edit out the settings plugin. I will let Jimmy Conner know.

TheWitness

apperrault · Posted: Thu Jul 05, 2007 12:57 pm Post subject:

I did that, and what do you know, it worked.

I wonder if that was also causing my Uptime plugin to not run automatically.

We will have to see.

thanks much

app

apperrault · Posted: Thu Jul 05, 2007 1:15 pm Post subject:

Well, that fixed the problem i was having with MacTrack, but not with Uptime. I will try and uninstall that plugin and re-install it.

One other question, one earlier versions of MacTrack, you had a list of some of the common Device Types, but now it appears that is gone, and I have to create them all manually. Do you have that old list. For the most part, i used those as templates for other, similar items.

If you have that available, it would be great.

Thanks much

app

TheWitness · Posted: Thu Jul 05, 2007 1:29 pm Post subject:

More than likely, I will patch MacTrack.

TheWitness

TheWitness · Posted: Thu Jul 05, 2007 2:28 pm Post subject:

If you sync your MacTrack SVN, you should be all set now adding the settings plugin back in.