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@<RMed By Mod>' for key 2 at cgi-bin/gen_main.pl line 87


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



main::make_unique_key('table', 'ai_tinyemails', 'value', 'Lisa.Wulf@<RMed 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