SQL help needed

[hdd]

Hello there,

I admit I never learned SQL and never used it professionally. Therefore, my skills are low to none.

Problem
If I split a file in two, it's processed correctly.
If it's merged, then some of it (I can't understand precisely where it stops) it's not processed.
I know for sure it doesn't process the end.

Please see below:

I have this file:

Spoiler 1st SQL file :

--
-- _____________ UNITS _____________
--
--upgrade Gran Colombia feature, Ejercito Patriota
UPDATE ModifierArguments SET Value = 3 WHERE ModifierId = 'TRAIT_EJERCITO_PATRIOTA_EXTRA_MOVEMENT' AND Name = 'Amount';
--Super Roman Legions
UPDATE Units SET BaseMoves = 4, BaseSightRange = 3, BuildCharges = 24, Combat = 50 WHERE UnitType = 'UNIT_ROMAN_LEGION';
--Builders build wonders during all Eras
UPDATE UnitCommands SET MaxEra = 8 WHERE CommandType = 'UNITCOMMAND_WONDER_PRODUCTION';
--Better OKIHTCITAW
UPDATE ModifierArguments SET Value = 2 WHERE ModifierId = 'OKIHTCITAW_FREE_PROMOTION' AND Name = 'Amount';
UPDATE Units SET Cost = 45, BaseMoves = 4, BaseSightRange = 3, Combat = 23 WHERE UnitType = 'UNIT_CREE_OKIHTCITAW';
--Cheaper Settlers with slower cost progression, but requires 2 pop/settler and need population of 3 to build first
UPDATE Units SET Cost = 40, PopulationCost= 2, PrereqPopulation = 3, CanCapture='True', CostProgressionParam1 = 2 WHERE UnitType = 'UNIT_SETTLER';
--Builders cost progression downed
UPDATE Units SET Cost = 1, BuildCharges = 10, CostProgressionParam1=0.5 WHERE UnitType = 'UNIT_BUILDER';

and
this file

Spoiler 2nd SQL file :

--Unique units stick around +1 level
--Except for Sumerian War-Cart which is with you since forever
--Several exceptions also in place, since they already upgrade late or never
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_AT_CREW' WHERE Unit = 'UNIT_GREEK_HOPLITE';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_FIELD_CANNON' WHERE Unit = 'UNIT_MAYAN_HULCHE';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_HELICOPTER' WHERE Unit = 'UNIT_HUNGARY_HUSZAR';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_HELICOPTER' WHERE Unit = 'UNIT_MAPUCHE_MALON_RAIDER';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_INFANTRY' WHERE Unit = 'UNIT_HUNGARY_BLACK_ARMY';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_INFANTRY' WHERE Unit = 'UNIT_JAPANESE_SAMURAI';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_INFANTRY' WHERE Unit = 'UNIT_SULEIMAN_JANISSARY';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_INFANTRY' WHERE Unit = 'UNIT_ZULU_IMPI';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_AZTEC_EAGLE_WARRIOR';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_BABYLONIAN_SABUM_KIBITTUM';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_GAUL_GAESATAE';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_GEORGIAN_KHEVSURETI';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_KONGO_SHIELD_BEARER';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_LAHORE_NIHANG';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_NORWEGIAN_BERSERKER';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_LINE_INFANTRY' WHERE Unit = 'UNIT_ROMAN_LEGION';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_MACHINE_GUN' WHERE Unit = 'UNIT_MONGOLIAN_KESHIG';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY' WHERE Unit = 'UNIT_FRENCH_GARDE_IMPERIALE';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_MECHANIZED_INFANTRY' WHERE Unit = 'UNIT_SPANISH_CONQUISTADOR';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_MODERN_AT' WHERE Unit = 'UNIT_SWEDEN_CAROLEAN';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_TANK' WHERE Unit = 'UNIT_ETHIOPIAN_OROMO_CAVALRY';
UPDATE UnitUpgrades SET UpgradeUnit = 'UNIT_TANK' WHERE Unit = 'UNIT_MALI_MANDEKALU_CAVALRY';

I make some mistake somewhere.
Because separately they work, but if I merge them in a single file, they don't.
I've checked database.log.
There is nothing regarding this.
There are some minor errors generated by other mods/files, but nothing related to these files.

Please advise.

Thanks,
hdd

 

[raen]

If they work individually, I believe there is some problem in your mod config, send your .modinfo. If works split, why merge anyway?