Error on writePoint

[Anzic23]

if the object was a logical value and then became a number, I get this error. changing to other types does not produce results. null is written to the log.
influxdb_log.txt

[Apollon77]

Changing data types in influxdb is no good idea because they are "pinned" for each shard as soon as the first value is written. Plese check which value is really in the DB ... I think admin could show some values wrong (and influxdb do not support null at all, so value can not be null).

Also please try latest version (or which version you use?)

[Anzic23]

I understand that this is not a good idea, but I had to change the object that is linked to the original one. and there the type changed. I would not like to rewrite it in all scripts where it is used. driver version latest 1.8.4

[Apollon77]

But in fact according to your log the adapter did fine, he detected that type difference and fixed it and wrote it with the expected type. So only Admin seems to display wrong values in the table. Please check in DB directly what values are stored. Is it correct there?

[Anzic23]

I don't know if the data I got is correct, but it's all I could get. mqtt.3.ESP_Easy_DRAGON.Relay.Switch - this is an original object.
linkeddevices.0.server-room.voda - linked


if you tell me exactly how to check the data , I'll check it.

[Apollon77]

Try to select raw values plase ... not a "mean"

[Anzic23]

there is no such function (raw). there are only these. I made an export, I attach the file.
and it is not clear why this object has two "values"

iobroker.global.linkeddevices.0.server-room.voda.2020-05-12-08-40.zip

[Apollon77]

SELECT * from name ORDER BY time desc LIMIT 100

or such?

[Anzic23]

[Apollon77]

Sorry bug yes this query makes no sense :-(
And he says whats missing ... he expects ASC or DESC after ORDER BY time(...) and the Fill makes no sense

[Anzic23]

I give up. created a new object and reassigned the associated object to it.