Skip to content

SQL exception when we try to rename a year column #38506

Closed
@fgaroby

Description

@fgaroby
  • Laravel Version: 6.2
  • PHP Version: 7.4.16
  • Database Driver & Version: MySQL 8.0.26

Description:

When I try to rename a year column, I have this SQL exception :
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '2002' for column 'dfasp' at row 1 (SQL: ALTER TABLE apotiko_replaced_resumes CHANGE dfsap dfasp DATE DEFAULT NULL)

Steps To Reproduce:

  1. Create a migration script, with an year column, named "dfsap"
  2. Create another migration script, which tries to rename "dfsap" to "dfasp"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions