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
Article Comments
Hi, this is the query:
SELECT * FROM `shop_currencies_value` WHERE 1
this is the resulting table (header and first row):
| code | value | last_updated |
|---|---|---|
| eur | 1.09726000 | 2016-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.
Jun, 2016 - Permalink
The query looks a bit incomplete. Could you post a screenshot of the sensors settings page?
Jun, 2016 - Permalink
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:
Jun, 2016 - Permalink
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
Jun, 2016 - Permalink
Alright, I could reproduce the problem. I'll forward it to our developer and we'll have a look at it :)
Jun, 2016 - Permalink
Seems like it's indeed a bug where the received value is casted as Single instead of float. We'll look into it :)
Jun, 2016 - Permalink
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.
Jun, 2016 - Permalink
Ok, please inform me or write a reply in this topic when there is a new relase. And thank you for your help!
Jun, 2016 - Permalink
Can you post the entire query?
Jun, 2016 - Permalink