Conversation

Notices

1. Embed this notice
   hypolite (hypolite@friendica.mrpetovan.com)'s status on Friday, 09-Aug-2024 23:56:49 JST hypolite

   • heluecht
   • nemys

   @nemys Absolutely. If the block purge didn't work, you will have to manually clear your gserver table of the offending record and of all the records depending on it through foreign keys.

   @heluecht Is there any safe way of doing this manually?

   • Embed this notice
     Steffen K9 ? (steffen@misskey.de)'s status on Friday, 09-Aug-2024 23:56:38 JST Steffen K9 ?

     in reply to

     • heluecht
     • nemys

     @nemys@explorer.niwego.com @hypolite@friendica.mrpetovan.com @heluecht@pirati.ca table names with a dash (-) need to be enclosed in backticks.

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

     in reply to

     • heluecht

     @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

     🙄🙄🙄

   • Embed this notice
     nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:44 JST nemys

     in reply to

     • heluecht
     @heluecht @hypolite
     Sorry @heluecht I think I'm stuck
     sudo mysql
     USE myfriendicadb;
     SHOW tables;
     Output
     | gserver | | gserver-tag|
     how do I delete the entry in gserver ?
   • Embed this notice
     hypolite (hypolite@friendica.mrpetovan.com)'s status on Friday, 09-Aug-2024 23:56:44 JST hypolite

     in reply to

     • heluecht
     • nemys
     @nemys @heluecht
     DELETE FROM gserver WHERE nurl = “http://niwego.com”; should do the trick, I am not responsible if you end up deleting the wrong thing/whole table/whole database, yadda yadda.
   • Embed this notice
     heluecht (heluecht@pirati.ca)'s status on Friday, 09-Aug-2024 23:56:47 JST heluecht

     in reply to

     • heluecht
     • nemys
     @hypolite @nemys Like I said, delete the entry in the gserver table by hand. Just make sure to have a backup. That's all. BTW: It would be interesting to see, if the relocation still works, especially with Diaspora contacts.
   • Embed this notice
     nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:48 JST nemys

     in reply to

     • heluecht
     @hypolite @heluecht
     I tried but it doesn't work, look at the screenshot on the other post. What should I do, create another virtual machine, install Friendica and configure it with the root Domain, or are there steps I can follow? what do you suggest to me?
   • Embed this notice
     Steffen K9 ? (steffen@misskey.de)'s status on Friday, 09-Aug-2024 23:58:25 JST Steffen K9 ?

     in reply to

     • heluecht
     • nemys

     @nemys@explorer.niwego.com @hypolite@friendica.mrpetovan.com @heluecht@pirati.ca Ähm. I guess the - is called hyphen, not dash. 😊