[solved] Getting SQL errors without any devices

[cjolly3053]

I don't want to have to redo this install again. I somehow got something going on. Here is the error I am getting in my log and this is without any devices or data sources. Can somebody tell me what I am missing. I would like to try and fix this as opposed to just reinstalling due to if this was happening at a later point I would need to solve it. Only thing I did notice is spine is reporting 1 host processed but tech support says 0 hosts and there is no hosts listed. So I guess the next question is, where does spine look?? Is there a SQL table or a php file that has the objects to poll???

03/15/2012 08:45:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
03/15/2012 08:45:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT DISTINCT graph_tree_items.local_graph_id, graph_tree_items.host_id FROM graph_tree_items LEFT JOIN graph_templates_graph ON (graph_templates_graph.local_graph_id=graph_tree_items.local_graph_id) LEFT JOIN user_auth_perms ON ((graph_templates_graph.local_graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=) OR (graph_tree_items.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=) OR (graph_templates_graph.graph_template_id=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=)) WHERE graph_tree_items.title='' AND graph_tree_items.graph_tree_id=1 ORDER BY graph_tree_items.order_key"
03/15/2012 08:45:54 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT realm_id FROM user_auth_realm WHERE realm_id=8 AND user_id="
03/15/2012 08:45:54 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="
03/15/2012 08:44:53 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
03/15/2012 08:44:53 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT DISTINCT graph_tree_items.local_graph_id, graph_tree_items.host_id FROM graph_tree_items LEFT JOIN graph_templates_graph ON (graph_templates_graph.local_graph_id=graph_tree_items.local_graph_id) LEFT JOIN user_auth_perms ON ((graph_templates_graph.local_graph_id=user_auth_perms.item_id AND user_auth_perms.type=1 AND user_auth_perms.user_id=) OR (graph_tree_items.host_id=user_auth_perms.item_id AND user_auth_perms.type=3 AND user_auth_perms.user_id=) OR (graph_templates_graph.graph_template_id=user_auth_perms.item_id AND user_auth_perms.type=4 AND user_auth_perms.user_id=)) WHERE graph_tree_items.title='' AND graph_tree_items.graph_tree_id=1 ORDER BY graph_tree_items.order_key"
03/15/2012 08:44:53 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"SELECT realm_id FROM user_auth_realm WHERE realm_id=8 AND user_id="
03/15/2012 08:44:53 AM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"SELECT * FROM user_auth WHERE id="

Here is tech support page


Technical Support
General Information
Date Thu, 15 Mar 2012 08:48:39 -0500
Cacti Version 0.8.7i
Cacti OS win32
SNMP Version NET-SNMP version: 5.6.1.1
RRDTool Version RRDTool 1.2.x
Hosts 0
Graphs 0
Data Sources 0
Poller Information
Interval 300
Type SPINE 0.8.7i Copyright 2002-2011 by The Cacti Group
Items No items to poll
Concurrent Processes 2
Max Threads 2
PHP Servers 1
Script Timeout 25
Max OID 10
Last Run Statistics Time:1.0748 Method:spine Processes:2 Threads:2 Hosts:1 HostsPerProcess:1 DataSources:0 RRDsProcessed:0
PHP Information
PHP Version 5.2.14
PHP OS WINNT
PHP uname Windows NT 6.1 build 7601
PHP SNMP Installed
max_execution_time 300
memory_limit 128M

[BSOD2600]

MySQL error 1064 is a syntax error (thank you google!)

How did you install Cacti? Did you encounter any problems?
I'd also start out by using the cmd.php poller instead of spine. Then once your installation is fully functional, switch over to spine.

[cjolly3053]

MySQL error 1064 is a syntax error (thank you google!)

How did you install Cacti? Did you encounter any problems?
I'd also start out by using the cmd.php poller instead of spine. Then once your installation is fully functional, switch over to spine.

Yes I did google 1064 :-p just for reference but thats kinda vague honestly.

Install Cacti ok on windows thats kinda a trick question. Kind of walked through the website and did not have any problems during the install.

Ok I will change to cmd.php and see if that makes a difference for now.

Did you see that it was polling a device but I stated I had no devices??? That seemed odd to me as in researching this issue it's an error with a NUL id it seems.

[BSOD2600]

From the technical support page output, it would appear that you have no devices configured and nothing for cacti to poll. Is this incorrect?

[cjolly3053]

From the technical support page output, it would appear that you have no devices configured and nothing for cacti to poll. Is this incorrect?

You are correct. Well I could not find a resolution so I just wiped the database and cacti directory and just reinstalled. Not sure exactly what started it but I suspect it had something to do with the structured RRA option.

Anyway thanks for looking at it.

[BSOD2600]

after you added a device with something to poll, do those errors go away?

If yes, then it sounds like this is a bug.

[cjolly3053]

after you added a device with something to poll, do those errors go away?

If yes, then it sounds like this is a bug.

No. I tried adding a device and the errors remained. Also deleted it again and still had error. Was very odd. I don't think I should be getting any errors with no devices.

But since the reinstall everything is just peachy.