if ($offset !== null) {
$offset = (int) $offset;
if ($offset < 0) {
throw new DBALException("LIMIT argument offset=$offset is not valid");
}
if ($offset > 0 && ! $this->supportsLimitOffset()) {
throw new DBALException(sprintf("Platform %s does not support offset values in limit queries.", $this->getName()));
}
}
if ( ! $AST->orderByClause && ($orderBySql = $this->_generateOrderedCollectionOrderByItems())) {
$sql .= ' ORDER BY ' . $orderBySql;
}
if ($limit !== null || $offset !== null) {
$sql = $this->platform->modifyLimitQuery($sql, $limit, $offset);
}
if ($lockMode === null || $lockMode === false || $lockMode === LockMode::NONE) {
return $sql;
}
$outputWalkerClass = $this->customOutputWalker ?: __NAMESPACE__ . '\SqlWalker';
$outputWalker = new $outputWalkerClass($this->query, $this->parserResult, $this->queryComponents);
// Assign an SQL executor to the parser result
$this->parserResult->setSqlExecutor($outputWalker->getExecutor($AST));
return $this->parserResult;
}
/**
$groupesIds[] = $groupe->getId();
}
$data['totalImages'] = $em->getRepository('CommonBundle:Element')->countElementByTypes($types, $objectTypeId, $groupesIds);
$data['files'] = $em->getRepository('CommonBundle:Element')->getElementsByTemplates($types, $objectTypeId, $groupesIds, ($data['page'] - 1) * 21);
return $this->render('FrontBundle:Gallery:gallery_images.html.twig', $data);
}
}
$this->dispatcher->dispatch(KernelEvents::CONTROLLER_ARGUMENTS, $event);
$controller = $event->getController();
$arguments = $event->getArguments();
// call controller
$response = \call_user_func_array($controller, $arguments);
// view
if (!$response instanceof Response) {
$event = new GetResponseForControllerResultEvent($this, $request, $type, $response);
$this->dispatcher->dispatch(KernelEvents::VIEW, $event);
public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
{
$request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
try {
return $this->handleRaw($request, $type);
} catch (\Exception $e) {
if ($e instanceof RequestExceptionInterface) {
$e = new BadRequestHttpException($e->getMessage(), $e);
}
if (false === $catch) {
No log messages
DBALException |
---|
Doctrine\DBAL\DBALException: LIMIT argument offset=-21 is not valid at vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php:3318 at Doctrine\DBAL\Platforms\AbstractPlatform->modifyLimitQuery('SELECT e0_.date AS date_0, e0_.displayorder AS displayorder_1, e0_.certitude AS certitude_2, e0_.status AS status_3, e0_.id AS id_4, e0_.date_update AS date_update_5, e0_.value_id AS value_id_6, e0_.type_id AS type_id_7, e0_.object_id AS object_id_8, e0_.parent_id AS parent_id_9, e0_.commentaire AS commentaire_10, e0_.user_id AS user_id_11, e0_.user_update_id AS user_update_id_12, e0_.value_id AS value_id_13, e0_.type_id AS type_id_14, e0_.object_id AS object_id_15, e0_.association_id AS association_id_16, e0_.parent_id AS parent_id_17 FROM element e0_ LEFT JOIN object o1_ ON e0_.object_id = o1_.id LEFT JOIN `value` v2_ ON e0_.value_id = v2_.id LEFT JOIN type t3_ ON e0_.type_id = t3_.id LEFT JOIN user u4_ ON e0_.user_id = u4_.id LEFT JOIN object_groupe o5_ ON o1_.id = o5_.object_id LEFT JOIN groupe g6_ ON o5_.groupe_id = g6_.id WHERE t3_.template IN (?) AND g6_.id IN (?) ORDER BY o1_.value ASC', 21, -21) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:542) at Doctrine\ORM\Query\SqlWalker->walkSelectStatement(object(SelectStatement)) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42) at Doctrine\ORM\Query\Exec\SingleSelectExecutor->__construct(object(SelectStatement), object(SqlWalker)) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:277) at Doctrine\ORM\Query\SqlWalker->getExecutor(object(SelectStatement)) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:390) at Doctrine\ORM\Query\Parser->parse() (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:281) at Doctrine\ORM\Query->_parse() (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:293) at Doctrine\ORM\Query->_doExecute() (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:962) at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:917) at Doctrine\ORM\AbstractQuery->execute(null, 1) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:720) at Doctrine\ORM\AbstractQuery->getResult() (src/CommonBundle/Repository/ElementRepository.php:1236) at CommonBundle\Repository\ElementRepository->getElementsByTemplates(array('image_externe'), null, array(68), -21) (src/FrontBundle/Controller/GalleryController.php:125) at FrontBundle\Controller\GalleryController->galleryImagesAction(object(Request)) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (web/MABF.php:29) |