easyblog 1062 Duplicate entry '2' for key 'PRIMARY' SQL=INSERT INTO
By Pieter J.van horssen on Monday, 19 October 2015
Posted in General Issues
Replies 11
Likes 0
Views 2.4K
Votes 0
When I want to sign in to FB in the Autoposting to Facebook page, I get this sql error

"1062 Duplicate entry '2' for key 'PRIMARY' SQL=INSERT INTO `awb33_easyblog_oauth` (`id`,`user_id`,`type`,`auto`,`request_token`,`access_token`,`message`,`created`,`private`,`params`,`system`) VALUES ('2','427','facebook','0','{\"token\":\"facebook\",\"secret\":\"facebook\"}','','','2015-02-12 12:46:09','0','','1') "

I understand the "Duplicate entry" bit but not the why it happens.
Is it because I already did the sign-in to FB at some stage? In that case the code should put a message out like "Already signed in" .
Hey there,

It seems like you didn't set properly on your Facebook app domain, perhaps you can provide us with your Joomla backend and Facebook access so I can take a look of this?
Arlex Wong
·
Tuesday, 27 October 2015 23:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Pieter,

Hm, it seems like probably you are hitting this because the initial authorization of Facebook didn't complete for some reasons (Most likely because of mod_security earlier).

What you could do is to try running the SQL query below to reset the list of authorizations,

delete from awb33_easyblog_oauth where `type`='facebook';

Then, try re-authenticating again.
Mark
·
Monday, 19 October 2015 23:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Same problem here. Running...
- EasyBlog Professional 5.0.29.
- Joomla 3.4.5
- PHP 5.4.43
- MySQLi 5.5.42-37.1-log

Error Message: An error has occurred.
1062 Duplicate entry '2' for key 'PRIMARY' SQL=INSERT INTO `eli6y_easyblog_oauth` (`id`,`user_id`,`type`,`auto`,`request_token`,`access_token`,`message`,`created`,`private`,`params`,`system`) VALUES ('2','763','facebook','0','','','','0000-00-00 00:00:00','0','','1')

Please advise
Seth
·
Tuesday, 27 October 2015 12:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Seth,

I would personally prefer that you start a new thread then provide us with your Joomla backend, FTP and Facebook access so we can help you check on this?

[Edited]
Arlex Wong
·
Tuesday, 27 October 2015 13:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Sorry I have not been to do the SQL solution as suggested by Mark.
Will do this week.
Pieter J.van horssen
·
Tuesday, 27 October 2015 17:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Keep us updated then Pieter.
Arlex Wong
·
Tuesday, 27 October 2015 17:42
·
0 Likes
·
0 Votes
·
0 Comments
·
The sql went ok, but when cliking on the Facebook sign in button, I got this reply:
https://www.facebook.com/v2.0/dialog/oauth?redirect_uri=http%3A%2F%2Fwww.amsterdamwestband.nl%2Fadministrator%2Findex.php%3Foption%3Dcom_easyblog%26task%3Dfacebook.grant%26system%3D1&display=popup&state=aHR0cDovL3d3dy5hbXN0ZXJkYW13ZXN0YmFuZC5ubC9hZG1pbmlzdHJhdG9yL2luZGV4LnBocD9vcHRpb249Y29tX2Vhc3libG9n&scope=publish_actions%2Cmanage_pages%2Cpublish_pages%2Cuser_managed_groups&response_type=code&client_id=156862024429171&ret=roadblock&app_id=156862024429171#_=_

"This url is not allowed by the configuration of the application. TheURL has to agree ith website/canvas url or the domain must be a subdomain of one of the app domains."

Mind you, this a translation from Dutch to English.....
Pieter J.van horssen
·
Tuesday, 27 October 2015 19:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Arlex, the FB app codes did not match
Pieter J.van horssen
·
Wednesday, 28 October 2015 17:23
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome, glad to heard your issue resolved.
Arlex Wong
·
Wednesday, 28 October 2015 17:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi everyone,

I did exactly the same thing, I ran the SQL query and then it showed me this error:

"Blocked URL: The redirect failed because the URI is not included in the white list of the OAuth client settings of the application. Verify that OAuth client access and OAuth web access are enabled, and add all domains in the application as valid OAuth redirect URIs."

Help me, please.
Francisco Javier Hernandez Mendoza
·
Friday, 23 March 2018 00:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Francisco,

You are hitting a different error altogether as Facebook has already updated their API in their recent versions. Could you please start with a new thread and our support team will assist you with your inquiries?
Mark
·
Friday, 23 March 2018 00:37
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post