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 about 10 years ago.
Updated 3 months ago.
Start date:
04 November 2014
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.
- Status changed from New to Resolved
- Assignee set to krileon
- % Done changed from 0 to 100
- Status changed from Resolved to Feedback
- Assignee changed from krileon to beat
- % Done changed from 100 to 50
- Target version changed from CB 2.0.3 to CB 2.0.4
- Target version changed from CB 2.0.4 to CB 2.0.5
- Target version changed from CB 2.0.5 to CB 2.0.6
- Target version changed from CB 2.0.6 to CB 2.0.7
- Target version changed from CB 2.0.7 to CB 2.0.8
- Target version changed from CB 2.0.8 to CB 2.0.9
- Target version changed from CB 2.0.9 to CB 2.0.10
- Target version changed from CB 2.0.10 to CB 2.0.11
- Target version changed from CB 2.0.11 to CB 2.0.12
- Target version changed from CB 2.0.12 to CB 2.0.13
- Target version changed from CB 2.0.13 to CB 2.0.14
- Target version changed from CB 2.0.14 to CB 2.0.15
- Target version changed from CB 2.0.15 to CB 2.1
- Target version changed from CB 2.1 to CB 2.2
- Target version changed from CB 2.2 to CB 2.8
- Target version changed from CB 2.8 to CB 2.7.2
MR !659 being closed, as non-effective, moving to target version 2.7.1
- Target version changed from CB 2.7.2 to CB 2.7.3
- Target version changed from CB 2.7.3 to CB 2.7.4
- Target version changed from CB 2.7.4 to CB 2.8
- Target version changed from CB 2.8 to CB 2.8.1
- Target version changed from CB 2.8.1 to CB 2.8.2
- Target version changed from CB 2.8.2 to CB 2.9.0
- Target version changed from CB 2.9.0 to CB 2.9.2
- Target version changed from CB 2.9.2 to CB 2.9.3
- Target version changed from CB 2.9.3 to CB 2.9.4
Also available in: Atom
PDF