sql_query
caller TYPO3\CMS\Core\Database\DatabaseConnection::sql_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 'AND i.type = 1
AND (i.deleted_at = '0000-00-00 ' at line 4
lastBuiltQuery SELECT i.pimuid AS image_pimuid, i.unit_uid AS product_pimuid, i.api_image_url
FROM tx_roiproducts_domain_model_images AS i
WHERE i.unit_uid =
AND i.type = 1
AND (i.deleted_at = '0000-00-00 00:00:00' OR i.deleted_at IS NULL)
AND i.api_file_type IN (1,2,3,4,5,13,100)
AND i.api_image_url != ''
GROUP BY i.pimuid
ORDER BY api_file_type
debug_backtrace require(sysext/cms/tslib/index_ts.php),php#28 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->recursivelyReplaceIntPlaceholdersInContent#3648 // TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript_process#3681 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3733 // TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41 // call_user_func_array#6664 // TYPO3\CMS\Extbase\Core\Bootstrap->run# // TYPO3\CMS\Extbase\Core\Bootstrap->handleRequest#184 // TYPO3\CMS\Extbase\Mvc\Web\FrontendRequestHandler->handleRequest#195 // TYPO3\CMS\Extbase\Mvc\Dispatcher->dispatch#56 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->processRequest#69 // TYPO3\CMS\Extbase\Mvc\Controller\ActionController->callActionMethod#158 // call_user_func_array#287 // Tx_RoiProducts_Controller_ProductsController->detailAction# // Yum\RoiProducts\Domain\Repository\ProductsRepository->findImagesBeiProductPimuid#107 // TYPO3\CMS\Extbase\Persistence\Generic\Query->execute#268 // TYPO3\CMS\Extbase\Persistence\Generic\PersistenceManager->getObjectDataByQuery#201 // TYPO3\CMS\Extbase\Persistence\Generic\Backend->getObjectDataByQuery#102 // TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend->getObjectDataByQuery#175 // TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbBackend->getObjectDataByRawQuery#295 // TYPO3\CMS\Core\Database\DatabaseConnection->sql_query#414 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#992
Oops, an error occurred!

Oops, an error occurred!