Can't add forum in Discourse IOS/Android apps to not admin

[cimpleodev (Andrew)]

Hi!
We have drupal site that in bound with discourse forum (sso). Trying to subscribe to our forum from Discourse IOS app (and android too) - add forum in app, proceed to authorize api page, and It can be posible only if we on admin account. New account, moderator account, user with generated API key by admin - just a blank page after login and push Authorize button. Admin account - Discourse app works and authorize normally on IOS and Android.

After a few tests we found this error in logs:
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_user_api_keys_on_client_id" DETAIL: Key (client_id)=(7d5ed11e90a03cc28c91b96b3f231129

Min trust level for user api - 0,
Allow user api keys - checked.

Can you plese help with this? Maybe we need to config some user access?

[ffhaddad (Freddie Haddad)]

I’m having a similar problem:

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_user_api_keys_on_client_id" DETAIL: Key

Started after I restored a backup of my Discourse site on a new server.

[sam (Sam Saffron)]

Simplest workaround is uninstalling and installing the app

[sam (Sam Saffron)]

I am pretty sure I fixed the root cause of the issue a few weeks ago