I once had a similar issue before (last time I upgraded and I found the fix in another forum which was attributed to sql not CB - the fix was to change varchar 255
Thread link -
click here
-
This time though -
Check Community Builder User Fields Database - returns no errors - All CB fields data storage Database is up to date.
Check Core CB database: Results
Checking Community Builder Database:
All Community Builder comprofiler_field_values table fieldid rows all match existing fields.
All Community Builder comprofiler_field_values table rows link to correct fieldtype fields in comprofiler_field table.
All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table.
Checking Community Builder folders:
Avatars and thumbnails folder is Writeable.
All Core CB mandatory basics Database is up to date.
Core CB mandatory basics database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.
All Core CB Database is up to date.
Click here to Show details
Table #__comprofiler Column id structure is up-to-date.
Table #__comprofiler Column user_id structure is up-to-date.
Table #__comprofiler Column firstname structure is up-to-date.
Table #__comprofiler Column middlename structure is up-to-date.
Table #__comprofiler Column lastname structure is up-to-date.
Table #__comprofiler Column hits structure is up-to-date.
Table #__comprofiler Column message_last_sent structure is up-to-date.
Table #__comprofiler Column message_number_sent structure is up-to-date.
Table #__comprofiler Column avatar structure is up-to-date.
Table #__comprofiler Column avatarapproved structure is up-to-date.
Table #__comprofiler Column approved structure is up-to-date.
Table #__comprofiler Column confirmed structure is up-to-date.
Table #__comprofiler Column lastupdatedate structure is up-to-date.
Table #__comprofiler Column registeripaddr structure is up-to-date.
Table #__comprofiler Column cbactivation structure is up-to-date.
Table #__comprofiler Column banned structure is up-to-date.
Table #__comprofiler Column banneddate structure is up-to-date.
Table #__comprofiler Column unbanneddate structure is up-to-date.
Table #__comprofiler Column bannedby structure is up-to-date.
Table #__comprofiler Column unbannedby structure is up-to-date.
Table #__comprofiler Column bannedreason structure is up-to-date.
Table #__comprofiler Column acceptedterms structure is up-to-date.
Table #__comprofiler Index PRIMARY is up-to-date.
Table #__comprofiler Index user_id is up-to-date.
Table #__comprofiler Index apprconfbanid is up-to-date.
Table #__comprofiler Index avatappr_apr_conf_ban_avatar is up-to-date.
Table #__comprofiler Index lastupdatedate is up-to-date.
Table #__comprofiler_field_values Column fieldvalueid structure is up-to-date.
Table #__comprofiler_field_values Column fieldid structure is up-to-date.
Table #__comprofiler_field_values Column fieldtitle structure is up-to-date.
Table #__comprofiler_field_values Column ordering structure is up-to-date.
Table #__comprofiler_field_values Column sys structure is up-to-date.
Table #__comprofiler_field_values has no unneeded columns.
Table #__comprofiler_field_values Index PRIMARY is up-to-date.
Table #__comprofiler_field_values Index fieldid_ordering is up-to-date.
Table #__comprofiler_field_values Index fieldtitle_id is up-to-date.
Table #__comprofiler_field_values has no unneeded indexes.
Table #__comprofiler_fields Column fieldid structure is up-to-date.
Table #__comprofiler_fields Column name structure is up-to-date.
Table #__comprofiler_fields Column tablecolumns structure is up-to-date.
Table #__comprofiler_fields Column table structure is up-to-date.
Table #__comprofiler_fields Column title structure is up-to-date.
Table #__comprofiler_fields Column description structure is up-to-date.
Table #__comprofiler_fields Column type structure is up-to-date.
Table #__comprofiler_fields Column maxlength structure is up-to-date.
Table #__comprofiler_fields Column size structure is up-to-date.
Table #__comprofiler_fields Column required structure is up-to-date.
Table #__comprofiler_fields Column tabid structure is up-to-date.
Table #__comprofiler_fields Column ordering structure is up-to-date.
Table #__comprofiler_fields Column cols structure is up-to-date.
Table #__comprofiler_fields Column rows structure is up-to-date.
Table #__comprofiler_fields Column value structure is up-to-date.
Table #__comprofiler_fields Column default structure is up-to-date.
Table #__comprofiler_fields Column published structure is up-to-date.
Table #__comprofiler_fields Column registration structure is up-to-date.
Table #__comprofiler_fields Column profile structure is up-to-date.
Table #__comprofiler_fields Column displaytitle structure is up-to-date.
Table #__comprofiler_fields Column readonly structure is up-to-date.
Table #__comprofiler_fields Column searchable structure is up-to-date.
Table #__comprofiler_fields Column calculated structure is up-to-date.
Table #__comprofiler_fields Column sys structure is up-to-date.
Table #__comprofiler_fields Column pluginid structure is up-to-date.
Table #__comprofiler_fields Column params structure is up-to-date.
Table #__comprofiler_fields has no unneeded columns.
Table #__comprofiler_fields Index PRIMARY is up-to-date.
Table #__comprofiler_fields Index tabid_pub_prof_order is up-to-date.
Table #__comprofiler_fields Index readonly_published_tabid is up-to-date.
Table #__comprofiler_fields Index registration_published_order is up-to-date.
Table #__comprofiler_fields has no unneeded indexes.
Table #__comprofiler_fields Rows fieldid = 41 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 26 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 25 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 27 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 28 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 29 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 42 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 45 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 46 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 47 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 48 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 49 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 50 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 51 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 52 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 24 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 23 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 22 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 21 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 20 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 19 are up-to-date.
Table #__comprofiler_fields Rows fieldid = 18 are up-to-date.
Table #__comprofiler_lists Column listid structure is up-to-date.
Table #__comprofiler_lists Column title structure is up-to-date.
Table #__comprofiler_lists Column description structure is up-to-date.
Table #__comprofiler_lists Column published structure is up-to-date.
Table #__comprofiler_lists Column default structure is up-to-date.
Table #__comprofiler_lists Column usergroupids structure is up-to-date.
Table #__comprofiler_lists Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_lists Column sortfields structure is up-to-date.
Table #__comprofiler_lists Column filterfields structure is up-to-date.
Table #__comprofiler_lists Column ordering structure is up-to-date.
Table #__comprofiler_lists Column col1title structure is up-to-date.
Table #__comprofiler_lists Column col1enabled structure is up-to-date.
Table #__comprofiler_lists Column col1fields structure is up-to-date.
Table #__comprofiler_lists Column col2title structure is up-to-date.
Table #__comprofiler_lists Column col2enabled structure is up-to-date.
Table #__comprofiler_lists Column col1captions structure is up-to-date.
Table #__comprofiler_lists Column col2fields structure is up-to-date.
Table #__comprofiler_lists Column col2captions structure is up-to-date.
Table #__comprofiler_lists Column col3title structure is up-to-date.
Table #__comprofiler_lists Column col3enabled structure is up-to-date.
Table #__comprofiler_lists Column col3fields structure is up-to-date.
Table #__comprofiler_lists Column col3captions structure is up-to-date.
Table #__comprofiler_lists Column col4title structure is up-to-date.
Table #__comprofiler_lists Column col4enabled structure is up-to-date.
Table #__comprofiler_lists Column col4fields structure is up-to-date.
Table #__comprofiler_lists Column col4captions structure is up-to-date.
Table #__comprofiler_lists Column params structure is up-to-date.
Table #__comprofiler_lists has no unneeded columns.
Table #__comprofiler_lists Index PRIMARY is up-to-date.
Table #__comprofiler_lists Index pub_ordering is up-to-date.
Table #__comprofiler_lists Index default_published is up-to-date.
Table #__comprofiler_lists has no unneeded indexes.
Table #__comprofiler_members Column referenceid structure is up-to-date.
Table #__comprofiler_members Column memberid structure is up-to-date.
Table #__comprofiler_members Column accepted structure is up-to-date.
Table #__comprofiler_members Column pending structure is up-to-date.
Table #__comprofiler_members Column membersince structure is up-to-date.
Table #__comprofiler_members Column reason structure is up-to-date.
Table #__comprofiler_members Column description structure is up-to-date.
Table #__comprofiler_members Column type structure is up-to-date.
Table #__comprofiler_members has no unneeded columns.
Table #__comprofiler_members Index PRIMARY is up-to-date.
Table #__comprofiler_members Index pamr is up-to-date.
Table #__comprofiler_members Index aprm is up-to-date.
Table #__comprofiler_members Index membrefid is up-to-date.
Table #__comprofiler_members has no unneeded indexes.
Table #__comprofiler_plugin Column id structure is up-to-date.
Table #__comprofiler_plugin Column name structure is up-to-date.
Table #__comprofiler_plugin Column element structure is up-to-date.
Table #__comprofiler_plugin Column type structure is up-to-date.
Table #__comprofiler_plugin Column folder structure is up-to-date.
Table #__comprofiler_plugin Column backend_menu structure is up-to-date.
Table #__comprofiler_plugin Column access structure is up-to-date.
Table #__comprofiler_plugin Column ordering structure is up-to-date.
Table #__comprofiler_plugin Column published structure is up-to-date.
Table #__comprofiler_plugin Column iscore structure is up-to-date.
Table #__comprofiler_plugin Column client_id structure is up-to-date.
Table #__comprofiler_plugin Column checked_out structure is up-to-date.
Table #__comprofiler_plugin Column checked_out_time structure is up-to-date.
Table #__comprofiler_plugin Column params structure is up-to-date.
Table #__comprofiler_plugin has no unneeded columns.
Table #__comprofiler_plugin Index PRIMARY is up-to-date.
Table #__comprofiler_plugin Index idx_folder is up-to-date.
Table #__comprofiler_plugin Index type_pub_order is up-to-date.
Table #__comprofiler_plugin has no unneeded indexes.
Table #__comprofiler_plugin Rows id = 1 are up-to-date.
Table #__comprofiler_plugin Rows id = 2 are up-to-date.
Table #__comprofiler_plugin Rows id = 3 are up-to-date.
Table #__comprofiler_plugin Rows id = 4 are up-to-date.
Table #__comprofiler_plugin Rows id = 5 are up-to-date.
Table #__comprofiler_plugin Rows id = 6 are up-to-date.
Table #__comprofiler_plugin Rows id = 7 are up-to-date.
Table #__comprofiler_plugin Rows id = 8 are up-to-date.
Table #__comprofiler_plugin Rows id = 9 are up-to-date.
Table #__comprofiler_plugin Rows id = 10 are up-to-date.
Table #__comprofiler_plugin Rows id = 11 are up-to-date.
Table #__comprofiler_plugin Rows id = 12 are up-to-date.
Table #__comprofiler_plugin Rows id = 13 are up-to-date.
Table #__comprofiler_plugin Rows id = 14 are up-to-date.
Table #__comprofiler_plugin Rows id = 15 are up-to-date.
Table #__comprofiler_tabs Column tabid structure is up-to-date.
Table #__comprofiler_tabs Column title structure is up-to-date.
Table #__comprofiler_tabs Column description structure is up-to-date.
Table #__comprofiler_tabs Column ordering structure is up-to-date.
Table #__comprofiler_tabs Column ordering_register structure is up-to-date.
Table #__comprofiler_tabs Column width structure is up-to-date.
Table #__comprofiler_tabs Column enabled structure is up-to-date.
Table #__comprofiler_tabs Column pluginclass structure is up-to-date.
Table #__comprofiler_tabs Column pluginid structure is up-to-date.
Table #__comprofiler_tabs Column fields structure is up-to-date.
Table #__comprofiler_tabs Column params structure is up-to-date.
Table #__comprofiler_tabs Column sys structure is up-to-date.
Table #__comprofiler_tabs Column displaytype structure is up-to-date.
Table #__comprofiler_tabs Column position structure is up-to-date.
Table #__comprofiler_tabs Column useraccessgroupid structure is up-to-date.
Table #__comprofiler_tabs has no unneeded columns.
Table #__comprofiler_tabs Index PRIMARY is up-to-date.
Table #__comprofiler_tabs Index enabled_position_ordering is up-to-date.
Table #__comprofiler_tabs Index orderreg_enabled_pos_order is up-to-date.
Table #__comprofiler_tabs has no unneeded indexes.
Table #__comprofiler_tabs Rows tabid = 11 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 12 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 13 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 14 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 15 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 16 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 17 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 18 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 19 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 20 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 21 are up-to-date.
Table #__comprofiler_tabs Rows tabid = 22 are up-to-date.
Table #__comprofiler_userreports Column reportid structure is up-to-date.
Table #__comprofiler_userreports Column reporteduser structure is up-to-date.
Table #__comprofiler_userreports Column reportedbyuser structure is up-to-date.
Table #__comprofiler_userreports Column reportedondate structure is up-to-date.
Table #__comprofiler_userreports Column reportexplaination structure is up-to-date.
Table #__comprofiler_userreports Column reportedstatus structure is up-to-date.
Table #__comprofiler_userreports has no unneeded columns.
Table #__comprofiler_userreports Index PRIMARY is up-to-date.
Table #__comprofiler_userreports Index status_user_date is up-to-date.
Table #__comprofiler_userreports Index reportedbyuser_ondate is up-to-date.
Table #__comprofiler_userreports has no unneeded indexes.
Table #__comprofiler_views Column viewer_id structure is up-to-date.
Table #__comprofiler_views Column profile_id structure is up-to-date.
Table #__comprofiler_views Column lastip structure is up-to-date.
Table #__comprofiler_views Column lastview structure is up-to-date.
Table #__comprofiler_views Column viewscount structure is up-to-date.
Table #__comprofiler_views Column vote structure is up-to-date.
Table #__comprofiler_views Column lastvote structure is up-to-date.
Table #__comprofiler_views has no unneeded columns.
Table #__comprofiler_views Index PRIMARY is up-to-date.
Table #__comprofiler_views Index lastview is up-to-date.
Table #__comprofiler_views Index profile_id_lastview is up-to-date.
Table #__comprofiler_views has no unneeded indexes.
Table #__comprofiler_sessions Column username structure is up-to-date.
Table #__comprofiler_sessions Column userid structure is up-to-date.
Table #__comprofiler_sessions Column ui structure is up-to-date.
Table #__comprofiler_sessions Column incoming_ip structure is up-to-date.
Table #__comprofiler_sessions Column client_ip structure is up-to-date.
Table #__comprofiler_sessions Column session_id structure is up-to-date.
Table #__comprofiler_sessions Column session_data structure is up-to-date.
Table #__comprofiler_sessions Column expiry_time structure is up-to-date.
Table #__comprofiler_sessions has no unneeded columns.
Table #__comprofiler_sessions Index PRIMARY is up-to-date.
Table #__comprofiler_sessions Index expiry_time is up-to-date.
Table #__comprofiler_sessions Index userid is up-to-date.
Table #__comprofiler_sessions has no unneeded indexes.
Core CB database checks done. If all lines above are in green, test completed successfully. Otherwise, please take corrective measures proposed in red.
But still unable to create new fields
I am able to edit existing ones thought
I can also create new tabs and new lists just not new fields
After updating then seeing this problem I did again implement the recommended changes in cb.core.xml
All support gratedully received