Выберите какой то уникальный столбец и удалите записи по нему странно что у вас не все столбцы на месте
CREATE TABLE `sw_core_members` (
`member_id` MEDIUMINT(8) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`member_group_id` SMALLINT(3) NOT NULL DEFAULT '0',
`email` VARCHAR(150) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`joined` INT(10) NOT NULL DEFAULT '0',
`ip_address` VARCHAR(46) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`skin` SMALLINT(5) NULL DEFAULT NULL,
`warn_level` INT(10) NULL DEFAULT NULL,
`warn_lastwarn` INT(10) NOT NULL DEFAULT '0',
`language` MEDIUMINT(4) NULL DEFAULT NULL,
`restrict_post` INT(10) NOT NULL DEFAULT '0',
`bday_day` INT(2) NULL DEFAULT NULL,
`bday_month` INT(2) NULL DEFAULT NULL,
`bday_year` INT(4) NULL DEFAULT NULL,
`msg_count_new` INT(2) NOT NULL DEFAULT '0',
`msg_count_total` INT(3) NOT NULL DEFAULT '0',
`msg_count_reset` INT(1) NOT NULL DEFAULT '0',
`msg_show_notification` INT(1) NOT NULL DEFAULT '0',
`last_visit` INT(10) NULL DEFAULT '0',
`last_activity` INT(10) NULL DEFAULT '0',
`mod_posts` INT(10) NOT NULL DEFAULT '0',
`auto_track` VARCHAR(256) NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_ci',
`temp_ban` INT(10) NULL DEFAULT '0',
`mgroup_others` VARCHAR(245) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`member_login_key` VARCHAR(32) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`member_login_key_expire` INT(10) NOT NULL DEFAULT '0',
`members_seo_name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`members_cache` MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
`failed_logins` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`failed_login_count` SMALLINT(3) NOT NULL DEFAULT '0',
`members_profile_views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`members_pass_hash` VARCHAR(60) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`members_pass_salt` VARCHAR(22) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`members_bitoptions` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`fb_uid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`members_day_posts` VARCHAR(32) NOT NULL DEFAULT '0,0' COLLATE 'utf8mb4_unicode_ci',
`live_id` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`twitter_id` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`twitter_token` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`twitter_secret` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`notification_cnt` MEDIUMINT(9) NOT NULL DEFAULT '0',
`fb_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`ipsconnect_id` INT(10) NOT NULL DEFAULT '0',
`google_id` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`linkedin_id` VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_last_visitors` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_main_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_main_width` INT(5) NULL DEFAULT NULL,
`pp_main_height` INT(5) NULL DEFAULT NULL,
`pp_thumb_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_thumb_width` INT(5) NULL DEFAULT NULL,
`pp_thumb_height` INT(5) NULL DEFAULT NULL,
`pp_setting_count_comments` INT(2) NULL DEFAULT NULL,
`pp_reputation_points` INT(10) NULL DEFAULT NULL,
`pp_gravatar` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_photo_type` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`signature` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`pconversation_filters` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`fb_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`fb_photo_thumb` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`fb_bwoptions` INT(10) NULL DEFAULT NULL,
`tc_last_sid_import` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`tc_photo` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`tc_bwoptions` INT(10) NULL DEFAULT NULL,
`pp_customization` MEDIUMTEXT NULL COLLATE 'utf8mb4_unicode_ci',
`timezone` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`pp_cover_photo` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`profilesync` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`profilesync_lastsync` INT(10) NOT NULL DEFAULT '0' COMMENT 'Indicates the last time any profile sync service was ran',
`google_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`linkedin_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`live_token` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`allow_admin_mails` BIT(1) NULL DEFAULT b'0',
`members_bitoptions2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`create_menu` TEXT NULL COMMENT 'Cached contents of the "Create" drop down menu.' COLLATE 'utf8mb4_unicode_ci',
`ipsconnect_revalidate_url` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`members_disable_pm` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 - not disabled, 1 - disabled, member can re-enable, 2 - disabled',
`marked_site_read` INT(10) UNSIGNED NULL DEFAULT '0',
`pp_cover_offset` INT(10) NOT NULL DEFAULT '0',
`acp_skin` SMALLINT(6) NULL DEFAULT NULL,
`acp_language` MEDIUMINT(9) NULL DEFAULT NULL,
`member_title` VARCHAR(64) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`member_posts` MEDIUMINT(7) NOT NULL DEFAULT '0',
`member_last_post` INT(10) NULL DEFAULT NULL,
`idm_block_submissions` TINYINT(1) UNSIGNED NULL DEFAULT '0' COMMENT 'Blocked from submitting IP.Downloads files?',
`cm_credits` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`cm_no_sev` TINYINT(1) NULL DEFAULT '0',
`cm_return_group` SMALLINT(3) NULL DEFAULT '0',
`st_id` BIGINT(40) NULL DEFAULT NULL,
`vk_id` BIGINT(20) NULL DEFAULT NULL,
`vk_token` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
`member_streams` TEXT NULL COLLATE 'utf8mb4_unicode_ci',
`photo_last_update` INT(10) NULL DEFAULT NULL,
`invites_remaining` INT(10) NULL DEFAULT '0',
`invite_offset` INT(10) NULL DEFAULT '0',
`invited_by` MEDIUMINT(8) NULL DEFAULT '0',
PRIMARY KEY (`member_id`),
INDEX `bday_day` (`bday_day`),
INDEX `bday_month` (`bday_month`),
INDEX `members_bitoptions` (`members_bitoptions`),
INDEX `ip_address` (`ip_address`),
INDEX `failed_login_count` (`failed_login_count`),
INDEX `joined` (`joined`),
INDEX `fb_uid` (`fb_uid`),
INDEX `twitter_id` (`twitter_id`(191)),
INDEX `email` (`email`),
INDEX `member_groups` (`member_group_id`, `mgroup_others`(188)),
INDEX `google_id` (`google_id`),
INDEX `linkedin_id` (`linkedin_id`),
INDEX `mgroup` (`member_id`, `member_group_id`),
INDEX `allow_admin_mails` (`allow_admin_mails`),
INDEX `name_index` (`name`(191)),
INDEX `ipsconnect_id` (`ipsconnect_id`),
INDEX `mod_posts` (`mod_posts`),
INDEX `photo_last_update` (`photo_last_update`)
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=96
;
Вот моя структура , покажите свою для сравнения и вообще есть встроенный инструмент в ипб не помню где