Jump to content

MIDTEMP0

Clients
  • Posts

    5
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by MIDTEMP0

  1. 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?

×
×
  • Create New...