Skip to Content Skip to Menu

🌟 CB Editor Assistant 1.0.0 is here! Discover our new AI Joomla Plugin that wrote its story! (and this banner!)
Start at just $12.50/month* or 💸 save 30% with our 🛍️ Black Friday Intro Offer for your subscription's lifetime
Grab It Now!
🎉 Black Friday sale is here! Great savings on professional and developer memberships! Get 25% off now with code BLACK-FRIDAY-2024!

[SOLVED] CB connect not working properly

6 years 10 months ago - 6 years 10 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 10 months ago by krileon. Reason: Added [SOLVED] tag to subject

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

6 years 10 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 10 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 10 months ago - 6 years 10 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 10 months ago by asierraserna.
The following user(s) said Thank You: krileon

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

Moderators: beat, nant, krileon
Powered by Kunena Forum