problem in the logfile

[gerardsoraya]

hello,

i have an error in the logfile and i cant explain where its from, i googled it a lot but no answers found yet.
every 5 minutes the next problem is in the logfile:

Code: Select all

2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('313', '0')") : database disk image is malformed
2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('314', '0')") : database disk image is malformed
2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('3268', '50')") : database disk image is malformed
2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('3269', '0')") : database disk image is malformed
2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('3273', '0')") : database disk image is malformed
2018-06-16 12:40:00.500 Error: SQL Query("DELETE FROM Percentage WHERE strftime('%s',datetime('now','localtime')) - strftime('%s',Date) > (SELECT p.nValue * 86400 From Preferences AS p WHERE p.Key='5MinuteHistoryDays')") : database disk image is malformed

[waaren]

i have an error in the logfile and i cant explain where its from, i googled it a lot but no answers found yet.
every 5 minutes the next problem is in the logfile:

2018-06-16 12:40:00.454 Error: SQL Query("INSERT INTO Percentage (DeviceRowID, Percentage) VALUES ('313', '0')") : database disk image is malformed

The solution described here viewtopic.php?f=28&t=10984 might work for you

[waaren]

i had a issue with logfile that
I can see the log in Domoticz when i click on the log button.
Only is there a logfile, where i can see what happend, when my pc is off?
There is something wrong, so i hope i can see on this file,
And then i do not have to watch @ night to my p

According the wiki for installing on Windows
"A page for setting up the Domoticz Log File Location Path is shown. The default path (C:\Program Files (x86)\Domoticz\log) is shown and can be edited. If you do not wish to retain the log file permanently, select a temp folder (c:\windowstemp for instance)."
So if you did not edit this path during installation the domoticz log should be there.


On linux you can choose in the startup script in /etc/init.d/ if you want the logging to an OS file or only the last couple of lines in memory. You can also choose how much is logged using logsettings. Don't know if this is the same on Windows.