Only show version numbers from official Ubuntu sources in "First seen" and "Last seen" fields

[Evan]

The vast majority of developers viewing http://errors.ubuntu.com will be targeting Ubuntu. Showing versions from many different derivatives just creates noise - there may be a version bump in a Elementary that does not fix the issue, but effectively hides the last version of the package in the Ubuntu archive which experienced the bug from the front page view.

So lets just show versions from official Ubuntu sources in the "First seen" and "Last seen" fields. Equally, selecting a specific Ubuntu release at the top of the page should show the "First seen" and "Last seen" fields for that release.

We'll also provide a breakdown of versions a problem has been experienced on, which includes derivative versions, on the individual problem pages (bug 1021332).

Context:
[15:06:59] <seb128> I'm still trying to figure what to do for 12.04.1
[15:07:12] <seb128> we have been trying to increase the bug fixing
[15:07:36] <seb128> but the current errors.ubuntu.com lack of features,details make it hard to have a good picture
[15:08:06] <seb128> like the "running version vs installed version" issues makes it hard to figure if the issue was really fixed or not
[15:08:25] <seb128> and we don't have details of the repartition of the issues across versions
[15:08:44] <seb128> so it's hard to see what has been really fixed, what didn't get fixed, was is due to users who didn't upgrade yet...

It may save time to fix bug 1056061 at the same time as this bug.

[Evan (ev)]

This should be fixed in production:

http://bazaar.launchpad.net/~ev/daisy/trunk/revision/103

However, clearing out the existing non-Ubuntu versions in the BucketMetadata Column Family will require a new query in the lp:daisy tools/ directory.

[Evan (ev)]

To elaborate, this query should look at each row in BucketMetadata. If a package cannot be found in the Source field, it should be looked up from the OOPS Column Family. The package should then be looked up in Launchpad's API. If the version in Last seen or First seen is not in the list of binary packages returned from Launchpad, the field should be cleared.