Id Unique Constraint Failed

[ZackNAttack]

For some reason, I'm recieving the following error twice in the database.log:

ERROR: UNIQUE constraint failed: Improvement_BonusYieldChanges.Id, Improvement_BonusYieldChanges.ImprovementType, Improvement_BonusYieldChanges.YieldType

The only sql I have relating to the Improvement_BonusYieldChanges is the following:

INSERT INTO Improvement_BonusYieldChanges
        (ImprovementType,                YieldType,            BonusYieldChange,    PrereqTech,            PrereqCivic                    )
VALUES    ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_CULTURE',    2,                    NULL,                'CIVIC_MERCANTILISM'        ),
        ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_GOLD',        2,                    'TECH_ECONOMICS',    NULL                        ),
        ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_GOLD',        2,                    NULL,                'CIVIC_PROFESSIONAL_SPORTS'    ),
        ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_CULTURE',    2,                    NULL,                'CIVIC_GLOBALIZATION'        ),
        ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_GOLD',        2,                    NULL,                'CIVIC_GLOBALIZATION'        );

It doesn't have any Id column though.

What am I doing wrong?

 

[LeeS]

 ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_CULTURE',    2,                    NULL,                'CIVIC_MERCANTILISM'        ),
 ('IMPROVEMENT_ZACK_ONQ_UI',        'YIELD_CULTURE',    2,                    NULL,                'CIVIC_GLOBALIZATION'        ),

Table <Improvement_BonusYieldChanges> does in fact have an "Id" column which defaults to a value of integer "0" when nothing is specified.

		<Row Id="6" ImprovementType="IMPROVEMENT_MINE" YieldType="YIELD_PRODUCTION" BonusYieldChange="1" PrereqTech="TECH_APPRENTICESHIP"/>
		<Row Id="7" ImprovementType="IMPROVEMENT_MINE" YieldType="YIELD_PRODUCTION" BonusYieldChange="1" PrereqTech="TECH_INDUSTRIALIZATION"/>

Since you want two rows in the table where the ImprovementType and the YieldType are the same, you need to provide an "Id" value for these two rows so the game can differentiate between the two rows.

You will also have to do so for all the rows where the YieldType is 'YIELD_GOLD'.

What is needed is that each new row added to the table have a unique combination of values for columns "Id", "ImprovementType", and "YieldType".

 

[ZackNAttack]

Thank you!