We have been having issues with user registration after our recent upgrade to Joomla 4.
Here is the first error we get when we try to apply to be a new member.
Field 'accreditation' doesn't have a default value
Joomla version: 4.3.3
Community Builder: 2.8.0+build.2023.07.12.21.31.08.8f3ab82e7
CB Subs: 4.6.1+build.2023.06.21.13.40.37.680b3e218
No such "accreditation" database column exists in Joomla 4 or in CB. I'm guessing a 3rd party extension is acting on Joomla user store or it modified Joomla/CB database table. Check for 3rd party System or User plugins in System > Plugins and try disabling them then retry. If issue persists you'll need to check the _comprofiler and _users table to see if something added that database column to them and if so edit the column and give it a default (suggest null default).
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
