Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

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

Open
dlgreenwald opened this issue Aug 2, 2023 · 2 comments
Open

Comments

@dlgreenwald
Copy link

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
Copy link

leiweibau commented Aug 2, 2023

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

‼️ Please note this when opening an issue ‼️

@dlgreenwald
Copy link
Author

This is an accurate and embarrassing mistake. Apologies.

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants