For MySQL 8.0+, use REGEXP_REPLACE :
The good news is that there is a solution to this problem. The Topic Links 2.2 archive fix involves updating the plugin's code to correctly handle archived topics. This fix ensures that when topics are archived, they are properly redirected to a new location, and that links to these topics remain intact. Topic Links 2.2 Archive Fix
Rename your current .htaccess to .htaccess_old and upload the default .htaccess file included in the 2.2 installation package. 3. Database "Topic Link" Table Repair For MySQL 8