Restoration : database looks OK but the front does not show tasks

Support
1

Hello,

First, thank you for this application.
I decided to migrate from a Docker Compose configuration (with PostgreSQL) to a Proxmox container with the RPM installation (with SQLite).

The backup looks OK (done with vikunja dump).
I restore it (with vikunja restore) on the new system without errors.
The new vikunja.db looks OK when I look into it : users, projects and tasks tables are present with data in it.

But, after restarting the service, I can log in but all projects and tasks are empty.
I see this on the server : converting driver.Value type string to a float64: invalid syntax

The two versions are both v0.24.6.

Do you have any clue ?

Edit 1

There’s two requests from the front that get a HTTP 500 response :

2025-02-10T14:29:49Z: ERROR	▶ 117 converting driver.Value type string to a float64: invalid syntax
2025-02-10T14:29:49Z: WEB 	▶ xx.xx.xx.xx  GET 500 /api/v1/labels?page=1 1.084565ms - Mozilla/5.0 (X11; Linux x86_64; rv:135.0) Gecko/20100101 Firefox/135.0
2025-02-10T14:29:49Z: ERROR	▶ 11a converting driver.Value type string to a float64: invalid syntax
2025-02-10T14:29:49Z: WEB 	▶ xx.xx.xx.xx  GET 500 /api/v1/projects?is_archived=true&page=1 1.094675ms - Mozilla/5.0 (X11; Linux x86_64; rv:135.0) Gecko/20100101 Firefox/135.0
2

This sounds like a bug from the postgres export, which has since been fixed. Can you try with an unstable build? (upgrade the instance with postgres to unstable, then do the dump, then upgrade the other instance to unstable, then import the dump)

3

I update the container to the unstable version and do the dump.
For the restore part, I got this error :

2025-02-11T10:10:57Z: CRITICAL	▶ 070 Malformed version: unstable
4

That sounds like a bug. What’s the output of docker compose exec vikunja-container-name /app/vikunja/vikunja version?

5

The unstable container:

Vikunja api version v0.24.1-814-6d0330d786
Built with go1.23.6

With the RPM, it’s:

Vikunja api version unstable
Built with go1.23.6

With the binary vikunja-unstable-linux-386:

Vikunja api version v0.24.1-400-e393cfdfd7
Built with go1.23.2
6

And the error only happens with the rpm?

7

Yes, when I restore the dump from the unstable RPM, I got the error about malformed version.
Maybe I can try with the binary to import the dump.

8

ah! Then that’s likely the same issue as [Debian] Going from stable to unstable not possible (version number does not start with digit)

9

With the ./vikunja-unstable-linux-amd64 binary, it’s the same problem (Malformed version: unstable).

With the ./vikunja-unstable-linux-386 binary, the version is accepted (it’s v0.24.1-400-e393cfdfd7).
I update the VERSION inside the zip to match the server version.
But there’s another error:

2025-02-12T21:17:18+01:00: INFO ▶ 073 Restoring...
2025-02-12T21:17:18+01:00: INFO ▶ 074 Using config file: /home/jonathan/tmp_vikunja/config.yml
2025-02-12T21:17:18+01:00: INFO ▶ 11b Wiped database.
2025-02-12T21:17:18+01:00: CRITICAL     ▶ 11d could not create db structure: xormigrate: Tried to migrate to an ID that doesn't exist
1 Like
10

Okay, thanks for investigating the version issue! I’ll have a look.

Can you share the contents of the of the migrations.json file from the zip?

11

Here the migration.json:

[
  {
    "description": "",
    "id": "SCHEMA_INIT"
  },
  {
    "description": "",
    "id": "20190324205606"
  },
  {
    "description": "",
    "id": "20190328074430"
  },
  {
    "description": "",
    "id": "20190430111111"
  },
  {
    "description": "",
    "id": "20190511202210"
  },
  {
    "description": "",
    "id": "20190514192749"
  },
  {
    "description": "",
    "id": "20190524205441"
  },
  {
    "description": "",
    "id": "20190718200716"
  },
  {
    "description": "",
    "id": "20190818210133"
  },
  {
    "description": "",
    "id": "20190920185205"
  },
  {
    "description": "",
    "id": "20190922205826"
  },
  {
    "description": "",
    "id": "20191008194238"
  },
  {
    "description": "",
    "id": "20191010131430"
  },
  {
    "description": "",
    "id": "20191207204427"
  },
  {
    "description": "",
    "id": "20191207220736"
  },
  {
    "description": "",
    "id": "20200120201756"
  },
  {
    "description": "",
    "id": "20200219183248"
  },
  {
    "description": "",
    "id": "20200308205855"
  },
  {
    "description": "",
    "id": "20200308210130"
  },
  {
    "description": "",
    "id": "20200322214440"
  },
  {
    "description": "",
    "id": "20200322214624"
  },
  {
    "description": "",
    "id": "20200417175201"
  },
  {
    "description": "",
    "id": "20200418230432"
  },
  {
    "description": "",
    "id": "20200418230605"
  },
  {
    "description": "",
    "id": "20200420215928"
  },
  {
    "description": "",
    "id": "20200425182634"
  },
  {
    "description": "",
    "id": "20200509103709"
  },
  {
    "description": "",
    "id": "20200515172220"
  },
  {
    "description": "",
    "id": "20200515195546"
  },
  {
    "description": "",
    "id": "20200516123847"
  },
  {
    "description": "",
    "id": "20200524221534"
  },
  {
    "description": "",
    "id": "20200524224611"
  },
  {
    "description": "",
    "id": "20200614113230"
  },
  {
    "description": "",
    "id": "20200621214452"
  },
  {
    "description": "",
    "id": "20200801183357"
  },
  {
    "description": "",
    "id": "20200904101559"
  },
  {
    "description": "",
    "id": "20200905151040"
  },
  {
    "description": "",
    "id": "20200905232458"
  },
  {
    "description": "",
    "id": "20200906184746"
  },
  {
    "description": "",
    "id": "20201025195822"
  },
  {
    "description": "",
    "id": "20201121181647"
  },
  {
    "description": "",
    "id": "20201218152741"
  },
  {
    "description": "",
    "id": "20201218220204"
  },
  {
    "description": "",
    "id": "20201219145028"
  },
  {
    "description": "",
    "id": "20210207192805"
  },
  {
    "description": "",
    "id": "20210209204715"
  },
  {
    "description": "",
    "id": "20210220222121"
  },
  {
    "description": "",
    "id": "20210221111953"
  },
  {
    "description": "",
    "id": "20210321185225"
  },
  {
    "description": "",
    "id": "20210328191017"
  },
  {
    "description": "",
    "id": "20210403145503"
  },
  {
    "description": "",
    "id": "20210403220653"
  },
  {
    "description": "",
    "id": "20210407170753"
  },
  {
    "description": "",
    "id": "20210411113105"
  },
  {
    "description": "",
    "id": "20210411161337"
  },
  {
    "description": "",
    "id": "20210413131057"
  },
  {
    "description": "",
    "id": "20210527105701"
  },
  {
    "description": "",
    "id": "20210603174608"
  },
  {
    "description": "",
    "id": "20210709191101"
  },
  {
    "description": "",
    "id": "20210709211508"
  },
  {
    "description": "",
    "id": "20210711173657"
  },
  {
    "description": "",
    "id": "20210713213622"
  },
  {
    "description": "",
    "id": "20210725153703"
  },
  {
    "description": "",
    "id": "20210727204942"
  },
  {
    "description": "",
    "id": "20210727211037"
  },
  {
    "description": "",
    "id": "20210729142940"
  },
  {
    "description": "",
    "id": "20210802081716"
  },
  {
    "description": "",
    "id": "20210829194722"
  },
  {
    "description": "",
    "id": "20211212151642"
  },
  {
    "description": "",
    "id": "20211212210054"
  },
  {
    "description": "",
    "id": "20220112211537"
  },
  {
    "description": "",
    "id": "20220616145228"
  },
  {
    "description": "",
    "id": "20220815200851"
  },
  {
    "description": "",
    "id": "20221002120521"
  },
  {
    "description": "",
    "id": "20221113170740"
  },
  {
    "description": "",
    "id": "20221228112131"
  },
  {
    "description": "",
    "id": "20230307171848"
  },
  {
    "description": "",
    "id": "20230611170341"
  },
  {
    "description": "",
    "id": "20230824132533"
  },
  {
    "description": "",
    "id": "20230828125443"
  },
  {
    "description": "",
    "id": "20230831155832"
  },
  {
    "description": "",
    "id": "20230903143017"
  },
  {
    "description": "",
    "id": "20230913202615"
  },
  {
    "description": "",
    "id": "20231022144641"
  },
  {
    "description": "",
    "id": "20231108231513"
  },
  {
    "description": "",
    "id": "20240114224713"
  },
  {
    "description": "",
    "id": "20230104152903"
  },
  {
    "description": "",
    "id": "20231121191822"
  },
  {
    "description": "",
    "id": "20240304153738"
  },
  {
    "description": "",
    "id": "20240309111148"
  },
  {
    "description": "",
    "id": "20240311173251"
  },
  {
    "description": "",
    "id": "20240313230538"
  },
  {
    "description": "",
    "id": "20240314214802"
  },
  {
    "description": "",
    "id": "20240315093418"
  },
  {
    "description": "",
    "id": "20240315104205"
  },
  {
    "description": "",
    "id": "20240315110428"
  },
  {
    "description": "",
    "id": "20240329170952"
  },
  {
    "description": "",
    "id": "20240406125227"
  },
  {
    "description": "",
    "id": "20240603172746"
  },
  {
    "description": "",
    "id": "20240919130957"
  },
  {
    "description": "",
    "id": "20241028131622"
  },
  {
    "description": "",
    "id": "20241118123644"
  },
  {
    "description": "",
    "id": "20241119115012"
  }
]
12

It seems like the binary you’re running (v0.24.1-400-e393cfdfd7) is older than the one you did the dump from, hence the error. Can you check with the latest unstable build? The issue with the version number has been fixed in the meantime.

386 builds are discontinued due to issues with the build tooling, that’s probably why you got an outdated version there.