Fix permalinks to point to topic-url and not to first post of topic

rrit · February 15, 2022, 8:47pm

I did a SQL based approach on permalinks based on some code similar to

script/import_scripts/lithium.rb

c5fd8c42d


      
              WHERE pm.id IS NULL AND f.name = 'import_unique_id'
          SQL
          
              r = DB.exec sql
              puts "#{r} permalinks to topics added!"
          
              sql = <<-SQL
              INSERT INTO permalinks (url, post_id, created_at, updated_at)
              SELECT '/p/' || value, p.id, current_timestamp, current_timestamp
              FROM post_custom_fields f
              JOIN posts p on f.post_id = p.id AND post_number <> 1
              LEFT JOIN permalinks pm ON url = '/p/' || value
              WHERE pm.id IS NULL AND f.name = 'import_unique_id'
          SQL
          
              r = DB.exec sql
              puts "#{r} permalinks to posts added!"
          
            end
          
            def find_upload(user_id, attachment_id, real_filename)

… but with AND post_number <> 1 missing – so that was the culprit.

Topic		Replies	Views
Remapping old imported forum permalinks to posts and topics? Development	7	1580	October 31, 2016
Plugin to help mapping pre-migration threads after migration Development	12	885	February 9, 2023
Permalinks within Discourse Product Support	5	1855	May 7, 2019
Bulk importing Redirects to New Discourse Topics Migration	2	325	April 12, 2024
Problem with permalinks after migration Migration	8	783	January 17, 2021

Fix permalinks to point to topic-url and not to first post of topic

Related topics