Skip to Content Skip to Menu

[SOLVED] CB connect not working properly

6 years 9 months ago - 6 years 9 months ago #300645 by asierraserna
[SOLVED] CB connect not working properly was created by asierraserna
Hello,

Today I wanted to test the connect login via FB and Google buttons, and even though it works fine for users that were created some months ago, for new registered users it is not working fine.

For the new users in front end and in backend, when I want to see the user profile I receive the following error:

The user can login, but the error shows up when trying to see the user profile.
Code:
An error has occurred. 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

I tried setting the user fields as not mandatory, but the problem is still on.

Is there a minimum mapping that shoul dbe done in the new version of connect?
Last edit: 6 years 9 months ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

6 years 9 months ago #300646 by asierraserna
Replied by asierraserna on topic CB connect not working properly
To clarify, the error does not show up if the new user is created via the normal register form of CB

Please Log in or Create an account to join the conversation.

6 years 9 months ago #300647 by asierraserna
Replied by asierraserna on topic CB connect not working properly
Hello!

Solved my own issue, is my field CB_CATEGORY that is making a mess. I think is because I use it in a SQL field. I need to check.

Anyway, thanks!

Please Log in or Create an account to join the conversation.

6 years 9 months ago - 6 years 9 months ago #300648 by asierraserna
Replied by asierraserna on topic CB connect not working properly
If for some reason you guys are using a CB field as part of a SQL query field, make sure the CB field is not empty to avoid my same error. here is how I did it:
Code:
SELECT country.name FROM #_groupjive_categories as country, #_cities as city WHERE city.parent = country.id AND city.id = (if ('[cb_category]' <> '', '[cb_category]', '34'))

In case this can help anyone!

Alejandro
Last edit: 6 years 9 months ago by asierraserna.
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum