Upgrade error - BLOB/TEXT column without keylength

[MIDTEMP0]

Hiya,

Getting the following script error when upgrading 

BLOB/TEXT column 'profilesync' used in key specification without a key length

/path/to/board/applications/core/sources/Setup/Upgrade.php::753

ALTER TABLE `ibf_core_members` DROP INDEX `name_index`, CHANGE COLUMN `name` `name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
ADD KEY `name_index` (`name`(191)), CHANGE COLUMN `email` `email` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
CHANGE COLUMN `auto_track` `auto_track` VARCHAR (256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' , 
DROP INDEX `member_groups`, 
CHANGE COLUMN `mgroup_others` `mgroup_others` VARCHAR (245) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
ADD KEY `member_groups` (`member_group_id`,`mgroup_others`(191)), CHANGE COLUMN `members_seo_name` `members_seo_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
CHANGE COLUMN `members_cache` `members_cache` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `failed_logins` `failed_logins` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `members_pass_hash` `members_pass_hash` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `members_pass_salt` `members_pass_salt` VARCHAR (22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `members_day_posts` `members_day_posts` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0' , CHANGE COLUMN `pp_last_visitors` `pp_last_visitors` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `pp_main_photo` `pp_main_photo` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `pp_thumb_photo` `pp_thumb_photo` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `pp_photo_type` `pp_photo_type` VARCHAR (20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `signature` `signature` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `pconversation_filters` `pconversation_filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_customization` `pp_customization` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `timezone` `timezone` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `pp_cover_photo` `pp_cover_photo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , 
DROP INDEX `profilesync`, 
CHANGE COLUMN `profilesync` `profilesync` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `profilesync` (`profilesync_lastsync`,`profilesync`), 
CHANGE COLUMN `create_menu` `create_menu` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Cached contents of the \"Create\" drop down menu.', 
CHANGE COLUMN `member_title` `member_title` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `member_streams` `member_streams` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `mfa_details` `mfa_details` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , 
CHANGE COLUMN `permission_array` `permission_array` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'A cache of the clubs and social groups that the member is in';

 

Stack overflow tells me what's wrong, but I'm not sure how to fix this in the middle of an upgrade.  Any ideas?

[CoffeeCake]

You should file a support request.

[MIDTEMP0]

Yeah, of course 🙂

Done, thanks

[bfarber]

I know a colleague is looking into the ticket. Thanks!