[GH-ISSUE #418] Koel tests #298

New issue

Closed

opened 2026-02-26 02:32:44 +03:00 by kerem · 2 comments

kerem commented

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

Owner

Originally created by @BernardGoldberger on GitHub (Aug 21, 2016).
Original GitHub issue: https://github.com/koel/koel/issues/418

Windows, sqlite, Master

I'm unable to to get successful unit testing, here is the error I keep running into.

PHPUnit 5.5.2 by Sebastian Bergmann and contributors.                                                                                                                                                                

F....E..                                                            8 / 8 (100%)                                                                                                                                     

Time: 1.59 seconds, Memory: 24.00MB                                                                                                                                                                                  

There was 1 error:                                                                                                                                                                                                   

1) MediaTest::testWatchSingleFileDeleted                                                                                                                                                                             
Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: songs.id (SQL: insert into "songs" ("title", "length", "track", "lyrics", "path", "mtime", "album_i
d", "id", "updated_at", "created_at") values (Eos et iusto modi velit., 346.03, 377496, At nam sed sapiente dolores ullam velit ea. Sed culpa harum impedit ut quo rerum. Aut eos expedita aut perspiciatis., /tmp/57
b9e91596743.mp3, 1471801621, 2, b8d52ec6629713c7719d6bb71c2603d8, 2016-08-21 17:47:01, 2016-08-21 17:47:01))                                                                                                         

C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:729                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:685                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:414                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2066                                                                                                                           
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:1423                                                                                                                        
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1604                                                                                                                          
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1488                                                                                                                          
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\FactoryBuilder.php:90                                                                                                                   
C:\wamp64\www\koel\tests\TestCase.php:79                                                                                                                                                                             
C:\wamp64\www\koel\tests\MediaTest.php:172                                                                                                                                                                           

Caused by                                                                                                                                                                                                            
PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: songs.id                                                                                                                 

C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:457                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:722                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:685                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:414                                                                                                                               
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2066                                                                                                                           
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:1423                                                                                                                        
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1604                                                                                                                          
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1488                                                                                                                          
C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\FactoryBuilder.php:90                                                                                                                   
C:\wamp64\www\koel\tests\TestCase.php:79                                                                                                                                                                             
C:\wamp64\www\koel\tests\MediaTest.php:172

Originally created by @BernardGoldberger on GitHub (Aug 21, 2016). Original GitHub issue: https://github.com/koel/koel/issues/418 Windows, sqlite, Master I'm unable to to get successful unit testing, here is the error I keep running into. ``` php PHPUnit 5.5.2 by Sebastian Bergmann and contributors. F....E.. 8 / 8 (100%) Time: 1.59 seconds, Memory: 24.00MB There was 1 error: 1) MediaTest::testWatchSingleFileDeleted Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: songs.id (SQL: insert into "songs" ("title", "length", "track", "lyrics", "path", "mtime", "album_i d", "id", "updated_at", "created_at") values (Eos et iusto modi velit., 346.03, 377496, At nam sed sapiente dolores ullam velit ea. Sed culpa harum impedit ut quo rerum. Aut eos expedita aut perspiciatis., /tmp/57 b9e91596743.mp3, 1471801621, 2, b8d52ec6629713c7719d6bb71c2603d8, 2016-08-21 17:47:01, 2016-08-21 17:47:01)) C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:729 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:685 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:414 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2066 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:1423 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1604 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1488 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\FactoryBuilder.php:90 C:\wamp64\www\koel\tests\TestCase.php:79 C:\wamp64\www\koel\tests\MediaTest.php:172 Caused by PDOException: SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: songs.id C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:457 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:722 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:685 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:414 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Query\Builder.php:2066 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php:1423 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1604 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:1488 C:\wamp64\www\koel\vendor\laravel\framework\src\Illuminate\Database\Eloquent\FactoryBuilder.php:90 C:\wamp64\www\koel\tests\TestCase.php:79 C:\wamp64\www\koel\tests\MediaTest.php:172 ```

kerem closed this issue

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

kerem commented

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

Author

Owner

@BernardGoldberger commented on GitHub (Sep 18, 2016):

@phanan I cant seem to get around this issue and can't figure out why.

@BernardGoldberger commented on GitHub (Sep 18, 2016): @phanan I cant seem to get around this issue and can't figure out why.

kerem commented

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

Author

Owner

@phanan commented on GitHub (Sep 19, 2016):

Must be another Windows-specific issue, too bad I don't have a proper Windows env to test it now. Just ignore these two issues during your development for now.

@phanan commented on GitHub (Sep 19, 2016): Must be another Windows-specific issue, too bad I don't have a proper Windows env to test it now. Just ignore these two issues during your development for now.

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

No description provided.

Rows
Columns