Actions
Bug #4830
openDatabase Checker: Upon uninstall of a plugin, all remaining columns are supposed to be default TEXT type, instead of being left as is
Description
As reported by Nick:
If I install CB Connect 2.0 and then uninstall it and run CB Field tools I get:
CB fields data storage database structure differences: Table #__comprofiler Column fb_userid type is varchar(50) instead of text Table #__comprofiler Column steam_userid type is varchar(50) instead of text Table #__comprofiler Column vkontakte_userid type is varchar(50) instead of text Table #__comprofiler Column github_userid type is varchar(50) instead of text Table #__comprofiler Column foursquare_userid type is varchar(50) instead of text Table #__comprofiler Column instagram_userid type is varchar(50) instead of text Table #__comprofiler Column google_userid type is varchar(50) instead of text Table #__comprofiler Column windowslive_userid type is varchar(50) instead of text Table #__comprofiler Column linkedin_userid type is varchar(50) instead of text Table #__comprofiler Column twitter_userid type is varchar(50) instead of text Table #__comprofiler Column tumblr_userid type is varchar(50) instead of text
And if I Chose to fix then I get:
An error has occurred. 1170 BLOB/TEXT column 'fb_userid' used in key specification without a key length SQL=ALTER TABLE `wpdgf_comprofiler` CHANGE `fb_userid` `fb_userid` text Return to Control Panel
So instead of supposing that they should be TEXT, they should not be treated at all.
Actions