An error occurred

An error occurred during execution; please try again later.

Additional information:

Zend\Db\Adapter\Exception\InvalidQueryException

File:

/home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:245

Message:

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 'order by vitri ASC,manhom ASC' at line 1)

Stack trace:

#0 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(233): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
#1 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(208): Zend\Db\TableGateway\AbstractTableGateway->executeSelect(Object(Zend\Db\Sql\Select))
#2 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(195): Zend\Db\TableGateway\AbstractTableGateway->selectWith(Object(Zend\Db\Sql\Select))
#3 /home/thi4e52b/public_html/module/Application/src/Application/Model/Nhomhang.php(16): Zend\Db\TableGateway\AbstractTableGateway->select('parent=0 and ma...')
#4 /home/thi4e52b/public_html/module/Application/src/Application/Controller/HangsanxuatController.php(17): Application\Model\Nhomhang->getAllByIdHang(NULL)
#5 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Controller/AbstractActionController.php(83): Application\Controller\HangsanxuatController->nhomhangAction()
#6 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#7 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#8 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#9 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#10 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#11 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#12 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#13 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#14 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#15 /home/thi4e52b/public_html/index.php(20): Zend\Mvc\Application->run()
#16 {main}

Previous exceptions:

• PDOException

  File:

  /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php:240

  Message:

  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 'order by vitri ASC,manhom ASC' at line 1

  Stack trace:

  #0 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/Adapter/Driver/Pdo/Statement.php(240): PDOStatement->execute()
  #1 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(233): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
  #2 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(208): Zend\Db\TableGateway\AbstractTableGateway->executeSelect(Object(Zend\Db\Sql\Select))
  #3 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Db/TableGateway/AbstractTableGateway.php(195): Zend\Db\TableGateway\AbstractTableGateway->selectWith(Object(Zend\Db\Sql\Select))
  #4 /home/thi4e52b/public_html/module/Application/src/Application/Model/Nhomhang.php(16): Zend\Db\TableGateway\AbstractTableGateway->select('parent=0 and ma...')
  #5 /home/thi4e52b/public_html/module/Application/src/Application/Controller/HangsanxuatController.php(17): Application\Model\Nhomhang->getAllByIdHang(NULL)
  #6 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Controller/AbstractActionController.php(83): Application\Controller\HangsanxuatController->nhomhangAction()
  #7 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
  #8 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
  #9 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
  #10 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
  #11 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
  #12 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
  #13 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
  #14 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
  #15 /home/thi4e52b/public_html/vendor/ZF2/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
  #16 /home/thi4e52b/public_html/index.php(20): Zend\Mvc\Application->run()
  #17 {main}