but why is status shown as operational

Just updated

where link?

Status pages usually don't update in real time, sometimes they might be 30min to 1hr behind

Dashboard seems to be working now, at least for me

fixed now

yea works

gg @User and @User

hey everyone sorry about this, bad deploy - reverted it now.

no luck for me. is it my database breaking something? 😄

apologies everyone - should have only been the Dashboard, not the database

is anyone still having issues? If so, can you please confirm here: https://app.supabase.io/support/new so that we get your project IDs? If you can't reach that page just let us know your project id

@User - looking for your support ticket. seems to be unrelated to the Dashboard issue

sorry that it's recorded with phone but here its how it is

ah that's super helpful - thanks! Looks like a legit bug. Do you already have a github issue for this one?

no since i am using cloud supabase, i only sent support ticket and didn't do anything with it yet

i mean, not self hosted

OK cool - would you mind starting a github issue too? More people looking at it means faster fixes 🙂 They Dashboard is open source, so anyone can help fix this

(while we also investigate on the support ticket)

but speaking of this, i have a query in my app:

Javascript
const { data: logs, count } = await this.$sb
        .from("logs")
        .select("*, added_by(discord)", { count: "exact" })
        .range(startIndex, endIndex)
        .order("created_at", { ascending: false });

and this fetches just fine, but when i add

.eq('user_id', id)

i get 0 results

I'll help you create the github issue for the first one - I don't want it to get lost in the threads. The second issue could be an RLS issue

hm, for this project i didnt set up rls at all and use super key so i thought there wont be issues

created an issue here @User : https://github.com/supabase/supabase/issues/4531

> didnt set up rls definitely not RLS then ! It won't be an error though, just that the combination of filters you're passing legitimately don't match any data. It's very hard to give an exact resolution because it depends on your data. Perhaps trim back the filters and play around with combos until you find a the right methods?

javascript
.from("logs")
        .select("*, added_by(discord)")
        .range(startIndex, endIndex)
        .order("created_at", { ascending: false })
        .eq("verified", false);

returns all results with verified==false

javascript
.from("logs")
        .select("*, added_by(discord)")
        .range(startIndex, endIndex)
        .order("created_at", { ascending: false })
        .eq("guild_id", id);

returns empty. guild_id is a foreign key to different db (just like added_by)

tested by adding new column of int8 (and text) and filter for them, and also same empty result

You can use a database schema migration library

Can you create a thread for this and share what your table schemas look like too, It's hard to follow with other conversations going on in-between them all

ahh, i thought threads are only made by staff. anyway i tried for science and removed all underscores from my schemas. suddenly everything works..