30 09 2025 11:27:39 El Archivo 2025-09-30 - log_error.txt se ha creado ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzU5MjQ5NTE4LCJleHAiOjE3NTkyNTg1MTh9.cGwmS3QtLFbu0PqpZWCHE73zCdNSBTpjewupStgZn5A -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 30 Sep 2025 16:27:38 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B22P02%5D%3A%20Invalid%20text%20representation%3A%207%20ERROR%3A%20%20la%20sintaxis%20de%20entrada%20no%20es%20v%C3%83%C2%A1lida%20para%20tipo%20integer%3A%20%C3%82%C2%AB%C3%82%C2%BB%0ALINE%201%3A%20...3%27%2C%271091%27%2C0%2C%27%27%2C%27dadada%27%2C%2730-09-2025%27%2C%2730-09-2025%27%2C%27%27%29%20RETURN...%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5E X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:87 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 284808
// We have to match against the SQLSTATE in the error message in these cases. if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) { return new ConnectionException($exception, $query); } return new DriverException($exception, $query); }} private function handleDriverException( Driver\Exception $driverException, ?Query $query ): DriverException { $this->exceptionConverter ??= $this->_driver->getExceptionConverter(); $exception = $this->exceptionConverter->convert($driverException, $query); if ($exception instanceof ConnectionLost) { $this->close(); } Driver\Exception $e, string $sql, array $params = [], array $types = [] ): DriverException { return $this->handleDriverException($e, new Query($sql, $params, $types)); } /** @internal */ final public function convertException(Driver\Exception $e): DriverException { return new Result( $this->stmt->execute($params), $this->conn, ); } catch (Driver\Exception $ex) { throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types); } finally { if ($logger !== null) { $logger->stopQuery(); } } if ($params === []) { $params = null; // Workaround as long execute() exists and used internally. } return $this->execute($params); } /** * Executes the statement with the currently bound parameters and return affected rows. * } */ // $resultSet = $stmt->executeQuery();//execute(); /* try { */ // $resultSet_aux = $stmt->executeQuery();//execute(); // $resultSet = $resultSet_aux->fetchAllAssociative();//execute(); $resultSet = $stmt->executeQuery()->fetchAllAssociative(); $this->cnn->close(); /* } catch (\Throwable $th) { } */ // $this->log->logs("respuestaaa ",array($resultSet)); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', ccostos = '$ccostosList', estado = 0, respuesta = '', descripcion = '$descripcion', fechai = '$fechai', fechaf = '$fechaf', tipo_ticket = '$tipo_ticket' WHERE id = $id_sol RETURNING id";
else
$sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', estado = 0, respuesta = '', descripcion = '$descripcion', tipo_ticket = '$tipo_ticket', fechai = NULL, fechaf = NULL, ccostos = NULL WHERE id = $id_sol RETURNING id";
}
$res = $this->cnn->query('0', $sql);
if (count($res) <= 0)
{
$respuesta["info"] = $respuesta["message"] = "No se pudo realizar, intente nuevamente";
$response->headers->set('HTTP_AUTHENTICATION', $token_auth);
return $response->setContent(json_encode($respuesta));
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);}; } else { $code = $exception->getCode(); $sqlState = null; } return new self($exception->getMessage(), $sqlState, $code, $exception); }} } try { $this->stmt->execute($params); } catch (PDOException $exception) { throw Exception::new($exception); } return new Result($this->stmt); } $logger->startQuery($this->sql, $this->params, $this->types); } try { return new Result( $this->stmt->execute($params), $this->conn, ); } catch (Driver\Exception $ex) { throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types); } finally { if ($params === []) { $params = null; // Workaround as long execute() exists and used internally. } return $this->execute($params); } /** * Executes the statement with the currently bound parameters and return affected rows. * } */ // $resultSet = $stmt->executeQuery();//execute(); /* try { */ // $resultSet_aux = $stmt->executeQuery();//execute(); // $resultSet = $resultSet_aux->fetchAllAssociative();//execute(); $resultSet = $stmt->executeQuery()->fetchAllAssociative(); $this->cnn->close(); /* } catch (\Throwable $th) { } */ // $this->log->logs("respuestaaa ",array($resultSet)); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', ccostos = '$ccostosList', estado = 0, respuesta = '', descripcion = '$descripcion', fechai = '$fechai', fechaf = '$fechaf', tipo_ticket = '$tipo_ticket' WHERE id = $id_sol RETURNING id";
else
$sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', estado = 0, respuesta = '', descripcion = '$descripcion', tipo_ticket = '$tipo_ticket', fechai = NULL, fechaf = NULL, ccostos = NULL WHERE id = $id_sol RETURNING id";
}
$res = $this->cnn->query('0', $sql);
if (count($res) <= 0)
{
$respuesta["info"] = $respuesta["message"] = "No se pudo realizar, intente nuevamente";
$response->headers->set('HTTP_AUTHENTICATION', $token_auth);
return $response->setContent(json_encode($respuesta));
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);}; . ' Statement::bindParam() or Statement::bindValue() instead.', ); } try { $this->stmt->execute($params); } catch (PDOException $exception) { throw Exception::new($exception); } return new Result($this->stmt); . ' Statement::bindParam() or Statement::bindValue() instead.', ); } try { $this->stmt->execute($params); } catch (PDOException $exception) { throw Exception::new($exception); } return new Result($this->stmt); $logger->startQuery($this->sql, $this->params, $this->types); } try { return new Result( $this->stmt->execute($params), $this->conn, ); } catch (Driver\Exception $ex) { throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types); } finally { if ($params === []) { $params = null; // Workaround as long execute() exists and used internally. } return $this->execute($params); } /** * Executes the statement with the currently bound parameters and return affected rows. * } */ // $resultSet = $stmt->executeQuery();//execute(); /* try { */ // $resultSet_aux = $stmt->executeQuery();//execute(); // $resultSet = $resultSet_aux->fetchAllAssociative();//execute(); $resultSet = $stmt->executeQuery()->fetchAllAssociative(); $this->cnn->close(); /* } catch (\Throwable $th) { } */ // $this->log->logs("respuestaaa ",array($resultSet)); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', ccostos = '$ccostosList', estado = 0, respuesta = '', descripcion = '$descripcion', fechai = '$fechai', fechaf = '$fechaf', tipo_ticket = '$tipo_ticket' WHERE id = $id_sol RETURNING id";
else
$sql = "UPDATE sem_ant_viat_reg_solicitud SET usuario_respuesta = '$cc_jefe', tipo_solicitud = $tipo_solicitud, valor = $valor, ticket = '$ticket', estado = 0, respuesta = '', descripcion = '$descripcion', tipo_ticket = '$tipo_ticket', fechai = NULL, fechaf = NULL, ccostos = NULL WHERE id = $id_sol RETURNING id";
}
$res = $this->cnn->query('0', $sql);
if (count($res) <= 0)
{
$respuesta["info"] = $respuesta["message"] = "No se pudo realizar, intente nuevamente";
$response->headers->set('HTTP_AUTHENTICATION', $token_auth);
return $response->setContent(json_encode($respuesta));
$this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};No log messages
|
[3/3]
DriverException
|
|---|
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «»
LINE 1: ...3','1091',0,'','dadada','30-09-2025','30-09-2025','') RETURN...
^
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
(vendor/doctrine/dbal/src/Connection.php:1908)
at Doctrine\DBAL\Connection->handleDriverException()
(vendor/doctrine/dbal/src/Connection.php:1851)
at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
(vendor/doctrine/dbal/src/Statement.php:194)
at Doctrine\DBAL\Statement->execute()
(vendor/doctrine/dbal/src/Statement.php:224)
at Doctrine\DBAL\Statement->executeQuery()
(src/Services/Conexion.php:578)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:6783)
at App\Controller\PtatController->metodos()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|
|
[2/3]
Exception
|
|---|
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «»
LINE 1: ...3','1091',0,'','dadada','30-09-2025','30-09-2025','') RETURN...
^
at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
at Doctrine\DBAL\Driver\PDO\Exception::new()
(vendor/doctrine/dbal/src/Driver/PDO/Statement.php:136)
at Doctrine\DBAL\Driver\PDO\Statement->execute()
(vendor/doctrine/dbal/src/Statement.php:190)
at Doctrine\DBAL\Statement->execute()
(vendor/doctrine/dbal/src/Statement.php:224)
at Doctrine\DBAL\Statement->executeQuery()
(src/Services/Conexion.php:578)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:6783)
at App\Controller\PtatController->metodos()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|
|
[1/3]
PDOException
|
|---|
PDOException:
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «»
LINE 1: ...3','1091',0,'','dadada','30-09-2025','30-09-2025','') RETURN...
^
at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134
at PDOStatement->execute()
(vendor/doctrine/dbal/src/Driver/PDO/Statement.php:134)
at Doctrine\DBAL\Driver\PDO\Statement->execute()
(vendor/doctrine/dbal/src/Statement.php:190)
at Doctrine\DBAL\Statement->execute()
(vendor/doctrine/dbal/src/Statement.php:224)
at Doctrine\DBAL\Statement->executeQuery()
(src/Services/Conexion.php:578)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:6783)
at App\Controller\PtatController->metodos()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|