Install Steam
login
|
language
简体中文 (Simplified Chinese)
繁體中文 (Traditional Chinese)
日本語 (Japanese)
한국어 (Korean)
ไทย (Thai)
Български (Bulgarian)
Čeština (Czech)
Dansk (Danish)
Deutsch (German)
Español - España (Spanish - Spain)
Español - Latinoamérica (Spanish - Latin America)
Ελληνικά (Greek)
Français (French)
Italiano (Italian)
Bahasa Indonesia (Indonesian)
Magyar (Hungarian)
Nederlands (Dutch)
Norsk (Norwegian)
Polski (Polish)
Português (Portuguese - Portugal)
Português - Brasil (Portuguese - Brazil)
Română (Romanian)
Русский (Russian)
Suomi (Finnish)
Svenska (Swedish)
Türkçe (Turkish)
Tiếng Việt (Vietnamese)
Українська (Ukrainian)
Report a translation problem
You can add the ability to remove grassland and plains floodplains by adding the commands below to your TCHarvestableResources.sql file (floodplain code is at line 166). This file is found at ...\Steam\steamapps\workshop\content\289070\2556804240
UPDATE Features
SET RemoveTech = 'TECH_ENGINEERING', Removable = '1'
WHERE FeatureType = 'FEATURE_FLOODPLAINS_GRASSLAND';
UPDATE Features
SET RemoveTech = 'TECH_ENGINEERING', Removable = '1'
WHERE FeatureType = 'FEATURE_FLOODPLAINS_PLAINS';
The updated mod is Removable Resources and Features: Fixificated
Is this a common issue?
[483733.364] [Gameplay] ERROR: UNIQUE constraint failed: Resource_Harvests.ResourceType, Resource_Harvests.YieldType
[483733.364] [Gameplay] ERROR: UNIQUE constraint failed: Resource_Harvests.ResourceType, Resource_Harvests.YieldType
this doesnt keep the game away from loading like it did with civilizations expanded mod for me but you might want to give it a check
You don't need to improve this, but if you want to, what do you think about adding an environmental cost to the later removal, especially strategic.
Like completely removing oil would be a bit of an occurrence environmental mess!
Great work.
The underlying cause: RESOURCE_AMBER can be improved by a mine (on land) or fishing boats (on water). It ends up in Resources_TC_Harvestable_Luxury_Data twice (as Food/Gold and Production/Gold), and then inserted into Resource_Harvests twice from there. The two different gold yields trigger the "ERROR: UNIQUE constraint failed: Resource_Harvests.ResourceType, Resource_Harvests.YieldType" error, and the entire mod fails to load as a result.
The mod failing to load due to SQL error explains all the complaints about it not doing anything. It's been broken since Amber was introduced (In R&F), or since a UNIQUE constraint was added to the Resource_Harvests table (unknown when).