[GH-ISSUE #613] Problem with koel:sync #437

Closed
opened 2026-02-26 02:33:13 +03:00 by kerem · 4 comments
Owner

Originally created by @sagar3506 on GitHub (Jun 16, 2017).
Original GitHub issue: https://github.com/koel/koel/issues/613

s

[Illuminate\Database\QueryException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contributing_artist
_id' in 'field list' (SQL: insert into songs (id, title, length, t rack, lyrics, path, mtime, album_id, contributing_artist_id, up dated_at, created_at) values (87b49ead3cc4412fdce092316fbde871, Badri Ki
Dulhania, 206.86367346939, 0, , /var/www/html/koel/media/top/01. Badri Ki
Dulhania - Title Track.mp3, 1497623416, 3, 4, 2017-06-16 16:00:24, 2017-06-
16 16:00:24))

[PDOException]
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contributing_artist
_id' in 'field list'

Originally created by @sagar3506 on GitHub (Jun 16, 2017). Original GitHub issue: https://github.com/koel/koel/issues/613 ![s](https://cdn.pbrd.co/images/hf7PhZ01.png) > [Illuminate\Database\QueryException] > SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contributing_artist > _id' in 'field list' (SQL: insert into `songs` (`id`, `title`, `length`, `t > rack`, `lyrics`, `path`, `mtime`, `album_id`, `contributing_artist_id`, `up > dated_at`, `created_at`) values (87b49ead3cc4412fdce092316fbde871, Badri Ki > Dulhania, 206.86367346939, 0, , /var/www/html/koel/media/top/01. Badri Ki > Dulhania - Title Track.mp3, 1497623416, 3, 4, 2017-06-16 16:00:24, 2017-06- > 16 16:00:24)) > > > > [PDOException] > SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contributing_artist > _id' in 'field list'
kerem closed this issue 2026-02-26 02:33:13 +03:00
Author
Owner

@gamerlv commented on GitHub (Jun 16, 2017):

Sounds like not all database migrations have ran.
From your install directory run: php artisan migrate:status to check if all migrations have actually completed.
If some haven't, you can complete the process with php artisan migrate

<!-- gh-comment-id:309075602 --> @gamerlv commented on GitHub (Jun 16, 2017): Sounds like not all database migrations have ran. From your install directory run: `php artisan migrate:status` to check if all migrations have actually completed. If some haven't, you can complete the process with `php artisan migrate`
Author
Owner

@sagar3506 commented on GitHub (Jun 17, 2017):

s

<!-- gh-comment-id:309195242 --> @sagar3506 commented on GitHub (Jun 17, 2017): ![s](https://cdn.pbrd.co/images/v8MzGxBl.png)
Author
Owner

@phanan commented on GitHub (Jun 17, 2017):

Please adhere to the issue template and provide sufficient information. The issue template is there for a purpose.

<!-- gh-comment-id:309206605 --> @phanan commented on GitHub (Jun 17, 2017): Please adhere to the issue template and provide sufficient information. The issue template is there for a purpose.
Author
Owner

@sagar3506 commented on GitHub (Jun 17, 2017):

i just drop the whole database and create new one with php artisan koel:init
now its working superb thanks

<!-- gh-comment-id:309219481 --> @sagar3506 commented on GitHub (Jun 17, 2017): i just drop the whole database and create new one with `php artisan koel:init` now its working superb thanks
Sign in to join this conversation.
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#437
No description provided.