Koel Sync error - SQLSTATE[HY000]: General error: 1 no such table: info
ch1nch4ch4 opened this issue · 0 comments
ch1nch4ch4 commented
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.