I get a 1062 error when setting up auto posting to facebook
By Mark on Monday, 31 August 2015
Posted in Technical Issues
Replies 7
Likes 0
Views 774
Votes 0
I get a 1062 error when setting up auto posting to a facebook page. I have created the app in facebook. Please help!
Mark

An error has occurred.
1062 Duplicate entry '19' for key 'PRIMARY' SQL=INSERT INTO `imphoto_easyblog_oauth` (`id`,`user_id`,`type`,`auto`,`request_token`,`access_token`,`message`,`created`,`private`,`params`,`system`) VALUES ('19','365','facebook','0','{\"token\":\"facebook\",\"secret\":\"facebook\"}','','','2015-08-30 06:37:36','0','','1')
Oh, it seems like your hosting enabled the mod_security from your server, and recently our user shared with us how to solve this, perhaps you can take a look of this thread then consult with your webhosting provider regarding this issue?

http://stackideas.com/forums/auto-post-facebook-the-connection-was-reset-while-sign-in-with-facebook-account-first-and-grant-the-application-access#reply-219974

Keep us updated then.
Arlex Wong
·
Monday, 31 August 2015 13:21
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark ,

I am really sorry for the delay of this reply as it is a public holiday for us here.

It seems like you provided that user account do not assign to Superadmin privileges so I can't access any settings page from backend, perhaps you can try follow my instruction and see how it goes? (when I tried to access in your Facebook account, I hitting that "Please Confirm Your Identity")

#1. Go to your database > find this table `imphoto_easyblog_oauth` > remove id `19`
#2. Then go to your backend > Easyblog > Facebook autopost configuration page > Click sign in via Facebook
Then try publish a post again see how it goes?

If the issue still persists, can you provide us with your Facebook identity code and assign that Joomla user account to have Superadmin privileges.
Arlex Wong
·
Monday, 31 August 2015 12:30
·
0 Likes
·
0 Votes
·
0 Comments
·
OK, I did step 1 and 2. Joomla user upgraded to superadmin. See below for FB ID. Now I have this message:

Not Acceptable!
An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.

Please dont send FB 3rd party access text until later in the day. The client is in Detroit, and those texts woke her up, lol.
Mark
Mark
·
Monday, 31 August 2015 13:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Will do, thanks...
Mark
·
Monday, 31 August 2015 13:40
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Mark. Keep us updated and see how it goes.
Ezrul Fazwan
·
Tuesday, 01 September 2015 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hostgator adjusted my mod_security for me, which I got from your link. Thanks!
Mark
Mark
·
Thursday, 03 September 2015 12:44
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome, glad to heard your issue resolved.
Arlex Wong
·
Thursday, 03 September 2015 13:20
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post