You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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
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 toInnoDB
andInnoDB 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.
The text was updated successfully, but these errors were encountered: