Domoticz

Posted: **Thursday 30 April 2020 14:55**

Hi All,

I was wondering if it is possible to migrate my domoticz installation from a pi to a Debian Buster based VM.
reason why I am asking is that after several attempts to copy the database from the Pi(Debian Buster) to a new VM(Debian Buster) it is not working.
I get a massive amount of errors but its not clear te me why it is not working?

the only difference is the move from an ARM based system to a Intel based system.

in addtion I want to use my Pi as a USB over network server. anyone experience with this and what about delays?

Thanks advance!

Posted: **Thursday 30 April 2020 15:49**

Should be nothing more than get domoticz running in your VM. Then stop the service and replace the database file.
You could also consider copying the Zwave XML file to keep those settings.

Posted: **Thursday 30 April 2020 16:56**

When I login to the new VM and copy the database file from the Pi to the VM, this is the output.

Code: Select all

2020-04-30 14:16:57.950 Status: PluginSystem: Started, Python version '3.7.3'.
2020-04-30 14:16:57.954 Status: WebServer(HTTP) started on address: :: with port 8080
2020-04-30 14:16:57.957 Status: WebServer(SSL) started on address: :: with port 443
2020-04-30 14:16:57.958 Status: RxQueue: queue worker started...
2020-04-30 14:35:36.754 Status: Incoming connection from: 192.168.1.54
2020-04-30 16:40:00.775 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=6) OR (Type=243 AND SubType=30) OR (Type=243 AND SubType=31)") : database disk image is malformed
2020-04-30 16:40:00.775 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:40:00.775 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=7)") : database disk image is malformed
2020-04-30 16:40:00.775 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='5MinuteHistoryDays')") : database disk image is malformed
2020-04-30 16:40:00.890 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:40')))") : database disk image is malformed
2020-04-30 16:40:00.890 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:40')))") : database disk image is malformed
2020-04-30 16:41:00.895 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:41')))") : database disk image is malformed
2020-04-30 16:41:00.895 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:41')))") : database disk image is malformed
2020-04-30 16:42:00.901 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:42')))") : database disk image is malformed
2020-04-30 16:42:00.901 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:42')))") : database disk image is malformed
2020-04-30 16:43:00.907 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:43')))") : database disk image is malformed
2020-04-30 16:43:00.907 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:43')))") : database disk image is malformed
2020-04-30 16:44:00.912 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:44')))") : database disk image is malformed
2020-04-30 16:44:00.913 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:44')))") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=80 OR Type=81 OR Type=82 OR Type=84 OR Type=247 OR Type=87 OR Type=86 OR Type=64 OR Type=112 OR Type=253 OR Type=70 OR Type=71 OR Type=72 OR (Type=243 AND SubType=5) OR (Type=242 AND SubType=1) OR (Type=243 AND SubType=26))") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=85)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,DeviceID, Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=86)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=87) OR (Type=243 AND SubType=25)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Name,HardwareID,DeviceID,Unit,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=113 OR Type=251 OR Type=252 OR Type=90 OR Type=92 OR Type=249 OR Type=248 OR Type=246 OR Type=93 OR (Type=254 AND SubType=3) OR (Type=243 AND SubType=1) OR (Type=243 AND SubType=2) OR (Type=243 AND SubType=3) OR (Type=243 AND SubType=4) OR (Type=112 AND SubType=1) OR (Type=112 AND SubType=2) OR(Type=243 AND SubType=8) OR(Type=243 AND SubType=23) OR(Type=243 AND SubType=24) OR(Type=243 AND SubType=27) OR (Type=243 AND SubType=9) OR (Type=243 AND SubType=28) OR (Type=243 AND SubType=29))") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=250 OR Type=89 OR Type=91)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=6) OR (Type=243 AND SubType=30) OR (Type=243 AND SubType=31)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=7)") : database disk image is malformed
2020-04-30 16:45:00.830 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='5MinuteHistoryDays')") : database disk image is malformed
2020-04-30 16:45:00.918 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:45')))") : database disk image is malformed
2020-04-30 16:45:00.918 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:45')))") : database disk image is malformed
2020-04-30 16:46:00.925 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:46')))") : database disk image is malformed
2020-04-30 16:46:00.925 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:46')))") : database disk image is malformed
2020-04-30 16:47:00.932 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:47')))") : database disk image is malformed
2020-04-30 16:47:00.933 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:47')))") : database disk image is malformed
2020-04-30 16:47:57.954 Error: SQL Query("DELETE FROM UserSessions WHERE ExpirationDate < datetime('now', 'localtime')") : database disk image is malformed
2020-04-30 16:47:57.957 Error: SQL Query("DELETE FROM UserSessions WHERE ExpirationDate < datetime('now', 'localtime')") : database disk image is malformed
2020-04-30 16:48:00.940 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:48')))") : database disk image is malformed
2020-04-30 16:48:00.940 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:48')))") : database disk image is malformed
2020-04-30 16:49:00.948 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:49')))") : database disk image is malformed
2020-04-30 16:49:00.948 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:49')))") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=80 OR Type=81 OR Type=82 OR Type=84 OR Type=247 OR Type=87 OR Type=86 OR Type=64 OR Type=112 OR Type=253 OR Type=70 OR Type=71 OR Type=72 OR (Type=243 AND SubType=5) OR (Type=242 AND SubType=1) OR (Type=243 AND SubType=26))") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=85)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,DeviceID, Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=86)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=87) OR (Type=243 AND SubType=25)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Name,HardwareID,DeviceID,Unit,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=113 OR Type=251 OR Type=252 OR Type=90 OR Type=92 OR Type=249 OR Type=248 OR Type=246 OR Type=93 OR (Type=254 AND SubType=3) OR (Type=243 AND SubType=1) OR (Type=243 AND SubType=2) OR (Type=243 AND SubType=3) OR (Type=243 AND SubType=4) OR (Type=112 AND SubType=1) OR (Type=112 AND SubType=2) OR(Type=243 AND SubType=8) OR(Type=243 AND SubType=23) OR(Type=243 AND SubType=24) OR(Type=243 AND SubType=27) OR (Type=243 AND SubType=9) OR (Type=243 AND SubType=28) OR (Type=243 AND SubType=29))") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=250 OR Type=89 OR Type=91)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=6) OR (Type=243 AND SubType=30) OR (Type=243 AND SubType=31)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=7)") : database disk image is malformed
2020-04-30 16:50:00.898 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='5MinuteHistoryDays')") : database disk image is malformed
2020-04-30 16:50:00.956 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:50')))") : database disk image is malformed
2020-04-30 16:50:00.956 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:50')))") : database disk image is malformed
2020-04-30 16:51:00.963 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:51')))") : database disk image is malformed
2020-04-30 16:51:00.963 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:51')))") : database disk image is malformed
2020-04-30 16:52:00.971 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:52')))") : database disk image is malformed
2020-04-30 16:52:00.971 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:52')))") : database disk image is malformed
2020-04-30 16:53:00.978 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:53')))") : database disk image is malformed
2020-04-30 16:53:00.978 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:53')))") : database disk image is malformed
2020-04-30 16:54:00.985 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:54')))") : database disk image is malformed
2020-04-30 16:54:00.985 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:54')))") : database disk image is malformed
2020-04-30 16:54:48.322 Status: Incoming connection from: 192.168.1.54
2020-04-30 16:54:48.322 Error: SQL Query("SELECT sValue FROM Preferences WHERE (Key='Title')") : database disk image is malformed
2020-04-30 16:54:48.322 Error: SQL Query("SELECT SessionID, Username, AuthToken, ExpirationDate FROM UserSessions WHERE SessionID = '7ef0b9d62e63721756d3bbb13db6a05d'") : database disk image is malformed
2020-04-30 16:54:48.322 Error: SQL Query("INSERT INTO UserSessions (SessionID, Username, AuthToken, ExpirationDate, RemoteHost) VALUES ('7ef0b9d62e63721756d3bbb13db6a05d', '', '9f4518657cb90801555a166c1f4481bc', '2020-04-30 17:04:48', '192.168.1.54')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT sValue FROM Preferences WHERE (Key='Language')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT sValue FROM Preferences WHERE (Key='DegreeDaysBaseTemperature')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='DashboardType')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='MobileType')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='5MinuteHistoryDays')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='ShowUpdateEffect')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabFloorplans')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabLights')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabScenes')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabTemp')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabWeather')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabUtility')") : database disk image is malformed
2020-04-30 16:54:49.056 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='EnableTabCustom')") : database disk image is malformed
2020-04-30 16:54:49.120 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='UseAutoUpdate')") : database disk image is malformed
2020-04-30 16:54:49.712 Error: SQL Query("SELECT ID, Name, [Order] FROM Plans ORDER BY [Order]") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT ID, Name, Enabled, Type, Mode1, Mode2 FROM Hardware") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT A.ID, A.Name, A.nValue, A.LastUpdate, A.Favorite, A.SceneType, A.Protected, B.XOffset, B.YOffset, B.PlanID, A.Description FROM Scenes as A LEFT OUTER JOIN DeviceToPlansMap as B ON (B.DeviceRowID==a.ID) AND (B.DevSceneType==1) ORDER BY A.[Order],A.LastUpdate DESC") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT ID FROM Plans WHERE (Name=='$Hidden Devices')") : database disk image is malformed
2020-04-30 16:54:49.725 Error: SQL Query("SELECT A.ID, A.DeviceID, A.Unit, A.Name, A.Used,A.Type, A.SubType, A.SignalLevel, A.BatteryLevel, A.nValue, A.sValue, A.LastUpdate, A.Favorite, A.SwitchType, A.HardwareID, A.AddjValue, A.AddjMulti, A.AddjValue2, A.AddjMulti2, A.LastLevel, A.CustomImage, A.StrParam1, A.StrParam2, A.Protected, IFNULL(B.XOffset,0), IFNULL(B.YOffset,0), IFNULL(B.PlanID,0), A.Description, A.Options, A.Color FROM DeviceStatus as A LEFT OUTER JOIN DeviceToPlansMap as B ON (B.DeviceRowID==a.ID) AND (B.DevSceneType==0) ORDER BY A.[Order],A.LastUpdate DESC") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='HideDisabledHardwareSensors')") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT ID, Name, Enabled, Type, Mode1, Mode2 FROM Hardware") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT A.ID, A.Name, A.nValue, A.LastUpdate, A.Favorite, A.SceneType, A.Protected, B.XOffset, B.YOffset, B.PlanID, A.Description FROM Scenes as A LEFT OUTER JOIN DeviceToPlansMap as B ON (B.DeviceRowID==a.ID) AND (B.DevSceneType==1) ORDER BY A.[Order],A.LastUpdate DESC") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT ID FROM Plans WHERE (Name=='$Hidden Devices')") : database disk image is malformed
2020-04-30 16:54:49.770 Error: SQL Query("SELECT A.ID, A.DeviceID, A.Unit, A.Name, A.Used,A.Type, A.SubType, A.SignalLevel, A.BatteryLevel, A.nValue, A.sValue, A.LastUpdate, A.Favorite, A.SwitchType, A.HardwareID, A.AddjValue, A.AddjMulti, A.AddjValue2, A.AddjMulti2, A.LastLevel, A.CustomImage, A.StrParam1, A.StrParam2, A.Protected, IFNULL(B.XOffset,0), IFNULL(B.YOffset,0), IFNULL(B.PlanID,0), A.Description, A.Options, A.Color FROM DeviceStatus as A LEFT OUTER JOIN DeviceToPlansMap as B ON (B.DeviceRowID==a.ID) AND (B.DevSceneType==0) ORDER BY A.[Order],A.LastUpdate DESC") : database disk image is malformed
2020-04-30 16:55:00.968 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.968 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=80 OR Type=81 OR Type=82 OR Type=84 OR Type=247 OR Type=87 OR Type=86 OR Type=64 OR Type=112 OR Type=253 OR Type=70 OR Type=71 OR Type=72 OR (Type=243 AND SubType=5) OR (Type=242 AND SubType=1) OR (Type=243 AND SubType=26))") : database disk image is malformed
2020-04-30 16:55:00.968 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=85)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,DeviceID, Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=86)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=87) OR (Type=243 AND SubType=25)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Name,HardwareID,DeviceID,Unit,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=113 OR Type=251 OR Type=252 OR Type=90 OR Type=92 OR Type=249 OR Type=248 OR Type=246 OR Type=93 OR (Type=254 AND SubType=3) OR (Type=243 AND SubType=1) OR (Type=243 AND SubType=2) OR (Type=243 AND SubType=3) OR (Type=243 AND SubType=4) OR (Type=112 AND SubType=1) OR (Type=112 AND SubType=2) OR(Type=243 AND SubType=8) OR(Type=243 AND SubType=23) OR(Type=243 AND SubType=24) OR(Type=243 AND SubType=27) OR (Type=243 AND SubType=9) OR (Type=243 AND SubType=28) OR (Type=243 AND SubType=29))") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate,Options FROM DeviceStatus WHERE (Type=250 OR Type=89 OR Type=91)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=6) OR (Type=243 AND SubType=30) OR (Type=243 AND SubType=31)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='SensorTimeout')") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT ID,Type,SubType,nValue,sValue,LastUpdate FROM DeviceStatus WHERE (Type=243 AND SubType=7)") : database disk image is malformed
2020-04-30 16:55:00.969 Error: SQL Query("SELECT nValue, sValue FROM Preferences WHERE (Key='5MinuteHistoryDays')") : database disk image is malformed
2020-04-30 16:55:00.993 Error: SQL Query("SELECT ID FROM Timers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:55')))") : database disk image is malformed
2020-04-30 16:55:00.993 Error: SQL Query("SELECT ID FROM SceneTimers WHERE (Type == 5 AND ((Date < '2020-04-30') OR (Date == '2020-04-30' AND Time < '16:55')))") : database disk image is malformed

It is saying that the disk image is malformed but domoticz on the Pi is working fine.

not sure where to go from here

oh yeah, BTW. the pi version is 2020.1 and the vm version is 2020.2

Domoticz

Migrate Domoticz from Pi to VM

Migrate Domoticz from Pi to VM

Re: Migrate Domoticz from Pi to VM

Re: Migrate Domoticz from Pi to VM