[GH-ISSUE #591] Migrating database failure #419

New issue

Closed

opened 2026-02-26 02:33:09 +03:00 by kerem · 1 comment

kerem commented

2026-02-26 02:33:09 +03:00

Owner

Originally created by @tlebars on GitHub (May 7, 2017).
Original GitHub issue: https://github.com/koel/koel/issues/591

Hi,

I just tried to install Koel but I get an error to the final step: php artisan koel:init
Database migration fails:

[Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150) (SQL: ALTER TABLE songs CHANGE contributing_artist_id artist_id INT UNSIGNED DEFAULT NULL)

[Doctrine\DBAL\Driver\PDOException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150)

[PDOException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150)

I followed the Debian 8 tutorial to install.
yarn version: 0.23.4
node version: 7.10.0
npm version: 4.2.0

Don't really know how to fix this.

Thanks.

Originally created by @tlebars on GitHub (May 7, 2017). Original GitHub issue: https://github.com/koel/koel/issues/591 Hi, I just tried to install Koel but I get an error to the final step: php artisan koel:init Database migration fails: `[Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150) (SQL: ALTER TABLE songs CHANGE contributing_artist_id artist_id INT UNSIGNED DEFAULT NULL)` `[Doctrine\DBAL\Driver\PDOException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150)` `[PDOException] SQLSTATE[HY000]: General error: 1025 Error on rename of './koel/#sql-5028_3a' to './koel/songs' (errno: 150)` I followed the Debian 8 tutorial to install. yarn version: 0.23.4 node version: 7.10.0 npm version: 4.2.0 Don't really know how to fix this. Thanks.

kerem closed this issue

2026-02-26 02:33:09 +03:00

kerem commented

2026-02-26 02:33:09 +03:00

Author

Owner

@phanan commented on GitHub (May 8, 2017):

You're on master branch. Please switch to a stable branch instead.

@phanan commented on GitHub (May 8, 2017): You're on `master` branch. Please switch to a stable branch instead.

kerem referenced this issue

2026-02-26 02:35:57 +03:00

[PR #419] [CLOSED] Clean UserTableSeeder #1244

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#419

No description provided.

Rows
Columns