'Error in $: not enough input' on .update()

[rphly]

Bug report

To Reproduce

res = db.table(table_name).update({"notes": notes}).eq("id", user_id).execute()

Expected behavior

Update and return me the row.

Actual behaviour

{'data': {'message': 'Error in $: not enough input'}, 'status_code': 400}

System information

• Version of supabase-py: 0.0.2

[rphly]

Temporary workaround is to use .insert() with upsert=True

[fedden]

Yes noticing this too. Is upsert actually working or is it simply inserting a new row? From what I've noticed it's inserting new rows so would be helpful to get confirmation thats what you are seeing. Perhaps request headers/jwt is misconfigured somehow..

[rphly]

@fedden it updates the row when I use insert with upsert=true.

To be clear, I don't think partial updates work.
What I'm doing is editing parts of the row and then executing db.table("notes").insert(data, upsert=True)

Think PUT not PATCH

[remybroun]

It would be nice to have this documented somewhere. Without this issue there is no way to know how to update a row.

[J0]

Hey @remybroun @rphly,

We have tested this issue and it seems to work fine now. We are closing this for now but please feel free to let us know if you're still facing any issues.

Thanks!

[krishnerkar]

Hey @remybroun @rphly,

We have tested this issue and it seems to work fine now. We are closing this for now but please feel free to let us know if you're still facing any issues.

Thanks!

I am still facing the same issue :(

res = supabase.table("Servers").update({"Server_ID" : "test-id, "Server_Name" : "test-server,"Channel_ID" : "test-channel", }).execute()

[dreinon]

Make sure to update your supabase version to the latest and tell us if you still face the issue please 😊
@Krish-Nerkar

[mohnish7]

Hello @dreinon - I am running into the same issue again despite having the latest supabase version.

I am trying to update a single column using id as the matching value. My id is stored in uuid format and is generated using uuid_generate_v4()

supabase_client.table("table").update({"field": "True"}).eq("id", str(local_data.iloc[x]['id'])).execute()

[smandava98]

I recently faced this issue. If anyone comes across this again this was how I solved it:
I was using supabase-py instead of supabase. Also I updated supabase to latest version (1.0.3 as of this date) and my python version was 3.10.10.

[Bobbyjsx]

@smandava98 how were you able to use supabase in a python project without using supabase-py ??

[alananisimov]

@smandava98 how were you able to use supabase in a python project without using supabase-py ??

You can try pip install supabase and you will have no errors))))

[AkashC-goML]

if you are using supabase_py or supabase-py instead use supabase alone to create client

it is working for me any more issues add a comment