Update via docker: Migration Error 1064
m50434 opened this issue · 5 comments
Description
Hi,
I just updated Vikunja API ("latest" in Docker) and im getting the following error when starting the container:
migration/Migrate 052 Migration failed: migration 20221113170740 failed: Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COLUMN list_id TO project_id' at line 1
Any ideas what to do?
Vikunja Frontend Version
latest
Vikunja API Version
latest
Browser and version
No response
Can you reproduce the bug on the Vikunja demo site?
No
Screenshots
No response
Which mariadb version are you using?
mariadb 10.3.32 - 1040 (Im using Synology NAS. The system says its the newest version)
Looks like your mariadb version is too old. You need at least 10.5.2 to run that migration.
10.3.32 was released in late 2021, you'll probably want to upgrade that anyway (even if Synology does not offer a newer version directly).
For Vikunja, you could switch to sqlite, probably the resource-friendlier option for a nas anyway.
Thanks for your fast reply.
Im sorry. I was using an old Firmware for the Synoloy as well. Therefore I couldnt update MariaDB.
Anyway, now I updated MariaDB (its now 10.11) and the vikunja-api seems to be fine (the log says the migration was succesful and there are no more errors).
Unfortunately something is wrong with the frontend:
If Im try to access vikunja I got a "502 Bad Gateway error".
The log of the frontend is "/bin/sh: /run.sh: not found".
Me again:
I installed a new frontend-container (with the same preferences). Now it works.