Discourse Voting 플러그인에서 PostgreSQL 테이블이 없습니다

제품 지원 자체 호스팅
1

GitHub - discourse/discourse-topic-voting: Adds the ability for voting on a topic within a specified category in Discourse. · GitHub 를 설치한 후 로그(docker)에 다음 오류가 발생합니다:

discourse           | Started GET "/" for 2.3.75.18 at 2020-10-22 17:36:58 +0000
discourse           | Processing by ListController#latest as HTML
discourse_db        | 2020-10-22 17:36:59.073 UTC [2221] ERROR:  relation "discourse_voting_category_settings" does not exist at character 454
discourse_db        | 2020-10-22 17:36:59.073 UTC [2221] STATEMENT:  SELECT a.attname, format_type(a.atttypid, a.atttypmod),
discourse_db        |        pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
discourse_db        |        c.collname, col_description(a.attrelid, a.attnum) AS comment
discourse_db        |   FROM pg_attribute a
discourse_db        |   LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
discourse_db        |   LEFT JOIN pg_type t ON a.atttypid = t.oid
discourse_db        |   LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
discourse_db        |  WHERE a.attrelid = '"discourse_voting_category_settings"'::regclass
discourse_db        |    AND a.attnum > 0 AND NOT a.attisdropped
discourse_db        |  ORDER BY a.attnum
discourse_db        | 
discourse           | Completed 500 Internal Server Error in 30ms (ActiveRecord: 0.0ms | Allocations: 9365)
discourse           | ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR:  relation "discourse_voting_category_settings" does not exist
discourse           | LINE 8:  WHERE a.attrelid = '"discourse_voting_category_settings"'::...
discourse           |                             ^
discourse           | )
discourse           | /opt/bitnami/discourse/vendor/bundle/ruby/2.6.0/gems/rack-mini-profiler-2.0.2/lib/patches/db/pg.rb:110:in `exec'
discourse           | Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR:  relation "discourse_voting_category_settings" does not exist
discourse           | LINE 8:  WHERE a.attrelid = '"discourse_voting_category_settings"'::...
discourse           |                             ^
discourse           | 
discourse           | Started GET "/service-worker-c8000968830b6f6bd33f1e842dffdd569664119d449f93dc7d428d963a71635d.js" for 2.3.75.18 at 2020-10-22 17:37:01 +0000
discourse           | Processing by StaticController#service_worker_asset as */*
discourse           |   Rendering text template
discourse           |   Rendered text template (Duration: 0.0ms | Allocations: 1)
discourse           | Completed 200 OK in 6ms (Views: 0.8ms | ActiveRecord: 0.0ms | Allocations: 1731)

플러그인은 명령줄을 통해 오류 없이 설치되었습니다:

RAILS_ENV=production bundle exec rake plugin:install[https://github.com/discourse/discourse-voting]
2

이 마이그레이션 실행 시 문제가 발생했던 적이 있습니다. 수정 방안이 나올 때까지 콘솔에서 bin/rake db:migrate를 실행하거나 컨테이너를 다시 빌드하여 해결해 주세요.

7

안녕하세요 @justin
이 방법으로 문제가 해결되는 것 같습니다. 감사합니다.

다만, 해당 문제에 대한 수정 사항도 마련해 주셨으면 좋겠습니다 :smiley:

9

플러그인을 설치하려면 이 가이드를 따르세요: Install plugins on a self-hosted site

또한 다른 주제에서 말씀드린 대로, Discourse를 설치하려면 Discourse 공식 표준 설치 방법을 따르세요.