Offset must be a positive integer or zero, -9 given
500 Internal Server Error - DBALException
Stack Trace
-
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Platforms/AbstractPlatform.php at line 3414
$offset = (int) $offset;
if ($offset < 0) {
throw new DBALException(sprintf(
'Offset must be a positive integer or zero, %d given',
$offset
));
-
at
AbstractPlatform
->modifyLimitQuery
('SELECT c0_.id AS id_0, c0_.nombre AS nombre_1, c0_.orden AS orden_2, c0_.imagen AS imagen_3, c0_.destacar AS destacar_4, c1_.id AS id_5, c1_.nombre AS nombre_6, c1_.descripcionCorta AS descripcionCorta_7, c1_.descripcion AS descripcion_8, c2_.id AS id_9, c2_.nombre AS nombre_10, c2_.orden AS orden_11, c2_.imagen AS imagen_12, c3_.id AS id_13, c3_.nombre AS nombre_14, c4_.id AS id_15, c4_.nombre AS nombre_16, c4_.orden AS orden_17, c5_.id AS id_18, c5_.nombre AS nombre_19, c5_.adjunto AS adjunto_20, c6_.id AS id_21, c6_.orden AS orden_22, c6_.logo AS logo_23, c6_.nombre AS nombre_24, c6_.imagen AS imagen_25, c6_.estrellas AS estrellas_26, c7_.id AS id_27, c7_.nombre AS nombre_28, c7_.descripcion AS descripcion_29, c0_.categoria_id AS categoria_id_30, c0_.gama_id AS gama_id_31, c1_.locale_id AS locale_id_32, c1_.articulo_id AS articulo_id_33, c2_.tipo_id AS tipo_id_34, c3_.categoria_id AS categoria_id_35, c3_.locale_id AS locale_id_36, c5_.tipo_id AS tipo_id_37, c5_.locale_id AS locale_id_38, c6_.tipo_id AS tipo_id_39, c7_.gama_id AS gama_id_40, c7_.locale_id AS locale_id_41 FROM catalogo_articulo c0_ INNER JOIN catalogo_articulo_traduccion c1_ ON c0_.id = c1_.articulo_id AND (c1_.locale_id = ? AND c1_.articulo_id = c0_.id) INNER JOIN catalogo_categoria c2_ ON c0_.categoria_id = c2_.id INNER JOIN catalogo_categoria_traduccion c3_ ON c2_.id = c3_.categoria_id AND (c3_.locale_id = ? AND c3_.categoria_id = c2_.id) INNER JOIN catalogo_tipo c4_ ON c2_.tipo_id = c4_.id INNER JOIN catalogo_tipo_traduccion c5_ ON c4_.id = c5_.tipo_id AND (c5_.locale_id = ? AND c5_.tipo_id = c4_.id) LEFT JOIN catalogo_gama c6_ ON c0_.gama_id = c6_.id LEFT JOIN catalogo_gama_traduccion c7_ ON c6_.id = c7_.gama_id AND (c7_.locale_id = ? AND c7_.gama_id = c6_.id) WHERE c0_.categoria_id = ? GROUP BY c0_.id ORDER BY c6_.nombre + 1 DESC', '9', '-9')
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php at line 545 -
at
SqlWalker
->walkSelectStatement
(object(SelectStatement))
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php at line 42 -
at
SingleSelectExecutor
->__construct
(object(SelectStatement), object(SqlWalker))
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php at line 278 -
at
SqlWalker
->getExecutor
(object(SelectStatement))
in vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php at line 398 -
at
Parser
->parse
()
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php at line 283 -
at
Query
->_parse
()
in vendor/doctrine/orm/lib/Doctrine/ORM/Query.php at line 295 -
at
Query
->_doExecute
()
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 957 -
at
AbstractQuery
->executeIgnoreQueryCache
(null, '1')
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 912 -
at
AbstractQuery
->execute
(null, '1')
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php at line 716 -
at
AbstractQuery
->getResult
()
in src/Luma/CatalogoBundle/Repository/ArticuloRepository.php at line 85 -
at
ArticuloRepository
->findByCategoriaAndLocale
(object(Categoria), object(Locale), null, '9', '-9')
in src/Luma/CatalogoBundle/Controller/DefaultController.php at line 81 - at DefaultController ->categoriaAction (object(Request))
-
at
call_user_func_array
(array(object(DefaultController), 'categoriaAction'), array(object(Request)))
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php at line 153 -
at
HttpKernel
->handleRaw
(object(Request), '1')
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php at line 68 -
at
HttpKernel
->handle
(object(Request), '1', true)
in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php at line 169 -
at
Kernel
->handle
(object(Request))
in web/app.php at line 18