Any i dea why I get these strange errors when doing an test upgrade from my v4.10717 database to v2023.2?
The database is not updated properly and keeps given some sql errors at startup.
When taking a copy of the v4.10717 database and doing the same sql command listed in SQLite Expert Personal 5, things work fine.
I can ofcourse do these conversion command manually, but maybe others have the same issue and didn't notice this, which could cause issues for the future.
Code: Select all
Status: Domoticz V2023.2 (c)2012-2023 GizMoCuz
Status: Build Hash: 19efd039c, Date: 2023-07-21 17:23:44
Status: Startup Path: /home/pi/domoticz/
Error: SQL Query("ALTER TABLE PushLink RENAME TO tmp_PushLink") : error in trigger shareddevicesupdate: no such column: Order
Error: SQL Query("INSERT INTO PushLink (PushType, DeviceRowID, DelimitedValue, TargetType, TargetVariable, TargetDeviceID, TargetProperty, Enabled, IncludeUnit) SELECT [PushType], [DeviceID], [DelimitedValue], [TargetType], [TargetVariable], [TargetDeviceID], [TargetProperty], [Enabled], [IncludeUnit] FROM tmp_PushLink") : table PushLink has no column named DeviceRowID
Error: SQL Query("DROP TABLE tmp_PushLink") : no such table: tmp_PushLink
Error: SQL Query("ALTER TABLE Preferences RENAME to Preferences_without_primary_key") : error in trigger shareddevicesupdate: no such column: Order
Error: SQL Query("DELETE from Preferences_without_primary_key WHERE Rowid NOT IN (SELECT MIN(rowid) FROM Preferences_without_primary_key GROUP BY Key)") : no such table: Preferences_without_primary_key
Error: SQL Query("CREATE TABLE [Preferences] ([Key] VARCHAR(50) PRIMARY KEY, [nValue] INTEGER DEFAULT 0, [sValue] VARCHAR(200))") : table [Preferences] already exists
Error: SQL Query("INSERT INTO Preferences SELECT * from Preferences_without_primary_key") : no such table: Preferences_without_primary_key
Error: SQL Query("DROP TABLE Preferences_without_primary_key;") : no such table: Preferences_without_primary_key
Error: SQL Query("ALTER TABLE UserVariables RENAME TO tmp_UserVariables;") : error in trigger shareddevicesupdate: no such column: Order
Error: SQL Query("INSERT INTO UserVariables ([ID],[Name],[ValueType],[Value],[LastUpdate]) SELECT [ID],[Name],[ValueType],[Value],[LastUpdate] FROM tmp_UserVariables") : no such table: tmp_UserVariables
Error: SQL Query("DROP TABLE tmp_UserVariables;") : no such table: tmp_UserVariables
Sunrise: 07:34:00 SunSet: 17:19:00