SQL Query error Topic is solved

[Thuis]

I installed beta 17950. One device is giving an error, although i have lots of this device types. It is a virtual device usage/electra.

Spoiler: show

Error: SQL Query("SELECT Value, Price, Date FROM MultiMeter_Calendar WHERE (DeviceRowID==2149 AND Date>='2026-05-06' AND Date<='2026-05-13') ORDER BY Date ASC") : no such column: Value
2026-05-13 17:00:00.798

No such column: value, anyone else seeing this? Should i add a column myself or should it see value1 or 2 instead of value?

[willemd]

I think you need to check where this device is stored by using select * from either multimeter_calendar or meter_ calender and then use the correct column names for that table.

[Thuis]

Ok thanks, i adjusted the db and it seems to be giving no more errors.