Notices by nemys (nemys@explorer.niwego.com)
-
Embed this notice
nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:48 JST nemys @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
nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:44 JST nemys @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
nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:42 JST nemys @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
🙄🙄🙄