mirromutth/mysql-action

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

Opened this issue · 0 comments

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.