Exception information:

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

Stack trace:

#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}

Request Parameters:

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

Följ oss