(5.66 upgrade error) Action Schedule field is too short
civicrm_action_schedule
.name
is currently VARCHAR(64)
.
In the upgrade:
Incremental/sql/5.66.alpha1.mysql.tpl
has the statement:
UPDATE `civicrm_action_schedule` a1, `civicrm_action_schedule` a2
SET a2.name = CONCAT(a2.name, '_', a2.id)
WHERE a2.name = a1.name AND a2.id > a1.id;
However, the name can quite easily already be 64 characters, so this causes a data too long
error.
Additionally, CRM/Upgrade/Incremental/php/FiveSixtySix.php
has the following line:
$this->addTask('Make ActionSchedule.name required', 'alterColumn', 'civicrm_action_schedule', 'name', "varchar(64) NOT NULL COMMENT 'physical tablename for entity being joined to discount, e.g. civicrm_event'");
So if you manually alter your table, the varchar(64)
portion of this causes it to break again. I was able to finish the incomplete upgrade via cv
with --skip
.