H
Homarr•13mo ago
MuscularCrab

Fresh Install - Error [TRPCClientError]: no such table: user

G'Day all! Migrating Homarr from Docker for Desktop (Windows) to a new Ubuntu machine. Everything freshly installed on Ubuntu. Docker-compose: 
version: '3'
#---------------------------------------------------------------------#
#     Homarr - A simple, yet powerful dashboard for your server.     #
#---------------------------------------------------------------------#
services:
  homarr:
    container_name: homarrboard
    image: ghcr.io/ajnart/homarr:latest
    restart: unless-stopped
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock # Optional, only if you want docker integration
      - /mnt/v/linuxdata/homarr/configs:/app/data/configs
      - /mnt/v/linuxdata/homarr/icons:/app/public/icons
      - /mnt/v/linuxdata/homarr/data:/data
    ports:
      - '7575:7575'
version: '3'
#---------------------------------------------------------------------#
#     Homarr - A simple, yet powerful dashboard for your server.     #
#---------------------------------------------------------------------#
services:
  homarr:
    container_name: homarrboard
    image: ghcr.io/ajnart/homarr:latest
    restart: unless-stopped
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock # Optional, only if you want docker integration
      - /mnt/v/linuxdata/homarr/configs:/app/data/configs
      - /mnt/v/linuxdata/homarr/icons:/app/public/icons
      - /mnt/v/linuxdata/homarr/data:/data
    ports:
      - '7575:7575'
When starting Homarr from docker run or docker-compose, I get the error: 
Error [TRPCClientError]: no such table: user

    at TRPCClientError.from (file:///app/.next/server/src/middleware.js:1718:20)

    at <unknown> (file:///app/.next/server/src/middleware.js:2273:60)

    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
Error [TRPCClientError]: no such table: user

    at TRPCClientError.from (file:///app/.next/server/src/middleware.js:1718:20)

    at <unknown> (file:///app/.next/server/src/middleware.js:2273:60)

    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
(Among other errors) Lurked on Github and here and seen similar issues. Looks like deleting/replacing the db.sqlite file has fixed it for most people but no luck on my end. I've tried: - copying the data/icons/configs folders from my old instance - no luck - Repulling the image (even homarr-dev) - no luck - Deleting everything in working folder - no luck - Replacing the db.sqlite file with someone elses (Worked for others) - no luck Apparently this was fixed in the latest version but not for me 😭 Anyone able to assist? Love yall Full error log: https://pastebin.com/7MKAPTRF
Pastebin
Exporting hostname...Migrating database...yarn run v1.22.19$ ts-nod...
Pastebin.com is the number one paste tool since 2002. Pastebin is a website where you can store text online for a set period of time.
Solution:
Hi All, If anyone runs into this issue in the future, I had the woprking folder connected via CIFS (SMB) to a Windows server....
Jump to solution
2 Replies
Manicraft1001
Manicraft1001•13mo ago
@Meierschlumpf
Solution
MuscularCrab
MuscularCrab•13mo ago
Hi All, If anyone runs into this issue in the future, I had the woprking folder connected via CIFS (SMB) to a Windows server. The fix was to mount my CIFS in the following way: 
//myserver /mymount cifs username=*,password=*,nobrl,uid=1000,gid=1000
//myserver /mymount cifs username=*,password=*,nobrl,uid=1000,gid=1000
Feel free to DM if u have this issue and I can explain further> Cheers

Did you find this page helpful?