a space is missing in an SQL request and generate error

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
etn
Posts: 8
Joined: Mon Feb 13, 2006 4:32 am

a space is missing in an SQL request and generate error

Post by etn »

Hello everybody,

I use cacti on 2 servers under Red Hat Enterprise Linux ES release 4 (Nahant Update 2).

One Webserver with cacti 0.8.6h, Cactid 0.8.6g with the official "MySQL Maximum Packet Size" patch, php-4.3.9-3.9, httpd-2.0.52-22.en
One Database server with mysql-server-4.1.12-3.RHEL4.1

Everything seems work perfectly, but i have lots of entries in log file like that :

Code: Select all

02/14/2006 11:48:03 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=15limit 0,1

There's a mistake after local_graph_id=15, a space is missing between 15 and limit and this is still this request. . My question is only to know where can i correct this mistake?

Thank's a lot

Etn
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Please submit a bug to bugs.cacti.net.
[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]
Top
etn
Posts: 8
Joined: Mon Feb 13, 2006 4:32 am

Post by etn »

It's done :)

http://bugs.cacti.net/view.php?id=703
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

Ok, I had a brain fart... This is already an addressed bug. The "Invalid SQL When Creating Graphs" patch fixes it.

Btw, I suggest you apply all patches.

I will close the bug.
[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]
Top
etn
Posts: 8
Joined: Mon Feb 13, 2006 4:32 am

Post by etn »

No problem ;)
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 2 guests