1

When trying to upgrade CiviCRM from 5.58.1 to 5.67.0 fails with

1265                                                                                                                                                                                                                                       
  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

3

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.