When trying to upgrade CiviCRM from 5.58.1 to 5.67.0 fails with

  ALTER TABLE `civicrm_note` CHANGE `privacy` `privacy` varchar(255) NOT NULL DEFAULT 0 COMMENT 'Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)' [nativecode=1265 ** Data truncated for column   
  'privacy' at row 2018] 

1 Answer 1


Try updating the database with below query

UPDATE civicrm_note
SET privacy = 0
WHERE privacy IS NULL;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.