Technically speaking, they really are missing. A single error in a file will cause the game XML parser - the part of the game engine that converts XML into game-useable database format - to discard the
entire file, along with everything you did correctly therein.
The first and most obvious reason I see in the logs that your civ isn't showing up is this:
Code:
[99185.906] table Civilization_FreeBuildingClasses has no column named BuildingClassTypes
[99185.906] In Query - insert into Civilization_FreeBuildingClasses('CivilizationType', 'BuildingClassTypes') values (?, ?);
[99185.906] In XMLSerializer while updating table Civilization_FreeBuildingClasses from file XML/Civilizations/Civ_USA.xml.
You're going to have to learn to read log errors. So, here's a teaching moment for you - what does this error say, line by line?
Typical database.log errors are divided into three lines, which are, in order, the Error, the Process, and the Traceback.
------------------------------------------------------
Line 1: The Error
Code:
[99185.906] table Civilization_FreeBuildingClasses has no column named BuildingClassTypes
This is the immediate cause of why the message appears in the first place. The error won't tell you what exactly you did wrong to trigger the error, but it does tell you what the computer ran across that made the game engine implode, and that's a start.
This error tells us that a table called Civilization_FreeBuildingClasses was being somehow altered using a column called BuildingClassTypes, and that there is no such column, so it doesn't know what to do with the information you gave it.
Usually you'll have to look very closely at spelling. In this case, you added an extra and unneeded - and mod-breaking - "s" at the end of the column name.
At this point the game dumped the file - along with everything else in the file (including the parts defining the civilization, meaning that as far as the game knows,
your civilization does not exist) - and the game still doesn't know what exists in the file after that line. In other words, there are
potentially more errors still unfound beyond this line. So you'll have to correct this, and try again - and if the game turns up another error, fix that, try again... in an endless loop until the game can find no more errors.
Line 2: The Process
Code:
[99185.906] In Query - insert into Civilization_FreeBuildingClasses('CivilizationType', 'BuildingClassTypes') values (?, ?);
This is what the XML parser was doing when it encountered your error. This line tells us pretty much nothing we didn't already know - that Civilization_FreeBuildingClasses was being altered. But there is still extractable information from it, namely:
1. You didn't include the BuildingType column, which
must exist in your code for it to work properly. I don't know if the parser will outright reject your code otherwise or if it will disable that unitclass altogether, but either way... not good.
2. We're inserting into Civilization_FreeBuildingClasses. Before, all we knew is that the table was being altered somehow. This is not particularly useful information, but information nonetheless.
Line 3: The Traceback
Code:
[99185.906] In XMLSerializer while updating table Civilization_FreeBuildingClasses from file XML/Civilizations/Civ_USA.xml.
This line is second in importance only to the first line, because
it tells you what file the error was found in. This is not particularly important in a mod like yours where, chances are, only one file is going to be altering this specific table in anyway. But it still narrows down the search for the error, and in much larger mods, this line can spare you a lot of headaches.
--------------------------------------------------
With that little lesson, I advise you to dissect this error:
Code:
[99185.921] table Language_en_US has no column named Row
[99185.921] In Query - insert into Language_en_US('Row') values (?);
[99185.921] In XMLSerializer while updating table Language_en_US from file XML/NewText/GameText1.xml.
Because it's the cause of all these errors:
Code:
[99188.015] Invalid Reference on Buildings.Help - "TXT_KEY_BUILDING_STEELMILL_HELP" does not exist in Language_en_US
[99188.093] Invalid Reference on Buildings.Strategy - "TXT_KEY_BUILDING_STEELMILL_STRATEGY" does not exist in Language_en_US
[99188.156] Invalid Reference on Buildings.Civilopedia - "TXT_KEY_CIV5_BUILDINGS_STEELMILL_TEXT" does not exist in Language_en_US
[99188.234] Invalid Reference on Buildings.Description - "TXT_KEY_BUILDING_STEELMILL" does not exist in Language_en_US
[99188.625] Invalid Reference on Civilization_UnitClassOverrides.CivilizationType - "CIVILIZATION_USA" does not exist in Civilizations
[99189.046] Invalid Reference on Traits.ShortDescription - "TXT_KEY_TRAIT_CARRY_A_BIG_STICK_SHORT" does not exist in Language_en_US
[99189.125] Invalid Reference on Traits.Description - "TXT_KEY_TRAIT_CARRY_A_BIG_STICK" does not exist in Language_en_US
[99191.203] Invalid Reference on Units.Help - "TXT_KEY_UNIT_HELP_USA_ROUGHRIDERS" does not exist in Language_en_US
[99191.296] Invalid Reference on Units.Strategy - "TXT_KEY_UNIT_USA_ROUGHRIDERS_STRATEGY" does not exist in Language_en_US
[99191.375] Invalid Reference on Units.Civilopedia - "TXT_KEY_CIVILOPEDIA_UNITS_USA_ROUGHRIDERS_TEXT" does not exist in Language_en_US
[99191.453] Invalid Reference on Units.Description - "TXT_KEY_UNIT_USA_ROUGHRIDERS" does not exist in Language_en_US