After manually downloading and setting up Vikunja (v2.3.0), it is showing “Internal Server Error” on the overview and upcoming pages due to an SQL error. I also noticed a WebSocket error in the logs, but am not sure if it’s relevant.
Changing the configuration to use SQLite allows the software to run without any issues.
Errors from logs:
time=2026-04-23T16:14:08.395-04:00 level=ERROR component=http remote_ip=127.0.0.1 method=GET uri=“/api/v1/projects?is_archived=true&expand=permissions&page=1” status=500 latency=3.15578ms err=“Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘int)) AS is_archived, all_projects.background_file_id, all_projects.background_b’ at line 5”
time=2026-04-23T16:14:08.395-04:00 level=ERROR component=http remote_ip=127.0.0.1 method=GET uri=“/api/v1/labels?page=1” status=500 latency=3.316214ms err=“Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘int)) AS is_archived, all_projects.background_file_id, all_projects.background_b’ at line 5”
time=2026-04-23T16:14:33.581-04:00 level=ERROR msg=“WebSocket: upgrade failed: failed to accept WebSocket connection: WebSocket protocol violation: Connection header "Keep-Alive" does not contain Upgrade”
System Setup:
- Vijunja 2.3.0
- Ubuntu 24.04.3 LTS
- MySQL 8.0.45
- Apache Reverse Proxy