CB users are not being activated

The best way is to send me a private message with the credentials. You can do so by clicking the arrow under my avatar (<

---

) and then hitting the mail icon.

Thanks,
Alex

Sorry for the delay. We will be investigating this later today and should be able to get you an answer quickly when we do. We'll let you know what we find, and hopefully it will be something simple.

Thanks,
Alex

Michael,
Did a bit of testing on your site tonight. We don't have an answer yet, but we have a question which might help lead to the root of the problem. Basically, when we're creating the user in CB, we're calling their own "Save User" functions. When that's being called though, the following SQL error is being produced.. which prevents CB from saving the user.. and then prevents JFBConnect from activating that user. I scrubbed some of the values, but the important bit is there:

Store failed, error: moscomprofiler::storeNew failed: Unknown column 'payment_method' in 'field list' SQL=INSERT INTO `jos_comprofiler` ( `id`,`user_id`,`approved`,`confirmed`,`payment_method`,`paypalId`,... .... ) VALUES ( 'xxx','xxx','0','0','','','','','','','','','','' )

Basically, Community Builder, when we call it, thinks there's 2 fields that should be stored in the users profile that don't exist: payment_method and paypalId. I don't see these in the CB field manager anywhere. Do you know what these fields are and where they may have come from? Can you look (if you know how) in the database to determine if these fields are in the cb_fields table? If so, they may need to be deleted.

Hopefully, this information will help you get started in narrowing down the issue. If you need more help debugging or looking into it, just let us know.

Thanks,
Alex

Yes, I'd definitely recommend adding those fields (and any others in case I missed something) to CB. Simply add it as a text field, and I believe you should be able to add it as a non-profile field, so that a user can't edit it. Basically, you want it so CB knows it exists, but not necessarily available for the user to edit.

We generally try not to modify anything not related to JFBConnect, so we'd ask that you add these fields, please. Once added, if you still get the same error, we'll gladly test and debug again if the user isn't being created successfully. If not, and it is something JFBConnect specific, we'll definitely do what we can to fix it. Otherwise, we'll notify you again of what might be interfering and hopefully you can rectify it too.

Thanks,
Alex