Livechat hanging in list of incomming chats - room not found - not deletable

Hi. We have one very old support chat hanging: in the desktop client it appears in “incomming chats”. When clicking on it it says “room not found”. Also in Livechat admin / Current chats it is not in the list

=> how can I delete this weird hanging thing? Is this something I need to delete in MongoDB directly? how would I do that?

Thanks for any advise
Regards
Petr

I have this same problem. Did you ever find a resolution?

I was able to find the solution on github in the issues list here: https://github.com/RocketChat/Rocket.Chat/issues/15748. You will need to run a query on the rocketchat database.

Run the mongodb shell. If you are using docker, follow these steps, otherwise skip to the next section:

  • Locate your rocket chat mongodb container id by executing: docker ps | grep mongo
  • Execute the following using your container ID in place of [container_id]: docker exec -it [container_id] /bin/bash
  • You should now be at a prompt inside your docker container.

Run the mongodb shell:
mongo

Switch to the rocketchat database:
use rocketchat

Execute the following query:
db.rocketchat_livechat_inquiry.update({status: 'queued',closedBy: {$exists: 1}},{$set: {status: 'closed'}},{multi: true})

You should see a result with some number of matched and modified records.