hide translated atributes at define attribute translated tags because translated tags works only with untranslated attributes with own language column

same at MetaModels/attribute_translatedselect#21

The commit MetaModels/attribute_tags@ce00233 caused issue #4.

To solve the initial reason for above mentioned commit, we need to implement the method widgetToValue() in translated tags, so the configured sorting column will get used (instead of using the hardcoded column name "sorting" as in the reverted commit which reflected the real column name by accident).

Error 1064 if column name "condition" with MariaDB

Szenario:
MM-Functions sind MM mit translated-text als Funktionsnamen, weitere Felder sind nicht definiert.
MM-Products soll als (translated)Tags die MM-Functions einbinden - leider ist das im BE nicht sinnvoll möglich, da die translated-Attribute in der tabelle mm_functions nicht vorhanden sind und man schlecht die Tabelle tl_metamodel_translatedtext auswählen kann.

--- Originally created by davidmaack

TODO:

• Bump PHP and Contao version (see MetaModels/core#1011)
• Fix all remaining tickets tagged for 2.0.0
• Check all file header (like https://github.com/MetaModels/core/blob/master/src/MetaModels/MetaModel.php#L1-L26)
• Add .check-author.yml or check this
• Add .github/ templates - see example but ensure to update the links in the files!
• Add .gittattributes file (see MetaModels/core#846)
• remove minimum-stability from composer.json and add "metamodels/core": "~2.0@alpha" and "contao-community-alliance/dc-general": "~2.0@beta"
• Ensure LICENSE file is present! (see https://github.com/MetaModels/core/blob/master/LICENSE)
• Update badges in README.md! (look at first rows https://raw.githubusercontent.com/MetaModels/core/master/README.md)
• Check build status is green!

Unter Contao 3.1.4 und aktualler Nightly Build kann kein neuer Datensatz erstellt werden, wenn das Attribut translatedtags enthalten ist. Dabei kommt folgende Fehlermeldung:

Exception: Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '6),(74,4,,7),(74,4,,8),(74,4,,5),(74,4,,1),(74,4,,2),(74,4,,3),(74,4,,4),(74,4,,' at line 1 (INSERT INTO tl_metamodel_tag_relation (att_id, item_id, value_sorting, value_id) VALUES (74,4,,6),(74,4,,7),(74,4,,8),(74,4,,5),(74,4,,1),(74,4,,2),(74,4,,3),(74,4,,4),(74,4,,9),(74,4,,10),(74,4,,11),(74,4,,12),(74,4,,13),(74,4,,14),(74,4,,15),(74,4,,16),(74,4,,17),(74,4,,18),(74,4,,19),(74,4,,20),(74,4,,21),(74,4,,22),(74,4,,23),(74,4,,24),(74,4,,25),(74,4,,26),(74,4,,27),(74,4,,28),(74,4,,29),(74,4,,30)) in file .../system/modules/core/library/Contao/Database/Statement.php on line 282

Hey,
wie in dem anderen Issue geschrieben, taucht bei den Tags ein Fehler auf:
attribute_tags #16

Gruß,
Sebi

Checklist before I submit this issue report

I confirm that:

• [x ] I have tested this with the latest version available
• [ x] I have read documentation @ http://metamodels.readthedocs.org/en/ or http://metamodels.readthedocs.org/de/
• [x ] I have checked the Contao community forums for references https://community.contao.org/
• [ x] I have checked existing issues for duplicates and found none @ https://github.com/MetaModels/attribute_translatedtags/issues?q=is%3Aissue

My environment is:

(Please fill in the actual values from your environment)

Issue description

(Describe the problem you are having)

Steps to reproduce

1. mm_equipe to list the team members (with translations fr, en, es)
   translated_tags 'zonegeo' linked to mm_pays
2. mm_pays to list the countries of intervention (with translations fr, en, es for countries names)

• translated_text 'nom_pays_trad'
• alias : pays_ref_alias

Describe the behaviour of the application

I the input mask, I can't select tags with this error :
Error: An exception occurred while executing 'SELECT COUNT(source.id) AS mm_count, source.id, source.pays_ref_alias FROM mm_pays_ref source GROUP BY source.id ORDER BY nom_pays_trad ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'nom_pays_trad' in 'order clause'

Describe the expected behaviour of the application

For each member, I would like to select one or many countries of interventions. I want these countries names to be displayed with the right corresponding country name (fr: France, en : France, es: Francia)

Screenshots

Thanks for help.

Fatal error: Uncaught exception Exception with message Query error: Column 'att_id' in where clause is ambiguous (SELECT COUNT(value_id) as mm_count, value_id AS item_id, tl_metamodel_translatedtext.item_id , mm_norika_sorten_icon.* FROM tl_metamodel_tag_relation RIGHT JOIN tl_metamodel_translatedtext ON(tl_metamodel_tag_relation.value_id=tl_metamodel_translatedtext.item_id) JOIN mm_norika_sorten_icon ON tl_metamodel_translatedtext.item_id=mm_norika_sorten_icon.id WHERE att_id='18' AND (tl_metamodel_translatedtext.att_id=3) GROUP BY value_id ORDER BY mm_norika_sorten_icon.sorting, tl_metamodel_translatedtext.item_id) thrown in /system/libraries/Database.php on line 686
#0 /system/libraries/Database.php(633): Database_Statement->query()
#1 /system/modules/metamodelsattribute_translatedtags/MetaModelAttributeTranslatedTags.php(131): Database_Statement->execute('18')
#2 /system/modules/metamodelsattribute_translatedtags/MetaModelAttributeTranslatedTags.php(235): MetaModelAttributeTranslatedTags->getValueIds(NULL, true, NULL)
#3 /system/modules/metamodels/MetaModelFilterSettingSimpleLookup.php(167): MetaModelAttributeTranslatedTags->getFilterOptions(NULL, true)
#4 /system/modules/metamodels/MetaModelFilterSettings.php(173): MetaModelFilterSettingSimpleLookup->getParameterDCA()
#5 /system/modules/metamodels/TableContent.php(48): MetaModelFilterSettings->getParameterDCA()
#6 /system/drivers/DC_Table.php(200): TableContent->buildCustomFilter(Object(DC_Table))
#7 /system/modules/backend/Backend.php(226): DC_Table->__construct('tl_content')
#8 /contao/main.php(120): Backend->getBackendModule('article')
#9 /contao/main.php(230): Main->run()
#10 {main}

See also:
https://community.contao.org/de/showthread.php?47160-Translated-Tags-Column-att_id-in-where-clause-is-ambiguous&p=315270#post315270