Can't connect pixeldroid after 0.11.2 update

[ashemsay]

Can't connect pixeldroid after 0.11.2 update

[lapineige]

Could you check if the API page (part of the URL here : "GET /oauth/authorize?client_id=30&redirect_uri=oauth2redirect://org.pixeldroid.app&response_type=code&scope=read%20write%20follow) is accessible without being logged in Pixelfed/Yunohost ? (in private browsing mode for instance)

[ashemsay]

On PC the link redirects me to a pixelfed login page:

After I log in it tries to find an app to open the link and fails (which is normal I assume)

On my phone after I login I get redirected to the app instance selection screen:

[Wv5twkFEKh54vo4tta9yu7dHa3]

Hi, pixeldroid dev here (yes, I know nice username, I try not to use github).

I had someone come on the project's matrix channel #pixeldroid:gnugen.ch with this exact problem

The application manages to create a token, but then calls the verify_credentials endpoint which returns a 500 error with the following message in it:

{
  "error": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: \"verify_credential\" (SQL: select * from \"profiles\" where \"profiles\".\"id\" = verify_credential and \"profiles\".\"deleted_at\" is null limit 1)"
}

This is likely because you are using Postgres as database, which although officially supported, has quite some issues still for pixelfed. See pixelfed/pixelfed#2335 for example with a similar error message.

[lapineige]

Well thank you for that input 🙂

Ok, so again a Pixelfed-not-supporting-correctly-Postgres-issue :/

Let's hope it will get fixed, one day…

[lapineige]

Next release should fix it : pixelfed/pixelfed#2335