Game crashes with my mod installed on some map reveal event

[slegach]

That is. I can start a game, play for many turns, but at some point when I move a unit and he uncovers some object on the map from the fog of war, the game crashes.
I've checked the database log, it's ok.
I don't use lua, only change DB values.
What can it be? Can I look for some other logs?
BTW this happens both Vanilla and R&F

Here is an additional question to understand how to find out the problem. Does mod file changes affect the state of loaded save games or not? I mean is it possible to start the game with a mod, have a crash, change mod, load save and test whether there is a crash again or not.

 

[LeeS]

I mean is it possible to start the game with a mod, have a crash, change mod, load save and test whether there is a crash again or not.

So long as you do not add or remove a unit, building, etc., from your mod's code you can correct your DB code and reload the save.

Without your mod to look at it will be nearly impossible for any of us to attempt to determine the cause of your crash

 

[slegach]

Here it is (I've also changed configuration db to adjust map sizes/allowed players/cs but don't think it relates to the problem):

DELETE FROM CivicModifiers WHERE ModifierId='CIVIC_GRANT_PLAYER_GOVERNOR_POINTS';
DELETE FROM BuildingModifiers WHERE ModifierId='CONTRATACION_GOVERNOR_POINTS';
UPDATE GreatPersonIndividualActionModifiers SET ModifierId='GREATPERSON_GOLD_SMALL' WHERE ModifierId='GREATPERSON_GOVERNOR_POINTS';
UPDATE Moments SET MinimumGameEra=NULL, MaximumGameEra=NULL, ObsoleteEra='ERA_ANCIENT';
UPDATE GlobalParameters SET Value='0' WHERE Name='DARK_AGE_SCORE_BASE_THRESHOLD';
UPDATE GlobalParameters SET Value='0' WHERE Name='NEXT_ERA_TURN_COUNTDOWN';

UPDATE Maps SET GridWidth='30', GridHeight='15' WHERE MapSizeType='MAPSIZE_DUEL';
UPDATE Maps SET GridWidth='45', GridHeight='25' WHERE MapSizeType='MAPSIZE_TINY';
UPDATE Maps SET GridWidth='60', GridHeight='35' WHERE MapSizeType='MAPSIZE_SMALL';
UPDATE Maps SET GridWidth='75', GridHeight='45' WHERE MapSizeType='MAPSIZE_STANDARD';
UPDATE Maps SET GridWidth='90', GridHeight='55' WHERE MapSizeType='MAPSIZE_LARGE';
UPDATE Maps SET GridWidth='105', GridHeight='65' WHERE MapSizeType='MAPSIZE_HUGE';
UPDATE GlobalParameters SET Value='2' WHERE Name='CITY_MIN_RANGE';
UPDATE GlobalParameters SET Value='15' WHERE Name='BARBARIAN_CAMP_MAX_PER_MAJOR_CIV';
UPDATE GlobalParameters SET Value='1' WHERE Name='BARBARIAN_CAMP_MINIMUM_DISTANCE_ANOTHER_CAMP';
UPDATE GlobalParameters SET Value='3' WHERE Name='BARBARIAN_CAMP_ODDS_OF_NEW_CAMP_SPAWNING';
UPDATE GlobalParameters SET Value='50' WHERE Name='WARMONGER_REDUCTION_IF_DENOUNCED';
UPDATE GlobalParameters SET Value='80' WHERE Name='WARMONGER_REDUCTION_IF_AT_WAR';
UPDATE GlobalParameters SET Value='2' WHERE Name='WAR_WEARINESS_WARMONGER_BASE';
UPDATE GlobalParameters SET Value='25' WHERE Name='WARMONGER_LIBERATE_POINTS';
UPDATE Eras SET WarmongerPoints ='1', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_LIGHT' WHERE EraType='ERA_CLASSICAL';
UPDATE Eras SET WarmongerPoints ='2', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_LIGHT' WHERE EraType='ERA_MEDIEVAL';
UPDATE Eras SET WarmongerPoints ='3', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_MODERATE' WHERE EraType='ERA_RENAISSANCE';
UPDATE Eras SET WarmongerPoints ='5', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_MODERATE' WHERE EraType='ERA_INDUSTRIAL';
UPDATE Eras SET WarmongerPoints ='10', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_HEAVY' WHERE EraType='ERA_MODERN';
UPDATE Eras SET WarmongerPoints ='15', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_HEAVY' WHERE EraType='ERA_ATOMIC';
UPDATE Eras SET WarmongerPoints ='20', WarmongerLevelDescription='LOC_WARMONGER_LEVEL_HEAVY' WHERE EraType='ERA_INFORMATION';

UPDATE Happinesses SET MaximumAmenityScore='-7', GrowthModifier='-100', NonFoodYieldModifier='-80', RebellionPoints='5' WHERE HappinessType='HAPPINESS_REVOLT';
UPDATE Happinesses SET MinimumAmenityScore='-6', MaximumAmenityScore='-5', GrowthModifier='-75', NonFoodYieldModifier='-60', RebellionPoints='2' WHERE HappinessType='HAPPINESS_UNREST';
UPDATE Happinesses SET MinimumAmenityScore='-4', MaximumAmenityScore='-3', GrowthModifier='-50', NonFoodYieldModifier='-40', RebellionPoints='1' WHERE HappinessType='HAPPINESS_UNHAPPY';
UPDATE Happinesses SET MinimumAmenityScore='-2', MaximumAmenityScore='-1', GrowthModifier='-25', NonFoodYieldModifier='-20', RebellionPoints='0' WHERE HappinessType='HAPPINESS_DISPLEASED';
UPDATE Happinesses SET MinimumAmenityScore='0', MaximumAmenityScore='1', GrowthModifier='0', NonFoodYieldModifier='0', RebellionPoints='-1' WHERE HappinessType='HAPPINESS_CONTENT';
UPDATE Happinesses SET MinimumAmenityScore='2', MaximumAmenityScore='3', GrowthModifier='25', NonFoodYieldModifier='25', RebellionPoints='-1' WHERE HappinessType='HAPPINESS_HAPPY';
UPDATE Happinesses SET MinimumAmenityScore='4', GrowthModifier='50', NonFoodYieldModifier='50', RebellionPoints='-1' WHERE HappinessType='HAPPINESS_ECSTATIC';

UPDATE Districts SET OnePerCity='0';
UPDATE Districts SET OnePerCity='1' WHERE DistrictType='DISTRICT_CITY_CENTER';
UPDATE Districts SET OnePerCity='1' WHERE DistrictType='DISTRICT_WONDER';
UPDATE Districts SET Housing='1' WHERE Housing='0';
UPDATE GlobalParameters SET Value='0' WHERE Name='DISTRICT_POPULATION_REQUIRED_PER';

UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_FARM' AND YieldType='YIELD_FOOD';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_MINE' AND YieldType='YIELD_PRODUCTION';
UPDATE Improvement_YieldChanges SET YieldChange='1' WHERE ImprovementType='IMPROVEMENT_QUARRY' AND YieldType='YIELD_GOLD';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_FISHING_BOATS' AND YieldType='YIELD_FOOD';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_PASTURE' AND YieldType='YIELD_PRODUCTION';
UPDATE Improvement_YieldChanges SET YieldChange='1' WHERE ImprovementType='IMPROVEMENT_PLANTATION' AND YieldType='YIELD_FOOD';
UPDATE Improvement_YieldChanges SET YieldChange='1' WHERE ImprovementType='IMPROVEMENT_CAMP' AND YieldType='YIELD_FOOD';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_LUMBER_MILL' AND YieldType='YIELD_PRODUCTION';
INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_LUMBER_MILL', 'YIELD_GOLD', '1');

UPDATE Improvement_YieldChanges SET YieldChange='3' WHERE ImprovementType='IMPROVEMENT_OIL_WELL' AND YieldType='YIELD_PRODUCTION';
INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_OIL_WELL', 'YIELD_SCIENCE', '2');
UPDATE Improvement_YieldChanges SET YieldChange='3' WHERE ImprovementType='IMPROVEMENT_OFFSHORE_OIL_RIG' AND YieldType='YIELD_PRODUCTION';
INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_OFFSHORE_OIL_RIG', 'YIELD_SCIENCE', '2');
UPDATE Improvement_YieldChanges SET YieldChange='3' WHERE ImprovementType='IMPROVEMENT_CHATEAU' AND YieldType='YIELD_CULTURE';
UPDATE Improvement_YieldChanges SET YieldChange='3' WHERE ImprovementType='IMPROVEMENT_COLOSSAL_HEAD' AND YieldType='YIELD_FAITH';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_KURGAN' AND YieldType='YIELD_FAITH';
UPDATE Improvement_YieldChanges SET YieldChange='3' WHERE ImprovementType='IMPROVEMENT_MISSION' AND YieldType='YIELD_FAITH';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_SPHINX' AND YieldType='YIELD_CULTURE';
UPDATE Improvement_YieldChanges SET YieldChange='2' WHERE ImprovementType='IMPROVEMENT_STEPWELL' AND YieldType='YIELD_FOOD';
INSERT INTO Improvement_YieldChanges (ImprovementType, YieldType, YieldChange) VALUES ('IMPROVEMENT_ZIGGURAT', 'YIELD_GOLD', '1');

UPDATE Terrains SET DefenseModifier='5' WHERE DefenseModifier='3';
UPDATE Improvements SET DefenseModifier='5' WHERE ImprovementType='IMPROVEMENT_BARBARIAN_CAMP';
UPDATE Improvements SET DefenseModifier='10' WHERE ImprovementType='IMPROVEMENT_FORT';
UPDATE Improvements SET DefenseModifier='10' WHERE ImprovementType='IMPROVEMENT_ROMAN_FORT';
UPDATE GlobalParameters SET Value='5' WHERE Name='COMBAT_FLANKING_BONUS_MODIFIER';
UPDATE GlobalParameters SET Value='10' WHERE Name='COMBAT_RIVER_DEFENSE';
UPDATE GlobalParameters SET Value='5' WHERE Name='FORTIFY_BONUS_PER_TURN';
UPDATE GlobalParameters SET Value='1' WHERE Name='FORTIFY_TURN_MAX';
UPDATE GlobalParameters SET Value='5' WHERE Name='COMBAT_GARRISON_MILITIA_MODIFIER';
UPDATE Districts SET HitPoints='300', CityStrengthModifier='5' WHERE DistrictType='DISTRICT_CITY_CENTER';
UPDATE Buildings SET OuterDefenseHitPoints='100', OuterDefenseStrength='5' WHERE BuildingType='BUILDING_WALLS' OR BuildingType='BUILDING_CASTLE' OR BuildingType='BUILDING_STAR_FORT';

UPDATE Resource_YieldChanges SET YieldChange='2' WHERE ResourceType='RESOURCE_FISH' AND YieldType='YIELD_FOOD';
INSERT INTO Resource_YieldChanges (ResourceType, YieldType, YieldChange) VALUES ('RESOURCE_WHALES', 'YIELD_FOOD', '1');