Problem with normal user subscription

Hi Kyle,

I have a problem. The Joomla table is getting out of sync with the community user database.

Here is the problem: I have an automatic login for FB (JFBConnect) that used to work superbly with CB before I installed CB subs. This plugin allows registration to Joomla database and somehow also triggers something in CB (or CB used to automatically take over). Since installing CB subs, this does not work anymore. Somehow, the joomla db and the CB db are getting out of sync.

The user who signs up via the component JFBConnect (which is nearly all of them), are getting logged into the joomla db without any problems and can use all of the site APART from anything to do with CB (the users get the message that the account has not been confirmed yet, CB sends out an email etc...).

Also, weird enough, CB sends an email with the useraccount registration. It did not use to do this beforehand (over 4000 people registered already).

EDIT: I have set CB to allow registration independent of CMS. (EDIT: I changed it and it did not change the problem at all)

EDIT: Once I synchronise the Joomla db and the CB table, it works perfectly again.

JFBConnect does not use CB API to register or login users. So you will go out of sync. Don't use JFBConnect, but use CB Connect if you don't want them to go our of sync. Otherwise contact JFBConnect and see if they're interested in integrating with CB; the API to do so can be found below.

www.joomlapolis.com/forum/153-professional-member-support/229059-api-tutorials-register-user#261169

www.joomlapolis.com/forum/153-professional-member-support/228495-solved-cb-version-api-cb-version-205#258806

How come that it used to work for the 4000 previous users? They got taken over immediatly into CB...

They are using the API I think... I will enquire with them. It used to work.

Pretty sure that it is a CB problem. I will wait another 24 hours for the cache to clear and then try again but I have verified that it works normally (before I started working on CB again). I will keep you updated.

_Website sends an link with "Please confirm email" as normal (Email from CB login BUT user is not present in usertable). When user (who is already logged in) clicks on it, then they get an error message with "Please logout as you are not allowed to view this message when logged in". When the user is logged out and clicks the link, they get an error message with "Please log in to see the content of this page" (or something like this). Considering that the confirmation emails come from CB HOWEVER the user is NOT present in CB user list, I am strongly expecting the problem to be CB related.

_My older website "saigon.international-friends.net" is basically a copy of the website "munich.international-friends.net" without the CB subs and the CB conditional nightly. It works perfectly there.

_ Just enabled the CB connect facebook thing (I am not using the CB FB connect as it does not have an auto-login feature like JFBConnect has). It does not work either: Unknown column 'fb_userid' in 'where clause' SQL=SELECT `id` FROM `ifm_comprofiler` WHERE `fb_userid` = '61205233'

You may have CBSubs setup to not allow free registrations without a subscription. Registrations through JFBConnect and even CB Connect will not have a subscription. So you need to ensure you allow free registrations without a subscription within CBSubs > Settings > Global to all their registrations to complete. CB Connect has an option to form-fill the registration page to allow it to work with CBSubs. No idea if JFBConnect has similar functionality.

As you're registering users through a 3rd party extension there's nothing more I can suggest. If normal CB registrations and logins are not having this issue it's probably a configuration problem in your 3rd party extension or their API usage maybe wrong.

Thought of that already. Did that test already before I contacted you and checked again just now... See above what the CB connect login reported. The CB subs is set to allow free subscribers.