There is now a milestone admin page which allows us to select the
relevant ProductSeries or DistroRelease for a milestone. Some milestones
have been automatically assigned to a series/release but the balance
(about 50) need to be done manually. This is because, where there is
more or less than one series for the milestone product/distro, we could
not guess automatically which series to use. In these cases:
1. we need to create a series if there is not already an appropriate
one for that milestone
2. in the case of distributions, with the exception of Ubuntu and Sid
there should not be any distroreleases or milestones
3. we need to assign all milestones to a series or distrorelease
New milestones can only be created on a series or distrorelease, so its
just a question of updating all the old ones, then we can enforce the
existence of a series or distrorelease at the database level.
The following query will give you the list of milestones that need this
done:
SELECT Milestone.name, Product.name, Distribution.name FROM Milestone
LEFT OUTER JOIN Product ON Milestone.product=Product.id LEFT OUTER JOIN
Distribution ON Milestone.distribution=Distribution.id ORDER BY
Product.name, Distribution.name WHERE Milestone.productseries IS NULL
AND Milestone.distrorelease IS NULL;
affects /products/launchpad
assignee <email address hidden>