fugu
04/19/2022, 10:37 PMupdate()
call to work; I make this call:
js
const { profileData, error } = supabase
.from('profiles')
.update({ 'username': emailUsername(user.email) })
.eq('id', user.id)
And I get a 404 response:
json
{
error: [],
data: null,
count: null,
status: 404,
statusText: 'Not Found',
body: null
}
Even though user.id
in my request exactly matches an id in a row in my profiles table.kvnam
04/19/2022, 11:44 PMpg_net background worker
error when trying to update / create rows in some tables. Any ideas on how I can fix this? Or what could be causing this? Should I just restart the server?
Also I checked no changes were made to internal tables or foreign keys added.
message: \"the pg_net background worker must be up when doing requests\",
detail: Some(\"the pg_net background worker is down due to an internal error and cannot process requests\"),
hint: Some(\"make sure that you didn't modify any of pg_net internal tables or used them for foreign key references\"),
position: None,
where_: Some(\"PL/pgSQL function _check_worker_is_up() line 4 at RAISE\\nSQL statement \\\"insert into net.http_request_queue(method, url, headers, body, timeout_milliseconds)\\n values (\\n 'POST',\\n net._encode_url_with_params_array(url, params_array),\\n headers,\\n convert_to(body::text, 'UTF8'),\\n timeout_milliseconds\\n )\\n returning id\\\"\\nPL/pgSQL function http_post(text,jsonb,jsonb,jsonb,integer) line 42 at SQL statement\\nSQL statement \\\"SELECT http_post FROM net.http_post(\\n url,\\n payload,\\n params,\\n headers,\\n timeout_ms\\n )\\\"\\nPL/pgSQL function http_request() line 54 at SQL statement\"), schema: None,
table: None,
column: None,
datatype: None,
constraint: None,
file: Some(\"pl_exec.c\"),
line: Some(3859),
routine: Some(\"exec_stmt_raise\")
TUFFLES
04/20/2022, 12:09 AMpy
from realtime.connection import Socket
def callback1(payload):
print("Callback 1: ", payload)
def callback2(payload):
print("Callback 2: ", payload)
if __name__ == "__main__":
URL = "ws://localhost:4000/socket/websocket"
s = Socket(URL)
s.connect()
channel_1 = s.set_channel("realtime:public:todos")
channel_1.join().on("UPDATE", callback1)
channel_2 = s.set_channel("realtime:public:users")
channel_2.join().on("*", callback2)
s.listen()
Result:
websockets.exceptions.InvalidStatusCode: server rejected WebSocket connection: HTTP 403
Server:
2022-04-20 00:02:59.397 [info] REFUSED CONNECTION TO RealtimeWeb.UserSocket in 32µs
Transport: :websocket
Serializer: Phoenix.Socket.V1.JSONSerializer
Parameters: %{}
What am I doing wrong here?Aravindha Hariharan
04/20/2022, 5:04 AMstandard_init_linux.go:228: exec user process caused: exec format error
standard_init_linux.go:228: exec user process caused: exec format error
standard_init_linux.go:228: exec user process caused: exec format error
Kariak
04/20/2022, 5:25 AMHausik
04/20/2022, 9:20 AMHausik
04/20/2022, 9:20 AMgeordi
04/20/2022, 12:25 PMjrstnly
04/20/2022, 12:31 PM4a6d65
04/20/2022, 1:49 PMmike-lua
04/20/2022, 2:26 PMSTILLWATER;
04/20/2022, 2:46 PMSTILLWATER;
04/20/2022, 3:18 PMNeedle
04/20/2022, 3:18 PM/title
command!
We have solved your problem?
Click the button below to archive it.Lars
04/20/2022, 4:01 PMNeedle
04/20/2022, 4:39 PM/title
command!
We have solved your problem?
Click the button below to archive it.chops
04/20/2022, 6:12 PMerror: TS2339 [ERROR]: Property 'ref' does not exist on type 'Listener'.
and it wont start upLars
04/20/2022, 6:57 PMrookiedeveloper
04/20/2022, 8:16 PMVΞLO
04/20/2022, 9:17 PMconst { count } = await supabase.from('some_table').select('*', {count: 'exact', head: true})
gel
04/20/2022, 9:34 PMNeedle
04/20/2022, 9:34 PM/title
command!
We have solved your problem?
Click the button below to archive it.takumikunn15
04/21/2022, 5:21 AMmeera_datey
04/21/2022, 6:10 AMgun
04/21/2022, 6:52 AMjhrtn
04/21/2022, 9:28 AMNARCISO
04/21/2022, 1:00 PMRPC parameters
(calling RPC from the supabase-js
client) are sorted by name (alphabetically) before calling the database function?
Is this a feature or something that can be disabled? or am I forced to sort my RPC's params in that way?Dexter
04/21/2022, 1:27 PMNeedle
04/21/2022, 3:58 PM/title
command!
We have solved your problem?
Click the button below to archive it.venus
04/21/2022, 3:58 PMalbums
) has. Is this possible to do in one query? So basically I want to get known how many images
each albums
record has
js
const { data } = await supabaseClient
.from("albums")
.select(
`
name,
created_at,
images (*)
`)
.limit(3, { foreignTable: "images" });