I have 2 subdomain, one for staffs and another for students but the issue here is that some students are also staff so if they signup using student(subdomain) with same email or phone they can't signup to teachers(subdomain) with that email and phone. I want them to create account on teachers(subdomain) like signup even though they already signed up on students(subdomain). Is there any way?

I'd like to be able to generate coverage information while running my edge functions. This is possible by setting the

--trace-block-coverage

v8 flag to

deno run

. Is there an equivalent process for doing this with the

edge-runtime

command?

hello so basically i don't want that auth page layout so can we remove it? and automatic redirect to auth page of platform?

can anyone help me with this while setting up the local env for open source contribution I am getting thi error on running "npm install"

I'm trying to use a column that I set as int8 and checked "Define as array". When I insert data as a test like the example below, they get converted into strings. Is this normal? 🤔 https://cdn.discordapp.com/attachments/1110628252793446511/1110628253145776150/msedge_xOLjLRRK26.mp4

Hello guys, I'm working on integrating authentication using Supabase Javascript client for a full stack application. I have been receiving errors such as "url argument is missing for auth". I have attempted to change the Site Url multiple times to see if the issue was a trailing slash or whichever. Attached are some images with some background regarding the issue. For context, this is a brand new project with no tables, function, webhooks etc. I'm simply trying to connect a signup form to Supabase Auth database but am receiving url argument is missing error. Any help would be appreciated! Let me know if there is additional information that is required.

Why this discord auth functions not working?

js
import { useRouter } from 'next/router';
import { useState, useEffect } from 'react';
import supabase from '@/components/supabase';

export default function Auth2() {
  const router = useRouter();
  const [session, setSession] = useState('');

    useEffect(async () => {
        const data = await supabase.auth.getSession();
        if (!data) return;
        setSession('GetData');
    }, []);

  supabase.auth.onAuthStateChange(async (event) => {
    if (event === "SIGNED_IN") {
      router.push('/dashboard');
    }
    if (event === 'SIGNED_OUT') {
        router.push("/");
    }
  });

    async function signInWithDiscord() {
        const { data, error } = await supabase.auth.signInWithOAuth({
            provider: 'discord',
            options: {
                scopes: 'identify guilds'
           }
        });
    }
    async function signout() {
        const { error } = await supabase.auth.signOut();
    }
    
    if (session === "GetData") {
        signout();
    } else {
        signInWithDiscord();
    }
}

I created a project on the Pro tier. I had 2 free projects and 1 pro project. I just deleted the pro project with the intention of recreating it, but now its prompting me to pay again, even though I already paid. I didn't realize this would happen. Am I going to be charged twice now within a single week period because I did this?

Hi guys using cloudinary but seems transformation is not working``` const fetchPosts=useCallback(async()=>{ const { data:files } = await supabase .from('category') .select() if(files && files.length>0){ const promises = files.map(async(file)=>{ const { data: { publicUrl } } = supabase.storage .from('files') .getPublicUrl(file.vname); const myImage = new CloudinaryImage(publicUrl, {cloudName: 'cloudname'}) .resize(fill().width(100).height(200)); return {id:file.id, myImage:myImage}; }); const posts = await Promise.all(promises); setDownload(posts); console.log(posts) } ```

hi guys, i can´t work login with google from supabase in ios ionic only works in web , anyone help me?

I'm working on an application where users need to log in with specific roles: Org, Admins, Leads, and Employees. Upon creating a new row in the auth.user table, I receive the following JSON object:

json
{
    "user": {
        "id": "21cd995a-84ae-42f3-a9e8-3cd48074ba84",
        "aud": "authenticated",
        "role": "authenticated",
        "email": "ihopethisworks@gmail.com",
        "phone": "",
        "confirmation_sent_at": "2023-05-23T23:38:06.314959404Z",
        "app_metadata": {
            "provider": "email",
            "providers": [
                "email"
            ]
        },
        "user_metadata": {},
        "identities": [
            {
                "id": "21cd995a-84ae-42f3-a9e8-3cd48074ba84",
                "user_id": "21cd995a-84ae-42f3-a9e8-3cd48074ba84",
                "identity_data": {
                    "email": "ihopethisworks@gmail.com",
                    "sub": "21cd995a-84ae-42f3-a9e8-3cd48074ba84"
                },
                "provider": "email",
                "last_sign_in_at": "2023-05-23T23:38:06.312979098Z",
                "created_at": "2023-05-23T23:38:06.313013Z",
                "updated_at": "2023-05-23T23:38:06.313013Z"
            }
        ],
        "created_at": "2023-05-23T23:38:06.310532Z",
        "updated_at": "2023-05-23T23:38:06.737187Z"
    },
    "session": null
}

I'm wondering if there's a way to access the role key in this JSON object and change it to a specific role such as Admin or Lead. Additionally, I would appreciate recommendations on the best approach to assign roles in this scenario. Should I have each user create their own profile and assign their roles, or is it better to have the organization or designated administrators create and assign roles to users? Since this application is intended as an internal tool, it seems logical for the organization to manage account creation and role assignments. What would be the recommended approach for implementing role-based access control? I'm having trouble finding information on how to achieve this and where to start. Any guidance or clarification would be greatly appreciated!

I successfully created a client, but this doesn't work.

Have anyone connected Bubble database with Supabase? #885237287280070708 #bubble. Are there any #867349237799714856 videos tha

hi there, i'm struggling to access user data with the new app dir / auth helpers (following this guide: https://supabase.com/docs/guides/auth/auth-helpers/nextjs-server-components) is there an equivalent of the

useUser()

function? or any examples you can point me to for how to access user data when signed in? simple use case is just showing an account page with profile info when a user signs in. thank you!

Hey there, Is there a way with the supabase-js libray to match a timestampz column just by the DATE, instead of the exact timestamp?

I'm trying to change users passowrd from password recovery email The email template and redirect to my web site is working well, actually I can get .Toke, .TokenHask and .Email variables in my react app Now, I want to update a new password with this information but I cannot do it. I have seen that I can use supabase.auth.updateUser( accessToken, { password: '123456' }) but this does not work. somebody know how to update the password in a secure way? Thanks in advance 🙂

I am unable to delete a row with (auth.uid() = user_id) policy, and a select policy in place. Update and Insert works I feel like I am over looking something but not exactly sure what it is.

What happened here? How can I setup realtime?

The docs give no explanation as to what does and doesn't trigger an update. Most importantly, it doesn't explain what

primaryKey

does. For example, I have a table with the syntax

id | created_at | user_id | ...

where

id

is the primary key. How do I write a query that returns events for the most recent row for a given

user_id

? The following is what I wrote but I'm not getting any updates after the first event and my best guess is it's because of

primaryKey

but

primaryKey

is almost entirely undocumented so I'm not sure...

dart
return supabase.from('myTable')
        .stream(primaryKey: [idCol])
        .eq(anonIdCol, anonId)
        .order(createdAtCol, ascending: false)
        .limit(1);

I created a supabase-provider.jsx file in the root of my app directory (attached). I also added this provider to my root layout.js (attached). I am following the instruction from this article: https://supabase.com/docs/guides/auth/auth-helpers/nextjs-server-components But NextJS keeps telling me I need the 'use client' directive in supabase-provider.jsx to declare "useContext" hook. Why would it throw this error when its pretty clear that I have added and saved the file with the 'use client' directive to the top of the file.

Hello, basically i am trying to make discord auth login but after login page automatic redirect to home page why?

When I add the correct domain and anon key into the flutterflow interface, and click 'Get Schema' it does nothing. I tried the rest and kong endpoints also. Any tips to overcome this?

await supabase .from('jobs') .select( 'full_title, branch_id, state, created_at, location, updated_at, slug, wage_lower_bound, wage_upper_bound, candidates (*)' ) .eq('org_id', userData.org_id) .neq('candidates.disqualified', true) .in('state', ['published', 'closed']) Is there anyway to limit the number of candidates rows in this nested query (not just the jobs rows)?

hello there, basically i am making a button for redirect login and logout but getting a issues about session data is not rendering for show text here my navbar codes. in my codes the login ButtonName show still after login why?

I see in the dosc that it gets obfuscated on client side, but is there any possible way i can check this?

If Confirm email is enabled in your project, an obfuscated/fake user object is returned.

I'm essentially just trying to do this flow: - let users fill out form without creating account - on fill out of form, prompt to sign up - on sign up success i save the form data to my backend Just trying to make it as simple to onboard folks as I can! https://supabase.com/docs/reference/javascript/auth-signup

I have been trying to migrate some db changes from the public schema from another Supabase project, but since postgres version is different, I cannot use diff/pg_diff right off the bat, the scripts from the dump that alters the privileges for the superbase_admin fails since I am logged in as the user 'postgres'. Is there a way to work around this?

Hi folks, I'm trying to do all my messing around in local dev before finalizing a migration script and pushing it to prod, and so far everything looks good except the command doesn't seem to have picked up on any of the privilege changes I've made. (eg making a column read only via:

REVOKE INSERT, UPDATE ON table FOR authenticated

GRANT INSERT (col1, col2, ... all the columns except created_at) ON table FOR authenticated

) Am I missing a flag?

I am getting the REST error "Invalid Refresh Token: Already used" and after that I am logged out in my app. I think I know why it happens - access token used on both client side and server side, and once it is used for refresh at either, it fails to work at another side. The question is, how it is supposed to work? Both server side and client side need to have user authenticated, but there is no guaranteed communication between them, even if I ping every 10 seconds (which is wrong IMO) because browser can be closed, tab can be unloaded, etc. Related settings: Project Settings => Auth => JWT expiry limit & Reuse interval & Enable automatic reuse detection Relevant posts here: https://discord.com/channels/839993398554656828/1011635657006923828 and https://github.com/supabase/gotrue-js/issues/620

Hi all, I'm trying to join twice on the same table. Example is an accounts table with both a billing address id and a delivery address id, both pointing to the address table. I'm getting the following message: table name "account_address_1" specified more than once. What can i do?

how do I check if the login with discord was authorized successfully? I tried did the code below, but as soon as I click the login button the afterSignIn callback function gets called. I want to check if the user authorization was successful then only I want to execute the afterSignIn

js
export async function signInWithDiscord(afterSignIn) {
  const { data, error } = await supabase.auth.signInWithOAuth({ provider: "discord" })

  if (error) {
    console.error("Authorization failed:", error.message)
    return
  }

  if (data) {
    if (afterSignIn) {
      afterSignIn()
    }
  }
}