Poller Error after Update plugin install

[AmosC]

Hello all - I'm new to cacti and am having a few issues. I get the following error in my log file and am not able to poll any devices....
04/30/2008 12:06:24 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * from plugin_update_info"

Any ideas would be greatly appreciated.

[jimmy]

Did you import the update.sql file into your cacti database?

[AmosC]

I don't think so. I'll try that and let you know.

[AmosC]

Ok, I ran the following to import the sql file.

mysql -u root -p cacti < pa.sql

I didn't receive any messages so I assume it worked. I'm still getting the same errors in my log file.

05/01/2008 07:30:45 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT * from plugin_update_info"
05/01/2008 07:30:44 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1146', SQL:"INSERT INTO plugin_update_info (plugin, name, version, author, homepage, email) VALUES ('cacti_plugin_arch' ,'Plugin Architecture' ,'2.1' ,'Jimmy Conner' ,'http://cactiusers.org' ,'jimmy@sqmail.org''')'

Thanks again for the help

[jimmy]

mysql -u root -p cacti < pa.sql

No, you need to find the update.sql that came with the Update plugin, it should be in its directory.

[AmosC]

I found the update.sql file and imported it. I'm getting the following errors:

05/01/2008 03:04:04 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO plugin_update_info (plugin, name, version, author, homepage, email) VALUES ('cacti_plugin_arch' ,'Plugin Architecture' ,'2.1' ,'Jimmy Conner' ,'http://cactiusers.org' ,'jimmy@sqmail.org''')'
05/01/2008 03:04:04 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1364', SQL:"INSERT INTO plugin_update_info (plugin, name, version, author, homepage, email) VALUES ('cacti' ,'Cacti' ,'0.8.7b' ,'Cacti Developers' ,'http://cacti.net' ,'''')'


The one thing I noticed while doing the import is that mysql wouldn't take the last command: changes TEXT NOT NULL default ''

It complained about the default '' portion of the code. If I remove this it works fine. I checked and the table is definitely in the database.

[jimmy]

Are you running mysql in strict mode. Others have had the issue of it requiring the default, which is why it is there.

[AmosC]

Thanks a bunch. That seemed to do the trick. I'm still struggling with getting my graphs populated and figuring out how to get the appropriate templates for me devices. But this seems to be a very useful tool.