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
_______________________________________________
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]