Upgrade fails below error

CRM_Core_Exception: 1265 ALTER TABLE `civicrm_managed` CHANGE `cleanup` `cleanup` varchar(16) NOT NULL DEFAULT 'always' COMMENT 'Policy on when to cleanup entity (always, never, unused)' [nativecode=1265 ** Data truncated for column 'cleanup' at row 62] in /var/www/html/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php on line 101

2 Answers 2


Try updating the database with below query before the upgrade and then run Civi update

UPDATE civicrm_managed
SET cleanup = 'always'
WHERE cleanup IS NULL;
  • Thank you Pradeep. I set cleanup to never Feb 22 at 10:52

It sounds like you have some weird data in that column. The new maxlength is 16 which is plenty long for the 3 possible values (always, never, or unused). Can you check your existing data & see what's in there?

  • Yeah, seems to be odd data in civicrm_managed table. It was set to NULL changed it to never using sql query Feb 22 at 10:51

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.