Talk has stale room that cannot be deleted


#1

Nextcloud version: 13.0.3
Operating system and version: FreeBSD 11.1
Apache version: 2.4.33
PHP version: 7.0.30

The wifey has a stale room/conversation that cannot be deleted from the Android app or web UI. In the web UI, the URL shows as /call/null when hovering the room in her list. She can remove the conversation from her list, but it returns after refreshing the page. That looks like it should clear it up:

DELETE FROM oc_talk_participants;
DELETE FROM oc_talk_rooms;

Is it safe to execute those queries? Anything else I should do?


#2

Hi @chriswells,
What Nextcloud Talk version are you running?


#3

Nextcloud Talk 3.2.2 on the server
Nextcloud Talk 2.0.0 on Android devices

However, the room would have been created when we had older versions of everything. At this point, it’s just the fact that we have the extra “null” room in her account and the DB even has a shared room that doesn’t appear in either of our accounts. I simply need to remove these rooms without any side effects.


#4

Anyone know if this is both safe and complete?

DELETE FROM oc_talk_participants;
DELETE FROM oc_talk_rooms;