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

[Rchtr]

Hello,
i get this error unknown error (status 500): {resp:0x40007b6000} when i run any of the following commands:

echo "✓" | gotify push
echo '✓' | gotify push
echo ✓ | gotify push

What is the right syntax to push a message which includes the symbol above?

[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?

[jmattheis]

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

[Rchtr]

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