dawarich icon indicating copy to clipboard operation
dawarich copied to clipboard

New setup wont import points in dawarich

Open ArneNaessens opened this issue 7 months ago • 1 comments

OS & Hardware Proxmox host with debian vm on it Dawarich installed behind nginx reverse proxy using docker compose

Version Provide the version of Dawarich you're experiencing the problem on. 0.23.6

Describe the bug Clean install of dawarich using docker compose. Setup the owntrack application on my phone and entered the api url. No location shows in the app.

Whenever i try to force an update to dawarich i get the following error in my docker logs.

dawarich_sidekiq  | W, [2025-05-20T10:11:32.351399 #8]  WARN -- : ActiveRecord::StatementInvalid: PG::UndefinedColumn: ERROR:  column points.lonlat does not exist
dawarich_sidekiq  | LINE 1: SELECT 1 AS one FROM "points" WHERE "points"."lonlat" = $1 A...

To Reproduce Steps to reproduce the behavior: Go to owntrack and click the upload button

Expected behavior Points visible in dawarich

Screenshots

Logs See explination

Additional context Already had contact in discord. They asked me to run rails db:migrate. Done that but no solution.

I have also tried deleting all the volumes and restarting the app.

ArneNaessens avatar May 20 '25 10:05 ArneNaessens

column points.lonlat does not exist

indicates some database migrations (pretty old ones) were not applied. Can't tell you why unfortunately, I'd suggest reinstalling dawarich with the latest version (since your at clean slate instance) and making sure all db migrations are applied and application webui returns no errors

Freika avatar May 20 '25 17:05 Freika

After removing and reinstalling twice it started to work. Closing issue

ArneNaessens avatar Jun 04 '25 13:06 ArneNaessens