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 problems: Syntax error or access violation: 1071 Specified key was too long; max key length is 3072 bytes #29

Open
kaiserkiwi opened this issue Nov 28, 2022 · 0 comments

Comments

@kaiserkiwi
Copy link

Hi there,

I'm working on an Laravel project and wanted to start with GitHub Actions. Sadly I can't run the Actions because it always fails at the MySQL-Level with the following error

Syntax error or access violation: 1071 Specified key was too long; max key length is 3072 bytes

I googled a lot and everything that works for other people failed for me.
The weird part is that the column that is mentioned is only 1027 Bytes long. I don't think an index on this single column triples that. And in all other environments everything works fine.

I added Schema::defaultStringLength(191); to the AppServiceProvider as mentioned in so many threads, changed the engine in the database config to InnoDB and InnoDB ROW_FORMAT=DYNAMIC tried to set the charset to utf8 instead if utf8mb4 and so on.

I don't really have any idea how I could get it to work.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant