04/03/2006 11:13:29 AM - CMDPHP: Poller[0] ERROR: SQL Cell Failed "select data_template_data.rrd_step from (data_template_data,data_template_rrd,graph_templates_item) where graph_templates_item.task_item_id=data_template_rrd.id and data_template_rrd.local_data_id=data_template_data.local_data_id and graph_templates_item.local_graph_id=553limit 0,1"
There should be a space between "553" and "limit". I ran and tested this query myself with my cacti db user from sql prompt and it ran just fine. Any light you can shed would be great. If nothing else maybe I will submit a patch, but wanted to confirm bug's existence.
sql syntax error?
Moderators: Developers, Moderators
-
rony
- Developer/Forum Admin
- Posts: 6022
- Joined: Mon Nov 17, 2003 6:35 pm
- Location: Michigan, USA
- Contact:
Patches at: http://www.cacti.net/download_patches.php
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
sweet, for reference (if anyone finds my thread via searching)
http://www.cacti.net/downloads/patches/ ... a_id.patch
cheers
-s
http://www.cacti.net/downloads/patches/ ... a_id.patch
cheers
-s
Who is online
Users browsing this forum: No registered users and 3 guests