Project

General

Profile

Actions

Bug #4830

open

Database Checker: Upon uninstall of a plugin, all remaining columns are supposed to be default TEXT type, instead of being left as is

Added by beat over 9 years ago. Updated 6 months ago.

Status:
Feedback
Priority:
Low
Assignee:
Target version:
Start date:
04 November 2014
Due date:
% Done:

50%

Estimated time:

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

Also available in: Atom PDF