Homarr•12mo ago

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•12mo ago

@Meierschlumpf

Solution

MuscularCrab•12mo 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

Gaming

Programming

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