Error: GetJSonDevices: exception occurred : 'stoull'
Moderator: leecollings
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Error: GetJSonDevices: exception occurred : 'stoull'
Hello,
This message appears in log ans I can't find to solve it.
I disable all my scripts: The problem is not here.
It appears when I click on log button of a device Smart P1 and a second time when I close the log graphs, for instance.
Thanks for your help
This message appears in log ans I can't find to solve it.
I disable all my scripts: The problem is not here.
It appears when I click on log button of a device Smart P1 and a second time when I close the log graphs, for instance.
Thanks for your help
- waltervl
- Posts: 6676
- Joined: Monday 28 January 2019 18:48
- Target OS: Linux
- Domoticz version: 2025.1
- Location: NL
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
You have an incorrect value in your database, see for example
viewtopic.php?t=43351
viewtopic.php?t=43351
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
Deleting and recreating a device is the key? (but I lost all old datas...)
- waltervl
- Posts: 6676
- Joined: Monday 28 January 2019 18:48
- Target OS: Linux
- Domoticz version: 2025.1
- Location: NL
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
Or make a backup of the database and examine and modify it with for example https://sqlitebrowser.org
If you just want to examine it you can make a backup dump with menu Setup-Settings -tab Backup/restore and open the file in the online viewer https://sqliteviewer.app/
If you just want to examine it you can make a backup dump with menu Setup-Settings -tab Backup/restore and open the file in the online viewer https://sqliteviewer.app/
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
Yes, I have already done it.
Integrity check is OK.
but I don't know where I search in the DB.
This message appears each time I click 'Log' regardless of the device.
Integrity check is OK.
but I don't know where I search in the DB.
This message appears each time I click 'Log' regardless of the device.
- waltervl
- Posts: 6676
- Joined: Monday 28 January 2019 18:48
- Target OS: Linux
- Domoticz version: 2025.1
- Location: NL
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
Then it gets data out of the database so probably look in the meter_calendar or multimeter_calendar table. It could also be in the short term meter or multimeter tables but those get cleaned up every x days (depends on your short log settings). So probably not the root cause of your issue.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
I put 1 day in short log settings and I see tomorrow...
Thank for your help
Thank for your help
-
imautohuttraeger
- Posts: 172
- Joined: Saturday 14 March 2020 13:40
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.1
- Location: Germany
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
@FilnetFilnet wrote: Thursday 29 January 2026 17:18 I put 1 day in short log settings and I see tomorrow...
Thank for your help
I have a similar problem. Could you solve it?
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
No, the problem is not solved. I inspected the database with DB browser for sqlite and found no anomalies, especially in the stored Strings.
-
imautohuttraeger
- Posts: 172
- Joined: Saturday 14 March 2020 13:40
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.1
- Location: Germany
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
OK. Will keep you updated if I should find something. But as me as a non-tech-guy the likelihood is not very high ...
-
Filnet
- Posts: 53
- Joined: Tuesday 06 March 2018 13:55
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2025.2 ß
- Location: FR
- Contact:
Re: Error: GetJSonDevices: exception occurred : 'stoull'
Thank you for your feedback. Hopefully someone will have an idea.
Who is online
Users browsing this forum: No registered users and 1 guest