I have a issue with Blockly,
there is one event i cannot delete, and i cannot create a event anymore.
Version: 3.5469
Build Hash: 594766f
Compile Date: 2016-08-11 15:54:56
reading the log my database is malformed:
Code: Select all
2016-08-11 17:30:23.243 Error: SQL Query("DELETE FROM EventMaster WHERE (ID == '3')") : database disk image is malformed
2016-08-11 17:35:01.174 Error: SQL Query("INSERT INTO UV (DeviceRowID, Level) VALUES ('90', '2')") : database disk image is malformed
2016-08-11 17:35:01.182 Error: SQL Query("INSERT INTO Meter (DeviceRowID, Value, [Usage]) VALUES ('12', '0', '0')") : database disk image is malformed
2016-08-11 17:35:01.182 Error: SQL Query("INSERT INTO Meter (DeviceRowID, Value, [Usage]) VALUES ('14', '1864', '0')") : database disk image is malformed
2016-08-11 17:35:01.192 Error: SQL Query("INSERT INTO Meter (DeviceRowID, Value, [Usage]) VALUES ('97', '50', '0')") : database disk image is malformed
2016-08-11 17:35:01.256 Error: SQL Query("DELETE FROM UV 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
2016-08-11 17:35:01.257 Error: SQL Query("DELETE FROM Meter 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