Detect & clean up messages inconsistent with flags

[Jeroen T. Vermeulen]

Bug 317578 shows how message translations can end up being inconsistent with their flags, so that neither gettext nor Launchpad would accept them the way they are.

Besides catching that situation, we should also be able to clean up the cases where this has happened.

[Jeroen T. Vermeulen (jtv)]

The attached branch re-checks messages in Hardy and later for gettext errors when given the selection clause:

  is_current IS TRUE AND id >= 74539159 AND EXISTS (
    SELECT * FROM POTMsgSet
    WHERE
      POTMsgSet.sequence > 0 AND
      POTMsgSet.id = TranslationMessage.potmsgset AND
      flagscomment LIKE '%format%'
  )

Took just under 6 hours on staging, of which about 24 minutes were spent collecting the TranslationMessages. It may be advisable to break it down into chunks.

[Jeroen T. Vermeulen (jtv)]

After a bit more tweaking, this is now waiting for approval to run.

[Jeroen T. Vermeulen (jtv)]

Script has been run.