An error occurred
An error occurred during execution; please try again later.
Additional information:
Doctrine\DBAL\Exception\SyntaxErrorException
- File:
-
/home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:90
- Message:
-
An exception occurred while executing 'SELECT min(p.usdprice) as minprice, max(p.usdprice) as maxprice FROM tl_product_view p WHERE p.CID = '10604' and p.Show_product='Y' AND p.premium_type='Y' AND p.mp_active = 'Y' AND p.showinthumb='Y' and (p.group_product_display='N' OR(p.group_product_display='Y' AND p.product_option_type='OPMAIN')) AND p.Main_category= and (p.product_visibility='now' or (p.product_visibility='later' and p.visible_from<=CURRENT_DATE() and p.visible_to>=CURRENT_DATE()))': SQLSTATE[42000]: Syntax error or access violation: 1064 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 (p.product_visibility='now' or (p.product_visibility='later' and p.visible_f' at line 1
- Stack trace:
-
#0 /home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException)) #1 /home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(178): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Driver\PDOException), 'SELECT min(p.us...', Array) #2 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(659): Doctrine\DBAL\Statement->execute() #3 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(213): Apps\Controller\Plugins\CategoryPagePlugin->categoryfilters() #4 /home/tomlibo/public_html/module/Application/src/Controller/PageController.php(1616): Apps\Controller\Plugins\CategoryPagePlugin->categorydetails() #5 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Application\Controller\PageController->indexAction() #6 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #7 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #8 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #9 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #10 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #11 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #12 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #13 /home/tomlibo/public_html/public/index.php(41): Zend\Mvc\Application->run() #14 {main}
Previous exceptions:
-
Doctrine\DBAL\Driver\PDOException
- File:
-
/home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
- Message:
-
SQLSTATE[42000]: Syntax error or access violation: 1064 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 (p.product_visibility='now' or (p.product_visibility='later' and p.visible_f' at line 1
- Stack trace:
-
#0 /home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL) #1 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(659): Doctrine\DBAL\Statement->execute() #2 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(213): Apps\Controller\Plugins\CategoryPagePlugin->categoryfilters() #3 /home/tomlibo/public_html/module/Application/src/Controller/PageController.php(1616): Apps\Controller\Plugins\CategoryPagePlugin->categorydetails() #4 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Application\Controller\PageController->indexAction() #5 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #6 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #7 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #8 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #9 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #10 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #11 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #12 /home/tomlibo/public_html/public/index.php(41): Zend\Mvc\Application->run() #13 {main}
-
PDOException
- File:
-
/home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
- Message:
-
SQLSTATE[42000]: Syntax error or access violation: 1064 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 (p.product_visibility='now' or (p.product_visibility='later' and p.visible_f' at line 1
- Stack trace:
-
#0 /home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute(NULL) #1 /home/tomlibo/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): Doctrine\DBAL\Driver\PDOStatement->execute(NULL) #2 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(659): Doctrine\DBAL\Statement->execute() #3 /home/tomlibo/public_html/module/Apps/src/Controller/Plugins/CategoryPagePlugin.php(213): Apps\Controller\Plugins\CategoryPagePlugin->categoryfilters() #4 /home/tomlibo/public_html/module/Application/src/Controller/PageController.php(1616): Apps\Controller\Plugins\CategoryPagePlugin->categorydetails() #5 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(78): Application\Controller\PageController->indexAction() #6 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #7 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #8 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(106): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #9 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(138): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response)) #10 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(322): Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent)) #11 /home/tomlibo/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(179): Zend\EventManager\EventManager->triggerListeners(Object(Zend\Mvc\MvcEvent), Object(Closure)) #12 /home/tomlibo/public_html/vendor/zendframework/zend-mvc/src/Application.php(332): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent)) #13 /home/tomlibo/public_html/public/index.php(41): Zend\Mvc\Application->run() #14 {main}