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

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

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

  1. 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

Feeds

  • Activity Streams
  • 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.