Topic-icon Error on Google login

Active Subscriptions:

None
12 years 4 months ago #40887 by certified
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 ''%google' at line 3 SQL=SELECT COUNT(*) count FROM `MADE_jfbconnect_user_map` um WHERE um.provider LIKE '%google
The topic has been locked.
Support Specialist
12 years 4 months ago #40899 by alzander
Replied by alzander on topic Error on Google login
Sorry for the issue you're running into. It's a silly SQL mistake we made in the current release, but will be fixed in the next major revision (due out in about 2 weeks). Logging out of Joomla and back in should work as long as you go to JFBConnect -> Usermap. If you click on the social network icons in the overview page, that will cause the issue because the filtering by network provide feature is currently broken. There's no 'functional' problems with this, and user accounts should be created as expected.

If you'd like to fix the issue 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));
I hope that helps, but if you need anything else, just let me know.

Thanks,
Alex
The topic has been locked.