Error running migration SQL for history

michaelliu — Tue, 29 Oct 2019 06:35:25 GMT

I have a Spring application running Activiti 5.9 on MySQL 5.7. I want to upgrade to Spring boot 2 with Activiti 7 starter 7.1.97. But got error trying to run activiti.mysql.upgradestep.514.to.515.history.sql on line https://github.com/Activiti/Activiti/blob/develop/activiti-engine/src/main/resources/org/activiti/db/upgrade/activiti.mysql.upgradestep.514.to.515.history.sql#L14. The error is MySQL Incorrect datetime value: '0000-00-00 00:00:00'. It seems MySQL 5.7 rejects not null datetime column without explicit default value.

Can anyone please help get this through? Thanks

topic Error running migration SQL for history in Alfresco Forum