Just recently there was a similar support question, and the solution offered (basically the answer MarkDHamill gave here), didn't work (yet it is correct).
Coincidentally I had a similar issue yesterday and encountered some problems in the sense that the same SQL MarkDHamill provided just now, didn't work for me this time (although it works on another system), and neither did the SQL I had posted (which also worked on another system). I still haven't found out what the reason is (tried on different systems) but I needed to move on so I used another solution I proposed:
Put the board in maintenance mode, download the posts_table, edit the posts_table (SQL format) with a good text editor capable of handling large files (in my case 3 GB). I needed to remove a part of a url in all posts containing a certain link and used Notepad+.
It needed about 30 seconds and it was done. Then uploaded the edited SQL to restore the posts_table.
All done in about 30 minutes. (taking a full backup, backup the posts_table, download, edit, upload, restore the edited post_table).
bikeridr wrote: ↑Wed Jan 25, 2023 8:09 am
I will try that on my mock forum and test this thoroughly before doing so to my real forum.
Exactly!!
Edited:
reformulated the first paragraph: I was probably half asleep when I wrote it originally