191745 - The versions table accepts duplicate entries

Status: RESOLVED DUPLICATE of bug 7233

(Bugzilla :: Administration, task)

Description

[Ramon Guiu]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529

We can add duplicate entries in the versions MySQL table of Bugzilla when not
using the Bugzilla interface to edit them. It seems to be a "software check" to
detect if the version already exists.
I think you should add a unique(value,program) line in the checksetup.pl script
when creating the versions table to avoid it. It will avoid problems when
automating things to add versions in the table.


Reproducible: Always

Steps to Reproduce:
1.Connect to MySQL bugs database directly, i.e. with a mysql client.
2.Add twice the same entry.

Comment 1

[Ramon Guiu]

Steps to Reproduce:
1.Connect to MySQL bugs database directly, i.e. with a mysql client.
2.Add twice the same entry in the versions table.

Comment 2

[Dave Miller [:justdave]]

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