XF 2.3 BBCode replacement not taking effect after SQL update (IPB to XenForo migration)

[jacdem]

Hello,
I recently migrated my forum from Invision Power Board (IPB) to XenForo. As part of the cleanup process, I ran the following SQL queries directly in the database to replace old BBCode tags:

UPDATE xf_post
SET message = REPLACE(message, '[hide]', '[REPLYTHANKS]')
WHERE message LIKE '%[hide]%';

UPDATE xf_post
SET message = REPLACE(message, '[/hide]', '[/REPLYTHANKS]')
WHERE message LIKE '%[/hide]%';

The queries executed without error, and the xf_post table is quite large (over 400 MB). However, no change is visible on the forum frontend, even after several hours.
Is there any internal cache I need to rebuild, or an extra step required for XenForo to reflect the updated post content?
Do I need to rebuild post content manually from the Admin CP?
Thank you for your guidance.

 

[ForumDevs]

Is there any internal cache I need to rebuild, or an extra step required for XenForo to reflect the updated post content?
Do I need to rebuild post content manually from the Admin CP?

You should Rebuild threads on admin.php?tools/rebuild:

 

[jacdem]

I did this action 10 times. No difference.