github-starred/vikunja
2
0
Fork 0
mirror of https://github.com/go-vikunja/vikunja.git synced 2026-05-05 19:18:16 -05:00
Code Issues 690 Packages Projects Releases 11 Wiki Activity

Critical error: invalid character 'd' looking for beginning of value #566

New Issue
Closed
opened 2025-11-01 20:59:20 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2025-11-01 20:59:20 -05:00
Owner
Copy Link

Originally created by @chris2deuce on GitHub (Aug 24, 2025).

Description

After upgrading to RC1 version I got this ERROR "invalid character 'd' looking for beginning of value", found in logfile.
Switching to unstable v1.0.0-rc1-21-f6b6fadb still shows this error:

vikunja | time=2025-08-24T18:57:52.855Z level=ERROR msg="invalid character 'd' looking for beginning of value"
vikunja | time=2025-08-24T18:57:52.855Z level=INFO msg="GET /api/v1/projects?is_archived=true&expand=permissions&page=1" component=http status=500 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=10.840573ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:53.421Z level=INFO msg="GET /sw.js" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=1.156329ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:54.342Z level=ERROR msg="invalid character 'd' looking for beginning of value"
vikunja | time=2025-08-24T18:57:54.342Z level=INFO msg="PUT /api/v1/projects/2/tasks" component=http status=500 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=4.362595ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:57.820Z level=INFO msg="POST /api/v1/user/token" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=986.846µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:57.872Z level=INFO msg="GET /api/v1/avatar/christian?size=40" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=988.25µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:57.872Z level=INFO msg="GET /api/v1/user" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=1.163031ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"
vikunja | time=2025-08-24T18:57:57.919Z level=INFO msg="GET /api/v1/avatar/christian?size=40" component=http status=200 remote_ip=2a01:xxx6:748:1:eecb:82c9:75c8:9b8e latency=824.227µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0"

Inside Vikunja, I can only see one of my created tasks.All Projects missing. All others are missing. Also opening of a new item is failing. But I see all of my labels. Any idea?

Btw: it's similar to #420 I think.

Vikunja Version

v1.0.0-rc1-21-f6b6fadb

Browser and version

Firefox/141.0

Can you reproduce the bug on the Vikunja demo site?

No

Screenshots

Image Image
Originally created by @chris2deuce on GitHub (Aug 24, 2025). ### Description After upgrading to RC1 version I got this ERROR "invalid character 'd' looking for beginning of value", found in logfile. Switching to unstable v1.0.0-rc1-21-f6b6fadb still shows this error: > vikunja | time=2025-08-24T18:57:52.855Z level=ERROR msg="invalid character 'd' looking for beginning of value" vikunja | time=2025-08-24T18:57:52.855Z level=INFO msg="GET /api/v1/projects?is_archived=true&expand=permissions&page=1" component=http status=500 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=10.840573ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:53.421Z level=INFO msg="GET /sw.js" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=1.156329ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:54.342Z level=ERROR msg="invalid character 'd' looking for beginning of value" vikunja | time=2025-08-24T18:57:54.342Z level=INFO msg="PUT /api/v1/projects/2/tasks" component=http status=500 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=4.362595ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:57.820Z level=INFO msg="POST /api/v1/user/token" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=986.846µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:57.872Z level=INFO msg="GET /api/v1/avatar/christian?size=40" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=988.25µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:57.872Z level=INFO msg="GET /api/v1/user" component=http status=200 remote_ip=2a01:xxx:748:1:eecb:82c9:75c8:9b8e latency=1.163031ms user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" vikunja | time=2025-08-24T18:57:57.919Z level=INFO msg="GET /api/v1/avatar/christian?size=40" component=http status=200 remote_ip=2a01:xxx6:748:1:eecb:82c9:75c8:9b8e latency=824.227µs user_agent="Mozilla/5.0 (X11; Linux x86_64; rv:141.0) Gecko/20100101 Firefox/141.0" Inside Vikunja, I can only see one of my created tasks.All Projects missing. All others are missing. Also opening of a new item is failing. But I see all of my labels. Any idea? Btw: it's similar to #420 I think. ### Vikunja Version v1.0.0-rc1-21-f6b6fadb ### Browser and version Firefox/141.0 ### Can you reproduce the bug on the Vikunja demo site? No ### Screenshots <img width="1084" height="610" alt="Image" src="https://github.com/user-attachments/assets/541aee86-12c1-4f24-bc96-145f0e464c51" /> <img width="1084" height="610" alt="Image" src="https://github.com/user-attachments/assets/0f8a2358-ea8c-428a-b960-bda321de11b7" />
GiteaMirror commented 2025-11-01 20:59:20 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Aug 31, 2025):

Can you investigate if this is caused by the same thing as #420?

@kolaente commented on GitHub (Aug 31, 2025): Can you investigate if this is caused by the same thing as #420?
GiteaMirror commented 2025-11-01 20:59:21 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Aug 31, 2025):

The error message seems to be related to creating a new task only.

@kolaente commented on GitHub (Aug 31, 2025): The error message seems to be related to creating a new task only.
GiteaMirror commented 2025-11-01 20:59:21 -05:00
Author
Owner
Copy Link

@chrismilson commented on GitHub (Aug 31, 2025):

@chris2deuce Sounds like we had the same bug. If you have access to your DB directly, you can confirm you have the same issue as #420 by first running SELECT count(*) FROM project_views WHERE filter ~ '^d'; (The WHERE clause will hopefully catch the rows that might be causing the invalid character 'd' part of your error message) and then running SELECT count(*) FROM migration WHERE id = '20250323212553';.

If you see a non-zero count for both, I would be pretty confident that we do indeed have the same issue. (The migration already ran but there are still rows in project_views with invalid values)

I was able to resolve the issue by:

  • Removing the migration from the migration log (by running DELETE FROM migration WHERE id = '20250323212553';)
  • Restarting vikunja
@chrismilson commented on GitHub (Aug 31, 2025): @chris2deuce Sounds like we had the same bug. If you have access to your DB directly, you can confirm you have the same issue as #420 by first running `SELECT count(*) FROM project_views WHERE filter ~ '^d';` (The WHERE clause will hopefully catch the rows that might be causing the `invalid character 'd'` part of your error message) and then running `SELECT count(*) FROM migration WHERE id = '20250323212553';`. If you see a non-zero count for both, I would be pretty confident that we do indeed have the same issue. (The migration already ran but there are still rows in `project_views` with invalid values) I was able to resolve the issue by: - Removing the migration from the migration log (by running `DELETE FROM migration WHERE id = '20250323212553';`) - Restarting vikunja
GiteaMirror commented 2025-11-01 20:59:21 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Sep 1, 2025):

Since there seems to be a solution available, I'll close this as resolved. Please ping if the solution does not work for you or open a new issue for other problems.

@kolaente commented on GitHub (Sep 1, 2025): Since there seems to be a solution available, I'll close this as resolved. Please ping if the solution does not work for you or open a new issue for other problems.
GiteaMirror commented 2025-11-01 20:59:21 -05:00
Author
Owner
Copy Link

@chris2deuce commented on GitHub (Sep 1, 2025):

@chrismilson Thanks for your help! You were right, and running DELETE FROM migration WHERE id = '20250323212553'; solved my problem. Much appreciated!

@chris2deuce commented on GitHub (Sep 1, 2025): @chrismilson Thanks for your help! You were right, and running DELETE FROM migration WHERE id = '20250323212553'; solved my problem. Much appreciated!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
area/api
area/attachments
area/auth
area/avatars
area/backup-restore
area/caldav
area/calendar-view
area/comments
area/config
area/database
area/desktop
area/docker
area/email
area/favorites
area/filters
area/frontend
area/gantt
area/i18n
area/import-export
area/internal-code
area/kanban
area/labels
area/list-view
area/mobile
area/notifications
area/permissions
area/projects
area/pwa
area/recurring-tasks
area/reminders
area/search
area/shortcuts
area/subtasks
area/sync
area/table-view
area/task-editor
area/task-metadata
area/task-relations
area/teams
area/theming
area/time-tracking
area/typesense
area/views
area/webhooks
bug
changes requested
concern/accessibility
concern/performance
concern/regression
concern/ux
confirmed
db/mysql
dependencies
enhancement
good first issue
help wanted
integration/inbound
integration/outbound
kind/bug
kind/feature
needs reproduction
pull-request
Mirrored from GitHub Pull Request
 question
security
support
upstream issue
waiting for reply
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/vikunja#566
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?