nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:42 JST

@hypolite @heluecht
Thanks for the advice, but I always do a backup+snapshot before making changes
I spent many hours to find the right syntax , I tried different ways but it didn't work
first of all I had to temporarily disable the key check because it gave me the error
SET FOREIGN_KEY_CHECKS=0;
DELETE FROM gserver WHERE nurl='http://niwego.com';
SET FOREIGN_KEY_CHECKS=1;
and it worked,now i have the same error but in inbox-status , and I'm trying to find the right syntax
```
bin/console relocate niwego.com
Relocation started from explorer.niwego.com to niwego.com. Could take a while to complete.
Entering maintenance mode
Updating apcontact table fields
Updating contact table fields
Updating conv table fields
Updating delayed-post table fields
Updating endpoint table fields
Updating event table fields
Updating diaspora-contact table fields
Updating fsuggest table fields
Updating gserver table fields
Updating inbox-status table fields
Process aborted with message: Failed updating inbox-status: Duplicate entry 'https://niwego.com/inbox' for key 'PRIMARY' thrown in /var/www/html/src/Database/Database.php:1878
Leaving maintenance mode
``
DELETE FROM inbox-status WHERE PRIMARY='https://niwego.com/inbox';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-status WHERE PRIMARY='https://niwego.com/inbox'' at line 1

🙄🙄🙄