Fatal error: Uncaught exception Exception with message Query error: FUNCTION k.COALESCE does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual (SELECT DISTINCT(aussenst) AS aussenst FROM kurse WHERE (CONCAT(kurzbez,nr,((SELECT GROUP_CONCAT(DISTINCT k.COALESCE(text,'') SEPARATOR ', ') FROM `kennz` AS k INNER JOIN kennz_ad AS ka ON k.kennz=ka.kennz AND ka.typ='K' WHERE ka.nr=kurse.nr)),ort,(IF(RIGHT(trim(nr),1) REGEXP '^[0-9]+$', 'Präsenzveranstaltung', ''))) LIKE '%phip%' AND CONCAT(kurzbez,nr,((SELECT GROUP_CONCAT(DISTINCT k.COALESCE(text,'') SEPARATOR ', ') FROM `kennz` AS k INNER JOIN kennz_ad AS ka ON k.kennz=ka.kennz AND ka.typ='K' WHERE ka.nr=kurse.nr)),ort,(IF(RIGHT(trim(nr),1) REGEXP '^[0-9]+$', 'Präsenzveranstaltung', ''))) LIKE '%rezeptur%' AND 1) AND internetaktiv = 'W' AND NOT nr LIKE 'BYA__9%' AND (CAST(ende_dat AS DATE) >= CURDATE()) AND (CURDATE() BETWEEN CAST(internetvon AS DATE) AND CAST(internetbis AS DATE) OR (CURDATE() >= CAST(internetvon AS DATE) AND (internetbis IS NULL OR internetbis = '1899-12-30')) OR ((internetvon IS NULL OR internetvon = '1899-12-30') AND CAST(internetbis AS DATE) >= CURDATE()) OR ((internetvon IS NULL OR internetvon = '1899-12-30') AND (internetbis IS NULL OR internetbis = '1899-12-30'))) ORDER BY aussenst) thrown in …/system/libraries/Database.php on line 686
#0 …/system/libraries/Database.php(633): Database_Statement->query()
#1 …/system/modules/catalog_otherDb/ModuleCatalogFilterOtherDb.php(55): Database_Statement->execute(Array)
#2 …/system/modules/catalog_otherDb_combine/ModuleCatalogFilterCombine.php(18): ModuleCatalogFilterOtherDb->fetchAvailableFilterOptions('aussenst', ' (CONCAT(kurzbe...', Array, true)
#3 …/system/modules/catalog/ModuleCatalog.php(1583): ModuleCatalogFilterCombine->fetchAvailableFilterOptions('aussenst', ' (CONCAT(kurzbe...', Array, true)
#4 …/system/modules/catalog/ModuleCatalogFilter.php(83): ModuleCatalog->generateFilter()
#5 …/system/modules/frontend/Module.php(140): ModuleCatalogFilter->compile()
#6 …/system/modules/catalog/ModuleCatalog.php(164): Module->generate()
#7 …/system/modules/catalog/ModuleCatalogFilter.php(73): ModuleCatalog->generate()
#8 …/system/modules/frontend/ContentModule.php(72): ModuleCatalogFilter->generate()
#9 …/system/libraries/Controller.php(511): ContentModule->generate()
#10 …/system/modules/frontend/ModuleArticle.php(194): Controller->getContentElement('572')
#11 …/system/modules/frontend/Module.php(140): ModuleArticle->compile()
#12 …/system/modules/frontend/ModuleArticle.php(71): Module->generate()
#13 …/system/libraries/Controller.php(443): ModuleArticle->generate(false)
#14 …/system/libraries/Controller.php(307): Controller->getArticle('317', false, false, 'left')
#15 …/system/modules/frontend/PageRegular.php(100): Controller->getFrontendModule('0', 'left')
#16 …/index.php(279): PageRegular->generate(Object(DB_Mysqli_Result))
#17 …/index.php(414): Index->run()
#18 {main}