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

Supabase

Hello <@266534875333525504>!
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.

Thanks for the details <@!393787307637080064> . Let wait for <@!296507565309952001> reply then

<@!761480500916256768> thanks for the ping! <@!393787307637080064> i replied on the issue itself. See my comment here: https://github.com/supabase/realtime/issues/167#issuecomment-898052550

You changed the call to
```javascript
supabase.from('game_directory').select(`*, users_games(*)`).eq('id', user.id);
```
right?

also, it only seems to work after a save, not a refresh

not to butt in here 😬 but shouldn't it be `supabase.from('game_directories')...`?

so its a directory of games, hence, game_directory :)

also heres my stuff just to get an overall view

```js
const fetchGames = async () => {
    if (!user) return;

    let { data, error } = await supabase.from('game_directory').select(`*, users_games(*)`).eq('id', user.id);

    if (error) return error;
    if (data) return data;
    };

    useEffect(() => {
        fetchGames()
            .then((res) => {
                console.log(res);
            })
            .catch((error) => {
                console.log(error);
            });
    }, []);
```

this returns undefined on refresh, but if i edit the file, save, then look at console without refreshing the page, it'll return

seems like its outrunning itself some how?

did i see you say that you're using NextJS?

if you `console.log(error)`, does that return anything?

https://cdn.discordapp.com/attachments/843999948717555735/869627128017195098/unknown.png

oh haha. reason i ask, is because i'll usually see those errors when types are mismatched for the mutation inputs

so the name of the table you're trying to query from inside of Supabase  is called `game_directory`?