Domoticz

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

You have an incorrect value in your database, see for example
viewtopic.php?t=43351

Deleting and recreating a device is the key? (but I lost all old datas...)

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/

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.

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.

I put 1 day in short log settings and I see tomorrow...

Thank for your help

Filnet wrote: Thursday 29 January 2026 17:18 I put 1 day in short log settings and I see tomorrow...

Thank for your help

@Filnet
I have a similar problem. Could you solve it?

No, the problem is not solved. I inspected the database with DB browser for sqlite and found no anomalies, especially in the stored Strings.

OK. Will keep you updated if I should find something. But as me as a non-tech-guy the likelihood is not very high ...

Thank you for your feedback. Hopefully someone will have an idea.