Untitled attachment

Notices where this attachment appears

1. Embed this notice
   fedilist (fedilist@fsebugoutzone.org)'s status on Thursday, 19-Jun-2025 12:00:47 JST fedilist
   [2025-06-13 21:14:20] FediList found gaybdsm.top (Mastodon 4.3.8) through niwego.com
   
   http://fedilist.com/instance/gaybdsm.top
2. Embed this notice
   nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:42 JST nemys

   in reply to

   @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

   🙄🙄🙄