Exception information:

Class Doctrine\DBAL\DBALException

Message: An exception occurred while executing 'SELECT COUNT(c0_.parent_id) AS sclr0, c1_.id AS id1, c1_.branch_id AS branch_id2, c1_.organisation_number AS organisation_number3, c1_.name AS name4, c1_.description AS description5, c1_.first_address AS first_address6, c1_.second_address AS second_address7, c1_.zipcode AS zipcode8, c1_.district AS district9, c1_.homepage AS homepage10, c1_.email AS email11, c1_.trademark AS trademark12, c1_.units AS units13, c1_.investment_capital AS investment_capital14, c1_.toll AS toll15, c1_.contact_name AS contact_name16, c1_.contact_phone AS contact_phone17, c1_.contact_email AS contact_email18, c1_.has_logo AS has_logo19, c1_.created_at AS created_at20, c1_.updated_at AS updated_at21, c1_.deleted_at AS deleted_at22, c2_.id AS id23, c2_.name AS name24, c1_.branch_id AS branch_id25 FROM companies c1_ LEFT JOIN company_categories c2_ ON c1_.branch_id = c2_.id LEFT JOIN company_views c0_ ON c1_.id = c0_.parent_id WHERE c1_.created_at >= '2022-10-29 22:33:39' AND c1_.deleted_at IS NULL AND c1_.created_at >= '2022-10-29' GROUP BY c1_.id ORDER BY sclr0 DESC LIMIT 6': SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine

Stack trace:

#0 /opt/franchise/library/Doctrine/DBAL/Connection.php(649): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT COUNT(c0...', Array)
#1 /opt/franchise/library/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(c0...', Array, Array, NULL)
#2 /opt/franchise/library/Doctrine/ORM/Query.php(264): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#3 /opt/franchise/library/Doctrine/ORM/AbstractQuery.php(737): Doctrine\ORM\Query->_doExecute()
#4 /opt/franchise/library/PMG/Entity/Repository/AbstractRepository.php(354): Doctrine\ORM\AbstractQuery->execute()
#5 /opt/franchise/library/App/EntityRepository/Franchise/Company.php(99): PMG\Entity\Repository\AbstractRepository->getQueryResult(Object(Doctrine\ORM\QueryBuilder), Object(PMG\Entity\Repository\QueryRequirements))
#6 /opt/franchise/library/App/Service/Franchise/Company.php(468): App\EntityRepository\Franchise\Company->fetchAll(Object(PMG\Entity\Repository\QueryRequirements), Array, true)
#7 /opt/franchise/modules/franchise/controllers/IndexController.php(206): App\Service\Franchise\Company->fetchAll(Array, Array)
#8 /opt/franchise/library/Zend/Controller/Action.php(513): Franchise_IndexController->mostViewedAction()
#9 /opt/franchise/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('mostViewedActio...')
#10 /opt/franchise/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#11 /opt/franchise/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#12 /opt/franchise/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#13 /opt/franchise/public/index.php(37): Zend_Application->run()
#14 {main}	  

Request Parameters:

array (
  'module' => 'franchise',
  'controller' => 'index',
  'action' => 'most-viewed',
)

Följ oss