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:

New to Tomlibo?

Sign up now and get your own personalized timeline & store!