On Thu, 23 Aug 2018, Raphael Hertzog wrote: > On Thu, 23 Aug 2018, Alexander Wirt wrote: > > > A simple SQL update query would save us a lot of time. Thank you for > > > considering it. > > Sure, do you have the query? And please ensure not to affect bots > > running on other networks. > > I don't have any gitlab instance where to make test so this is untested > and based on some output provided by Pierre-Elliot Bécue. But I believe > that this should do the trick. > > UPDATE services SET properties = REPLACE(properties, > 'irc://irc.oftc.net:6697', 'ircs://irc.oftc.net:6697') > WHERE properties LIKE '%ruprecht.snow-crash.org%' and type = 'IrkerService'; > > Run it in a transaction and check the result on some sample entries before > and after the update command and commit if you are happy. > > properties seems to be JSON data in a text field and it contains the > IRC URI multiple times. done, thanks. Please check in your settings if all is fine now.
Alex
signature.asc
Description: PGP signature
