The remap rethink worked as suggested by @pfaffman but was actually the catalyst for the solution, not not the solution per se, it helped me figured out what I was doing wrong, it remapped me eyes!
If I had read the error properly i.e. paid attention. I would have solved this a long time ago as I would have seen the key information was in the error message.
All I had to do was included the post number flagged by the stop error …/p/123456789
in the url to navigate directly and fix each post manually.
This occurred for the majority in a second remap run to convert the www from the first remap to the apex non-www url as was the original need.
Now internal URL’s should only include apex links.
This solves some of the www SSL re-direciton where there were many legacy www internal links. It does not solve a user typing in www into the address bar or linkbakc out on teh WWW itself for not but it should tackle all the internally generated ones. Waiting to see how it affects google indexing before doing anything more on this issue.
Perhaps of interest. To devs.
I found a lot of stops on duplicate key value violates unique constraint “unique_post_links”
, these occurred when a post was moved and discourse included the “Continued from …. “ with hotlink, but if the split posts included quoted blocks to the same spot then it woudl stop the remap.
This caused the majority of stops errors.
The solution was remove one of the duplicate internal linkbacks or code bracket (did not always work) them and the remap would move on once re-run.
Other stops were caused by users creating the same on post conditions manually by re-posting the same link back to a post not realising the Quote also linked back, perhaps historical habits, styles etc come into play here indicating many users still do not realise how much discourse handles links to make life easier, oh the irony!
After the remap I could have reverted the edits but it was not that many to make a difference and there was still one correct link back to the internal discourse source of the post or quite.
Hopefully this reverses the bulk of google de-indexing 10’s of 1000’s of pages into un-indexed grey limbo.
A little knowledge is a dangerous thing! 