Domoticz

Hello,

I use Domoticz with some scripts.
Sometimes, one of my scripts seems to have trouble and modify something in the database, and Domoticz crashes with this message

WebServer PO exception occurred : 'stoull'

How to debug this ?
I don't know where is the problem in the database.
I explore the database with DB Browser for sqlite I can see a nan instead of a valid value, I change it but domoticz still crashes.
I remove all the history for this device but nothing changes...

How to trace the different request to identify the bad one ?

I rebuild my configuration for the 4th or 5th time and I don't see how to identify the problem.

Thank you for your help....

Domange wrote: ↑Friday 03 January 2020 16:35 Sometimes, one of my scripts seems to have trouble and modify something in the database, and Domoticz crashes with this message
I don't know where is the problem in the database.

Have a look at these topics. First one is a dzVents script giving an alert when there could be a database problem. Second one show some approaches to fix a malformed database.

https://www.domoticz.com/forum/viewtopi ... 72&t=26692
https://www.domoticz.com/forum/viewtopi ... 28&t=10984

Thank you very for your answer.

I don't yet know the dvVents scripts. It's very usefull.

And the database test might help me to solve my issue.