Topic-icon error 1064 on administrator/index.php?option=com_jfbconnect&view=userm

Active Subscriptions:

None
error 1064

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 ''%facebook' at line 3 SQL=SELECT COUNT(*) count FROM `x4k9d_jfbconnect_user_map` um WHERE um.provider LIKE '%facebook

:(
The topic has been locked.
Support Specialist
Sorry for the issue. There's currently a SQL bug in the latest release. It will be fixed in the next release, due out in about two weeks. To work around it, for now, don't use the filtering options in the Usermap area. Once the error occurs, you'll need to logout of the admin area and log back in to clear your session data. Then, go directly to the Usermap area. Don't use the dropdown filter and don't use the social network icons on the main JFBConnect admin page (which preset the filters).

If you'd rather fix the code right now, please edit the /administrator/components/com_jfbconnect/models/usermap.php file. Around line 176, you'll see:
if ($filter_network != -1) 
                $query->where("um.provider LIKE '%" . $filter_network);
Update that to:
if ($filter_network != -1) 
                $query->where("um.provider = " . $this->_db->q($filter_network));
Sorry for the trouble. It's a silly bug, but not not large enough to warrant a full release right now since another is right on the horizon. There's no 'functional' issues that this problem will cause other than not being able to see the usermap area.

I hope that helps,
Alex
The topic has been locked.
Active Subscriptions:

None
Yes, it is fixed but I cannot find any user there.

I have removed the user created by JFBConnect in the existing Joomla user manager, however it seems that it is not removed completed. Every time I go to the site, it said I am log in, "You are now being log in using your facebook credential", then it redirects me to this page.

File Attachment:
The topic has been locked.
Active Subscriptions:

None
The database table
jfb_notification,jfb_request, jfb_user_man are all empty
The topic has been locked.
Support Specialist
That's because you've already approved the Facebook application. Once you login using your Facebook credentials, when you return to the site, Facebook tells JFBConnect that a user is returning that's already logged into your site. Facebook doesn't know that the user was deleted from your site at some point.

So, when Facebook tells us a user is logged in, we go through the standard login process. If we can't find a user mapping for that user, we bring them to the register page to create one.

The behavior you see is correct, it's just unusual in that you've deleted the user. Register again and the user will show up in the user_map table as expected and you should be able to login with Facebook going forward.

I hope that helps,
Alex
The topic has been locked.