Core CB database warning

Hi guys.

I am setting up a new site, but it looks like a created some fields wrongly. When I conducted a db check from CB Tools panel, I got this warning, but I don't know what I need to do to correct it. Please help.

Warning: 14 entries in Community Builder comprofiler_field_values link back to fields of wrong fieldtype.

fieldvalueid=605 fieldtype=text

fieldvalueid=606 fieldtype=text

fieldvalueid=607 fieldtype=text

fieldvalueid=608 fieldtype=text

fieldvalueid=609 fieldtype=text
......

Looks like you've some database row entries in _comprofiler_fields_values that below to text fields, which isn't valid. The below queries ran on your database would delete them for you. Please ensure to take a DB backup before performing any direct queries.

Replace jos_ in the above if it's not your actual table prefix.

This usually happens if a fields type is changed in _comprofiler_field, please avoid changing a fields type once the field has been created.

I did not change anything. And I don't really understand this error message. The only field in _comprofiler_fields that is type text is 'tablecolumns'

I traced the fieldid's against each of these values and checked the corresponding entries in _comprofiler_field and found that they are fields created by cbsubs. How cbsubs created fields with wrong field types I cannot tell, but rather than delete them (I think that would break cbsubs) can you tell me how to correct the error?

They all have the prefix cb_subs_inv

It helps if you provide what fields exactly. It's possible the fields were once select types then later changed with a new CBSubs released. You're not deleting the fields themselves. You're simply deleting their select values as if they were drop-down select fields, which they aren't so their values in _comprofiler_field_values are unused. Please of course make a DB backup before performing the delete. Again, you're not deleting the fields or their columns; just the values in _comprofiler_field_values.