Catalog Navigation SQL Bug?!

**darki777** · 15.08.2011, 18:12

Hi,
ich habe im Frontend das Modul "Catalog Navigation" eingebunden, allerdings wird mir dann immer eine Fehlermeldung ausgespuckt. Ich verwende TL 2.9.5 mit dem neuesten Catalog Modul (2.0beta), bei allen anderen Catalog Modulen hatte ich bisher keine Probleme feststellen können, nur eben leider bei diesem.

Code:

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 '0 AS itemCount ORDER BY oberflaeche' at line 1 (SELECT id, id, 0 AS childCount, oberflaeche AS name FROM configurator_oberflaeche, 0 AS itemCount ORDER BY oberflaeche) thrown in /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Database.php on line 642

#0 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Database.php(589): Database_Statement->query()
#1 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Database.php(164): Database_Statement->execute()
#2 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/catalog/ModuleCatalog.php(2960): Database->execute('SELECT id, id, ...')
#3 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/catalog/ModuleCatalog.php(3187): ModuleCatalog->internalRenderCatalogNavigation(0, 1, NULL)
#4 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/catalog/ModuleCatalogNavigation.php(92): ModuleCatalog->renderCatalogNavigation(0)
#5 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/Module.php(140): ModuleCatalogNavigation->compile()
#6 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/catalog/ModuleCatalog.php(143): Module->generate()
#7 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/catalog/ModuleCatalogNavigation.php(78): ModuleCatalog->generate()
#8 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/ContentModule.php(72): ModuleCatalogNavigation->generate()
#9 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Controller.php(415): ContentModule->generate()
#10 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/ModuleArticle.php(173): Controller->getContentElement('2')
#11 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/Module.php(140): ModuleArticle->compile()
#12 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/ModuleArticle.php(71): Module->generate()
#13 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Controller.php(348): ModuleArticle->generate(false)
#14 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/libraries/Controller.php(221): Controller->getArticle('2', false, false, 'main')
#15 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/system/modules/frontend/PageRegular.php(71): Controller->getFrontendModule('0', 'main')
#16 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/index.php(198): PageRegular->generate(Object(DB_Mysql_Result))
#17 /Applications/XAMPP/xamppfiles/htdocs/projects/configurator/index.php(333): Index->run()
#18 {main}

Viele Grüße,
darki777