Mac Modding Help: Lua script fails to load due to persistent UNIQUE constraint failed error

[Lockwood27]

I'm hoping for some expert eyes on an issue I've been facing for like weeks (tried 50 times, I'm desperate) on macOS (Sequoia 15.6, Steam, Gathering Storm). I'm building the mod manually.

My goal is a minimal test: a Lua script that adds 1 point to the score each turn. However, the script never runs, and the score stays at 0. After fixing some initial errors, my logs now consistently point to a <span>UNIQUE constraint failed</span> error in my text file, even though I believe I've corrected it.

Since I don't have a <span>lua.log</span> on Mac, the <span>Database.log</span> is my only clue, and it seems the game is halting the loading of my mod's components because of this text file error.

The Problem​

My <span>Database.log</span> shows this error:<span>[Localization] ERROR: UNIQUE constraint failed: LocalizedText.Language, LocalizedText.Tag ... In XMLSerializer while updating table LocalizedText from file BalancedScoring_Text.xml.</span>

This happens because I'm trying to change the text for <span>LOC_WORLD_RANKINGS_SCORE_VICTORY</span>. I've changed my XML to use <span>&lt;Update&gt;</span> instead of <span>&lt;Row&gt;</span>, but the error persists. I'm wondering if there's a subtle issue in my <span>.modinfo</span> or the XML file itself that's causing the game to misinterpret the action.

Could anyone please review my files below and see if you can spot the mistake? I've literally been banging my head against a wall and can't seem to even get off the starting line with this mod. Feel like an idiot.

The Mod Files​

Here is the complete code for my test mod.

<span>BalancedScoring_V1_Test.modinfo</span>

<span>&lt;?xml version="1.0" encoding="utf-8"?&gt;<br>&lt;Mod id="f5d7e9c8-a1b2-4f3c-8d5e-6a7b8c9d0e1f" version="1"&gt;<br> &lt;Properties&gt;<br> &lt;Name&gt;Balanced Scoring V1 (Minimal Test)&lt;/Name&gt;<br> &lt;Description&gt;A new scoring system for Civilization VI.&lt;/Description&gt;<br> &lt;Teaser&gt;Balanced Scoring V1 Test&lt;/Teaser&gt;<br> &lt;Authors&gt;You&lt;/Authors&gt;<br> &lt;CompatibleVersions&gt;2.0&lt;/CompatibleVersions&gt;<br> &lt;/Properties&gt;<br><br> &lt;Files&gt;<br> &lt;File&gt;Lua/BalancedScoring_GameManager.lua&lt;/File&gt;<br> &lt;File&gt;Lua/BalancedScoring_UI.lua&lt;/File&gt;<br> &lt;File&gt;UI/WorldRankings_Expansion2.xml&lt;/File&gt;<br> &lt;File&gt;XML/BalancedScoring_GameSetup.xml&lt;/File&gt;<br> &lt;File&gt;XML/BalancedScoring_Text.xml&lt;/File&gt;<br> &lt;/Files&gt;<br><br> &lt;FrontEndActions&gt;<br> &lt;UpdateDatabase id="UpdateGameSetup"&gt;<br> &lt;File&gt;XML/BalancedScoring_GameSetup.xml&lt;/File&gt;<br> &lt;/UpdateDatabase&gt;<br> &lt;UpdateText id="UpdateGameText"&gt;<br> &lt;Properties&gt;<br> &lt;LoadOrder&gt;100&lt;/LoadOrder&gt;<br> &lt;/Properties&gt;<br> &lt;File&gt;XML/BalancedScoring_Text.xml&lt;/File&gt;<br> &lt;/UpdateText&gt;<br> &lt;/FrontEndActions&gt;<br><br> &lt;InGameActions&gt;<br> &lt;AddGameplayScripts id="AddGameManager"&gt;<br> &lt;File&gt;Lua/BalancedScoring_GameManager.lua&lt;/File&gt;<br> &lt;/AddGameplayScripts&gt;<br> &lt;AddUserInterfaces id="AddWorldRankingsUI"&gt;<br> &lt;Properties&gt;<br> &lt;Context&gt;InGame&lt;/Context&gt;<br> &lt;/Properties&gt;<br> &lt;File&gt;UI/WorldRankings_Expansion2.xml&lt;/File&gt;<br> &lt;/AddUserInterfaces&gt;<br> &lt;AddUserInterfaces id="AddUIHooks"&gt;<br> &lt;Properties&gt;<br> &lt;Context&gt;InGame&lt;/Context&gt;<br> &lt;/Properties&gt;<br> &lt;File&gt;Lua/BalancedScoring_UI.lua&lt;/File&gt;<br> &lt;/AddUserInterfaces&gt;<br> &lt;UpdateText id="UpdateGameText_InGame"&gt;<br> &lt;Properties&gt;<br> &lt;LoadOrder&gt;100&lt;/LoadOrder&gt;<br> &lt;/Properties&gt;<br> &lt;File&gt;XML/BalancedScoring_Text.xml&lt;/File&gt;<br> &lt;/UpdateText&gt;<br> &lt;/InGameActions&gt;<br>&lt;/Mod&gt;<br></span><br>
<span>XML/BalancedScoring_Text.xml</span>

<span>&lt;?xml version="1.0" encoding="utf-8"?&gt;<br>&lt;GameInfo&gt;<br> &lt;LocalizedText&gt;<br> &lt;!-- Add new text entries for the mod's options --&gt;<br> &lt;Row Tag="LOC_BALANCED_SCORING_NAME" Language="en_US"&gt;<br> &lt;Text&gt;Enable Balanced Scoring&lt;/Text&gt;<br> &lt;/Row&gt;<br> &lt;Row Tag="LOC_BALANCED_SCORING_DESC" Language="en_US"&gt;<br> &lt;Text&gt;Enables the Balanced Scoring mode.&lt;/Text&gt;<br> &lt;/Row&gt;<br> &lt;Row Tag="LOC_SCORE_TEST" Language="en_US"&gt;<br> &lt;Text&gt;Per Turn Test&lt;/Text&gt;<br> &lt;/Row&gt;<br><br> &lt;!-- Update existing game text --&gt;<br> &lt;Update&gt;<br> &lt;Where Tag="LOC_WORLD_RANKINGS_SCORE_VICTORY" Language="en_US"/&gt;<br> &lt;Set&gt;<br> &lt;Text&gt;Balanced Scoring&lt;/Text&gt;<br> &lt;/Set&gt;<br> &lt;/Update&gt;<br> &lt;/LocalizedText&gt;<br>&lt;/GameInfo&gt;<br></span><br>
<span>Lua/BalancedScoring_GameManager.lua</span>

<span>-- ===========================================================================<br>-- BalancedScoring_GameManager.lua (MINIMAL VIABLE TEST)<br>-- This script attempts to add 1 point to the human player's score every turn.<br>-- ===========================================================================<br><br>function AddOnePointPerTurn(iPlayer)<br> -- We only care about the human player (Player ID 0 in single player)<br> if iPlayer == 0 then<br> local pPlayer = Players[iPlayer];<br> <br> -- This is a critical safety check. If pPlayer is nil for any reason,<br> -- the script will stop here instead of crashing.<br> if pPlayer then<br> pPlayer:ChangeScore(1, "LOC_SCORE_TEST");<br> print("Minimal Test: Attempted to add 1 point to Player 0.");<br> else<br> print("Minimal Test Error: Player 0 object is nil.");<br> end<br> end<br>end<br><br>-- We are hooking into PlayerTurnStarted. This event fires reliably at the start of every player's turn.<br>GameEvents.PlayerTurnStarted.Add(AddOnePointPerTurn);<br><br>print("Balanced Scoring Minimal Test Loaded.");<br></span><br>
(The other files are just UI placeholders and the game setup toggle, which works fine, so I've omitted them for brevity but can post if needed).

Log Files​

Here are my <span>Modding.log</span> and <span>Database.log</span> from the failed test.

<span>Modding.log</span>

<span>[2664641.232] Initializing Modding Framework.<br>[2664641.232] Connected to modding database!<br>[2664641.232] Modding database is up-to-date!<br>[2664641.232] Initializing Services...<br>[2664641.232] Mod Discovery Service initialized.<br>[2664641.232] Scanning for Mods...<br>[2664641.232] Discovered Mod: f5d7e9c8-a1b2-4f3c-8d5e-6a7b8c9d0e1f (Balanced Scoring V1 (Minimal Test))<br>...<br>[2664641.232] Modding Framework - Apply Components<br>[2664641.232] Loading Mod - /Users/AK/Library/Application Support/Sid Meier's Civilization VI/Sid Meier's Civilization VI/Mods/BalancedScoring_V1_Test/BalancedScoring_V1_Test.modinfo<br>[2664641.232] Applying Component - UpdateGameSetup (UpdateDatabase)<br>[2664641.232] Applying Component - UpdateGameText (UpdateText)<br>...<br>[2664641.232] Applying Component - AddGameManager (AddGameplayScripts)<br>[2664641.232] Applying Component - AddWorldRankingsUI (AddUserInterfaces)<br>[2664641.232] Applying Component - AddUIHooks (AddUserInterfaces)<br>[2664641.232] Applying Component - UpdateGameText_InGame (UpdateText)<br>...<br>[2664641.232] Modding Framework - Finished Apply Components<br>[2664641.232] Applied all components of enabled mods.<br></span><br>
<span>Database.log</span>

<span>[2664640.232] [Configuration]: Validating Foreign Key Constraints...<br>[2664640.232] [Configuration]: Passed Validation.<br>[2664641.232] [FullTextSearch]: Initializing FullTextSearch<br>[2664641.232] [Gameplay]: Validating Foreign Key Constraints...<br>[2664641.232] [Gameplay]: Passed Validation.<br>[2664641.232] [Localization] ERROR: UNIQUE constraint failed: LocalizedText.Language, LocalizedText.Tag<br>[2664641.232] [Localization]: While executing - 'insert into LocalizedText('Tag', 'Language', 'Text') values (?, ?, ?);'<br>[2664641.232] [Localization]: In XMLSerializer while inserting row into table insert into LocalizedText('Tag', 'Language', 'Text') with values (LOC_WORLD_RANKINGS_SCORE_VICTORY, en_US, Balanced Scoring, ).<br>[2664641.232] [Localization]: In XMLSerializer while updating table LocalizedText from file BalancedScoring_Text.xml.<br>[2664673.232] [Gameplay]: Validating Foreign Key Constraints...<br>[2664673.232] [Gameplay]: Passed Validation.<br></span><br>
(I've cleaned up the logs to show only the relevant parts)

Can anyone see what I'm missing? Why isn't this script running and changing the score? Any advice would be hugely appreciated.

 

[Smayo]

first off, you are in the VII forum, so the wrong section. Second, its very hard to debug these things without Firetuner or a Lua.log. I gave up doing so on Mac. It probably wont be your localisaton, there are errors by firaxis in those as well. Lastly. your code is such a mess to look at, did you mess up the formatting?