TipofmyJoystick - What was that game called again?

I recall seeing this game in a video a long while ago about soft-locks in games iirc.

From what I remember the game seemed like a traditional retro JRPG with pixel art graphics and turn-based combat with stats, HP/MP, levels, and magic skills. I suspect it predates the N64 due to it being more reminiscent of SNES RPGs in terms of style but I'm not sure.

The party was visible along side the enemy and I think it was four members in the party?

The defining feature I remember from this game was that there was an encounter with an enemy where at some point in the battle you would learn a skill you have to use to defeat this enemy. But the video I watched also described a quirk where for some reason the character may not learn the skill leading to a soft-lock where the player has to reset the encounter.

I think the skill was a fire skill as well but it's possible I'm also misremembering that.

Edit: I think the video game came from an Outsidexbox/Outside Xtra video if anyone is looking.

Edit 2: This is incredibly dubious but from what I remember the enemy might've been on horseback?

I've been trying to recall a game I played briefly as a kid at a friends house.

I feel like it was similar in style to Settlers 4 with an isometric view, typical click and drag a square around who you want to control, and a focus on building and combat. What makes me think it wasn't Settlers 4 is I don't recall it having that kind of cartoon style and I vividly remember there being some kind of cheat code that would reveal the map.

The reason I say it's around 2006 was because I originally went to buy it in a Future Shop (a Canadian store that was bought by Best Buy) but my mom said I should get Civilizations 4 instead because she recalled my uncle talking about it.