Hi there, I'm facing this issue here: https://github.com/supabase/supabase/issues/4883 And ran the SQL suggested as a fix in the comment thread - but now hitting another error of: "URL using bad/illegal format or missing URL" In the postgres logs - could someone please help investigate? 🙂 I had just unpaused my project today after a few weeks

Hello @geordi! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

You are going to need to provide more context on what you are doing that caused the original error and what you are doing when you get the url error now.

Very similar to this thread you had answered here: https://discord.com/channels/839993398554656828/986571085724139550

You might try recreating a new function hook and deleting the old one. I don't know enough about the resources pg_net (used for function hooks) uses. When you used the sql to create grants you did that on the net schema?

I have tried to recreate a few times - what do you mean by grants sorry?

That is what you did here https://github.com/supabase/supabase/issues/4883#issuecomment-1017955034. Seems like your instance is messed up. Might be best to contact support or try a new instance, especially if you started running code that modifies Supabase functions and schemas (even if suggested as a fix).

haha so recreate the whole project?

Contacting support might be something they can look at. Hard to debug the inner workings of pg_net from here and the pause/restore did cause a couple of issues a month or so ago if i recall.

Np, thanks for the help