Thatoo

It doesn't feel like nextcloud social is a very actived and maintain app.

Would this script work on a x86 server?

Yes we did port the database from SQLite to Postgres just before this issue occurred (no other problems have been reported so far). We didn't manually delete rows, we didn't...

It was version 1.59.1. We port the database from SQLite to Postgres and the we updated from v 1.59.1 to v 1.63.

> When you ported from sqlite, which version of synapse was installed at the time? > > (You may have ported before the fix in #13226 was available.) if I...

Here are what I got : ``` root@cccc:~# sqlite3 /var/lib/matrix-synapse/homeserver.db SQLite version 3.27.2 2019-02-25 16:06:06 Enter ".help" for usage hints. sqlite> SELECT rowid FROM events WHERE event_id = '$d07wypTuQbxA5SUD3OwBPBUNl1mCF6ydmDwsdUGhxrw'; -22730...

> @Thatoo I don't think you're connected to your Postgres database properly; maybe you need to try `psql synapse` or something (if your database name is `synapse`). > > However...

What I want to be sure is if this command will indeed remove the room from our homeserver but will allow us to rejoin it after.

it failed... ``` root@Matrix:~# curl -X DELETE --header 'Authorization: Bearer ' --header 'Content-Type: application/json' --header 'Accept: application/json' 'http://xxx.xxx.xxx.xxx:8008/_synapse/admin/v2/rooms/!nsxQkuXAmwktOKyUNc:matrix.org' -d '{ "message": "This room didnt work after migrating from SQLite to...

It is indeed my account but I can't leave the space, this is the subject of this issue... How can I manually kick this user? Is there an admin API...