openim-web When a user is invited to a group, the group will not be displayed on the chat list, but there will be a sound reminder when there is a message.

openimsdk / open-im-server

IM Chat

https://openim.io

Apache License 2.0

13.47k stars 2.37k forks source link

openim-web When a user is invited to a group, the group will not be displayed on the chat list, but there will be a sound reminder when there is a message. #1993

Open blackwhite084 opened 4 months ago

blackwhite084 commented 4 months ago

What happened?

openim-web 用户被邀请进群时，群不显示在聊天列表上，但有消息时会有声音提醒

What did you expect to happen?

群应该在聊天列表上

How can we reproduce it (as minimally and precisely as possible)?

fix bug

Anything else we need to know?

No response

version

r 3.5

Cloud provider

OS version

linux

Install tools

blackwhite084 commented 4 months ago

原因：group_id被设置为非纯数字，导致openim-web查表的时候把group_id当成了列名。如：select xxx from xx where groupid in (gp10013123)

kubbot commented 4 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Reason: group_id is set to a non-pure number, which causes openim-web to treat group_id as a column name when looking up the table. For example: select xxx from xx where groupid in (gp10013123)

kubbot commented 2 months ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days.