I’m working on an importer for answerhub and need to mark posts as solved. A couple other importers do something like this: if topic["answer"] == '[accepted]' post.custom_fields['is_accepted_answer'] = true end And then later call this: def mark_topics_as_solved puts "", "Marking topics as solved..." PostAction.exec_sql <<-SQL INSERT INTO topic_custom_fields (name, value, topic_id, created_at, updated_at) SELECT 'accepted_answer_post_id', pcf.post_id, p.topic_id, p.created_at, p.created_at FROM post_custom_fields pcf JOIN posts p ON p.id = pcf.post_id WHERE pcf.name = 'is_accepted_answer' SQL end When I do that, the posts don’t show up as solved, but if I try to mark a post as solved, I get a 500 error (presumably because it’s trying to mark a solved post as solved). Is there something that I need to do to get rails to notice that the table has been updated? My other solution is to just do this as a post_create_action if topic["answer"] == '[accepted]' post.custom_fields['is_accepted_answer'] = true the_topic = Topic.find(parent) the_topic.custom_fields['accepted_answer_post_id'] = post.id the_topic.save end

Your other solution looks good. I hope you are calling post.save action later. plugin.rb main end auto_close_hours = 0 if topic&.category.present?

Thanks, @vinothkannans.. I wondered about that too, but it seems that post.save is getting called, by the importer code. I see that stuff is in the stashers.

Well, post.custom_fields is getting updated, and the topic shows that the post is the solution, but the post itself is missing the solution marker. It turns out that the appropriate value for “is_accepted_answer” is not true, but "true".

:wave: Thanks for sharing your solutions @pfaffman and @vinothkannans I just re-used your code: post.custom_fields["is_accepted_answer"] = "true" topic.custom_fields["accepted_answer_post_id"] = post.id topic.save! post.save! This worked to an extent, I can see the solved status when I scroll to the accepted post, but the import fell-short in two ways: Solved post is not quoted into 1st post of topic Title of solved post on index page is not prepended with a :check_box_with_check: I am parsing through the code in plugin.rb but it’s a little beyond me… any ideas?

[image] andyh: Title of solved post on index page is not prepended with a :ballot_box_with_check: You need to mark topics as solved like it’s done in some of our import scripts. script/import_scripts/telligent.rb 526ffc496 def mark_topics_as_solved puts "", "Marking topics as solved..." DB.exec <<~SQL INSERT INTO topic_custom_fields (name, value, topic_id, created_at, updated_at) SELECT 'accepted_answer_post_id', pcf.post_id, p.topic_id, p.created_at, p.created_at FROM post_custom_fields pcf JOIN posts p ON p.id = pcf.post_id WHERE pcf.name = 'is_accepted_answer' AND pcf.value = 'true' SQL end

Mark posts as solved in an importer

Development

andyh (Andy H) September 14, 2018, 8:44pm 7

Running that once at the end of my import script worked perfectly! Thanks.

Topic		Replies	Views
How to find solved topics in db Product Support solved , sql-query	1	167	April 30, 2025
Mark as Solution feature? Product Support	6	4512	October 21, 2016
Accepted solutions: plugin + migrating markers from Khoros Migration migrations-tooling	1	113	August 10, 2026
Where is Solved data stored in the database? Product Support solved	4	724	February 9, 2024
/posted empty with a phpbb3 import Migration phpbb	1	666	February 28, 2023

Mark posts as solved in an importer

Related topics