Looks like it. The syntax for that INSERT should include an “IGNORE” clause if there’s any possibility the database has already been updated. If you are brave, you can log into MySQL as root and enter “DELETE FROM endpoint_global WHERE key = “legacyXML”;”
There are all sorts of ways this could go, including doing the right thing and allowing you to continue or failing with some other problem in the database.
Well, I don’t know how it started working again, but it is.
I ran fwconsole ma --edge install endpoint and it installed a newer version of framework. ran the same command again (fwconsole ma --edge install endpoint) and it successfully installed endpoint without any sql error. I then installed restapps again. seems to be fine.
weird.