Supabase #javascript

Bôgras

07/08/2022, 9:41 PM

Hello, I'm new to both Supabase and JavaScript. I was trying to do sign ups with email, password and additional user data, following what I saw in

https://github.com/supabase/supabase/discussions/3491

and

https://dev.to/sruhleder/creating-user-profiles-on-sign-up-in-supabase-5037

. I am getting the error message > Database error saving new user every time I try to do a sign up, accompanied by a code 500 error. I've tried everything I could think of to solve it. I've checked the table's field types, email confirmation, the SQL queries, and still nothing. Am I missing something gruesomely obvious?

Relisora

07/08/2022, 10:53 PM

How to connect to custom schema? I did:

Copy code

js
createClient(
  'xxx.supabase.co',
  'xxx',
  { schema: 'otherschema' }
)

But now every request gives me an error 406,

Not Acceptable

. Am I missing something ?

FestiveLlama

07/08/2022, 11:33 PM

Hey. Does anyone know how to save to a table that has a fk constraint?

Abanob Boles

07/10/2022, 8:30 AM

Hello I have a question about date filtering. I have a timestamp and only want to get all the lines that are in a specific day. I can't find which is the right filter function for the timestamp. (Supabase JS)

stingray21

07/10/2022, 10:50 AM

I'm struggling with the redirect link for subdomains, I apologize if I am not suppose to link this from the general channel, but since I cannot figure it out in the settings, I'm starting to wonder whether I'm doing the JS implementation wrong [RedirectTo does not work for addition redirect URLs](https://discord.com/channels/839993398554656828/994604809082638397/)

tche

07/11/2022, 2:53 PM

Hey, my server is getting the error "An invalid response was received from the upstream server" from Supabase and my dashboard is loading indefinitely. Would you know why? Any downtime on some of your servers?

tche

07/11/2022, 2:55 PM

Sorry if it is not the right channel to ask for this kind of support.

GlennS

07/11/2022, 9:26 PM

Hiya folks. I am surmising from looking at https://github.com/supabase/storage-js/blob/main/src/lib/StorageFileApi.ts that there is no "overwrite" option for the .copy and .move methods. I understand this might be due to the underying S3 API (Backblaze?). I am resigned to proceed to do a combo .remove() + .copy() call but just wanted to make sure this is the right path.

GlennS

07/11/2022, 10:52 PM

Ok, I just figured this out. Duh. ;-). .update is the answer:

GlennS

07/11/2022, 10:52 PM

Copy code

const avatarFile = event.target.files[0]
const { data, error } = await supabase
  .storage
  .from('avatars')
  .update('public/avatar1.png', avatarFile, {
    cacheControl: '3600',
    upsert: false
  })

sudoramen

07/12/2022, 4:43 AM

Hi All! If I've got RLS rules, does

supabase.from('table-name').on('*', cb)

only listen to rows restricted by the rules or will it trigger for all rows?

AdrianMsM91 {KBL}

07/12/2022, 9:29 AM

Hello! Somebody is having troubles with the redirect when you're pressing Forget my password ? In my LocalHost works fine, but as soon as I go to enviromment with Vercel always the URL which is arriving is just

${APP_HOST}

, is not arriving the rest /authentication/recovery-password , obviously I have the URL added to: Additional redirect URLs also in:

Copy code

js
  const resetPasswordForEmail = async (email) => {
    return supabase.auth.api.resetPasswordForEmail(email, {
      redirectTo: `${APP_HOST}/authentication/recovery-password`
    });
  };

Then I decided tu do the trick putting this /authentication/recovery-password

Copy code

js
<h2>Reset Password</h2>

<p>Follow this link to reset the password for your user:</p>
<p><a href="{{ .ConfirmationURL }}authentication/recovery-password">Reset Password</a></p>

Then looks like the URL arrives correctly but once I click It doesn't redirect to

authentication/recovery-password

but to

${APP_HOST}

Any solution please?

rommyarb

07/12/2022, 10:35 AM

Suddenly cannot signIn with email & pass with supabase.

Copy code

502 error "An invalid response was received from the upstream server"

I'm using supabase js client supabase.auth.signIn()

garyaustin

07/12/2022, 12:53 PM

RLS and subscriptions

conrad.lin

07/12/2022, 2:58 PM

Hi guys, is anyone having issues with realtime? All of a sudden my realtime subscribes in my projects are not triggering anymore, even when there is definitely a change in the database. No configuration has changed for the last few days, and only noticing this problem today.

garyaustin

07/12/2022, 3:05 PM

Hmmm. Supabase is rolling out a fix for recent instances and realtime not working with RLS. https://github.com/supabase/realtime/issues/265#issuecomment-1181548704 Hope it is not breaking working instances.

conrad.lin

07/12/2022, 3:06 PM

Yeah, it seems so 😦 I just rebooted my project and still no luck. Should I just wait for a fix? How can I be helpful?

garyaustin

07/12/2022, 3:08 PM

I’d actually comment in that issue saying you were working now not. And send a support request, if you did not change anything. The rollout of the “fix” is happening now, so you may be the first to see it break something else…. Or it could just be random timing.

conrad.lin

07/12/2022, 3:12 PM

https://github.com/supabase/realtime/issues/265#issuecomment-1181885153 Made a comment, thank you for suggestion.

conrad.lin

07/12/2022, 3:12 PM

Doing the support ticket now.

conrad.lin

07/12/2022, 3:13 PM

Thank you so much @garyaustin - will keep you updated when a fix comes by

MelodicAlbuild

07/12/2022, 7:03 PM

Minor Question, I am authenticating through Discord with Supabase but I don't know how to get the user's discord guilds and other information through that, how would I go about getting that information?

joshcowan25

07/12/2022, 7:43 PM

How to get user's metadata from the auth table? I tought It would be send when I sign in, but it's not there.

J0s3v4rg4s

07/12/2022, 7:51 PM

hi everyone, I'm having error when I try to upload a file, anyone can give me a hand ?

Olyno

07/12/2022, 8:14 PM

More informations with oauth2

Olyno

07/12/2022, 8:16 PM

Issue with user metadata

Olyno

07/12/2022, 8:16 PM

Upload file error

AdrianMsM91 {KBL}

07/12/2022, 11:03 PM

Hello, can anybody help me with this?

jaitaiwan

07/12/2022, 11:44 PM

Authentication redirect issue

jaitaiwan

07/12/2022, 11:45 PM

Suddenly cannot signIn with email pass