I think you accidentally have water taking up 10 cargo capacity per unit rather than 1 cargo capacity per unit
Nah this is intentional
That's really unfortunate because it's basically gamebreaking; if I get a mission to transport something it calculates assuming 1 unit = 1 cargo capacity. I just got a mission to transport some 2000 water, I thought I had the cargo capacity for it, so did the game. But it loaded me up past 20,000 cargo capacity, forcing me to cancel the contract and sell all the water at that planet.
Two better implementations would be:
1. The game understands water takes up 10 cargo capacity per unit and calculates appropriately when providing missions, loot, etc.
2. Water is provided in amounts like ore, in the tens of thousands, so that it continues to stick with the game's consistent logic that 1 cargo capacity = 1 unit that applies to all other economic goods while providing water in the large amounts intended
For those interested in fixing this manually, I think
a change to commodities.csv in Ashes of The Domain- Vaults of Knowledge 1.5.1\data\campaign may do itNevermind, this causes the game to crash. I guess the source code needs to be edited and recompiled then.