broadcast_text and _locale tables mixed up for ID 24993,25261,33657

[biosfree]

Current Behaviour

In the acore_world database in the broadcast_text and broadcast_text_locale tables, the text from broadcast_text does not match the text from locale (when comparing IDs). The following IDs are mixed up: 24993,25261,33657

Expected Blizzlike Behaviour

I don't understand how to check in the game (or according to www.wowhead.com/wotlk data), because I don't understand what the ID from the broadcast_text table correlates to. Accordingly, I cannot understand whether the error is in the broadcast_text or broadcast_text_locale table.

Source

No response

Steps to reproduce the problem

You can see the mismatch by executing an SQL query:

SELECT broadcast_text.ID, broadcast_text.MaleText, broadcast_text.FemaleText, broadcast_text_locale.MaleText, broadcast_text_locale.FemaleText
FROM acore_world.broadcast_text JOIN acore_world.broadcast_text_locale USING (ID)
WHERE ID IN (24993,25261,33657);

Extra Notes

No response

AC rev. hash/commit

d851f97 2025-01-21 20:13:22 -0300 (master branch)

Operating system

Debian 12 x64

Custom changes or Modules

| +- mod-ah-bot
| +- mod-anticheat
| +- mod-eluna
| +- mod-gain-honor-guard
| +- mod-reagent-bank-account
| +- mod-skip-dk-starting-area
| +- mod-solo-lfg
| +- mod-solocraft
| +- mod-starter-guild
| +- mod-transmog

[TheSCREWEDSoftware]

I'm trying to understand the issue here i'm confused. I added broadcast_text_locale.locale to the query to I could visualise the 2 tables with their respectives locales.

SELECT broadcast_text.ID, broadcast_text.MaleText, broadcast_text.FemaleText, broadcast_text_locale.locale, broadcast_text_locale.MaleText, broadcast_text_locale.FemaleText
FROM acore_world.broadcast_text JOIN acore_world.broadcast_text_locale USING (ID)
WHERE ID IN (24993,25261,33657);

Edit: I think i understand what you mean some of this entries are the wrong equivalent translation is that it?