Skip to content

[5.x]: SQL error with m230617_070415_entrify_matrix_blocks migration #15417

@tyssen

Description

@tyssen

What happened?

Description

While attempting a Craft 5 upgrade I got the following

  1. Ran the composer upgrade successfully
  2. When running craft up it got to m230617_070415_entrify_matrix_blocks and then stopped with:

Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'postDate' at row 18
The SQL being executed was: ALTER TABLE entries ADD CONSTRAINT fk_uideqcoxvflgzpuixztokolwgbortxmtbrjs FOREIGN KEY (fieldId) REFERENCES fields (id) ON DELETE CASCADE (/var/www/html/craft/vendor/yiisoft/yii2/db/Schema.php:676)

Craft CMS version

5.2.8

PHP version

8.1

Operating system and version

Mac OSX / DDEV

Database type and version

MySQL 8.0

Image driver and version

No response

Installed plugins and versions

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions