Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Column 'att_id' in where clause is ambiguous. #6

Closed
discordier opened this issue Mar 13, 2014 · 2 comments
Closed

Column 'att_id' in where clause is ambiguous. #6

discordier opened this issue Mar 13, 2014 · 2 comments
Assignees
Milestone

Comments

@discordier
Copy link
Member

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

@discordier
Copy link
Member Author

Should be fixed with 889fc04 in all branches, please test.

@andreasisaak andreasisaak added this to the 1.0.x milestone Mar 13, 2014
@MiniModel
Copy link
Member

This issue has been labeled with "testing" but got no feedback.

We are reliant on feedback to prove a ticket fixed as we can not tell if the ticket has been resolved if we receive no feedback.
I will close this ticket now, as I assume it has been resolved.
If the ticket should still be valid, please feel free to reopen it.

@discordier could you please have a final look at this and tell if your issue has been resolved?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants