"Mark as unread" does nothing

Troubleshooting
1

Summary
When “Mark as unread” is used on a read message, nothing happens.

Steps to reproduce
Read a message.
Use “Mark as unread” from the menu or by pressing U.

Expected behavior
The message should be shown as new and jump up in the list on the sidebar if configured.

Observed behavior
Nothing.

According to a colleague, this used to work for months, now it doesn’t anymore.

Regards,
Thomas

2

Can you reproduce that? Does it only happen to one colleague? What server and client version is involved in this and can this also be reproduced in a different client or with a different user?

3

Server v 7.7.1
Client v 5.4.0

It works in channels, but not with private messages. This also happens with my account and several others.

Regards,
Thomas

4

I started a 7.7.1 instance here and connected with my 5.4.0 desktop client and am unable to reproduce that.
Can you also reproduce this behaviour using the web client?

Can you see anything in the server startup logs, maybe an issue with the database schema? Did you upgrade your server recently?

5

Channel:
image

image

image

User:
image

image

This happens with every user, regardless of whether client or browser is used.

I made no recent upgrades.

Serverlog:

{“timestamp”:“2023-07-03 07:20:50.298 +02:00”,“level”:“error”,“msg”:“Unable to count urgent posts since given date.”,“caller”:“web/context.go:117”,“path”:“/api/v4/users/i9m6toag4fd5txibw4j9juh3xc/posts/s5ccdtg8wfbnxkyoynxg6y34pa/set_unread”,“request_id”:“py9ofi1rhbryir1s6zt6ekc87y”,“ip_addr”:“xxx.xxx.xxx.xxx”,“user_id”:“i9m6toag4fd5txibw4j9juh3xc”,“method”:“POST”,“err_where”:“countMentionsFromPost”,“http_code”:500,“error”:“countMentionsFromPost: Es ist nicht möglich, dringende Nachrichten seit dem angegebenen Datum zu zählen., failed to count urgent Posts: Error 1267: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation ‘=’”}
{“timestamp”:“2023-07-03 07:38:30.666 +02:00”,“level”:“error”,“msg”:“Unable to get user’s Drafts.”,“caller”:“web/context.go:117”,“path”:“/api/v4/users/me/teams/s1h13mmfubbzuexbwjd4c96umh/drafts”,“request_id”:“yfjgco411tgxb85ugp3jy6mjia”,“ip_addr”:“185.231.255.84”,“user_id”:“c7gt5u5p6jnydnn9uwc8whftxc”,“method”:“GET”,“err_where”:“GetDraftsForUser”,“http_code”:500,“error”:“GetDraftsForUser: Die Entwürfe des Benutzers können nicht abgerufen werden., failed to get user drafts: Error 1267: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’”}

Regards,
Thomas