Direct messages no longer work

[onlybro]

@girish

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.

Line

https://github.com/pixelfed/pixelfed/blob/4ad3de3b885b8d21a53ca9cc8a4a83e2a1d4a459/app/Http/Controllers/AccountController.php#L129-L132

in the account controller, the following SQL query is generated:

[2021-05-10 21:41:58] local.DEBUG: array (
0 =>
array (
'query' => 'select * from profiles where id != ? and profiles.id = ? and profiles.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.
“

[onlybro]

@girish

Direct messages does work to me when I login to pixelfed.social site without any issues.

[onlybro]

@girish

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 * from profiles where id != ? and profiles.id = ? and profiles.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
“

[onlybro]

@girish

Following is the GitHub link

https://github.com/pixelfed/pixelfed/issues/2729#issuecomment-837986008

[girish]

@onlybro let's continue there. I have replied on GitHub.

[onlybro]

@girish

Could you please update the pixelfed app to latest Daniel has updated to version 0.11.0 when I check for updates on dashboard it doesn’t do anything it still shows 0.10.0 as the latest

https://github.com/pixelfed/pixelfed

[onlybro]

@girish

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

[onlybro]

as per the developer this seems to be a issue with configuration

https://pasteboard.co/Kj1NAaR.jpg

@girish @nebulon

Please assist with this it has been months and months now haven’t beeen able to get messaging working on pixelfed yet

[girish]

@onlybro Is the situation any better with the 1.6.1 package?

[owlgeek]

Hi, I've the same problem with a docker installation of Pixelfed v0.11.1.
Someone have news?

[archos]

Hi, I have the same problem, private messages won't open. Attached is a screenshot.

[A Former User]

This happens on my instance as well