Exception {#1303
#message: "Offset must be a positive integer or zero, -24 given"
#code: 0
#file: "/usr/home/hispanoracing.com/web/vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php"
#line: 4382
trace: {
/usr/home/hispanoracing.com/web/vendor/doctrine/dbal/src/Platforms/AbstractPlatform.php:4382 {
› if ($offset < 0) {
› throw new Exception(sprintf(
› 'Offset must be a positive integer or zero, %d given',
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:267 {
› $this->maxResults,
› $this->firstResult
› );
arguments: {
$query: "SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, m1_.nombre FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.nombreUrl AS nombreUrl_2, a0_.referencia AS referencia_3, a0_.descripcion AS descripcion_4, a0_.datoAdicional AS datoAdicional_5, a0_.activado AS activado_6, a0_.estado AS estado_7, a0_.agrupacion AS agrupacion_8, a0_.fechaAlta AS fechaAlta_9, a0_.precio AS precio_10, a0_.precioCoste AS precioCoste_11, a0_.precioOferta AS precioOferta_12, a0_.porcentajeOferta AS porcentajeOferta_13, a0_.portesGratis AS portesGratis_14, a0_.buscar AS buscar_15, a0_.amazonUltimaActualizacion AS amazonUltimaActualizacion_16, a0_.amazonDiasSinActualizacion AS amazonDiasSinActualizacion_17, a0_.amazonPresencia AS amazonPresencia_18, a0_.googleShopping AS googleShopping_19 FROM articulo a0_ INNER JOIN marca m1_ ON a0_.idMarca = m1_.id WHERE a0_.idCategoria IN (?) AND a0_.activado = 1) dctrn_result_inner ORDER BY m1_.nombre ASC) dctrn_result"
$limit: 24
$offset: -24
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:300 {
› // path expressions referenced in the query.
› $walker->walkSelectStatementWithoutRowNumber($AST, false);
› $orderByPathExpressions = $walker->getOrderByPathExpressions();
arguments: {
$AST: SelectStatement {#1385 …}
$addMissingItemsFromOrderByToSelect: false
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:241 {
› // the SQL is generated.
› $this->addMissingItemsFromOrderByToSelect($AST);
› }
arguments: {
$AST: SelectStatement {#1385 …}
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Tools/Pagination/LimitSubqueryOutputWalker.php:165 {
›
› return $this->walkSelectStatementWithoutRowNumber($AST);
› }
arguments: {
$AST: SelectStatement {#1385 …}
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Query/Exec/SingleSelectExecutor.php:23 {
›
› $this->sqlStatements = $sqlWalker->walkSelectStatement($AST);
› }
arguments: {
$AST: SelectStatement {#1385 …}
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Query/SqlWalker.php:305 {
› default:
› return new Exec\SingleSelectExecutor($AST, $this);
› }
arguments: {
$AST: SelectStatement {#1385 …}
$sqlWalker: LimitSubqueryOutputWalker {#1310 …}
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Query/Parser.php:398 {
› // Assign an SQL executor to the parser result
› $this->parserResult->setSqlExecutor($outputWalker->getExecutor($AST));
›
arguments: {
$AST: SelectStatement {#1385 …}
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Query.php:276 {
›
› $this->parserResult = $parser->parse();
›
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Query.php:288 {
› {
› $executor = $this->parse()->getSqlExecutor();
›
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/AbstractQuery.php:1212 {
›
› $stmt = $this->_doExecute();
›
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/AbstractQuery.php:1166 {
›
› return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
› }
arguments: {
$parameters: null
$hydrationMode: 3
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/AbstractQuery.php:937 {
› {
› return $this->execute(null, self::HYDRATE_SCALAR);
› }
arguments: {
$parameters: null
$hydrationMode: 3
}
}
/usr/home/hispanoracing.com/web/vendor/doctrine/orm/src/Tools/Pagination/Paginator.php:153 {
›
› $foundIdRows = $subQuery->getScalarResult();
›
}
/usr/home/hispanoracing.com/web/app/src/Hispanoracing/FrontEnd/Service/CategoriaHtml.php:186 {
› $regs = [];
› foreach ($paginator as $pag)
› {
}
/usr/home/hispanoracing.com/web/app/src/Hispanoracing/FrontEnd/Controller/CategoriaController.php:19 {
› $cs = $container->get('app.front.categoria');
› $html = $cs->familiaAction($request);
›
arguments: {
$request: Request {#6 …}
}
}
/usr/home/hispanoracing.com/web/vendor/symfony/http-kernel/HttpKernel.php:151 {
› // call controller
› $response = \call_user_func_array($controller, $arguments);
›
arguments: {
$request: Request {#6 …}
}
}
/usr/home/hispanoracing.com/web/vendor/symfony/http-kernel/HttpKernel.php:68 {
› try {
› return $this->handleRaw($request, $type);
› } catch (\Exception $e) {
arguments: {
$request: Request {#6 …}
$type: 1
}
}
/usr/home/hispanoracing.com/web/index.php:23 {
› // le decimos a handle que no capture laexcepción para derivarlo al sistema antiguo
› $response = $kernel->handle($request,HttpKernelInterface::MASTER_REQUEST,false);
›
arguments: {
$request: Request {#6 …}
$type: 1
$catch: false
}
}
}
}
AKI 1