Error Updating Device CHECK constraint failed: dev_Favorite IN (0, 1) #236
Description
I installed Pi.Alert a day or so ago, and in the process of editing devices to organize my network in it, I have a few devices which I cannot edit without getting the same error. I'm running the latest Docker image. Other devices seem to update just fine. Any advice is appreciated.
Error updating device
UPDATE Devices SET
dev_Name = "SmartThings Hub ",
dev_Owner = "",
dev_DeviceType = "",
dev_Vendor = "",
dev_Icon = "",
dev_Favorite = "",
dev_Group = "",
dev_Location = "",
dev_Comments = "",
dev_Network_Node_MAC_ADDR = "",
dev_Network_Node_port = "",
dev_StaticIP = "",
dev_ScanCycle = "",
dev_AlertEvents = "",
dev_AlertDeviceDown = "",
dev_SkipRepeated = "",
dev_NewDevice = "",
dev_Archived = ""
WHERE dev_MAC="**:**:**:**:**"
CHECK constraint failed: dev_Favorite IN (0, 1)