starred/koel-koel

Fork 0

mirror of https://github.com/koel/koel.git synced 2026-04-25 16:56:02 +03:00

[GH-ISSUE #1611] DB errors #886

New issue

Closed

opened 2026-02-26 02:34:32 +03:00 by kerem · 6 comments

kerem commented

2026-02-26 02:34:32 +03:00

Owner

Originally created by @henrym94 on GitHub (Dec 2, 2022).
Original GitHub issue: https://github.com/koel/koel/issues/1611

When i run "php artisan koel:init"

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'name' (max = 16383);

how can i fix this? thanks

Originally created by @henrym94 on GitHub (Dec 2, 2022). Original GitHub issue: https://github.com/koel/koel/issues/1611 When i run "php artisan koel:init" Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'name' (max = 16383); how can i fix this? thanks

kerem closed this issue

2026-02-26 02:34:32 +03:00

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@nebulade commented on GitHub (Dec 3, 2022):

Was just about to report this as well. In our case this is on mysql v8.
It seems to be hitting https://github.com/koel/koel/blob/master/database/migrations/2021_12_06_164648_increase_string_columns_length.php#L16 although this has not changed since a long time, so maybe some dependency update causes this?

@nebulade commented on GitHub (Dec 3, 2022): Was just about to report this as well. In our case this is on mysql v8. It seems to be hitting https://github.com/koel/koel/blob/master/database/migrations/2021_12_06_164648_increase_string_columns_length.php#L16 although this has not changed since a long time, so maybe some dependency update causes this?

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@jSML4ThWwBID69YC commented on GitHub (Dec 4, 2022):

Here too.

Running php artisan koel:init --no-assets

Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'name' (max = 16383); use BLOB or TEXT instead (SQL: ALTER TABLE artists CHANGE name name VARCHAR(65504) CHA
RACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`) in /apps/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:759

I'm using Galera on MariaDB 10.6.
The issue started with v6.8.2 and exists in v6.8.3. Version 6.8.1 works fine.

@jSML4ThWwBID69YC commented on GitHub (Dec 4, 2022): Here too. Running _php artisan koel:init --no-assets_ ``` Next Illuminate\Database\QueryException: SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'name' (max = 16383); use BLOB or TEXT instead (SQL: ALTER TABLE artists CHANGE name name VARCHAR(65504) CHA RACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`) in /apps/koel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:759 ``` I'm using Galera on MariaDB 10.6. The issue started with v6.8.2 and exists in v6.8.3. Version 6.8.1 works fine.

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@henrym94 commented on GitHub (Dec 4, 2022):

@phanan

@henrym94 commented on GitHub (Dec 4, 2022): @phanan

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@phanan commented on GitHub (Dec 4, 2022):

Looking into it.

@phanan commented on GitHub (Dec 4, 2022): Looking into it.

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@phanan commented on GitHub (Dec 4, 2022):

Fixed (I think) and released in v6.8.4. Thanks everyone for reporting the issue :)

@phanan commented on GitHub (Dec 4, 2022): Fixed (I think) and released in v6.8.4. Thanks everyone for reporting the issue :)

kerem commented

2026-02-26 02:34:32 +03:00

Author

Owner

@nebulade commented on GitHub (Dec 5, 2022):

Thanks for the quick fix, I can confirm it is resolved for us.

@nebulade commented on GitHub (Dec 5, 2022): Thanks for the quick fix, I can confirm it is resolved for us.

kerem referenced this issue

2026-02-26 03:30:56 +03:00

[PR #886] [MERGED] Non interactive koel:init #1417

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

starred/koel-koel#886

No description provided.

Rows
Columns