Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hi all! I set up Supabase auth on the server using Express, and the sign up works just fine. However, when I try to login, I get an error saying that the email has not been confirmed. I checked my settings and I have email confirmation turned off. Has anyone experienced this?

Hello <@924483402881695754>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> 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.

Have you tried deleting the user and then signing up again?

Hi <@541088082905137172> Thank you for the reply! I deleted the user and signed them up again. But I get the same result. The sign up works just fine, but when I try to sign in it says 'Email not confirmed'

Interesting, just to double confirm -- enable email confirmation is off like this?

Yep, the only difference is that I do not have "Enable Custom SMTP" enabled - but otherwise it looks exactly the same.

Does it show `email_confirmed_at` in your `auth.users` table?

I just turned off `Enable Custom SMTP` and still works

It shows null in my ```auth.users``` table

Sorry, wrong screenshot the first time 🙂

Interesting, there isn't any gotcha's when working with Supabase auth that I know of. I see that the row `email_confirmed_at` isn't getting updated and is the reason why you are getting the error

Is that possibly related to doing this server side via Express?

Or, if it allows me to signup, does that make it seem like everything should be working?

I think it works the same as in frontend

```js
const { data: user, error } = await supabase.auth.api.createUser({
  email: 'user@email.com',
  password: 'password'
})
```

Ok, yeah that's what I've got in my server side code too

because you mentioned users are showing in your auth table

```js
const { data: user, error } = await supabase.auth.api.createUser({
  email: 'user@email.com',
  email_confirm: true
})
```

(I'm new to server side with Supabase but I think* this should do it ^)

Ok sounds good - leave out the password field then?

Ok, that set the email_confirmed_at column to the date value

Hey it worked! Awesome! I'm able to sign in now.

Does the email_confirm actually send an email confirmation then? Or is that unrelated to the email confirmation?

I don't think so since in settings, that is off

Ok cool. Thank you so much! I really appreciate your help. I'm pretty new to all this so you've been really helpful!

Excited to see new stuff you're learning/building!