https://supabase.com/ logo
Join Discord
Powered by
# help
  • e

    erik_flywheel

    08/22/2021, 5:56 PM
    You mean create a row with the Supabase UI in supabase, correct?
  • s

    silentworks

    08/22/2021, 5:56 PM
    That or use one of the supabase client libraries (supabase-js, supabase-dart or whichever language you use)
  • e

    erik_flywheel

    08/22/2021, 5:58 PM
    We're only connecting via API. No client library. Just manually created it - no issues...
  • s

    silentworks

    08/22/2021, 6:58 PM
    I think you should use the feedback widget in the dashboard to ask about this or email the Supabase team on beta@supabase.io so they can investigate this.
  • j

    jon.m

    08/22/2021, 9:16 PM
    I'm having trouble querying related data, and I'm not sure where the issue is: either in my query or in my fk configuration. Here's the error:
    Copy code
    "Could not find a relationship between posts and users in the schema cache
  • j

    jon.m

    08/22/2021, 9:17 PM
    And here is my query
    Copy code
    .from("posts")
          .select(
            `id,
            title,
            userEmail: users (
              email
            )
            `
          )
  • j

    jon.m

    08/22/2021, 9:30 PM
    This also does not work
    Copy code
    user_id,
            users (
              email
            )
  • d

    Di

    08/22/2021, 9:32 PM
    Can you share your foreign key configuration? From your error message it sounds like that's the issue.
  • j

    jon.m

    08/22/2021, 9:33 PM
    Where could I locate that data?
  • j

    jon.m

    08/22/2021, 9:34 PM
    I created the relation via sql query, when I view the post user_id column in the GUI it says "This column has a relation to table users on column id"
  • c

    CAMOU

    08/22/2021, 11:10 PM
    hi for some reason this is throwing "TypeError: Cannot read property 'user' of null" for me, does anybody know why?
    Copy code
    js
    import supabase from '$lib/db'
    
    export async function post(request) {
        let email = request.body.get('email')
        let password = request.body.get('password')
        let c_password = request.body.get('c_password')
    
        if (password !== c_password) {
            return {
                status: 401,
                body: 'Passwords are not matching'
            }
        }
    
        const { session, error } = await supabase.auth.signUp({email, password})
    
        if (error) {
            return {
                status: error.status,
                body: error.message
            }
        }
    
        return {
            status: 200,
            body: 'success',
            headers: {
                'set-cookie': `session=${session.user.id}; Path=/; HttpOnly; Secure; SameSite=Strict; Expires=${new Date(session.expires_at * 1000).toUTCString()};`
            }
        }
    }
  • j

    jon.m

    08/22/2021, 11:13 PM
    Is the user created by that in your table?
  • c

    CAMOU

    08/22/2021, 11:14 PM
    yep
  • c

    CAMOU

    08/22/2021, 11:14 PM
    its created but I get that error and no verification mail
  • j

    jon.m

    08/22/2021, 11:18 PM
    Is there a setting in the dash you need to toggle configure
  • c

    CAMOU

    08/22/2021, 11:19 PM
    uh wdym?
  • j

    jon.m

    08/22/2021, 11:31 PM
    I’m wondering if you need to configure something in the supabase dash to enable
  • c

    CAMOU

    08/22/2021, 11:32 PM
    uh dont think so i enabled this
  • s

    silentworks

    08/23/2021, 12:03 AM
    I think we spoke about this before and I asked that you contact the Supabase team about the issue or is this a different issue?
  • c

    CAMOU

    08/23/2021, 12:03 AM
    im not sure if its the same I found this new error now
  • s

    silentworks

    08/23/2021, 12:04 AM
    In that case create a thread to keep all replies in one place and easy to follow.
  • p

    Peanut

    08/23/2021, 1:31 AM
    Hi. Why do I not get a HTTP response from a HTTP request made via Supabase Function Hooks? My HTTP request row inside `net.http_request_queue`:
    Copy code
    [rowid]    "POST"    "http://[myip]:5000/myendpoint"    "{""x-api-key"": ""abc"", ""content-type"": ""application/json""}"    "binary data"    1000    "2021-08-23 01:14:00.261631+00"
    When I select all data from
    net._http_response
    the table is empty Btw made sure the IP works/ports are open (but that shouldn't matter - should still see a response in that table right?
  • j

    jon.m

    08/23/2021, 1:50 AM
    I submitted an issue regarding the error I was receiving when trying to join related data in my client query. For the interested: https://github.com/supabase/supabase/issues/2932
  • h

    HorseShoe

    08/23/2021, 5:43 AM
    It's okay for the supabase clientbe exposed to the client side right?
  • h

    HorseShoe

    08/23/2021, 5:43 AM
    I have seen examples where the supabase Auth is used directly in the svelte page
  • h

    HorseShoe

    08/23/2021, 5:44 AM
    But the client also has .from which has access to SQL?
  • h

    HorseShoe

    08/23/2021, 5:44 AM
    But then the client is initialized with url and public anon key
  • h

    HorseShoe

    08/23/2021, 5:44 AM
    Idk how this works
  • h

    HorseShoe

    08/23/2021, 5:45 AM
    Am I supposed to create two different clients one for my api which has full access to SQL and how do I that?
  • h

    HorseShoe

    08/23/2021, 5:45 AM
    And other for client side
1...596061...316Latest