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 5 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 #1

Updated by krileon over 9 years ago

  • Status changed from New to Resolved
  • Assignee set to krileon
  • % Done changed from 0 to 100

Fixed in MR !659

Actions #2

Updated by krileon over 9 years ago

  • Status changed from Resolved to Feedback
  • Assignee changed from krileon to beat
  • % Done changed from 100 to 50
Actions #3

Updated by krileon over 9 years ago

  • Target version changed from CB 2.0.3 to CB 2.0.4
Actions #4

Updated by beat over 9 years ago

  • Target version changed from CB 2.0.4 to CB 2.0.5
Actions #5

Updated by beat about 9 years ago

  • Target version changed from CB 2.0.5 to CB 2.0.6
Actions #6

Updated by beat about 9 years ago

  • Target version changed from CB 2.0.6 to CB 2.0.7
Actions #7

Updated by beat about 9 years ago

  • Target version changed from CB 2.0.7 to CB 2.0.8
Actions #8

Updated by beat almost 9 years ago

  • Target version changed from CB 2.0.8 to CB 2.0.9
Actions #9

Updated by beat almost 9 years ago

  • Target version changed from CB 2.0.9 to CB 2.0.10
Actions #10

Updated by beat almost 9 years ago

  • Target version changed from CB 2.0.10 to CB 2.0.11
Actions #11

Updated by beat over 8 years ago

  • Target version changed from CB 2.0.11 to CB 2.0.12
Actions #12

Updated by beat over 8 years ago

  • Target version changed from CB 2.0.12 to CB 2.0.13
Actions #13

Updated by beat about 8 years ago

  • Target version changed from CB 2.0.13 to CB 2.0.14
Actions #14

Updated by beat about 8 years ago

  • Target version changed from CB 2.0.14 to CB 2.0.15
Actions #15

Updated by beat over 7 years ago

  • Target version changed from CB 2.0.15 to CB 2.1
Actions #16

Updated by krileon over 7 years ago

  • Target version changed from CB 2.1 to CB 2.2
Actions #17

Updated by krileon almost 6 years ago

  • Target version changed from CB 2.2 to CB 2.8
Actions #18

Updated by beat about 2 years ago

  • Target version changed from CB 2.8 to CB 2.7.2
Actions #19

Updated by beat about 2 years ago

MR !659 being closed, as non-effective, moving to target version 2.7.1

Actions #20

Updated by beat about 2 years ago

  • Target version changed from CB 2.7.2 to CB 2.7.3
Actions #21

Updated by beat almost 2 years ago

  • Target version changed from CB 2.7.3 to CB 2.7.4
Actions #22

Updated by krileon over 1 year ago

  • Target version changed from CB 2.7.4 to CB 2.8
Actions #23

Updated by beat about 1 year ago

  • Target version changed from CB 2.8 to CB 2.8.1
Actions #24

Updated by beat 8 months ago

  • Target version changed from CB 2.8.1 to CB 2.8.2
Actions #25

Updated by beat 7 months ago

  • Target version changed from CB 2.8.2 to CB 2.9.0
Actions #26

Updated by beat 5 months ago

  • Target version changed from CB 2.9.0 to CB 2.9.2
Actions

Also available in: Atom PDF