[GH-ISSUE #1389] Synchronization interrupted : value too long ... #795

New issue

Closed

opened 2026-02-26 02:34:17 +03:00 by kerem · 0 comments

kerem commented

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

Owner

Originally created by @kazukyakayashi on GitHub (Dec 5, 2021).
Original GitHub issue: https://github.com/koel/koel/issues/1389

Describe the bug
The synchronization stops when there are "too many" artists in the metadata of some audio tracks

php artisan koel:sync
Syncing media from /mnt/usb

 2117/4435 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░]  47%
   Illuminate\Database\QueryException

  SQLSTATE[22001]: String data, right truncated: 7 ERROR:  value too long for type character varying(191) (SQL: insert into "artists" ("name", "updated_at", "created_at") values (James Brown; Ron Tooley; Joe Dupars; Levi Rasbury; Mike Ridley; Nat Jones; St. Clair Pinckney; L.D. 'Eldee' Williams; Al “Brisco” Clark; Maceo Parker; Jimmy Nolen; alphonso williams; David Williams; Melvin Parker, 2021-12-05 18:34:44, 2021-12-05 18:34:44) returning "id")

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703
    699▕         // If an exception occurs when attempting to run a query, we'll format the error
    700▕         // message to include the bindings with SQL, which will make this exception a
    701▕         // lot more helpful to the developer instead of just the database's errors.
    702▕         catch (Exception $e) {
  ➜ 703▕             throw new QueryException(
    704▕                 $query, $this->prepareBindings($bindings), $e
    705▕             );
    706▕         }
    707▕     }

      +21 vendor frames
  22  app/Models/Artist.php:64
      Illuminate\Database\Eloquent\Model::__callStatic()

  23  app/Services/FileSynchronizer.php:187
      App\Models\Artist::getOrCreate()

Environment

Koel version 5.1.8
OS: ubuntu serveur on Raspberry 3
PHP version 8.0.8
Node version v16
Run with Postgresql

Originally created by @kazukyakayashi on GitHub (Dec 5, 2021). Original GitHub issue: https://github.com/koel/koel/issues/1389 **Describe the bug** The synchronization stops when there are "too many" artists in the metadata of some audio tracks ```php php artisan koel:sync Syncing media from /mnt/usb 2117/4435 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░] 47% Illuminate\Database\QueryException SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(191) (SQL: insert into "artists" ("name", "updated_at", "created_at") values (James Brown; Ron Tooley; Joe Dupars; Levi Rasbury; Mike Ridley; Nat Jones; St. Clair Pinckney; L.D. 'Eldee' Williams; Al “Brisco” Clark; Maceo Parker; Jimmy Nolen; alphonso williams; David Williams; Melvin Parker, 2021-12-05 18:34:44, 2021-12-05 18:34:44) returning "id") at vendor/laravel/framework/src/Illuminate/Database/Connection.php:703 699▕ // If an exception occurs when attempting to run a query, we'll format the error 700▕ // message to include the bindings with SQL, which will make this exception a 701▕ // lot more helpful to the developer instead of just the database's errors. 702▕ catch (Exception $e) { ➜ 703▕ throw new QueryException( 704▕ $query, $this->prepareBindings($bindings), $e 705▕ ); 706▕ } 707▕ } +21 vendor frames 22 app/Models/Artist.php:64 Illuminate\Database\Eloquent\Model::__callStatic() 23 app/Services/FileSynchronizer.php:187 App\Models\Artist::getOrCreate() ``` **Environment** - Koel version 5.1.8 - OS: ubuntu serveur on Raspberry 3 - PHP version 8.0.8 - Node version v16 - Run with Postgresql

kerem

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

closed this issue
added the
[Type] Bug
label

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

No description provided.

Rows
Columns