Can the issue be reproduced with the latest available release? (y/n)
Which one is the environment gotify server is running in?
Docker startup command or config file here (please mask sensitive information)
services:
gotify:
image: gotify/server:latest
container_name: gotify
ports:
- 8082:80
environment:
- GOTIFY_DEFAULTUSER_NAME=user
- GOTIFY_DEFAULTUSER_PASS=password
- GOTIFY_DATABASE_DIALECT=mysql
- GOTIFY_DATABASE_CONNECTION=gotify:password@tcp(nsys-mysql:3306)/gotify?charset=utf8mb4&parseTime=True&loc=Local
- TZ=Europe/Rome
volumes:
- "./gotify-data:/app/data"
networks:
- nsys-net
restart: always
networks:
nsys-net:
external: true
volumes:
gotify-data:
Do you have an reverse proxy installed in front of gotify server? (Please select None if the problem can be reproduced without the presense of a reverse proxy)
Reverse proxy configuration (please mask sensitive information)
On which client do you experience problems? (Select as many as you can see)
What did you do?
Updated from 2.8.0 to 2.9.0
What did you expect to see?
What did you see instead? (Include screenshots, android logcat/request dumps if possible)
Starting Gotify version 2.9.0@2026-02-13-15:29:00
2026/02/16 12:02:08 /src/gotify/database/database.go:83 Error 1170 (42000): BLOB/TEXT column 'sort_key' used in key specification without a key length
[0.960ms] [rows:0] CREATE UNIQUE INDEX uix_application_user_id_sort_key ON applications(user_id,sort_key)
panic: Error 1170 (42000): BLOB/TEXT column 'sort_key' used in key specification without a key length
goroutine 1 [running]:
main.main()
/src/gotify/app.go:44 +0x33f
Can the issue be reproduced with the latest available release? (y/n)
Which one is the environment gotify server is running in?
Docker startup command or config file here (please mask sensitive information)
Do you have an reverse proxy installed in front of gotify server? (Please select None if the problem can be reproduced without the presense of a reverse proxy)
Reverse proxy configuration (please mask sensitive information)
On which client do you experience problems? (Select as many as you can see)
What did you do?
Updated from 2.8.0 to 2.9.0
What did you expect to see?
What did you see instead? (Include screenshots, android logcat/request dumps if possible)
Starting Gotify version 2.9.0@2026-02-13-15:29:00
2026/02/16 12:02:08 /src/gotify/database/database.go:83 Error 1170 (42000): BLOB/TEXT column 'sort_key' used in key specification without a key length
[0.960ms] [rows:0] CREATE UNIQUE INDEX
uix_application_user_id_sort_keyONapplications(user_id,sort_key)panic: Error 1170 (42000): BLOB/TEXT column 'sort_key' used in key specification without a key length
goroutine 1 [running]:
main.main()
/src/gotify/app.go:44 +0x33f