List View Broken on old projects

Support
1

Hi,

I see on existing older projects still an broker list view.

Red Box with:

Error
error.4024 The filter expression ‘{“filter”:“done = 'false”}’’ is invalid: unexpected character ‘{’

Is there any fix in the database which fixes these few old projects with this problem?

Thanks

2

I found the solution on my own. We can close this.
In case somebody has the same issue:

  1. go to your database container and into the SQL prompt:
    root@vikunja-db:/# psql -U username -d vikunja

  2. Take the project number from the URL of the project with the broken view and lookup the views. In my example 2

    vikunja=# SELECT
id,
project_id,
view_kind,
filter
FROM project_views
WHERE project_id = 2
ORDER BY id;
id | project_id | view_kind |                   filter
----±-----------±----------±-------------------------------------------
5 |          2 |         0 | {“filter”:“{"filter":"done = false"}”}
6 |          2 |         1 |
7 |          2 |         2 |
8 |          2 |         3 |
(4 rows)

  3. If you find a view like this, it is the cause of the problem.
    It should have been removed by the migration. If some entries are left for some reason, I do not understand, fix them manually:

    UPDATE project_views
    SET filter = '{“filter”:“done = false”}'
    WHERE id = 5;

Now the view is working.