Direct messages no longer work
-
Reporting from GitHub
“
I was able to reproduce the direct message issue within a docker container, and I think I know why it is happening.
In these lines in the account controller, the following SQL query is generated:
[2021-05-10 21:41:58] local.DEBUG: array (
0 =>
array (
'query' => 'select * fromprofiles
whereid
!= ? andprofiles
.id
= ? andprofiles
.deleted_at
is null limit 1',
'bindings' =>
array (
0 => 297440899045134336,
1 => '297465207490482176',
),
'time' => 37.91,
),
)
As you can see, the id in the URL gets treated as string and that's why the query does not return any results.
I made a preliminary patch on this branch with int casts wherever necessary and it resolves the issue locally, but there must be some sort of underlying issue that needs to be investigated to tell why this stopped working
“ -
-
Please take a look
https://github.com/pixelfed/pixelfed/issues/2752#
And the following
https://github.com/pixelfed/pixelfed/commit/2d0a253e071280c692b14516a6aac8d6c33c44d5
Daniel informed that he is using MySQL however the issue of sending messsges yet persists it’s still there not able to send messages yet
-
This happens on my instance as well