453951 - Cannot delete and add Component with the same name

Status: RESOLVED DUPLICATE of bug 247936

(Bugzilla :: Administration, task)

Description

[Hieu Le Trung]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1
Build Identifier: 3.0.4, 3.0.5, 3.2rc2

Cannot delete a Component and then add a new Component with the same name again

Exception is:
DBD::mysql::db do failed: Duplicate entry '1-1-3-All Open' for key 2 [for Statement "INSERT INTO series (creator, category, subcategory, name, frequency, query, is_public) VALUES (?, ?, ?, ?, ?, ?, ?)"] at Bugzilla/Series.pm line 200
	Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x8e4ae28)') called at /var/www/bugzilla/editcomponents.cgi line 244




Reproducible: Always

Steps to Reproduce:
1. Go to Edit Component of the product 'Foo'
2. Select a component to delete such as 'Bar'
3. Delete that component
4. Go to Edit Component of the product 'Foo'
5. Add a new component with the name 'Bar' again
Actual Results:  
The Component has been added into DB

But there's an exception:
DBD::mysql::db do failed: Duplicate entry '1-1-3-All Open' for key 2 [for Statement "INSERT INTO series (creator, category, subcategory, name, frequency, query, is_public) VALUES (?, ?, ?, ?, ?, ?, ?)"] at Bugzilla/Series.pm line 200
	Bugzilla::Series::writeToDatabase('Bugzilla::Series=HASH(0x8e4ae28)') called at /var/www/bugzilla/editcomponents.cgi line 244

Expected Results:  
The Component has been added into DB. No exception.

Comment 1

[A. Shimono [:himorin]]

I think i couldn't at 3.0, but i could do at 3.2rc1+ to create a component with the same name as a previously deleted one.

Comment 2

[Hieu Le Trung]

I think the root cause is the Series doesn't get deleted from the DB and when creating there's no code to check for existing record in the DB.

Comment 3

[Frédéric Buclin]

This bug is fixed in Bugzilla 3.0.6 (not yet release) and Bugzilla 3.2.