CB tool/db issue after upgrade to Joomla 3.6.2

Guys

Using CB 2.0.14 - after updating to Joomla 3.6.2 from 3.5.x whern using CB tools all checks are ok except for user database - I get the following errors:

CB fields data storage database structure differences:
Table #__comprofiler Column twitter_previous_userid type is varchar(50) instead of text
Table #__comprofiler Column fb_previous_userid type is varchar(50) instead of text
Table #__comprofiler Column tumblr_userid type is varchar(50) instead of varchar(255)
The CB fields data storage database structure differences can be fixed (adjusted) by clicking here: Click here to fix (adjust) all CB fields data storage database differences listed above

When I do a DRY RUN - it all works fine (apparently) but when I do the actual fic, i get this error:

An error has occurred.

1170 BLOB/TEXT column 'twitter_previous_userid' used in key specification without a key length SQL=ALTER TABLE `#__comprofiler` CHANGE `twitter_previous_userid` `twitter_previous_userid` text

Any ideas how to fix please?

I managed to FIX this by simply going into CB fields edit and pressing edit for each of those 3 fields and then saving them again - when I ran tools again, all eroors were fixed.

Cheers

text columns can't have an index without a size set. This is a known issue in CB when a fields type is being fixed and it has an index. Since those fields are no longer linked to CB Connect (either unused or CB Connect is uninstalled) you can just delete them.