remove nonexistent Moldavian language

Please remember that Ubuntu is not the only project using Launchpad and karmic is not the only series and that there is more stuff in Launchpad than what ends up in Ubuntu. There *are* Moldavian translations in Launchpad but as the language has been disabled and is not even used for Ubuntu (as you pointed out), I don't see a reason to hurry. This is more of a clean-up task that we'll do when time permits.

Leave this question open, if you like, to remind us.

We should not leave this open, it's been answered. There's also a bug.

Actually, bug has been closed in the favour of this. It is an administrative task that needs organising (if that's going to happen through a bug, it needs to be reopened at least).

The question has been open since 2009-10-29.

Is it ever going to get actioned?

What's a year between friends? :) That's actually only two Ubuntu releases, and this is a kind of task that makes sense only in relation to Ubuntu cycle. Perhaps you are right and we should close it and let users ping us again (though, there's a benefit for us in there as well: clean up the DB).

> Perhaps you are right and we should close it and let users ping us again

That would be a really annoying way to close bugs / answer questions, wouldn't it?

On Tuesday 22 February 2011 17:36:43 you wrote:
> Question #87284 on Launchpad itself changed:
> https://answers.launchpad.net/launchpad/+question/87284
>
> Данило Шеган posted a new comment:
> What's a year between friends? :) That's actually only two Ubuntu
> releases, and this is a kind of task that makes sense only in relation
> to Ubuntu cycle. Perhaps you are right and we should close it and let
> users ping us again (though, there's a benefit for us in there as well:
> clean up the DB).

Honestly, you should not be using Questions to track a task that has been
around this long!

Write it on a post-it note and do it, but don't leave questions open that
everyone doing the Maintenance Rotation has to look at if there's no intention
of attending to the task.

У уто, 22. 02 2011. у 17:48 +0000, Julian Edwards пише:
>
> Write it on a post-it note and do it, but don't leave questions open
> that
> everyone doing the Maintenance Rotation has to look at if there's no
> intention
> of attending to the task.
>
Somebody on maintenance should then approach me (or someone else in the
translations team) and ask us how do they get this done. They shouldn't
close the question.

Given that there are Moldavian translations in the system, it's not advisable to remove the language. (It's also likely to be quite difficult). What we can do is remove Moldavian translations from Ubuntu.

Unfortunately the remove-translations-by script doesn't like wholesale per-language deletions. There are few enough Moldavian translations in Ubuntu though that we can do it directly in SQL:

DELETE FROM TranslationMessage
USING Language, POTemplate AS pot, DistroSeries AS ds, TranslationTemplateItem AS tti
WHERE
    tti.potmsgset = TranslationMessage.potmsgset AND
    pot.id = tti.potemplate AND
    ds.id = pot.distroseries AND
    ds.distribution = 1 AND
    Language.id = TranslationMessage.language AND
    Language.code = 'mo';

It may take a while, since a trigger needs to come up with replacement POFileTranslator records as TranslationMessages are deleted. (Those new POFileTranslator records will then also be deleted, because eventually all of these TranslationMessages will be gone).

Once that's finished, we can get rid of the POFiles:

DELETE FROM POFile
USING Language, POTemplate, DistroSeries
WHERE
    Language.id = POFile.language AND
    Language.code = 'mo' AND
    POTemplate.id = POFile.potemplate AND
    DistroSeries.id = POTemplate.distroseries AND
    DistroSeries.distribution = 1

Opening again - can the next maintenance team please continue with this.

Since this isn't moving, I'm requesting the deletions to be run.

FWIW I still see Moldavian in:
* https://translations.launchpad.net/ubuntu/natty/
* https://edge.launchpad.net/~lucian.grijincu/+editlanguages

I don't see it in the Natty translations overview; probably you just looked before the statistics had a chance to update. If you followed the link when it was still there, you would see a listing of only empty translations: https://translations.launchpad.net/ubuntu/natty/+lang/mo

The language still exists, so it's not too surprising that it still shows up in your list; however it does mean that you probably have it selected somewhere (whether in your Launchpad preferences or in your browser). It doesn't appear in my language selection list.

Yep, I had it selected in my language list to be able to track it's removal.
After removing it I can no longer add it again, and don't see it in the statistics page (it was shown because I had it in my lang-list).

Thanks for taking care of this.

Thanks Jeroen T. Vermeulen, that solved my question.