Project

General

Profile

[SOLVED] Topic markdown links broken after restoring mistakenly deleted user

Added by Adam Flammino about 3 years ago

I'm running redmine 4.1.1 in a docker container backed by mysql community 5.7.31

I mistakenly deleted a user from redmine instead of locking, but I was able to restore their contributions.

The only trouble I'm having now is links to topics they created are broken- for example, on one topic we have two links:

text0: https://redmine.our-domain.com/boards/10/topics/3000 < works
text1: https://redmine.our-domain.com/boards/10/topics/0?r=3001#message-3001 < does not work, but if I manually change the format of the url to match the one above, it does. All the links that are broken link back to the previously deleted user's contributions

I thought I could just run a find/replace on the messages, but they're stored as markdown in the messages table in the db:

text0: SVN Access
text1: RE: Help with repository browsing

edit: interestingly the markdown is displayed differently here too, but what I meant by the above was

text0: message#3000
text1: message#3001

Any ideas on how I can fix these?


Replies (1)

RE: Topic markdown links broken after restoring mistakenly deleted user - Added by Adam Flammino about 3 years ago

The problem ended up being the user's threads got set to a parent_id of 0 instead of NULL, so the links were looking for a non-existent 3001st reply to the 0th message in the forums. I updated the parent ids to NULL, and that fixed it.

    (1-1/1)