You won't need to wait for CB 2.7. We'll be releasing the fix in a nightly build once it is reviewed and merged. Below is the fix. As it's pretty small and simple you should be able to apply it yourself so you don't have to wait.
IN: /components/com_comprofiler/plugin/user/plug_cbcore/cb.core.xml
ON: LINE 95
FROM:
Code:
<data name="" nametype="namesuffix" type="sql:mediumtext" />
TO:
Code:
<data name="" nametype="namesuffix" type="sql:mediumtext" null="true" default="NULL" translate-default="no" />
Once that is done within CB > Tools click the "Check Community Builder User Fields Database with strict column types" link in the description of the "Check Community Builder User Fields Database" tool. This will tell you that there's an issue with multicheckbox default value and offer to fix it. Once fixed your issue should be resolved.