By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,474 Members | 3,141 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,474 IT Pros & Developers. It's quick & easy.

Duplicate entry error [PERL] on CMS

100+
P: 135
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
Jun 5 '07 #1
Share this Question
Share on Google+
3 Replies


miller
Expert 100+
P: 1,089
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
Jun 5 '07 #2

100+
P: 135
Thank you Miller for your assistant.
Jun 6 '07 #3

miller
Expert 100+
P: 1,089
No Problem. Glad I could help.

- Miller
Jun 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.