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
 

Bingo, you nailed it, thank you.   I did previously upgrade Kunena to latest version but it did not resolve the problem.  I went into the database, table xxx__kunena_users, field "status_text" and change the default value to NULL and that resolved the problem.