/home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:244
Statement could not be executed (42000 - 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1)
#0 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(238): Zend\Db\Adapter\Driver\Pdo\Statement->execute() #1 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(208): Zend\Db\TableGateway\AbstractTableGateway->executeSelect(Object(Zend\Db\Sql\Select)) #2 /home/ngocnha.com/module/Desktop/src/Desktop/Model/Products.php(75): Zend\Db\TableGateway\AbstractTableGateway->selectWith(Object(Zend\Db\Sql\Select)) #3 /home/ngocnha.com/module/Desktop/src/Desktop/Block/Products/ProductsList.php(53): Desktop\Model\Products->getMaxMinPrice(Array) #4 [internal function]: Desktop\Block\Products\ProductsList->__invoke(Array) #5 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/Renderer/PhpRenderer.php(393): call_user_func_array(Object(Desktop\Block\Products\ProductsList), Array) #6 /home/ngocnha.com/module/Desktop/view/desktop/pages/index.phtml(22): Zend\View\Renderer\PhpRenderer->__call('product_list', Array) #7 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/Renderer/PhpRenderer.php(501): include('/home/ngocnha.c...') #8 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(205): Zend\View\Renderer\PhpRenderer->render(NULL) #9 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(233): Zend\View\View->render(Object(Zend\View\Model\ViewModel)) #10 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(198): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel)) #11 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/View/Http/DefaultRenderingStrategy.php(103): Zend\View\View->render(Object(Zend\View\Model\ViewModel)) #12 [internal function]: Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent)) #13 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #14 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('render', Object(Zend\Mvc\MvcEvent), Array) #15 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(353): Zend\EventManager\EventManager->trigger('render', Object(Zend\Mvc\MvcEvent)) #16 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(328): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent)) #17 /home/ngocnha.com/public_html/index.php(16): Zend\Mvc\Application->run() #18 {main}
/home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:239
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1
#0 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php(239): PDOStatement->execute() #1 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(238): Zend\Db\Adapter\Driver\Pdo\Statement->execute() #2 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Db/TableGateway/AbstractTableGateway.php(208): Zend\Db\TableGateway\AbstractTableGateway->executeSelect(Object(Zend\Db\Sql\Select)) #3 /home/ngocnha.com/module/Desktop/src/Desktop/Model/Products.php(75): Zend\Db\TableGateway\AbstractTableGateway->selectWith(Object(Zend\Db\Sql\Select)) #4 /home/ngocnha.com/module/Desktop/src/Desktop/Block/Products/ProductsList.php(53): Desktop\Model\Products->getMaxMinPrice(Array) #5 [internal function]: Desktop\Block\Products\ProductsList->__invoke(Array) #6 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/Renderer/PhpRenderer.php(393): call_user_func_array(Object(Desktop\Block\Products\ProductsList), Array) #7 /home/ngocnha.com/module/Desktop/view/desktop/pages/index.phtml(22): Zend\View\Renderer\PhpRenderer->__call('product_list', Array) #8 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/Renderer/PhpRenderer.php(501): include('/home/ngocnha.c...') #9 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(205): Zend\View\Renderer\PhpRenderer->render(NULL) #10 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(233): Zend\View\View->render(Object(Zend\View\Model\ViewModel)) #11 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/View/View.php(198): Zend\View\View->renderChildren(Object(Zend\View\Model\ViewModel)) #12 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/View/Http/DefaultRenderingStrategy.php(103): Zend\View\View->render(Object(Zend\View\Model\ViewModel)) #13 [internal function]: Zend\Mvc\View\Http\DefaultRenderingStrategy->render(Object(Zend\Mvc\MvcEvent)) #14 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #15 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('render', Object(Zend\Mvc\MvcEvent), Array) #16 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(353): Zend\EventManager\EventManager->trigger('render', Object(Zend\Mvc\MvcEvent)) #17 /home/ngocnha.com/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(328): Zend\Mvc\Application->completeRequest(Object(Zend\Mvc\MvcEvent)) #18 /home/ngocnha.com/public_html/index.php(16): Zend\Mvc\Application->run() #19 {main}