[SOLVED] "de" always default language for FAQ articles

[Mothra]

I think this may be a bug (OTRS 3.0.4)... whenever I create a new FAQ article, the default language is always "de", and the only other available value is "en", even though:

1. I have English (United Kingdom) selected in my preferences
2. The default language in Framework -> Core -> DefaultLanguage is set to "en_GB"
2. I have removed German from the available languages under Framework -> Core -> DefaultUsedLanguages.

Is it a bug, or something I've overlooked?

[Mothra]

Lol... it seems that the FAQ language is not related to the OTRS languages - it even has its own table (faq_language) with two entries, "de" and "en". Even stranger is the fact that although the id field is auto_increment, and "de" has an id of 2, "de" appears first in the list when you run SELECT * FROM faq_language (or at least did on my MySQL database).

As faq_language.id is only referenced in faq_item.f_language_id, and doesn't seem to actually do an awful lot (maybe it just allows the facility to search for articles by language), I think it's safe just to remove the "de" entry unless you need it.

Or, if you're squeamish about removing roles in the database, you could always customise AgentFAQAdd.dtl.