Hardyman,
Uggh.. I hate to say it, but you're running into 2 bugs in our current release. Both are pretty easy to fix and/or ignore, but I'll explain it all here:
SQL error - This is a silly bug with our filtering of providers in the Usermap area. If you logout of the admin area and back in again.. you should be able to go to the JFBConnect -> Usermap area without issue. It's only if you click the social network icons on the JFBConnect overview page or use the filter drop-down that that error will show. To fix now, there's a simple code change you can
see here
.
JomSocial users
First, if you haven't already, I'd recommend reading our
JomSocial / JFBConnect integration guide
.
Next, I'd make sure the "Automatically link users by email" setting is enabled in the JFBConnect configuration area. This will automatically make a connection between a user's Facebook and Joomla account if the Joomla account already exists on your site with the same email address as that user's Facebook account. This may be the case for your existing JomSocial users, so that when they login with Facebook (or Twitter, Google, LinkedIn), they're Joomla account will automatically be logged into with the same email address.
Finally, when you enable the Social Profiles - JomSocial plugin, there is a method to import any existing Facebook <-> JomSocial connections into JFBConnect. In Joomla 3.x though, there's a bug where the button to import those connections isn't properly shown. To find the hidden button, please:
* Go to the Usermap area of JFBConnect
* Hover your mouse over the space between the "Send Request" and "Delete" buttons. Your mouse cursor should change.
* Click there, and you'll see a popup warning you that you are about to import connections.
* Click Yes there and it should start importing them for you.
Both of the bugs for the Usermap area and connection importing will be fixed in the upcoming JFBConnect v6.0, due out in about a week.
I hope that helps, but should you need anything else, just let me know.
Thanks,
Alex