Discourse Voting missing table on postgresql

Installation
1

After installing https://github.com/discourse/discourse-voting, I get the following error in logs (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)

Plugin was installed without errors through command line:

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

There have been issues with this migration running at times. Try running bin/rake db:migrate from console or rebuilding your container to resolve until we find a fix.

4 Likes
7

Hi @justin
This does seems to fix the problem. Thank you.

I do hope though that you a fix for that :smiley:

2 Likes
9

Please follow this guide to install plugins: Install plugins on a self-hosted site

Also, as said on your other topic, please follow Discourse official Standard Installation to install Discourse.

6 Likes