Do you have any 3rd party extensions with user registration functionality of any kind? This can also happen if a 3rd party extension acts on Joomla user events, but errors. Then the Joomla user would be created, but the CB user wouldn't since it errored.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Thanks Kyle.
I just tried to register a new account, and upon completing the CB registration page, prior to the payment page, I received the following error:
Column 'checked_out' cannot be null
I was unable to advance at this point.
The site created my Joomla user account, with a strange last visit date:
-0001-11-29 18:42:28
But no CB user account.
My last CB user was added Jul 12, 2024 and beginning Jul. 13 - 12 new users have tried to register but I assume encountered the same problem, so only exist in the Joomla user database.
I don't recall if I updated Joomla and/or CB at this time, but suspect either may have caused the issue.
You likely have a 3rd party extension acting on Joomla user store events causing that. Joomla user and CB user don't have a checked_out column. Check what Joomla "User" plugins you have installed and try unpublishing 3rd party ones. If issue persists you'll have to look into "System" plugins. It's possible it's also a 3rd party CB plugin or bad code in CB Auto Actions usage so also worth looking into those as well.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
krileon
