Trying to register a spec with a existing name leads to an oops.

[Sivan Greenberg]

Registering a spec with the spec tracker sometimes causes an "Oops" error.

Example 1:
spec name = "automatic-updates"
title = "Automatic Updates"
summary = "Automatic Updates - automatic/silent installation of (security) updates, possible even when current user has no sudo privileges."
Priority = medium
Status = braindump
other fields empty (asignee, drafter, approver).

Example 2:
Product = launchpad
Name = "duplicate-handling"
Title = "Duplicate bug handling"
URL = "https://wiki.launchpad.canonical.com/DuplicateBugHandling"
Summary = "When bugs are marked as duplicates, their fix requests and subscriber lists need to be merged in a smart fashion, to minimize the followup work required."
Status = braindump
Assignee = none
Drafter = "mpt"
Approver = none

[Kevin Cole (kjcole)]

Similar to Sivan Greenberg. I had successfully added one spec, and then tried to repeat the procedure with a second spec, and ended up at Oops. (Previously, I had met "Mr. Oops" because of punctuation that Launchpad didn't like.)

PROBLEM: https://launchpad.net/products/edubuntu.cookbook/+addspec
NAME: lore
TITLE: Rewriting in Lore
SPECIFICATION URL: https://wiki.ubuntu.com/EdubuntuHowto
SUMMARY: Port the current document from reST or Docbook XML to Twisted Matrix's documentation system Lore. Docteam members have said focus on content, and they can worry about converting it to whatever they choose. Therefore, the drafting can be done in whatever format works best.
STATUS: Braindump
ASSIGNEE: <email address hidden>
DRAFTER:
APPROVER:

[Guilherme Salgado (salgado)]

On Thu, Dec 01, 2005 at 06:16:01PM -0000, Kevin Cole wrote:
> Similar to Sivan Greenberg. I had successfully added one spec, and then
> tried to repeat the procedure with a second spec, and ended up at Oops.
> (Previously, I had met "Mr. Oops" because of punctuation that Launchpad
> didn't like.)
>
> PROBLEM: https://launchpad.net/products/edubuntu.cookbook/+addspec
> NAME: lore
> TITLE: Rewriting in Lore
> SPECIFICATION URL: https://wiki.ubuntu.com/EdubuntuHowto

In your case, you got the error page because you tried to register a spec with
a URL that is already registered for another spec.

The problem is that this is not made clear in the interface, and you get an
error page which gives you no clue about what went wrong. This is already
reported in bug 3566, though.

[Diogo Matsubara (matsubara)]

Sivan, the database has some constraints on the spec table that aren't being checked by the UI.
On which product were you trying to register spec of example 1?

The example 2 is triggering the URL constraint on the db.

[Sivan Greenberg (sivan)]

I think it was against the Ubuntu product or distro, I don't recall if it's before the Ubuntu product was removed in favor of the Distro.