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

Fehler bei den Filtern #617

Closed
Hauge opened this issue Oct 24, 2014 · 3 comments
Closed

Fehler bei den Filtern #617

Hauge opened this issue Oct 24, 2014 · 3 comments
Assignees
Labels
bug A bug! A bug! Fast, squish it! duplicate This is a duplicate frontend This seems to be a bug in the frontend wrong repository This ticket is in the wrong repository and should get moved.
Milestone

Comments

@Hauge
Copy link

Hauge commented Oct 24, 2014

Fatal error: Uncaught exception Exception with message 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 'FROM mm_season WHERE alias IN ('asdfsdfsd')' at line 1 (SELECT FROM mm_season WHERE alias IN ('asdfsdfsd')) thrown in system/modules/core/library/Contao/Database/Statement.php on line 283

#0 system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 [internal function]: Contao\Database\Statement->execute(Array)
#2 system/modules/core/library/Contao/Database/Statement.php(502): call_user_func_array(Array, Array)
#3 system/modules/metamodelsattribute_select/classes/src/MetaModels/Filter/Rules/FilterRuleSelect.php(74): Contao\Database\Statement->executeUncached(Array)
#4 system/modules/metamodelsattribute_select/classes/src/MetaModels/Filter/Rules/FilterRuleSelect.php(88): MetaModels\Filter\Rules\FilterRuleSelect->sanitizeValue()
#5 system/modules/metamodelsattribute_select/classes/src/MetaModels/Attribute/Select/AbstractSelect.php(163): MetaModels\Filter\Rules\FilterRuleSelect->getMatchingIds()
#6 system/modules/metamodels/classes/src/MetaModels/Filter/Rules/SearchAttribute.php(81): MetaModels\Attribute\Select\AbstractSelect->searchFor('asdfsdfsd')
#7 system/modules/metamodels/classes/src/MetaModels/Filter/Filter.php(114): MetaModels\Filter\Rules\SearchAttribute->getMatchingIds()
#8 system/modules/metamodels/classes/src/MetaModels/Filter/Setting/Collection.php(247): MetaModels\Filter\Filter->getMatchingIds()
#9 system/modules/metamodels/classes/src/MetaModels/FrontendIntegration/FrontendFilter.php(230): MetaModels\Filter\Setting\Collection->getParameterFilterWidgets(Array, Array, Object(MetaModels\FrontendIntegration\FrontendFilterOptions))
#10 system/modules/metamodels/classes/src/MetaModels/FrontendIntegration/FrontendFilter.php(75): MetaModels\FrontendIntegration\FrontendFilter->getFilters()
#11 system/modules/metamodels/classes/src/MetaModels/FrontendIntegration/Content/Filter.php(69): MetaModels\FrontendIntegration\FrontendFilter->getMetaModelFrontendFilter(Object(MetaModels\FrontendIntegration\Content\Filter))
#12 system/modules/core/elements/ContentElement.php(174): MetaModels\FrontendIntegration\Content\Filter->compile()
#13 system/modules/metamodels/classes/src/MetaModels/FrontendIntegration/Content/Filter.php(58): Contao\ContentElement->generate()
#14 system/modules/core/library/Contao/Controller.php(468): MetaModels\FrontendIntegration\Content\Filter->generate()
#15 system/modules/core/modules/ModuleArticle.php(196): Contao\Controller::getContentElement(Object(Contao\ContentModel), 'right')
#16 system/modules/core/modules/Module.php(163): Contao\ModuleArticle->compile()
#17 system/modules/core/modules/ModuleArticle.php(59): Contao\Module->generate()
#18 system/modules/core/library/Contao/Controller.php(404): Contao\ModuleArticle->generate(false)
#19 system/modules/core/library/Contao/Controller.php(268): Contao\Controller::getArticle(Object(Contao\ArticleModel), false, false, 'right')
#20 system/modules/core/pages/PageRegular.php(138): Contao\Controller::getFrontendModule('0', 'right')
#21 index.php(260): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#22 index.php(444): Index->run()
#23 {main}

Ich weiß leider nicht wie lange der Fehler bereits besteht, da ich in diesem Bereich bereits einige Zeit nicht mehr gearbeitet habe - jedoch scheint es bei der Filterung (Einzelauswahl) aktuell Probleme zu geben (aktuelle nightly)

Obigen Fehler erhalte ich bei allen ehemals bereits funktionierenden Einzelauswahlfiltern.
https://community.contao.org/de/showthread.php?53565-Fehler-beim-Anlegen-eines-Textfilters&p=345479#post345479

@MacKP MacKP added this to the 2.0.0 milestone Oct 24, 2014
@MacKP MacKP added bug A bug! A bug! Fast, squish it! frontend This seems to be a bug in the frontend labels Oct 24, 2014
@MacKP
Copy link
Contributor

MacKP commented Oct 24, 2014

Hab ne Testinstall zum nachstellen @discordier (Prob hast am Mittwoch sehen können, damit du weißt welche Testinstall). Ich dachte dazu haben wir schon ein Ticket? Find das gerade nicht.

@kein-nickname
Copy link

Ich hab das gleiche Problem und kann nur durch ausschalten der Filterung die Fehlermeldung abstellen. Sobald man im Filter "Einfache Filter" unter Standard einen Wert auswählt, kommt die Fehlermeldung!!

@discordier discordier added wrong repository This ticket is in the wrong repository and should get moved. duplicate This is a duplicate labels Nov 1, 2014
@discordier
Copy link
Member

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug A bug! A bug! Fast, squish it! duplicate This is a duplicate frontend This seems to be a bug in the frontend wrong repository This ticket is in the wrong repository and should get moved.
Projects
None yet
Development

No branches or pull requests

4 participants