[#5584] CB-Connect Error: Unknown column 'fb_userid'

Hello!

I'am using:
Joomla 3.4.5
CB 2.0.11
PHP 5.4.45, cURL enabled, openSSL enabled

Successfully installed the CB Connect 7.0.0 beta 4.
Strictly follow the Facebook configuration manuals ( (from here , and from here too).
And after trying to frontend facebook login, there was an error:

Failed to retrieve Facebook profile. Error: Unknown column 'fb_userid' in 'where clause' SQL=SELECT `id` FROM `tnq15_comprofiler` WHERE `fb_userid` = '990947080961399'

I uninstall CB Connect 7.0.0. beta 4, and install 7.0.0. beta 3 - results the same.
Uninstall CB Connect 7.0.0. beta 3, and install 6.0.5 - results the same.

Try the Google login, that results the same with 'google_userid'.

I check the field manager, and there are cb_fb_userid, cb_google_userid, etc. And there aren't any fb_userid, google_userid, etc.
You mentioned in a former topic that during the CB Connect install the program must create fb_userid instead of cb_fb_userid (and must do the same with the other social logins).

It seems that in my case the program makes cb_ prefix at the install.
What can I do since I cannot change these field names.

Thank you!

The fields should not be prefixed with cb_, not sure why they are. Navigate to _comprofiler_fields and delete the cb_fb_userid, cb_google_userid, etc.. fields then re-install CB Connect 7.x Beta to see if the fields will create properly. Please ensure you have latest CB 2.0.12 before installing CB Connect 7.x Beta.

Hello!

Thanks your advice!
Ok, I delete all of the cb_fb_userid, cb_google_userid, etc. fields in Plugin menu.
Uninstall former CB Connect.
Update CB from 2.0.11 to 2.0.12.

Install the newest CB Connect module 7.0.0 beta 4.
And there were again the cb_ prefix in all of the fieldname of social login fields.
I went to phpmyadmin and manually changed the record: cb_fb_userid to fb_userid.

And after I try to login form frontend there is a new error:

Sign up with Facebook is not permitted.

I think the bad fieldnames problem is solved, but why is the ban still standing?

I really want to use your social connection module.
Thanks.

And there were again the cb_ prefix in all of the fieldname of social login fields.

Strange, that shouldn't be happening will test and see if there's a problem in CB it self or CB Connect.

Sign up with Facebook is not permitted.

This means Facebook either isn't configured or isn't enabled. Please see the below tutorial for configuring it.

www.joomlapolis.com/forum/6-news-and-publicity/229505-configuring-cb-connect-7x#263227

Ok, looks like it's a bug in CB directly. You should be able to fix it by re-installing CB Connect and it should create the proper fields. You maybe able to then delete the old ones.

forge.joomlapolis.com/issues/5584