[GS] Ziggurat improvement mod changes not registering

shortfatsteve

Chieftain
Joined
Mar 8, 2020
Messages
3
Hi, new to modding, so I'm starting by altering some mods I like that I wanted to tweak. There's a mod called Sumeria Revamp by S1AL from the Steam workshop that I've started with since it's kind of OP. There's a few sections to it that I've tweaked and all work fine as far as I've tested except for the one altering the Ziggurat. All I've done is removed some late era yield bonuses, but nothing, including the added Tech Prerequisite, seems to be registering. I'd appreciate any help offered. Here's the code :
Code:
DELETE FROM ImprovementModifiers          WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
DELETE FROM Improvement_BonusYieldChanges WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';
DELETE FROM Improvement_YieldChanges      WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';

UPDATE Improvements
    SET Housing='1' , TilesRequired='1' , OnePerCity='1' , SameAdjacentValid='0' , PrereqTech='TECH_MASONRY'
    WHERE ImprovementType='IMPROVEMENT_ZIGGURAT';

INSERT INTO Improvement_ValidTerrains
    (ImprovementType , TerrainType)
    VALUES
    ('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_DESERT_HILLS'),
    ('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_TUNDRA_HILLS'),
    ('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_PLAINS_HILLS'),
    ('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_GRASS_HILLS' ),
    ('IMPROVEMENT_ZIGGURAT' , 'TERRAIN_SNOW_HILLS'  );
INSERT INTO Improvement_YieldChanges
    (ImprovementType        , YieldType       , YieldChange)
    VALUES
    ('IMPROVEMENT_ZIGGURAT' , 'YIELD_SCIENCE' , '2'),
    ('IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1'),
    ('IMPROVEMENT_ZIGGURAT' , 'YIELD_FAITH'   , '2');
INSERT INTO Improvement_BonusYieldChanges
    (Id    , ImprovementType        , YieldType       , BonusYieldChange , PrereqTech , PrereqCivic)
    VALUES
    ('261' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1'              , NULL       , 'CIVIC_DRAMA_POETRY'     ),
    ('262' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_FAITH'   , '1'              , NULL       , 'CIVIC_CIVIL_SERVICE'    ),
    ('263' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_SCIENCE' , '1'              , NULL       , 'CIVIC_THE_ENLIGHTENMENT'),
    ('264' , 'IMPROVEMENT_ZIGGURAT' , 'YIELD_CULTURE' , '1'              , NULL       , 'CIVIC_OPERA_BALLET'     );
INSERT INTO District_Adjacencies
    (DistrictType         , YieldChangeId)
    VALUES
    ('DISTRICT_CAMPUS'    , 'Ziggurat_Science'),
    ('DISTRICT_THEATER'   , 'Ziggurat_Culture'),
    ('DISTRICT_HOLY_SITE' , 'Ziggurat_Faith'  );
INSERT INTO Adjacency_YieldChanges
    (ID                 , Description   , YieldType       , YieldChange , TilesRequired , AdjacentImprovement)
    VALUES
    ('Ziggurat_Science' , 'LOC_DISTRICT_ZIGGURAT_SCIENCE' , 'YIELD_SCIENCE' , '1'         , '1'           , 'IMPROVEMENT_ZIGGURAT'),
    ('Ziggurat_Culture' , 'LOC_DISTRICT_ZIGGURAT_CULTURE' , 'YIELD_CULTURE' , '1'         , '1'           , 'IMPROVEMENT_ZIGGURAT'),
    ('Ziggurat_Faith'   , 'LOC_DISTRICT_ZIGGURAT_FAITH'   , 'YIELD_FAITH'   , '1'         , '1'           , 'IMPROVEMENT_ZIGGURAT');
 
The first answer is as always: What is showing in Database.log ?

~\Documents\My Games\Sid Meier's Civilization VI\Logs/Database.log
This is actually just a text file that can be opened with Notepad++ or most other text editors. Plain Olde-Style Notepad doesn't read the encoding of the file correctly however, and you get one long indecipherable paragraph if you open the file with plain Notepad.
 
I had a look at the Database log and by comparing it with the Modding log I tracked the error down to this line :
Code:
[3173831.361] [Gameplay] ERROR: near "INSERT": syntax error
The file I'm altering is an SQL with a series of changes for different elements of the Sumeria civ. I realize now that the error was in the text above the portion I included in the original post, altering the War Cart, where I had removed a line from the original mod that ended with a semi-colon and forgot to add that semi-colon to the new final line above it. D'oh!

Thanks all the same LeeS -- it was your question that prompted me to look deeper into the the Log files and how they're easy to cross-reference with timestamps. All because I didn't want to copy my Database log, which is full of errors (mostly benign) relating to other mods, for everyone one to see, lol! I also have be using your 500+ page modding guide for learning and reference.

I've caught the modding bug, so I'll be back on these forums if (*when*) I have more questions!
 
Back
Top Bottom