[Dbix-class] Duplicate entry error on create

[Dermot]

2009/12/9 Ronald J Kimball <rkimball+dbixclass at pangeamedia.com>:
> Dermot wrote:
>>
>> 2009/12/9 Eden Cardim <edencardim at gmail.com>:
>>>>>>>>
>>>>>>>> "Dermot" == Dermot  <paikkos at googlemail.com> writes:
>>>
>>>   Dermot> Hi, I am getting the following error when I attempt to
>>>   Dermot> create a record.
>>>
>>>   Dermot> DBD::mysql::st execute failed: Duplicate entry '0' for key 3
>>>   Dermot> [for Statement "INSERT INTO products ( distribution,
>>>   Dermot> caption, contributor_id, ...) VALUES(( ?, ?, ?, ?, ?, ?, ?,
>>>   Dermot> ?, ?, ?, ? )" with ParamValues: 0='1', 1='Earth', 2='3'....)
>>>
>>>   Dermot> Is 'key 3' referring to 'the 3rd item in the INSERT list
>>>   Dermot> (contributor_id)?
>>>
>>> No, that's a mysql error, you're probably violating a constraint on your
>>> table with those values.
>>
>> Yes. I was hoping I could find out what 'key 3' was referring to.
>
> The third unique index on the table.
>
> Ronald

Brilliant. Thank you Ronald that helps narrow it down.
Dp.