Topic-icon SQL 1064 error FROM `jbq3p_jfbconnect_user_map

Active Subscriptions:

None
Hello!

I use Joomla 3.2.1 and the latest JFBC 5.2.2 installation. If I try to enter the usermap at the JFBC backend dashboard, I get the following error message:

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 `jbq3p_jfbconnect_user_map` um WHERE um.provider LIKE '%facebook

I send Alex login details and mysql access at the next step.

Thank you in forward

Regards
Manuel
The topic has been locked.
Support Specialist
10 years 4 months ago #40362 by alzander
Manuel,
You're running into a minor bug in our latest release. To fix, you would need to follow the directions in this post .

The issue only occurs when you're trying to filter the usermap area by a specific social network. That happens if you use the drop-down or click one of the icons on the main overview page. Once the error happens, you need to logout and back in again to 'reset' the view.. and then don't filter that way.

It's a small issue (in the scheme of things), but are likely going to put together a small bug-fix release later this week or early next with this and a few other minor things. That will hold everything over until the next major release, due in February.

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

None
10 years 4 months ago #40380 by TheAgency
Hello Alex,

you are right that was the issue and I solved it with the other post.

Thank you!
The topic has been locked.
Support Specialist
10 years 4 months ago #40396 by alzander
Sorry about that. We're working on the next major release, but are planning a minor patch for this and some other minor things over the next week.

Thanks,
Alex
The topic has been locked.