comprofiler_field_values link back to fields of wrong fieldtype

I recently migrated a Joomla 1.5 site to Joomla 3.2.3. Using SP Upgrade, I migrated my Community Builder 1.9.1 data. The process went very smooth except for one problem. In the Admin area, when I run the "Tools", "Check Community Builder Database", I get the following error message (Note: When I run "Check Community Builder User Fields Database" tool, all lines are green, meaning, OK):

Checking Community Builder Database:

All Community Builder comprofiler_field_values table fieldid rows all match existing fields.

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

fieldvalueid=16 fieldtype=text

fieldvalueid=17 fieldtype=text

fieldvalueid=18 fieldtype=text

fieldvalueid=19 fieldtype=text

fieldvalueid=20 fieldtype=text

fieldvalueid=21 fieldtype=text

This one can be fixed in SQL using a tool like phpMyAdmin.

All Community Builder fields from comprofiler_fields are present as columns in the comprofiler table.

Thanks for your help, Tim

A fieldtype was changed from a list type to a text type. This results in the fieldvalues for that field being left behind. You can either ignore it or remove them manually within the _comprofiler_field_values database table.