error when adding xiaomi gateway: database disk image is malformed

Xiaomi, Ikea TRÅDFRI, Philips Hue and more.
Post Reply
sander815
Posts: 46
Joined: Friday 13 January 2017 16:49
Target OS: Raspberry Pi
Domoticz version:
Contact:

error when adding xiaomi gateway: database disk image is malformed

Post by sander815 » Thursday 18 October 2018 22:16

when i try to add the xiaomi gateway to domoticz i get these errors

Code: Select all

2018-10-18 22:15:15.778 Status: XiaomiGateway: New Xiaomi Gateway Alarm Ringtone Found (7811dcdebe23)
2018-10-18 22:15:15.790 Status: XiaomiGateway: New Xiaomi Gateway Alarm Clock Found (7811dcdebe23)
2018-10-18 22:15:15.808 Status: XiaomiGateway: New Xiaomi Gateway Doorbell Found (7811dcdebe23)
2018-10-18 22:15:15.842 Status: XiaomiGateway: New Xiaomi Gateway MP3 Found (7811dcdebe23)
2018-10-18 22:15:15.857 Status: XiaomiGateway: New Xiaomi Gateway Volume Found (7811dcdebe23)
2018-10-18 22:15:15.885 Status: Incoming connection from: 127.0.0.1
2018-10-18 22:15:15.771 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:15.783 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:15.799 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:15.827 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:15.845 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:15.860 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
2018-10-18 22:15:16.270 Status: XiaomiGateway: New Xiaomi Door Sensor Found (158d00028b6b2f)
2018-10-18 22:15:16.273 Error: SQL Query("INSERT INTO LightingLog (DeviceRowID, nValue, sValue) VALUES ('18446744073709551615', '0', '0')") : database disk image is malformed
when i delete it again, the database disk image is malformed are gone again

User avatar
waaren
Posts: 1358
Joined: Tuesday 03 January 2017 15:18
Target OS: Raspberry Pi
Domoticz version: Beta
Location: Netherlands
Contact:

Re: error when adding xiaomi gateway: database disk image is malformed

Post by waaren » Friday 19 October 2018 0:24

There are quite a number of posts on this forum about a malformed db disk image but the most important thing to do if not done already is make sure you have a recent copy of your domoticz.db, stored on another system
Raspberry (debian stretch via berryboot on Synology DS916+) , Domoticz (almost) latest Beta, , dzVents 2.6, RFLink, RFXtrx433e, P1, Youless, Harmony, Hue, Yeelight, Xiaomi, HomeWizard, Zwave, Amazon echo

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests