How to migrate from 0.24.6 to unstable

Hi,

I used Vikunja (docker vesion self hosted) from some weeks now.
Some " problem " seems to be corrected in unstable version.

I try to only change the tag of the docker’s image but I lost some informations in the front-end (like project affected to tasks or priority) and I have an error " valid character ‘d’ looking for beginning of value " when I try to make a project from filter).

I didn’t find any answer in documentation and in this forum.

Maybe I didn’t search properly.

I’d love to continue testing this tool, which seems very promising. :slight_smile:

Regards.

DerO

Welcome :waving_hand:

Did you switch to the unstable tag? Which version do you see in the about dialogue in the frontend?

Thank you for you message.

Yes, I switch ti the unstable tag.

This is what I have in the about dialogue :

Frontend version: dev
API version: v0.24.1-1430-648f6f6a

All my tasks seems to be there but without any project.

So no projects in the menu on the left?

Do you see any projects when running select * from projects in your database?

Exactly, no project on left menu but :

select * from projects;
id | title | description | identifier | hex_color | owner_id | parent_project_id | is_archived | background_file_id | background_blur_hash | position | created | updated
3 | Pro | | | | 1 | 0 | f | 0 | | 196608 | 2025-06-06 16:28:11 | 2025-06-23 09:00:35
1 | Inbox | | | | 1 | 0 | f | 0 | | 65536 | 2025-06-06 15:16:54 | 2025-06-22 16:56:19
2 | Perso | | | | 1 | 0 | f | 0 | | 131072 | 2025-06-06 15:58:12 | 2025-06-23 11:15:27
4 | Développement | | | | 1 | 0 | f | 0 | | 262144 | 2025-06-06 16:43:55 | 2025-06-21 15:43:39
5 | Maison | | | | 1 | 0 | f | 0 | | 327680 | 2025-06-06 16:45:37 | 2025-06-21 15:31:51
(5 rows)

And :

select id, title, project_id from tasks LIMIT 1;
id | title | project_id
----±-----------------±-----------
10 | Factures OVH ESS | 2

So I don’t understand. :sweat_smile:

When I try to refresh projects page in the frontend, here is the log :

2025-06-23T12:32:54.847057874Z: INFO :play_button: [DATABASE] 200 [SQL] SELECT “id”, “title”, “project_id”, “view_kind”, “filter”, “position”, “bucket_configuration_mode”, “bucket_configuration”, “default_bucket_id”, “done_bucket_id”, “updated”, “created” FROM “public”.“project_views” WHERE “project_id” IN ($1,$2,$3,$4,$5,$6) ORDER BY position asc [1 2 3 4 5 -2] - 1.955714ms
2025-06-23T12:32:54Z: ERROR :play_button: 201 invalid character ‘d’ looking for beginning of value

OK, I try something : export data from 0.24.6 with the export task in the frontend an import it in a new unstable instance : doesn’t work.

Look the error and seems to be in the filter filed views.

Expected something like :

“filter”: {
“s”: “”,
“sort_by”: null,
“order_by”: null,
“filter”: “done = false”,
“filter_include_nulls”: false
},

and data in my file, for example :

“filter”: “done = false \u0026\u0026 (due_date \u003e= now/d+1d \u0026\u0026 due_date \u003c now/d+2d)”,

I put all my view filter to

“filter”: null,

And the import is OK (without filter of course).

I’m unable to verify this with the latest unstable build (v0.24.1-1442-247d82f0).

Do you only see this when fetching projects?

It seems like it’s only on projects.
I solve my problem (but not THE problem) by exporting from 0.24.6, change the filter field (only 24) and import in a unstable fresh install.