search

pucherot / Pi.Alert

WIFI / LAN intruder detector. Check the devices connected and alert you with unknown devices. It also warns of the disconnection of "always connected" devices
GNU General Public License v3.0
2.03k stars 126 forks source link

Error Updating Device CHECK constraint failed: dev_Favorite IN (0, 1) #236

Open dlgreenwald opened 1 year ago

dlgreenwald commented 1 year ago

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)
leiweibau commented 1 year ago

pucherot/Pi.Alert has no docker support. Surely you use a fork.

‼️ Please note this when opening an issue ‼️

dlgreenwald commented 1 year ago

This is an accurate and embarrassing mistake. Apologies.