Skip to content

Koel Sync error - SQLSTATE[HY000]: General error: 1 no such table: info #143

@ch1nch4ch4

Description

@ch1nch4ch4

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:

  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

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions