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.

[blackwhite084]

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

no

OS version

linux

Install tools

[blackwhite084]

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

[kubbot]

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]

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.

[skiffer-git]

Could you confirm if the groupID has been restricted to only include letters and numbers?

[icey-yu]

This issue has been fixed in the new version. Please use the code from the new version.