GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Notices by nemys (nemys@explorer.niwego.com)

  1. Embed this notice
    nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:48 JST nemys nemys
    in reply to
    • heluecht
    • hypolite
    @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?
    In conversation about a year ago from gnusocial.jp permalink
  2. Embed this notice
    nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:44 JST nemys nemys
    in reply to
    • heluecht
    • hypolite
    @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 ?
    In conversation about a year ago from gnusocial.jp permalink
  3. Embed this notice
    nemys (nemys@explorer.niwego.com)'s status on Friday, 09-Aug-2024 23:56:42 JST nemys nemys
    in reply to
    • heluecht
    • hypolite

    @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

    🙄🙄🙄

    In conversation about a year ago from gnusocial.jp permalink

    Attachments


    1. No result found on File_thumbnail lookup.
      NiWeGo Social | Home

User actions

    nemys

    nemys

    Tags
    • (None)

    Following 0

      Followers 0

        Groups 0

          Statistics

          User ID
          275467
          Member since
          9 Aug 2024
          Notices
          3
          Daily average
          0

          Feeds

          • Atom
          • Help
          • About
          • FAQ
          • TOS
          • Privacy
          • Source
          • Version
          • Contact

          GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

          Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.