[GH-ISSUE #1453] Koel Sync error - SQLSTATE[HY000]: General error: 1 no such table: info #829

New issue

Closed

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

kerem commented

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

Owner

Originally created by @ch1nch4ch4 on GitHub (May 20, 2022).
Original GitHub issue: https://github.com/koel/koel/issues/1453

I am trying to sync media via the command link using php artisan koel:sync and I keep getting the below error. Although I get the below error, music does appear after 5-10 mins in Koel.


  at vendor/teamtnt/tntsearch/src/TNTSearch.php:399
    395▕ 
    396▕     public function getValueFromInfoTable($value)
    397▕     {
    398▕         $query = "SELECT * FROM info WHERE key = '$value'";
  ➜ 399▕         $docs  = $this->index->query($query);
    400▕ 
    401▕         if ($ret = $docs->fetch(PDO::FETCH_ASSOC)) {
    402▕             return $ret['value'];
    403▕         }

  +20 vendor frames 
  21  app/Services/FileSynchronizer.php:198
      Illuminate\Database\Eloquent\Model::__callStatic()

 22  app/Services/MediaSyncService.php:95
      App\Services\FileSynchronizer::sync()

To reproduce
Steps to reproduce the behavior:

docker exec --user www-data -it koel bash
php artisan koel:sync

Expected behavior
Sync Music to Koel Server without error

Screenshots
Screenshot

Environment

DOCKER Docker version 19.03.13, build 4484c46d9d

Ansible deploys the containers - main config for each below

KOEL

docker_container:
    name: koel
    image: "phanan/koel:latest"
    pull: yes
    published_ports:
      - "127.0.0.1:800:80"
    env:
      BACKUP: "no"
      FORCE_HTTPS : "true"
      DB_CONNECTION: "mysql"
      DB_HOST : "mysql"
      DB_USERNAME : "koel"
      DB_PASSWORD : "samplePW"
      DB_DATABASE : "koel"
      PUID: "{{ uid }}"
      PGID: "{{ gid }}"
      UMASK: 002
      VIRTUAL_HOST: "koel.{{ user.domain }}"
      VIRTUAL_PORT: 80
      LETSENCRYPT_HOST: "koel.{{ user.domain }}"
      LETSENCRYPT_EMAIL: "{{ user.email }}"
      TZ: "{{ tz }}"
    volumes: "{{ default_volumes }}"
    labels:
     "com.github.cloudbox.cloudbox_managed": "true"
   networks:
      - name: koelnetwork
        aliases:
        - koel

MYSQL

docker_container:
    name: mysql
    image: "mysql"
    pull: yes
    env:
      TZ: "{{ tz }}"
      PUID: "{{ uid }}"
      PGID: "{{ gid }}"
      LOG_LEVEL: DEBUG
      MYSQL_DATABASE : "koel"
      MYSQL_USER : "koel"
      MYSQL_PASSWORD : "samplePW"
      MYSQL_ROOT_PASSWORD: "samplePW"
    volumes:
      - /opt/mysql/data:/var/lib/mysql
    labels:
      "com.github.cloudbox.cloudbox_managed": "true"
    networks:
      - name: koelnetwork
        aliases:
          - mysql

RClone Mount - Config

[Unit]
Description=Rclone VFS dibdab-t-en-01 Mount
After=network-online.target

[Service]
User=serveruser
Group=serveruser
Type=notify
ExecStartPre=/bin/sleep 10
ExecStart=/usr/bin/rclone mount \
  --user-agent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36' \
  --config=/home/serveruser/.config/rclone/rclone.conf \
  --allow-other \
  --allow-non-empty \
  --drive-skip-gdocs \
  --vfs-read-chunk-size=64M \
  --vfs-read-chunk-size-limit=2048M \
  --buffer-size=64M \
  --poll-interval=1m \
  --dir-cache-time=168h \
  --timeout=10m \
  --drive-chunk-size=64M \
  --vfs-cache-mode=writes \
  --umask=002 \
  --syslog \
  --use-mmap \
  -v \
  koel-music: /mnt/remote/koel
ExecStop=/bin/fusermount -uz /mnt/remote/koel
Restart=on-abort
RestartSec=5
StartLimitInterval=60s
StartLimitBurst=3

[Install]
WantedBy=default.target

Additional context
Add any other context about the problem here.

Originally created by @ch1nch4ch4 on GitHub (May 20, 2022). Original GitHub issue: https://github.com/koel/koel/issues/1453 I am trying to sync media via the command link using `php artisan koel:sync` and I keep getting the below error. Although I get the below error, music does appear after 5-10 mins in Koel. ```SQLSTATE[HY000]: General error: 1 no such table: info at vendor/teamtnt/tntsearch/src/TNTSearch.php:399 395▕ 396▕ public function getValueFromInfoTable($value) 397▕ { 398▕ $query = "SELECT * FROM info WHERE key = '$value'"; ➜ 399▕ $docs = $this->index->query($query); 400▕ 401▕ if ($ret = $docs->fetch(PDO::FETCH_ASSOC)) { 402▕ return $ret['value']; 403▕ } +20 vendor frames 21 app/Services/FileSynchronizer.php:198 Illuminate\Database\Eloquent\Model::__callStatic() 22 app/Services/MediaSyncService.php:95 App\Services\FileSynchronizer::sync() ``` **To reproduce** Steps to reproduce the behavior: 1. docker exec --user www-data -it koel bash 2. php artisan koel:sync **Expected behavior** Sync Music to Koel Server without error **Screenshots** [Screenshot](https://paste.pics/be29920814f39cd0ec13c8711a4384aa) **Environment** DOCKER `Docker version 19.03.13, build 4484c46d9d` Ansible deploys the containers - main config for each below KOEL ``` docker_container: name: koel image: "phanan/koel:latest" pull: yes published_ports: - "127.0.0.1:800:80" env: BACKUP: "no" FORCE_HTTPS : "true" DB_CONNECTION: "mysql" DB_HOST : "mysql" DB_USERNAME : "koel" DB_PASSWORD : "samplePW" DB_DATABASE : "koel" PUID: "{{ uid }}" PGID: "{{ gid }}" UMASK: 002 VIRTUAL_HOST: "koel.{{ user.domain }}" VIRTUAL_PORT: 80 LETSENCRYPT_HOST: "koel.{{ user.domain }}" LETSENCRYPT_EMAIL: "{{ user.email }}" TZ: "{{ tz }}" volumes: "{{ default_volumes }}" labels: "com.github.cloudbox.cloudbox_managed": "true" networks: - name: koelnetwork aliases: - koel ``` MYSQL ``` docker_container: name: mysql image: "mysql" pull: yes env: TZ: "{{ tz }}" PUID: "{{ uid }}" PGID: "{{ gid }}" LOG_LEVEL: DEBUG MYSQL_DATABASE : "koel" MYSQL_USER : "koel" MYSQL_PASSWORD : "samplePW" MYSQL_ROOT_PASSWORD: "samplePW" volumes: - /opt/mysql/data:/var/lib/mysql labels: "com.github.cloudbox.cloudbox_managed": "true" networks: - name: koelnetwork aliases: - mysql ``` RClone Mount - Config ``` [Unit] Description=Rclone VFS dibdab-t-en-01 Mount After=network-online.target [Service] User=serveruser Group=serveruser Type=notify ExecStartPre=/bin/sleep 10 ExecStart=/usr/bin/rclone mount \ --user-agent='Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.131 Safari/537.36' \ --config=/home/serveruser/.config/rclone/rclone.conf \ --allow-other \ --allow-non-empty \ --drive-skip-gdocs \ --vfs-read-chunk-size=64M \ --vfs-read-chunk-size-limit=2048M \ --buffer-size=64M \ --poll-interval=1m \ --dir-cache-time=168h \ --timeout=10m \ --drive-chunk-size=64M \ --vfs-cache-mode=writes \ --umask=002 \ --syslog \ --use-mmap \ -v \ koel-music: /mnt/remote/koel ExecStop=/bin/fusermount -uz /mnt/remote/koel Restart=on-abort RestartSec=5 StartLimitInterval=60s StartLimitBurst=3 [Install] WantedBy=default.target ``` **Additional context** Add any other context about the problem here.

kerem closed this issue

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

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

No description provided.

Rows
Columns