Easyblog Autopost 1062 Error LinkedIn
By David on Wednesday, 27 April 2016
Posted in Technical Issues
Replies 6
Likes 0
Views 641
Votes 0
Hello, I am having trouble setting up easyblog with linkedin.

Setup linkedin app as described on http://stackideas.com/docs/easyblog/administrators/autoposting/setting-up-linkedin-autoposting.

Duplicate entry '11' for key 'PRIMARY' SQL=INSERT INTO `#__easyblog_oauth` (`id`,`user_id`,`type`,`auto`,`request_token`,`access_token`,`message`,`created`,`private`,`params`,`system`) VALUES ('11','218','linkedin','0','{\"token\":\"78--e0eea547-c24a-4967-81fb-9092cac7df58\",\"secret\":\"b0d03db6-d858-4c8a-9762-23d498e8d124\"}','','','2016-04-26 17:05:28','0','','1')


I'm not sure what to do as I have entered the correct api and secret keys (triple checked). Pressed save before trying to login to linkedin however it does not work.

I found this thread http://stackideas.com/forums/save-failed-with-the-following-error-duplicate-entry-0-for-key-primary however I am unable to look at the answers as it says I have to renew my subscription which is incorrect as on the dashboard it says active and that it expires in 2oth August 2016.

Can you please advise on how to solve this.

Many thanks
Hi there,

I am sorry for the make you confuse, the # have to be changed to your Database Tables Prefix as you run the sql query , and yes you can simply the delete the relevant table/s on your phpmyadmin
Muhammad Fadhli
·
Thursday, 28 April 2016 10:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi David

I am sorry for the inconvenience caused.It seems like probably you are hitting this because the initial authorization of LinkedIn didn't complete for some reasons.

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

DELETE FROM #_easyblog_oauth WHERE `type`='linkedIn';

Then, try re-authenticating again.

Or would you mind to give us your Joomla back end and LinkedIn login credential, so we can try help this out;)? You can simply add the information needed by editing site detail on your first post or you can just include your site's access once at http://stackideas.com/dashboard/site rather than needing to keep adding them in your replies
Muhammad Fadhli
·
Wednesday, 27 April 2016 11:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Right sorry I'm not familiar with sql to execute commands like that. But tried running the following:

 DELETE FROM #_easyblog_oauth WHERE `type`='linkedIn';


Which outputs an error:

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


Was that the correct code?

Can I go into the database instead and delete the relevant table/s? I'm more comfortable with phpmyadmin.

many thanks
David
·
Wednesday, 27 April 2016 20:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Also the username appears to be David. We have a developers licence of easyblog with the above date of 20th August expiry.
David
·
Wednesday, 27 April 2016 21:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, I did woner if I was taking something within the statement literally. Done that.

Issue solved. Thanks.

Would like to be able to read forum support as we did purchases a dev licence which has not expired though.
David
·
Saturday, 30 April 2016 22:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating, and glad that your issues are resolved now As long your subscription is valid, you will be able to read the forums under EasyBlog's category
Mark
·
Saturday, 30 April 2016 22:51
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post