Reply to thread

I guess this is very similar to this bug / behaviour: https://xenforo.com/community/threads/data-truncated-for-column-user_state-at-row-888.134077/

When upgrading through CLI from 1.5.21 to 2.2 beta 3, i got the following error:

In AbstractStatement.php line 228:

xf_user_privacy: MySQL query error [1265]: Data truncated for column 'allow_post_profile' at row 17012

Exception query:

                                                                                                                                                                                                                  

ALTER TABLE xf_user_privacy

MODIFY COLUMN allow_post_profile ENUM('members', 'followed', 'none') NOT NULL DEFAULT 'members',

MODIFY COLUMN allow_send_personal_conversation ENUM('members', 'followed', 'none') NOT NULL DEFAULT 'members'

This happened at step 20 of upgrading to 2.2.0 Alpha