Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Laravel MySQL DB migrations failing since version 2.10.0 #3789

Closed
bartjuh4 opened this issue Dec 20, 2019 · 3 comments
Closed

Laravel MySQL DB migrations failing since version 2.10.0 #3789

bartjuh4 opened this issue Dec 20, 2019 · 3 comments

Comments

@bartjuh4
Copy link

bartjuh4 commented Dec 20, 2019

Bug Report

Laravel Database Migrations failing since dbal upgrade from 2.9.2 to 2.10.0:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CHARACTER SET utf8mb4 NOT NULL COLLATE utf8mb4_unicode_ci' at line 1 (SQL: ALTER TABLE user_federations CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT CHARACTER S
ET utf8mb4 NOT NULL COLLATE utf8mb4_unicode_ci)

Current behaviour

When you have a string field and change it to a bigInteger field strange character set errors are occurring.

How to reproduce

Create a Laravel db migration with an string column and make another migration with a change to that column where you change it to bigInteger.

@lcobucci
Copy link
Member

As discussed in laravel/framework#30539 this is being handled in Laravel.

@lcobucci
Copy link
Member

Closing as duplicate of #3714

@github-actions
Copy link

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jul 30, 2022
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants