Issue removing connection to unavailable other Nextcloud instance

Big THANKS to Tuffiglig for this solution.

In case less experienced people need to delete a record:

At command line connect to DB using “mysql” or “mariadb”

MariaDB [(none)]> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| mysql |
| owncloud |
| performance_schema |
±-------------------+
4 rows in set (0,015 sec)

MariaDB [(none)]> use owncloud;

MariaDB [owncloud]> SELECT * FROM oc_share_external;
±—±--------------------------------------±----------------±---------±---------------------±-----------±---------±----------------------------±---------------------------------±----------±---------±-------±-----------+
| id | remote | share_token | password | name | owner | user | mountpoint | mountpoint_hash | remote_id | accepted | parent | share_type |
±—±--------------------------------------±----------------±---------±---------------------±-----------±---------±----------------------------±---------------------------------±----------±---------±-------±-----------+
| 6 | http://nonexistant any more | tndssssssssssse | | /test.ods | jaaaaaaar | jaaaaaar | /Shares/test (2).ods | 58absssssssssssssssssss4d | 5 | 1 | -1 | 0 |
| 9 | https://cloud.dddddd.de/ | clddddddds0 | | /CyyyyyyyyyyymbH | vsssskov | sddddddn | /ssssssssssss GmbH | b9e4sssssssssssssssssc19 | 17387 | 1 | -1 | 0 |
±—±--------------------------------------±----------------±---------±---------------------±-----------±---------±----------------------------±---------------------------------±----------±---------±-------±-----------+
2 rows in set (0,002 sec)

MariaDB [owncloud]> Delete FROM oc_share_external where owner=“jaaaaaaar”;
Query OK, 1 row affected (0,002 sec)

2 Likes