Mark posts as solved in an importer

gerhard · September 14, 2018, 8:28pm

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

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