336861 - error message if create a component with a name, which was used in past, but is not used now

Status: RESOLVED DUPLICATE of bug 247936

(Bugzilla :: Administration, task)

Description

[My3bIkaHT]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20060322 Firefox/2.0a1
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20060322 Firefox/2.0a1

There seems to be a problem with adding a new record to "series" table in the database (it sais that there is already such record, and it can't create duplicate entries). I don't know exactly what this table is for, so either a record should be removed from it, when a component is deleted, or the new record should differ from the old one when a component with the old name is created.

The component was nevertheless created, so it's not a serious bug.

Reproducible: Always

Steps to Reproduce:
1.created a component (to a product)
2.deleted that component
3.created a component with the same name (in the same product)


Actual Results:  
I got error message in browser window

DBD::mysql::db do failed: Duplicate entry '19-30-30-All Open' for key 2 at
Bugzilla/Series.pm line 201
        Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x9b66668)')
called at /opt/www/html/bugzilla/editcomponents.cgi line 355

Comment 1

[Vlad Dascalu]

*** This bug has been marked as a duplicate of 247936 ***

Comment 2

[Vlad Dascalu]

Hmm, that bug talks about products and this one is about components, probably stil the same thing but leaving someone else to confirm the dupe.

Comment 3

[Frédéric Buclin]

Yup, I confirm the dupe. To fix this problem on our QA installations, we use this attachment https://bugzilla.mozilla.org/attachment.cgi?id=177855 from bug 247936.

*** This bug has been marked as a duplicate of 247936 ***