Discourse Stemmen mist tabel op postgresql

AI-generated summary

A user reports an error after installing the Discourse Voting plugin, stating that the discourse_voting_category_settings table is missing, causing a PG::UndefinedTable error. madmath03 installed the plugin via rake plugin:install without issues. justin suggests running bin/rake db:migrate or rebuilding the container to resolve the migration issue. madmath03 confirms the fix works. Falco advises following the official plugin installation guide and standard Discourse installation process to avoid such issues.

After installing GitHub - discourse/discourse-topic-voting: Adds the ability for voting on a topic within a specified category in Discourse. · GitHub, 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]

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.

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

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

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.