Got warning message from 3.0.6 to 3.0.7

[kbking]

Hi and thanks again for your work!

 

I ran these commands one after the other:

 

 ALTER TABLE headertags_default ADD PRIMARY KEY (default_title, language_id);
ALTER TABLE headertags_default ADD KEY idx_default_title (default_title);
ALTER TABLE headertags ADD PRIMARY KEY (page_name, language_id);
ALTER TABLE headertags ADD KEY idx_page_name (page_name);

 

The first and second went through fine. But in the table headertags_default I can see this warning:

 

PRIMARY and INDEX keys should not both be set for column 'default_title'

 

Should it be like that?

 

And when trying the next alteration, I got this error message:

ALTER TABLE headertags ADD PRIMARY KEY ( page_name, language_id );

 

MySQL said:

#1062 - Duplicate entry 'gift_cards.php-4' for key 1

 

What should I do?

 

(If very difficult to sort this out, would it harm the whole purpose of this contribution not to add these commands?)

Edited April 5, 2009 by kbking