Code:
PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'tl_iso_product.featured' in 'where clause' (SELECT DISTINCT p1.featured FROM tl_iso_product p1
LEFT OUTER JOIN tl_iso_product p2 ON p1.pid=p2.id
WHERE p1.language='' AND p1.featured!='' AND p1.published='1' AND (p1.start='' OR p1.start<1396945987) AND (p1.stop='' OR p1.stop>1396945987) AND (p1.id IN (SELECT pid FROM tl_iso_product_category WHERE page_id IN (2,3,9,13,14,15,16,114,115,17,18,19,4,5,6,7,8,11,12,25,39,40,41,26,24,27,28,29,30,31,32,33,34,35,36,37,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,111,112,113,1))
OR p1.pid IN (SELECT pid FROM tl_iso_product_category WHERE page_id IN (2,3,9,13,14,15,16,114,115,17,18,19,4,5,6,7,8,11,12,25,39,40,41,26,24,27,28,29,30,31,32,33,34,35,36,37,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,111,112,113,1))) AND (p1.pid=0 OR (p2.published='1' AND (p2.start='' OR p2.start<1396945987) AND (p2.stop='' OR p2.stop>1396945987))) AND tl_iso_product.featured!=1)' thrown in /home/.../public_html/system/modules/core/library/Contao/Database/Statement.php on line 283
#0 /home/.../public_html/system/modules/core/library/Contao/Database/Statement.php(254): Contao\Database\Statement->query()
#1 /home/.../public_html/system/modules/core/library/Contao/Database.php(189): Contao\Database\Statement->execute()
#2 /home/.../public_html/system/modules/isotope/library/Isotope/Module/ProductFilter.php(231): Contao\Database->execute('? ...')
#3 /home/.../public_html/system/modules/isotope/library/Isotope/Module/ProductFilter.php(153): Isotope\Module\ProductFilter->generateFilters()
#4 /home/.../public_html/system/modules/core/modules/Module.php(148): Isotope\Module\ProductFilter->compile()
#5 /home/.../public_html/system/modules/isotope/library/Isotope/Module/Module.php(80): Contao\Module->generate()
#6 /home/.../public_html/system/modules/isotope/library/Isotope/Module/ProductFilter.php(81): Isotope\Module\Module->generate()
#7 /home/.../public_html/system/modules/core/elements/ContentModule.php(63): Isotope\Module\ProductFilter->generate()
#8 /home/.../public_html/system/modules/core/library/Contao/Controller.php(456): Contao\ContentModule->generate()
#9 /home/.../public_html/system/modules/core/modules/ModuleArticle.php(205): Contao\Controller->getContentElement(Object(Contao\ContentModel), 'main')
#10 /home/.../public_html/system/modules/core/modules/Module.php(148): Contao\ModuleArticle->compile()
#11 /home/.../public_html/system/modules/core/modules/ModuleArticle.php(59): Contao\Module->generate()
#12 /home/.../public_html/system/modules/core/library/Contao/Controller.php(392): Contao\ModuleArticle->generate(false)
#13 /home/.../public_html/system/modules/core/library/Contao/Controller.php(254): Contao\Controller->getArticle(Object(Contao\ArticleModel), false, false, 'main')
#14 /home/.../public_html/system/modules/core/pages/PageRegular.php(138): Contao\Controller->getFrontendModule('0', 'main')
#15 /home/.../public_html/index.php(249): Contao\PageRegular->generate(Object(Contao\PageModel), true)
#16 /home/.../public_html/index.php(433): Index->run()
#17 {main}
Nehme ich das Filtermodul aus dem Artikel raus, dann sehe ich die Produkte wieder ungefiltert... mache ich was falsch? Stimmt meine Bedingung nicht? Habe in der Datenbank nachgeschaut, die Spalte existiert. Gebe ich dort direkt die komplette SQL-Bedingung ein, funktioniert sie. Hat da jemand einen Tipp oder gar die Lösung parat?
Lesezeichen