Answers.Body: <p>Try updating the database with below query</p>
  <pre><code>UPDATE civicrm_note
  SET privacy = 0
  WHERE privacy IS NULL;
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-11-13T13:37:11.437Z
Answers.LastActivityDate: 2023-11-13T13:37:11.437Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>When trying to upgrade CiviCRM from 5.58.1 to 5.67.0 fails with</p>
  <pre><code>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] 
  </code></pre>
  
Tags: <upgrade>
Title: Upgrade Civi to 5.67 failed
ThreadText: # Upgrade Civi to 5.67 failed
  
  (Asked by: username_0 on 2023-11-13)
  
  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]
  
  **Tags:** upgrade
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2023-11-13. Score: 1
  
  Try updating the database with below query
  UPDATE civicrm_note
  SET privacy = 0
  WHERE privacy IS NULL;
  
  
  ---
  
  