Class Doctrine\DBAL\DBALException
Message: An exception occurred while executing 'SELECT COUNT(a0_.parent_id) AS sclr0, a1_.id AS id1, a1_.user_id AS user_id2, a1_.company_id AS company_id3, a1_.category_id AS category_id4, a1_.topic AS topic5, a1_.intro AS intro6, a1_.body AS body7, a1_.fact AS fact8, a1_.image_author AS image_author9, a1_.published_at AS published_at10, a1_.created_at AS created_at11, a1_.updated_at AS updated_at12, a1_.deleted_at AS deleted_at13, a2_.id AS id14, a2_.name AS name15, a1_.company_id AS company_id16, a1_.category_id AS category_id17, a1_.user_id AS user_id18 FROM articles a1_ LEFT JOIN article_categories a2_ ON a1_.category_id = a2_.id LEFT JOIN article_views a0_ ON a1_.id = a0_.parent_id WHERE a1_.deleted_at IS NULL AND a1_.published_at >= '2022-11-07' GROUP BY a1_.id ORDER BY sclr0 DESC, a1_.published_at DESC LIMIT 6': SQLSTATE[HY000]: General error: 1030 Got error 122 from storage engine
#0 /opt/franchise/library/Doctrine/DBAL/Connection.php(649): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT COUNT(a0...', Array) #1 /opt/franchise/library/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(a0...', 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/Article.php(245): PMG\Entity\Repository\AbstractRepository->getQueryResult(Object(Doctrine\ORM\QueryBuilder), Object(PMG\Entity\Repository\QueryRequirements)) #6 /opt/franchise/library/App/Service/Article.php(87): App\EntityRepository\Article->getMostViewed() #7 /opt/franchise/modules/article/controllers/IndexController.php(162): App\Service\Article->getMostViewed() #8 /opt/franchise/library/Zend/Controller/Action.php(513): Article_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}
array ( 'module' => 'article', 'controller' => 'index', 'action' => 'most-viewed', )
![]() © PMG 2001 - 2023 |