strange error after adding data source

[Guest]

I just added a data source. My cacti log file displays the following:

X-Powered-By: PHP/4.1.2
Content-type: text/html

<br />
<b>Warning</b>: Unable to jump to row 0 on MySQL result index 219 in <b>/usr/share/cacti/cmd.php</b> on line <b>139</b><br />
<br />
<b>Warning</b>: Unable to jump to row 0 on MySQL result index 219 in <b>/usr/share/cacti/cmd.php</b> on line <b>147</b><br />
<br />
<b>Warning</b>: Supplied argument is not a valid MySQL result resource in <b>/usr/share/cacti/cmd.php</b> on line <b>150</b><br />
<br />
<b>Warning</b>: Unable to jump to row 0 on MySQL result index 219 in <b>/usr/share/cacti/cmd.php</b> on line <b>157</b><br />

If I disable the data source, everything is OK. Can anyone help me out? Rax?

[raX]

Is this data source utilizing a script that has multiple outputs? Also, what happens if you delete this data source and re-add it with the same data input source? Or a different data input source?

Just trying to narrow down the problem

-Ian

[dunkers]

I'm getting this one as well, but with the addition (at the end of reams of this stuff) of:

ERROR: Template contains more DS definitions than RRD

Only got it since adding the weather.com script, basically cutting and pasting from the readme.htm for the output and input strings, then typing in the fields very carefully. Take a look at the log entry:

'08/30/2002 3:56 PM - CMD: c:/apps/rrdtool/rrdtool.exe update c:/data/HT-DOCS/cacti/rra/weather_wokingham.rrd --template curtemp:feelstemp:heatind:pressure:pressure:humidity:humidity:uvindex:uvindex:visibility:wdirection:windspeed:windchill N:20:20:0:0.28:76.2762:0.13:94:0.03:2:150:45:24.14016:0'

See how some fields are duplicated - the field definitions in the data input thing are correct. Dunno weather (sic) the log shows a fault or symptom, if you see what I mean.

[dunker]

Sorted.

The SQL messages are caused by the data output string having unused fileds. In the case of the weather.com script these are Condition, Location, Update time, UVthingy. Cacti appears not to handle unused fields properly.

The other error (about non-matching data sources in the RRD) is caused by the above screwing up the RRD.

To fix, I edited fetchweather.php and commented out the fields that aren't actually used. Then I adjusted the data inpur output string to match. Then I created a new DS (so the RRD was new).