Question Answer Plugin

pfaffman · September 30, 2022, 6:10pm

I have a customer that is going to need it.

~~Seemed to be interested.~~ No. I think they just mean an existing normal topic. I’m a bit surprised that this isn’t solved, or perhaps all I need to do is to install Discourse Upvotes and it’ll just work?

I don’t see any rake tasks in the new plugin, and glancing at the migrations it doesn’t appear that there is any magic there, though I could be wrong on one or both counts.

EDIT: OOps. It does look like the first migration handles moving stuff to the new plugin right here. . . I’m running the upgrade now and will delete this when it works.

EDIT 2: Sigh. It didn’t work. It’s failing with "PG::InvalidParameterValue: ERROR: cannot extract elements from a scalar",

github.com

discourse/discourse-upvotes/blob/main/db/migrate/20211020062413_create_question_answer_votes.rb#L13-L28


      
          execute <<~SQL
          INSERT INTO question_answer_votes (post_id, user_id, created_at)
          SELECT
            X.post_id AS post_id,
            (X.value->>'user_id')::int AS user_id,
            (X.value->>'created_at')::timestamp AS created_at
          FROM (
            SELECT
              post_id,
              jsonb_array_elements(value::jsonb) AS value
            FROM post_custom_fields WHERE name = 'vote_history'
          ) AS X
          WHERE (X.value->>'action') != 'destroy'
          ORDER BY (X.value->>'created_at')::timestamp DESC
          ON CONFLICT DO NOTHING
          SQL

Topic		Replies	Views
Comment on a question instead of answering it support	13	3023	December 14, 2023
Multilingual Plugin :globe_with_meridians: plugin pavilion	120	14831	February 9, 2024
A more social Discourse layout ux	52	7474	April 17, 2022
A versioned API for client side plugins dev rest-api	32	18756	October 13, 2023
Plugin: Ask me anything or Q&A format (threaded replies) feature rfc	54	13730	July 2, 2022

Question Answer Plugin

Related Topics