Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

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

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

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

dlgreenwald opened this issue Aug 2, 2023 · 2 comments

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 •
edited

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dlgreenwald @leiweibau