Exisiting member unable to login via Facebook

[Gulshan_Kumar (Ultra Noob)]

Hi,

Reportedly, this is an error message.

Oops

The software powering this discussion forum encountered an unexpected problem. We apologize for the inconvenience.

Detailed information about the error was logged, and an automatic notification generated. We’ll take a look at it.

No further action is necessary. However, if the error condition persists, you can provide additional detail, including steps to reproduce the error, by posting a discussion topic in the site’s feedback category.

---

What I am aware?

• I recently changed FB App I’d.
• For me, sign up and login via FB Is working.
• I also used to some SSH command as suggested.

What I want to know?

• What above message indicate?

Thanks in advanced!
Sincerely,
Gulshan

[gdpelican (James Kiesel)]

Try visiting <your-site>/logs to see what the error is, and report back with that info, which will hopefully provide some more info for those that could help you.

[robmc (Robert McIntosh)]

If you changed your ID you may need to remove existing information

@codinghorror

Troubleshooting

If the Facebook app API is updated, or the app ID/secret are change, you’ll need to remove existing FacebookUserInfo from your site before users can log in again. To remove this data, run the following:

You can read the full topic here:

Configuring Facebook login for Discourse

Updating the Facebook app API or creating a new app will break existing logins. See troubleshooting at the bottom of this post for a solution. Configuration Go to developers.facebook.com/apps and … Login with the credentials of the account you want to connect to Discourse and follow the wizard. If you already have other apps instead of Get Started you will see the entry My Apps, then just click on Add new app and follow the guide from step 1b [image] 1a. S…

[Gulshan_Kumar (Ultra Noob)]

I have already run this command just after changing. Do I need to rebuild now?

cd /var/discourse
./launcher enter app
rails c
FacebookUserInfo.delete_all

[Gulshan_Kumar (Ultra Noob)]

Try visiting <your-site>/logs to see what the error is

Yes, there is an error message

ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 5:55 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 5:55 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:44 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:44 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:44 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:44 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:46 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:46 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:49 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:49 pm
(facebook) Authentication failure! invalid_credentials: OAuth2::Error, {"message"=>"This authorization code has been used.", "type"=>"OAuthException", "code"=>100, "fbtrace_id"=>"Elt2/DBijKq"}: {"err 8:49 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:49 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:49 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:50 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:50 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 8:51 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 8:51 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(250) already exists. : INSERT 9:23 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(250) 9:23 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(250) already exists. : INSERT 9:23 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(250) 9:23 pm
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) already exists. : INSERT I 10:14 pm
Failed to handle exception in exception app middleware : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_facebook_user_infos_on_user_id" DETAIL: Key (user_id)=(27) 10:14 pm

Please tell me, what should I do to resolve?

Thanks

[robmc (Robert McIntosh)]

If you can still log in then did it work? Were you required to re-authenticate?

[Gulshan_Kumar (Ultra Noob)]

This problem is happening for old member who uses FB for sign in to forum since day 1.

As a first time user, I am able to signup/login with new FB acc in the incognito.

[Gulshan_Kumar (Ultra Noob)]

Were you required to re-authenticate?

Learned, it ask for re-auth after above message comes.

[Gulshan_Kumar (Ultra Noob)]

I would like to give one more detail that, before it was working fine.
Somehow my FB app got deleted from my account, so I created again and followed official tutorial for the integration.

[pfaffman (Jay Pfaffman)]

Did you do that delete all command above? If so, I’m not sure what to think. You might try it again.

[Gulshan_Kumar (Ultra Noob)]

Thanks, I have tried it again.