Today I tried to upgrade my Discourse installation, from 2.9.0.beta9 to 2.9.0.beta10. But this went horribly wrong. My first attempt was on the console cd /var/discourse sudo git pull sudo ./launcher rebuild app This finally broke off, with the following message somewhere in the middle of all the logs PG::InvalidParameterValue: ERROR: cannot extract elements from a scalar /var/www/discourse/vendor/bundle/ruby/2.7.0/gems/rack-mini-profiler-3.0.0/lib/patches/db/pg.rb:110:in `exec' I was able to simply restore the forum by starting the old image (which was still hanging around). My second attempt was through the web console (/admin/upgrade). But this finally choked on the same kind of error: ERROR: cannot extract elements from a scalar. When going back to the upgrade panel, it told me all components were updated fine. But after a restart of the container, the server now threw a HTTP 500 error :frowning_face: I did a clean install on a separate machine, starting from scratch. I was able to install the beta10 version, but trying to restore from a backup caused exactly the same error! Anybody out there who could be of any help?

Have you commented out the line for the plugin and attempted a rebuild to confirm that?

I found the query that it is choking on 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 If I understand correctly, this happens because the psql function jsonb_array_elements expects an array, but receives a NULL value.

There have been a couple of reports of this: [תמונה] Bootstrap failed with exit code 1 Support I am trying to rebuild one (forum.techandtiny.com) of three Discourse instances that I run on my server. The crazy part is the plugins used are identical to the two other instances (forum.tabletpc.review and forum.farfarawaynews.com) that I run on my server. However, in updating all three instances today, only this one fails to spin up after rebuilding. Attached is the terminal output. [תמונה] Unable to install Discourse Question Answer: ON CONFLICT DO NOTHING Self-hosting Unable to install Discourse Question Answer == 20211020062413 CreateQuestionAnswerVotes: migrating ======================== -- create_table(:question_answer_votes, {}) -> 0.0478s -- add_index(:question_answer_votes, [:post_id, :user_id], {:unique=>true}) -> 0.0024s -- execute("INSERT INTO question_answer_votes (post_id, user_id, created_at)\nSELECT\n X.post_id AS post_id,\n (X.value->>'user_id')::int AS user_id,\n (X.value->>'created_at')::timestamp AS created_at\nFROM (\n SELECT\n … I think it may be to do with having the Pavilion Question/Answer plugin installed previously? I’ll see if I can get someone to take a deeper look. :+1:

We are using this plugin: https://github.com/angusmcleod/discourse-question-answer. It seems to be related to the Pavilion Question and Answer plugin. It is a fork from the discourse/discourse-upvotes plugin.

Just to check, which plugins do you have in your app.yml?

The site that I saw had a bunch of those Post Custom Fields that had a bunch of strings that had been encoded a bunch of times so that they were unusable. Some solutions, in order of complexity stop using the plugin (and perhaps switch to the new up votes) delete all of them delete the bad ones edit those fields to make the data back into valid json strings. The site that I saw had bad data that was years old. This appears to be a bug that existed years ago that is only now being discovered. It might be possible to write code to fix the broken json strings, but I wasn’t able to see how to do that in 10 minutes. See Question Answer Plugin - #301 by pfaffman for examples

[תמונה] Jay Pfaffman: stop using the plugin (and perhaps switch to the new up votes) I had thought of this too, but a quick check with Angus’ fork, it doesn’t seem to have any data migrations done. https://github.com/angusmcleod/discourse-question-answer/compare/main...discourse:discourse-upvotes:main This feels like data contamination from old Q&A posts as you said. I also find it funny that this is popping up now given that that migration is from Nov 2021 – I suppose this is because JayJay is only switching to the new plugin now? In any case we’ll have a look at that migration again.

- git clone https://github.com/discourse/docker_manager.git - git clone https://github.com/discourse/discourse-solved.git - git clone https://github.com/unfoldingWord-dev/discourse-mermaid.git - git clone https://github.com/angusmcleod/discourse-question-answer.git - git clone https://github.com/discourse/discourse-checklist.git - git clone https://github.com/discourse/discourse-cakeday.git - git clone https://github.com/discourse/discourse-canned-replies.git - git clone https://github.com/discourse/discourse-footnote.git - git clone https://github.com/discourse/discourse-staff-notes.git - git clone https://github.com/discourse/discourse-graphviz.git - git clone https://github.com/discourse/discourse-assign.git - git clone https://github.com/discourse/discourse-voting.git - git clone https://github.com/discourse/discourse-yearly-review.git - git clone https://github.com/discourse/discourse-saved-searches.git

@nat I’m not switching to the new plugin at all. I’m still running with the set of plugins that we have had for quite some time. At least every month, we run our updates, so it’s not like there is a huge gap between versions.

Just as a small ‘FYI’ aside from the question-answer issue, there’s also a replacement to canned-replies now: [תמונה] Discourse Templates Plugin discourse2 Summary Discourse Templates allows the creation of content templates for repeated use. The templates are stored as topics in a special category, where they can be edited and discussed as needed. open_book Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. information_source This plugin is pretty much a new version of Discourse Canned Replies but it is more flexible and stores the templates in a differ… And I believe there’s an #official Mermaid theme component now as well: [תמונה] Discourse Mermaid Theme component discourse2 Summary Discourse Mermaid lets you create very powerful graphs using the Mermaid syntax. eyeglasses Preview Preview on Discourse Theme Creator hammer_and_wrench Repository Link https://github.com/discourse/discourse-mermaid-theme-component open_book New to Discourse Themes? Beginner’s guide to using Discourse Themes Install this theme component Usage ```mermaid height=200 graph TD; A --> B; ``` [mermaid diagram example] Learn more about the Merma…

Thank you. Will look into that after my original problem is fixed :smile:

תוסף גורם לשגיאות במהלך בנייה מחדש

תמיכה התקנה

Jaap-Jan_Swijnenburg (JayJayS) 6 באוקטובר,‏ 2022,‏ 10:28am 5

We are using this plugin: https://github.com/angusmcleod/discourse-question-answer.

It seems to be related to the Pavilion Question and Answer plugin.
It is a fork from the discourse/discourse-upvotes plugin.

נושא		תגובות	צפיות
Importing old database to latest version Self-hosting	16	1629	7 ביוני,‏ 2022
Plugin post-voting conflicts with previous question-answer-plugin Self-hosting post-voting	20	1562	12 בדצמבר,‏ 2022
Cannot update with voting plugin Product Support	5	785	9 בספטמבר,‏ 2020
Discourse upgrade error "FAILED TO BOOTSTRAP" Product Support	14	2229	3 בספטמבר,‏ 2021
Database migration chokes on huge value of a "calendar-details" item in table "post_custom_fields" Bug	12	2348	7 בדצמבר,‏ 2020

תוסף גורם לשגיאות במהלך בנייה מחדש

נושאים קשורים