2009/12/9 Ronald J Kimball <[email protected]>: > Dermot wrote: >> >> 2009/12/9 Eden Cardim <[email protected]>: >>>>>>>> >>>>>>>> "Dermot" == Dermot <[email protected]> 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. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
