MIDTEMP0 Posted September 18, 2020 Share Posted September 18, 2020 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? Link to comment Share on other sites More sharing options...
CoffeeCake Posted September 18, 2020 Share Posted September 18, 2020 You should file a support request. Link to comment Share on other sites More sharing options...
MIDTEMP0 Posted September 18, 2020 Author Share Posted September 18, 2020 Yeah, of course 🙂 Done, thanks Link to comment Share on other sites More sharing options...
bfarber Posted September 21, 2020 Share Posted September 21, 2020 I know a colleague is looking into the ticket. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts