Hi, i cant help you on this specific issue but you seems impacted by this bug:
Mysql dependency error with MariaDB and Debian 12 - Request Tracker Community Forum (bestpractical.com)
If you start on a fresh server and database, for avoid future problem with text searching, i suggest you to go on a postgresql database who give better result with RT.
Kind regards,