unknown error (status 500): {resp:0x40007b6000} about cli

[jmattheis]

Gotify itself doesn't define any collation, so the default MySQL collation will be used.

[jmattheis]

This should work, does gotify/server log any error?

[Rchtr]

I could find this error in the log:
Error 1366: Incorrect string value: '\xE2\x9C\x93\x0A' for column 'gotify'.'messages'.'message' at row 1 ,

[jmattheis]

Please add your gotify configuration to this issue, this looks like the database doesn't accept a row with this character. If you're using mysql try the solution in this comment gotify/server#408 (comment)

[Rchtr]

I've changed manually the database collation of the table messages from latin1_swedish_ci to utf8_unicode_ci. Now its works. Thank you. 👍
Gotify is connected to MariaDB via GOTIFY_DATABASE_CONNECTION: user:password@tcp(mysql:3306)/gotify?charset=utf8&parseTime=True&loc=Local.
Why does gotify/server create all tables with collation latin1_swedish_ci?

[Rchtr]

So I think that issue can be closed. Thank you!