Topic-icon Error: 1064 for comprofiler table

Active Subscriptions:

None
11 years 11 months ago #45250 by andbal2
Hi, if an existing user cames back to the facebook application (i mean after the end of the session) shows this error message

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 '= '' WHERE user_id = 719' at line 1 SQL=UPDATE xa90w_comprofiler SET = '' WHERE user_id = 719;

i use community builder plugin and as you can see the error is about comprofiler table

tx
The topic has been locked.
Support Specialist
11 years 11 months ago #45256 by alzander
We haven't heard of that issue. If you disable the Social Profiles - Community Builder plugin, does the error go away?

If so, can you explain a bit more as to what's happening:
* User visits your Canvas application
* User logs in
* User lets the session timeout after 15 minutes (or whatever you have configured)
* User reloads the page
* User sees error message above
Do you have the auto-login feature of JFBConnect enabled? If so, can you disable it and see if it goes away?

The only time a SQL query happens directly on the comprofiler table from JFBConnect is when a user is authenticating. I don't see any case where the query would look like your error above though as information is clearly missing from the query.. in which case, the user looks like they weren't properly authenticated, and JFBConnect shouldn't be trying to import their profile data to begin with.

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

None
11 years 11 months ago #45270 by andbal2
hi, tx for your fast reply, i did tests you suggested, here you have results:
1. error happens not for first login but for next times, i mean when users return to visit application after session time (i have 60 min lifetime)
2. error happens just with community builder plugin in active state
3. error happens with autologin in yes and not state, both
4. user see the error message but also have button for homepage, if click and go to homepage all works, i mean user is logged

i hope to solve asap, tx
The topic has been locked.
Support Specialist
11 years 11 months ago #45276 by alzander

3) error happens with autologin in yes and not state, both
4. user see the error message but also have button for homepage, if click and go to homepage all works, i mean user is logged

If the auto-login is disabled in #3, how is the user being logged in in step #4? Do you have any extra code on your site to force the login?

Also, can you test if this happens outside of the Facebook Canvas? Mainly, if you test on your bare site, not within the Canvas, does the same issue happen?

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

None
11 years 11 months ago #45284 by andbal2
hi, error happens also out of facebook, i mean in web subdomain.
if the autologin is disabled and user click facebook button login error happens

my community builder plugin version is 6.0.0
maybe i can solve installing another time the community builder plugin? maybe there's a more recent version? please could you tell me where i can download it? tx
The topic has been locked.
Active Subscriptions:

None
11 years 11 months ago #45300 by andbal2
hi, solved just installing another time community builder plugin, tx for your help, i hope to don't have it again, bye
The topic has been locked.
Support Specialist
11 years 11 months ago #45307 by alzander
Andrea,
That's very strange that re-installing the plugin was necessary. I'm not sure what could have happened to require that. Either way, I'm happy to hear you got things going. If you run into anything else related to this, just let me know.

Thanks,
Alex
The topic has been locked.