New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


MySQL Sensor, Value not readable

Votes:

0

Your Vote:

Up

Down

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 by  backyard_racing (0) 1



10 Replies

Votes:

0

Your Vote:

Up

Down

Can you post the entire query?

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



Votes:

0

Your Vote:

Up

Down

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 by  backyard_racing (0) 1



Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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 by  backyard_racing (0) 1

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



Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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 by  backyard_racing (0) 1



Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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

Your Vote:

Up

Down

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 by  backyard_racing (0) 1



Please log in or register to enter your reply.


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.