HomarrH
Homarr•2y 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'


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)


(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.

The fix was to mount my CIFS in the following way:

//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
Jump to solution
Was this page helpful?