Duplicate entry error [PERL] on CMS

[patelxxx]

I'm trying to update a template on our Content Management System, however getting the following error. I know its difficult to know what the problem is without looking at the PERL coding, however any advise would be considered:


DBD::mysql::db do failed: Duplicate entry 'Lisa.Wulf@<RMe d By Mod>' for key 2 at cgi-bin/gen_main.pl line 87


main::__ANON__( 'DBD::mysql::db do failed: Duplicate entry \'Lisa.Wulf@<RM ed By Mod>...', 'Pkgs::DBI::db= HASH(0x2a3d4d0) ', 'undef') called at cgi-bin/gen_main.pl line 1422



main::make_uniq ue_key('table', 'ai_tinyemails' , 'value', 'Lisa.Wulf@<RMe d By Mod>', 'key_size', 8, 'key_column', 'email_key', 'value_column', ...) called at cgi-bin/gen_main.pl line 1449

[miller]

Greetings Patel,

This problem appears rather obvious. There is a record that is being created that has a column value that is a duplicate of another record. This is throwing an error.

According to gen_main.pl line 1449 error, the table is "ai_tinyemails" , the column is "email_key" , and the value is "Lisa.Wulf@..." .

Either this is supposed to be unique and therefore you need to adjust your input, it's not and you need to adjust your table.

- Miller

[patelxxx]

Thank you Miller for your assistant.

[miller]

No Problem. Glad I could help.

- Miller