I am not sure whether this fits here or in the general cb topics. The mySQL field works just fine. My problem is that when I run the Tools to check the system after an upgrade, I get this message when I run the Check Community Builder Database link.
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.
There are 1 column(s) missing in the comprofiler table, which are defined as fields (rows in comprofiler_fields):
- Field cb_nxtfrmbrn - Column cb_nxtfrmbrn is missing from comprofiler table.
This one can be fixed by deleting and recreating the field(s) using components / Community Builder / Field Management.
Please additionally make sure that columns in comprofiler table are not also duplicated in users 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
I have followed the instructions to fix the problem with no success but, in any case, the plugin works fine,displaying a maximum value of a couple of fields.
Have I set something wrong somewhere? Is is a plug in or cb problem.
You're right, I've just checked and I am getting the same warnings when I run the checks in CB tools.
It looks like CB expects a field in the comprofiler table for every MySQL field as I based it on a normal text field. I cant see it causing a problem in normal usage but I'll look into fixing that warning in the next version. I'll look at how the delimiter field works as the MySQL field is effectively a dynamic delimiter.
