Hello
I have been using vikunja for quite some time without docker and with mariadb as database and now I even migrated to a remote postesql instance without issue. I did make one change to the service today and that was creating a new linux user and giving them permission for /opt/vikunja, /etc/vikunja and even /var/log/vikunja. I didn’t want the service running as root anymore so I assigend this new user. The change deleted all my data in the database which wasn’t an issue since I created a dump with vikunja dump . When I went to restore the dump I didnt notice anything at first, but after I successfully created a new project I couldn’t add any new buckets to the kanban. It just says “internal server error” and this is the logged error:
INFO#011▶ [DATABASE] 28e#033[0m [SQL] INSERT INTO "buckets" ("title","project_view_id","limit","position","created","updated","created_by_id") VALUES ($1,$2,$3,$4,$5,$6,$7) RETURNING "id" [in progress 4 0 0 2025-01-11 16:04:08 2025-01-11 16:04:08 1] - 319.581µs
ERROR#011▶ 28f#033[0m pq: duplicate key value violates unique constraint "buckets_pkey"
I really don’t know what could cause this and I already tried setting the database up again and redoing the restore. I also tried exporting my userdata in the web application, but it just generates this as link:
If anyone could help me I would really appreciate it and I could provide more info if necessary.