I recently upgraded from joomla 3.x to 4.3.4. Upon saving an new user from CB, getting the message "error 'field status_text doesn't have a default value". Verified user is created in Joomla user list. When run CB "Check Users Database", get the following info:
All Community Builder comprofiler table rows have links to user table.
Warning: 1 entries in users table without corresponding comprofiler table rows.
users id: 4641 are missing in comprofiler table
This one can be fixed using menu Components / Community Builder / tools and then click "Synchronize users".
users table has no zero id row.
comprofiler table has no zero id row.
All rows in comprofiler table have user_id columns identical to id columns.
All users table rows have ACL entries in user_usergroup_map table.
All ACL user_usergroup_map table rows have corresponding entries in users table.
Running "Synchronize Users" tool, the record is fixed and then shows in CB Users. All other CB checks/tests come out clean/green. I reinstalled the latest version of CB, Please advise.
CB version: pkg_communitybuilder_2.8.1+2023.08.30.20.47.18.76c3e89d7
Joomla 4.3.4