exec_SELECTquery
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_nbessencedb_domain_model_productvariant.sys_language_uid = 0 AND tx_nbes' at line 14
lastBuiltQuery SELECT *, tx_nbessencedb_domain_model_productvariant.uid as variantuid, tx_nbessencedb_domain_model_productbase.uid as baseuid, tx_nbessencedb_domain_model_productsubcategory.uid as subcategoryuid FROM tx_nbessencedb_domain_model_productvariant

INNER JOIN
tx_nbessencedb_domain_model_productregionavailability ON tx_nbessencedb_domain_model_productvariant.product_variant_number = tx_nbessencedb_domain_model_productregionavailability.product_variant_number
INNER JOIN
tx_nbessencedb_domain_model_region ON tx_nbessencedb_domain_model_productregionavailability.region_iso = tx_nbessencedb_domain_model_region.region_iso
LEFT JOIN
tx_nbessencedb_domain_model_productbase ON tx_nbessencedb_domain_model_productvariant.product_base = tx_nbessencedb_domain_model_productbase.uid
LEFT JOIN
tx_nbessencedb_productbase_productsubcategory_mm on tx_nbessencedb_productbase_productsubcategory_mm.uid_local = tx_nbessencedb_domain_model_productbase.uid
LEFT JOIN
tx_nbessencedb_domain_model_productsubcategory on tx_nbessencedb_domain_model_productsubcategory.uid = tx_nbessencedb_productbase_productsubcategory_mm.uid_foreign

WHERE tx_nbessencedb_domain_model_productvariant.product_base = AND tx_nbessencedb_domain_model_productvariant.sys_language_uid = 0 AND tx_nbessencedb_domain_model_productvariant.deleted=0 AND tx_nbessencedb_domain_model_productvariant.t3ver_state<=0 AND tx_nbessencedb_domain_model_productvariant.pid<>-1 AND tx_nbessencedb_domain_model_productvariant.hidden=0 AND tx_nbessencedb_domain_model_productvariant.starttime<=1414690080 AND (tx_nbessencedb_domain_model_productvariant.endtime=0 OR tx_nbessencedb_domain_model_productvariant.endtime>1414690080) AND tx_nbessencedb_domain_model_productbase.deleted=0 AND tx_nbessencedb_domain_model_productbase.t3ver_state<=0 AND tx_nbessencedb_domain_model_productbase.pid<>-1 AND tx_nbessencedb_domain_model_productbase.hidden=0 AND tx_nbessencedb_domain_model_productbase.starttime<=1414690080 AND (tx_nbessencedb_domain_model_productbase.endtime=0 OR tx_nbessencedb_domain_model_productbase.endtime>1414690080) AND tx_nbessencedb_domain_model_region.region_language_id = 0 AND tx_nbessencedb_domain_model_productregionavailability.available_from <=1414690137 AND tx_nbessencedb_domain_model_productregionavailability.available_to >=1414690137 GROUP BY tx_nbessencedb_domain_model_productvariant.product_variant_number ORDER BY product_variant_priority,product_variant_colour_number
debug_backtrace require(-6.1.12/typo3/sysext/cms/tslib/index_ts.php),-6.1.12/index.php#41 // include(-6.1.12/typo3/sysext/cms/tslib/pagegen.php),-6.1.12/typo3/sysext/cms/tslib/index_ts.php#194 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#52 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#241 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->assignContentObjectVariables#94 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#224 // TYPO3\CMS\Frontend\ContentObject\ContentContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#117 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#725 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#49 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#55 // call_user_func_array#6462 // TYPO3\CMS\Extbase\Core\Bootstrap->run# // TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#197 // TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest#208 // TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch#84 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest#100 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod#186 // call_user_func_array#285 // netbureau\Nbessenceplugins\Controller\EssenceProductVariantController->showAction# // netbureau\Nbessenceplugins\Domain\Repository\EssenceProductVariantRepository->findProductSiblings#130 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#430 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#297
exec_SELECTquery
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_nbessencedb_domain_model_productrelated.deleted = 0 AND tx_nbessencedb_' at line 2
lastBuiltQuery SELECT * FROM tx_nbessencedb_domain_model_productrelated WHERE (
tx_nbessencedb_domain_model_productrelated.product_related1 = ) AND tx_nbessencedb_domain_model_productrelated.deleted = 0 AND tx_nbessencedb_domain_model_productrelated.hidden = 0
debug_backtrace require(-6.1.12/typo3/sysext/cms/tslib/index_ts.php),-6.1.12/index.php#41 // include(-6.1.12/typo3/sysext/cms/tslib/pagegen.php),-6.1.12/typo3/sysext/cms/tslib/index_ts.php#194 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#52 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#241 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->assignContentObjectVariables#94 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#224 // TYPO3\CMS\Frontend\ContentObject\ContentContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#117 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#725 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#49 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#55 // call_user_func_array#6462 // TYPO3\CMS\Extbase\Core\Bootstrap->run# // TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#197 // TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest#208 // TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch#84 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest#100 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod#186 // call_user_func_array#285 // netbureau\Nbessenceplugins\Controller\EssenceProductVariantController->showAction# // netbureau\Nbessenceplugins\Domain\Repository\EssenceProductVariantRepository->findProductRelateds#134 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#611 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#297
exec_SELECTquery
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 'tx_news_domain_model_news.tx_nbessencenewsext_relatedessenceproducts) AND tx_ne' at line 7
lastBuiltQuery SELECT tx_news_domain_model_news.*,tx_news_domain_model_category.single_pid FROM tx_news_domain_model_news

LEFT JOIN tx_news_domain_model_news_category_mm on tx_news_domain_model_news_category_mm.uid_local = tx_news_domain_model_news.uid
LEFT JOIN tx_news_domain_model_category on tx_news_domain_model_news_category_mm.uid_foreign =
tx_news_domain_model_category.uid

WHERE FIND_IN_SET(,tx_news_domain_model_news.tx_nbessencenewsext_relatedessenceproducts) AND tx_news_domain_model_news.deleted=0 AND tx_news_domain_model_news.t3ver_state<=0 AND tx_news_domain_model_news.pid<>-1 AND tx_news_domain_model_news.hidden=0 AND tx_news_domain_model_news.starttime<=1414690080 AND (tx_news_domain_model_news.endtime=0 OR tx_news_domain_model_news.endtime>1414690080) AND (tx_news_domain_model_news.fe_group='' OR tx_news_domain_model_news.fe_group IS NULL OR tx_news_domain_model_news.fe_group='0' OR FIND_IN_SET('0',tx_news_domain_model_news.fe_group) OR FIND_IN_SET('-1',tx_news_domain_model_news.fe_group)) AND tx_news_domain_model_news.sys_language_uid=0 GROUP BY tx_news_domain_model_news.uid ORDER BY tx_news_domain_model_news.uid DESC
debug_backtrace require(-6.1.12/typo3/sysext/cms/tslib/index_ts.php),-6.1.12/index.php#41 // include(-6.1.12/typo3/sysext/cms/tslib/pagegen.php),-6.1.12/typo3/sysext/cms/tslib/index_ts.php#194 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#52 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#241 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\FluidTemplateContentObject->assignContentObjectVariables#94 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#224 // TYPO3\CMS\Frontend\ContentObject\ContentContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#117 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#725 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\ContentObjectArrayContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#49 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#687 // TYPO3\CMS\Frontend\ContentObject\CaseContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#53 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#739 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#55 // call_user_func_array#6462 // TYPO3\CMS\Extbase\Core\Bootstrap->run# // TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#197 // TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest#208 // TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch#84 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest#100 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod#186 // call_user_func_array#285 // netbureau\Nbessenceplugins\Controller\EssenceProductVariantController->showAction# // netbureau\Nbessenceplugins\Domain\Repository\EssenceProductVariantRepository->findProductNews#143 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#515 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#297