| caller |
TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery
|
| 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 'AND tx_commerce_products_categories_mm.uid_foreign = AND tx_commerce_products.u' at line 1
|
| lastBuiltQuery |
SELECT tx_commerce_categories.uid as catUid, tx_commerce_categories.title as catTitle,tx_commerce_categories.sys_language_uid as catSysLanguageUid,MAX(tx_commerce_article_prices.purchase_price) as crossedPrice, MIN(tx_commerce_article_prices.price_gross) as priceMin, MAX(tx_commerce_article_prices.price_gross) as priceMax, GROUP_CONCAT(tx_commerce_products.sni_attributes SEPARATOR ",") as attributes, tx_commerce_categories.sni_attributes as catAttributes FROM tx_commerce_categories,tx_commerce_products,tx_commerce_products_categories_mm,tx_commerce_articles,tx_commerce_article_prices WHERE tx_commerce_categories.uid = AND tx_commerce_products_categories_mm.uid_foreign = AND tx_commerce_products.uid = tx_commerce_products_categories_mm.uid_local AND tx_commerce_articles.uid_product = tx_commerce_products.uid AND tx_commerce_article_prices.uid_article = tx_commerce_articles.uid AND tx_commerce_articles.deleted = 0 AND tx_commerce_articles.hidden = 0 AND tx_commerce_article_prices.deleted = 0 AND tx_commerce_article_prices.hidden = 0 AND tx_commerce_products.deleted = 0 AND tx_commerce_products.hidden = 0
|
| debug_backtrace |
require(src-6.2.31/typo3/sysext/cms/tslib/index_ts.php),src-6.2.31/index.php#28 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#212 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#215 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\TemplateContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#128 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#40 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\TemplateContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#128 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#40 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#697 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#752 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6663 // tx_snicommercefilter_pi1->main# // tx_snicommercefilter_pi1->getCategoryInfo#74 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#128 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#305
|
|
