ERROR: column accounts.silenced does not exist (installation error?)

Attempting to install 3.4.1 from scratch. Getting " We’re sorry, but something went wrong on our end." and the log says:

Sep 13 20:19:51 ubos-develop-red postgres[346889]: 2021-09-13 20:19:51.073 PDT [346889] ERROR:  column accounts.silenced does not exist at character 523
Sep 13 20:19:51 ubos-develop-red postgres[346889]: 2021-09-13 20:19:51.073 PDT [346889] HINT:  Perhaps you meant to reference the column "accounts.silenced_at".
Sep 13 20:19:51 ubos-develop-red postgres[346889]: 2021-09-13 20:19:51.073 PDT [346889] STATEMENT:  SELECT "accounts"."username", "accounts"."domain", "accounts"."private_key", "accounts"."public_key", "accounts"."created_at", "accounts"."updated_at", "accounts"."note", "accounts"."display_name", "accounts"."uri", "accounts"."url", "accounts"."avatar_file_name", "accounts"."avatar_content_type", "accounts"."avatar_file_size", "accounts"."avatar_updated_at", "accounts"."header_file_name", "accounts"."header_content_type", "accounts"."header_file_size", "accounts"."header_updated_at", "accounts"."avatar_remote_url", "accounts"."silenced", "accounts"."suspended", "accounts"."locked", "accounts"."header_remote_url", "accounts"."statuses_count", "accounts"."followers_count", "accounts"."following_count", "accounts"."last_webfingered_at", "accounts"."inbox_url", "accounts"."outbox_url", "accounts"."shared_inbox_url", "accounts"."followers_url", "accounts"."protocol", "accounts"."id" FROM "accounts" LEFT OUTER JOIN "account_stats" ON "account_stats"."account_id" = "accounts"."id" WHERE "accounts"."domain" IS NULL AND "accounts"."suspended_at" IS NULL AND "accounts"."moved_to_account_id" IS NULL AND "accounts"."silenced_at" IS NULL AND "accounts"."discoverable" = $1 ORDER BY account_stats.followers_count desc LIMIT $2
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] method=GET path=/about format=html controller=AboutController action=show status=500 error='ActionView::Template::Error: PG::UndefinedColumn: ERROR:  column accounts.silenced does not exist
Sep 13 20:19:51 ubos-develop-red bundle[346792]: LINE 1: ...ader_updated_at", "accounts"."avatar_remote_url", "accounts"...
Sep 13 20:19:51 ubos-develop-red bundle[346792]:                                                              ^
Sep 13 20:19:51 ubos-develop-red bundle[346792]: HINT:  Perhaps you meant to reference the column "accounts.silenced_at".
Sep 13 20:19:51 ubos-develop-red bundle[346792]: ' duration=188.06 view=0.00 db=19.24
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] ActionView::Template::Error (PG::UndefinedColumn: ERROR:  column accounts.silenced does not exist
Sep 13 20:19:51 ubos-develop-red bundle[346792]: LINE 1: ...ader_updated_at", "accounts"."avatar_remote_url", "accounts"...
Sep 13 20:19:51 ubos-develop-red bundle[346792]:                                                              ^
Sep 13 20:19:51 ubos-develop-red bundle[346792]: HINT:  Perhaps you meant to reference the column "accounts.silenced_at".
Sep 13 20:19:51 ubos-develop-red bundle[346792]: ):
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     26:                 %small= t('about.browse_directory')
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     27:
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     28:               .avatar-stack
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     29:                 - @instance_presenter.sample_accounts.each do |account|
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     30:                   = image_tag current_account&.user&.setting_auto_play_gif ? account.avatar_original_url : account.avatar_static_url, alt: '', class: 'account__avatar'
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     31:
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]     32:         - if Setting.timeline_preview
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000]
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] app/views/about/show.html.haml:29
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] app/helpers/home_helper.rb:62:in `optional_link_to'
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] app/views/about/show.html.haml:22
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] app/controllers/concerns/localized.rb:16:in `block in set_locale'
Sep 13 20:19:51 ubos-develop-red bundle[346792]: [6f75155d-5550-42a5-9d33-596f3bd85000] app/controllers/concerns/localized.rb:15:in `set_locale'
Sep 13 20:19:51 ubos-develop-red bundle[346795]: [f228195f-b0a5-4278-a179-36516de79d5d] Chewy request strategy is `custom_sidekiq`
Sep 13 20:19:51 ubos-develop-red bundle[346795]: [f228195f-b0a5-4278-a179-36516de79d5d] method=GET path=/oops.png format=png controller=ApplicationController action=raise_not_found status=404 duration=43.43 view=30.98

I’m not a Rails person, so this doesn’t tell me much. I can’t even find the line of code in which it says “silenced” in a db query, The database has silenced_at.

This is very odd. I think something like this could only happen if you ran database migrations and did not restart mastodon-web afterwards, but you’re telling you’re installing 3.4.1 form scratch, so I am pretty confused…

Never mind. Fixed it. Not sure what I did differently, but it works now.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.