MySQL Sensor, Value not readable

Can you post the entire query?

Hi, this is the query:

SELECT * FROM `shop_currencies_value` WHERE 1

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

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.

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

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:

or link to screenshot

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

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

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

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

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.

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