[Upgrade] - errors in the table "core_members"

[Helda]

Hello.

Good afternoon. I ran the update to 4.0, and the first step there is an error:

(Upgrader step1) Out of range value for column 'restrict_post' at row 1 INSERT INTO `ibf_core_members_temp` ( `member_id`, `name`, `member_group_id`, `email`, `joined`, `ip_address`, `allow_admin_mails`, `skin`, `warn_level`, `warn_lastwarn`, `language`, `restrict_post`, `bday_day`, `bday_month`, `bday_year`, `msg_count_new`, `msg_count_total`, `msg_count_reset`, `msg_show_notification`, `misc`, `last_visit`, `last_activity`, `mod_posts`, `auto_track`, `temp_ban`, `mgroup_others`, `member_login_key`, `member_login_key_expire`, `has_blog`, `has_gallery`, `members_seo_name`, `members_cache`, `members_disable_pm`, `failed_logins`, `failed_login_count`, `members_profile_views`, `gallery_perms`, `is_spammer`, `members_pass_hash`, `members_pass_salt`, `members_bitoptions`, `fb_uid`, `members_day_posts`, `live_id`, `twitter_id`, `twitter_token`, `twitter_secret`, `notification_cnt`, `fb_token`, `vk_uid`, `vk_token`, `blogs_recache`, `ipsconnect_id`, `ipsconnect_revalidate_url`, `shoutbox_shouts`, `pp_last_visitors`, `pp_main_photo`, `pp_main_width`, `pp_main_height`, `pp_thumb_photo`, `pp_thumb_width`, `pp_thumb_height`, `pp_setting_count_comments`, `notes`, `signature`, `pconversation_filters`, `fb_photo`, `fb_photo_thumb`, `fb_bwoptions`, `pp_reputation_points`, `pp_gravatar`, `pp_photo_type`, `tc_last_sid_import`, `tc_photo`, `tc_bwoptions`, `pp_customization`, `vk_bwoptions`, `pp_cover_photo`, `member_posts`, `member_title`, `member_last_post`, `marked_site_read`, `timezone` ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )#0 

After clicking Continue installation continues  but went a little further by appearing multiple errors in the processing changes of the table to Members.

Tell me what are the means of verifying the integrity and accuracy of the table to Members, or how to determine which  of a row in the source table containing incorrect data.

 

[TSP]

You should submit a support ticket if this is a live installation.

Do you find any information about which member triggers this error? You might find more information if you look in the uploads/logs-folder and look for any file that mentions upgrade and / or error in the file name. 

It would be interesting to know the former restrict_post-value from the IPS 3.4-installation for a member this error is given on. I think you should find it with 

SELECT restrict_post FROM ippbe_members WHERE member_id=X

Where you replace X with the member id.