Log in | Register
  1. Forum
  3. Discontinued Products
  5. JFBConnect v8.x Support (Joomla 3 Only) (CLOSED)
  7. Error: 1064 - You have an error in your SQL syntax

Topic-icon Error: 1064 - You have an error in your SQL syntax

Active Subscriptions:

None
8 years 8 months ago - 8 years 8 months ago #54441 by none
I found similar issues here reported by other members but mysteriously all of these issues got resolved by itself and no-one has ever explained how.
So here is the issue.

JFBconnect 6.4.1
Joomla 3.4.3 (this error message appeared on J3.3.6 as well before upgrading to J3.4)
SClogin 4.4.1
My database type: MySQLi

I try to logon the site by social login (the error comes up weather I use Facebook or other social login) and when Im about to logon I get a blank page with the error:
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 SQL=SELECT title FROM j25_usergroups WHERE


File Attachment:


If I use SClogin to logon as a normal registered user then it works without problem. This error only appears when I try to logon by social login.



Thanks
Last edit: 8 years 8 months ago by none.
The topic has been locked.
Support Specialist
8 years 8 months ago #54448 by alzander
I did a search but couldn't find any threads in our forums with similar SQL errors. There are posts with other SQL problems, but not this one.. which means its something new to us.

That specific query does not look to be coming from JFBConnect directly. We don't query the usergroups table directly. My guess is that some other extension is having issues when a user is authenticating with a social network. You'll need to start narrowing down where the issue lies by disabling some features/extensions on your site to determine what other extension is conflicting. To do that, I'd recommend disabling any Authentication, User or System plugins that are distributed with Joomla and that may deal with user authentication or user permissions.

I hope that helps narrow some things down. Once you find the conflicting plugin, please let us know and we should be able to help diagnose the actual cause.

Thanks,
Alex
The topic has been locked.
Active Subscriptions:

None
8 years 8 months ago #54450 by none
I spent some time on finding the source of this issue. It seems to me that one of our custom module causes this problem. I just don't quite understand how.
I had no problem with this module so far until I upgraded JFBconnect. Since it has been upgraded this custom module throws this error.
I will certainly look into it and find out why I get this error.

Thanks
The topic has been locked.
Support Specialist
8 years 8 months ago #54453 by mel
It's good that you've narrowed it down. Let us know if you find anything that points to JFBConnect being the culprit.

-Melissa
The topic has been locked.
  1. Forum
  3. Discontinued Products
  5. JFBConnect v8.x Support (Joomla 3 Only) (CLOSED)
  7. Error: 1064 - You have an error in your SQL syntax
From the Blog
Facebook | Twitter | LinkedIn | Blog RSS