What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

MySQL Sensor, Value not readable

Votes:

0

Hi, i try to read a value from a simple table. But always get an error "Die angegebene Umwandlung ist ungültig.".

The sensor and the query are working fine when i don't process any values. The query itself is working fine when i put it into phpMyAdmin SQL window.

The value i try to read is in the format "float(13,8)". Is that a problem?

Thank you! Oliver

error mysql-v2-sensor value

Created on Jun 21, 2016 9:11:30 AM



10 Replies

Votes:

0

Can you post the entire query?

Created on Jun 21, 2016 5:40:13 PM by Stephan Linke [Paessler Support]



Votes:

0

Hi, this is the query:

SELECT * FROM `shop_currencies_value` WHERE 1

this is the resulting table (header and first row):

codevaluelast_updated
eur1.097260002016-03-07

i wanna use the value from "value" and show it in the sensor channel. But as soon as i want to use any of the values from the result in a channel, i have the error message.

Created on Jun 22, 2016 8:28:31 AM



Votes:

0

The query looks a bit incomplete. Could you post a screenshot of the sensors settings page?

Created on Jun 22, 2016 9:04:42 AM by Stephan Linke [Paessler Support]



Votes:

0

The query is short, yes, but it's enough. I could alter it to this, but its not neccessary:

SELECT * FROM `shop_currencies_value` WHERE 1 order by `last_updated` desc limit 1;

Here are the Sensor Settings:

Sensor Settings

or link to screenshot

Created on Jun 22, 2016 9:23:48 AM

Last change on Jun 22, 2016 10:19:19 AM by Stephan Linke [Paessler Support]



Votes:

0

Alright, I'll rebuild the table and let you know what I find :)

Created on Jun 22, 2016 10:19:35 AM by Stephan Linke [Paessler Support]



Votes:

0

here ist the MySQL structure of the table, i think you need that to build this table?

https://www.dropbox.com/s/gol05lbj0m1b655/Screenshot%202016-06-22%2013.47.42.png?dl=0

Created on Jun 22, 2016 11:49:09 AM



Votes:

0

Alright, I could reproduce the problem. I'll forward it to our developer and we'll have a look at it :)

Created on Jun 23, 2016 9:17:33 AM by Stephan Linke [Paessler Support]



Votes:

0

Seems like it's indeed a bug where the received value is casted as Single instead of float. We'll look into it :)

Created on Jun 23, 2016 10:44:40 AM by Stephan Linke [Paessler Support]



Votes:

0

The bug has been found and will be fixed in the next preview version of PRTG. Thanks for the hint! :) Note that it might take a bit until it reaches the stable version.

Created on Jun 23, 2016 11:15:06 AM by Stephan Linke [Paessler Support]



Votes:

0

Ok, please inform me or write a reply in this topic when there is a new relase. And thank you for your help!

Created on Jun 23, 2016 12:39:40 PM




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.