Direct messages no longer work
-
Reported here - https://github.com/pixelfed/pixelfed/issues/2752 . @onlybro I will stop debugging since I don't think I can do anything to fix this without having a stable release where DM is known to work. You will have to reach out to the upstream author.
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 * fromprofileswhereid!= ? andprofiles.id= ? andprofiles.deleted_atis 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
“ -
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 * fromprofileswhereid!= ? andprofiles.id= ? andprofiles.deleted_atis 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
“ -
Following is the GitHub link
https://github.com/pixelfed/pixelfed/issues/2729#issuecomment-837986008
-
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
-
as per the developer this seems to be a issue with configuration
https://pasteboard.co/Kj1NAaR.jpg
Please assist with this it has been months and months now haven’t beeen able to get messaging working on pixelfed yet
-
This happens on my instance as well
