tsmethurst
/ 0.17.0_migrations.sql
Created
October 16, 2024 11:21
Summary of migrations from 0.16.0 to 0.17.0 (approximate)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE IF NOT EXISTS "conversations" ("id" CHAR(26) NOT NULL, "created_at" timestamptz NOT NULL DEFAULT current_timestamp, "updated_at" timestamptz NOT NULL DEFAULT current_timestamp, "account_id" CHAR(26) NOT NULL, "other_account_ids" VARCHAR, "other_accounts_key" VARCHAR NOT NULL, "thread_id" CHAR(26) NOT NULL, "last_status_id" CHAR(26) NOT NULL, "read" BOOLEAN DEFAULT false, PRIMARY KEY ("id"), UNIQUE ("id"), CONSTRAINT "conversations_account_id_last_status_id_uniq" UNIQUE ("account_id", "last_status_id"), CONSTRAINT "conversations_thread_id_account_id_other_accounts_key_uniq" UNIQUE ("account_id", "other_accounts_key", "thread_id")); | |
| CREATE TABLE IF NOT EXISTS "conversation_to_statuses" ("conversation_id" CHAR(26) NOT NULL, "status_id" CHAR(26) NOT NULL, CONSTRAINT "conversation_to_statuses_conversation_id_status_id_uniq" UNIQUE ("conversation_id", "status_id")); | |
| CREATE INDEX IF NOT EXISTS "conversations_account_id_idx" ON "conversations" ("account_id"); | |
| CREATE INDEX IF NOT EXISTS "conversations_las |
tsmethurst
/ gist:9b184f417f0074b1a7d3247703596b7c
Created
February 6, 2022 11:08
search for @[email protected] from @[email protected]
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] method=GET path=/users/dumpsterqueer format=json controller=AccountsController action=show status=500 error='NoMethodError: undefined method `zero?' for nil:NilClass' duration=297.28 view=0.00 db=5.47 key=https://testingtesting123.xyz/users/the_mighty_zork/main-key | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] NoMethodError (undefined method `zero?' for nil:NilClass): | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] app/services/activitypub/fetch_remote_account_service.rb:42:in `verified_webfinger?' | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] app/services/activitypub/fetch_remote_account_service.rb:29:in `call' | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] app/services/activitypub/fetch_remote_key_service.rb:37:in `find_account' | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] app/services/activitypub/fetch_remote_key_service.rb:24:in `call' | |
| [3c82b9b4-fff1-4e76-b7ce-5ec621a5f12d] app/controllers/concerns/signature_verification |