27 02 2025 10:13:51 El Archivo 2025-02-27 - log_error.txt se ha creado ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjY4NDQ2LCJleHAiOjE3NDA2Nzc0NDZ9.PGz9wPjDkvDlUOl-uSOrh80di5nhTGpi7nbluQRSvA4 -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 15:13:51 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%ABConsumo%20restaurante%C3%82%C2%BB%0ALINE%201%3A%20...%2C%20usuario_respuesta%29%20VALUES%20%28%2717%27%2C%20%27100%27%2C%20%274343%27%2C%20%27Consumo%20r...%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: 284544 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: «Consumo restaurante» LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

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: «Consumo restaurante»
LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r...
^

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5919)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «Consumo restaurante» LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5919)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «Consumo restaurante» LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5919)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[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: «Consumo restaurante»
LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5919)
  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: «Consumo restaurante»
LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5919)
  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: «Consumo restaurante»
LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', 'Consumo r...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5919)
  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)
27 02 2025 10:52:14 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjcwODg3LCJleHAiOjE3NDA2Nzk4ODd9.w3WZId7XOgwHILgXdR0g93-aMLQrZOeUpCOq8L01qmY -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 15:52:13 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...%2C%20usuario_respuesta%29%20VALUES%20%28%2717%27%2C%20%27100%27%2C%20%274343%27%2C%20%27%27%2C%20%271090%27...%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: 284373 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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'...
^

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «» LINE 1: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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: ..., usuario_respuesta) VALUES ('17', '100', '4343', '', '1090'...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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)
27 02 2025 10:58:54 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjcxODQwLCJleHAiOjE3NDA2ODA4NDB9.Cp1SQBvNiPQvakZRofPM3PSU6zNXJ5szVFt3rom25pI -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 15:58:54 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...edede%27%2C%20%270%27%2C%20%27%27%2C%20%2727-02-2025%27%2C%20%2728-02-2025%27%2C%20%272%27%2C%20%27%27%2C%20%27%27%2C%20%279...%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: 284373 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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9...
^

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: la sintaxis de entrada no es válida para tipo integer: «» LINE 1: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', '$dias', '$cantidad', '$valor_u', '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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: ...edede', '0', '', '27-02-2025', '28-02-2025', '2', '', '', '9...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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)
27 02 2025 11:05:01 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjcyMDg0LCJleHAiOjE3NDA2ODEwODR9.-GOOJDGQR2llIfw3axf4WnGCBczoqI4NAwiLOuSc1zs -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 16:05:00 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%5B42601%5D%3A%20Syntax%20error%3A%207%20ERROR%3A%20%20error%20de%20sintaxis%20en%20o%20cerca%20de%20%C3%82%C2%AB%2C%C3%82%C2%BB%0ALINE%201%3A%20...he%20okis%27%2C%20%270%27%2C%20%27%27%2C%20%2727-02-2025%27%2C%20%2728-02-2025%27%2C%202%2C%20%2C%20%2C%20%2785000...%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:62 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: 284140 An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception SyntaxErrorException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,»
LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000...
^

Exceptions 3

Doctrine\DBAL\Exception\ SyntaxErrorException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 62)
  2.             case '3F000':
  3.                 return new SchemaDoesNotExist($exception, $query);
  5.             case '42601':
  6.                 return new SyntaxErrorException($exception, $query);
  8.             case '42702':
  9.                 return new NonUniqueFieldNameException($exception, $query);
  11.             case '42703':
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5921)
  1.         $cc_jefe = $usu2;
  2.         $nombre_jefe = $res_cargo[0]['nombre'];
  3.       }
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$url', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] SyntaxErrorException 
Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000...
                                                             ^

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:62
  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 1: ...he okis', '0', '', '27-02-2025', '28-02-2025', 2, , , '85000...
                                                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5921)
  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)
27 02 2025 11:10:12 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjcyNTI4LCJleHAiOjE3NDA2ODE1Mjh9.XbM3gV6AwZOQk-lWwY45dcCO15b67GKcG7LX-AR3si8 -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 16:10:11 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%5B42601%5D%3A%20Syntax%20error%3A%207%20ERROR%3A%20%20error%20de%20sintaxis%20en%20o%20cerca%20de%20%C3%82%C2%AB%2C%C3%82%C2%BB%0ALINE%20127%3A%20AP%2FZ%27%2C%20%2727-02-2025%27%2C%20%2728-02-2025%27%2C%202%2C%20%2C%20%2C%20%2799500%27%2C%20%270%27%2C%20%27173...%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%5E X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:62 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: 285178 An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception SyntaxErrorException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,»
LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173...
^

Exceptions 3

Doctrine\DBAL\Exception\ SyntaxErrorException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 62)
  2.             case '3F000':
  3.                 return new SchemaDoesNotExist($exception, $query);
  5.             case '42601':
  6.                 return new SyntaxErrorException($exception, $query);
  8.             case '42702':
  9.                 return new NonUniqueFieldNameException($exception, $query);
  11.             case '42703':
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5927)
  1.       if (empty($valor_u)) $valor_u = null;
  2.       if (empty($fechai)) $fechai = null;
  3.       if (empty($fechaf)) $fechaf = null;
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5927)
  1.       if (empty($valor_u)) $valor_u = null;
  2.       if (empty($fechai)) $fechai = null;
  3.       if (empty($fechaf)) $fechaf = null;
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[42601]: Syntax error: 7 ERROR: error de sintaxis en o cerca de «,» LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5927)
  1.       if (empty($valor_u)) $valor_u = null;
  2.       if (empty($fechai)) $fechai = null;
  3.       if (empty($fechaf)) $fechaf = null;
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] SyntaxErrorException 
Doctrine\DBAL\Exception\SyntaxErrorException:
An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173...
                                                ^

  at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:62
  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5927)
  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[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173...
                                                ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5927)
  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[42601]: Syntax error: 7 ERROR:  error de sintaxis en o cerca de «,»
LINE 127: AP/Z', '27-02-2025', '28-02-2025', 2, , , '99500', '0', '173...
                                                ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5927)
  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)
27 02 2025 11:19:36 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjcyNjU3LCJleHAiOjE3NDA2ODE2NTd9.jSNk5pBJa3N31U9nW6xVtC7OP171uDn8eJbgXrKVIsM -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 16:19:36 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%5B22007%5D%3A%20Invalid%20datetime%20format%3A%207%20ERROR%3A%20%20la%20sintaxis%20de%20entrada%20no%20es%20v%C3%83%C2%A1lida%20para%20tipo%20date%3A%20%C3%82%C2%ABnull%C3%82%C2%BB%0ALINE%20130%3A%20AAAAAAAAAD%2F%2F2Q%3D%3D%27%2C%20%27null%27%2C%20%27null%27%2C%20null%2C%204%2C%2020000%2C%20%2780000%27%2C%20...%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%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: 285204 An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: la sintaxis de entrada no es válida para tipo date: «null» LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 7 ERROR: la sintaxis de entrada no es válida para tipo date: «null»
LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ...
^

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[22007]: Invalid datetime format: 7 ERROR: la sintaxis de entrada no es válida para tipo date: «null» LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ... ^

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[22007]: Invalid datetime format: 7 ERROR: la sintaxis de entrada no es válida para tipo date: «null» LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ... ^

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', '$fechai', '$fechaf', $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] DriverException 
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 7 ERROR:  la sintaxis de entrada no es válida para tipo date: «null»
LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ...
                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[22007]: Invalid datetime format: 7 ERROR:  la sintaxis de entrada no es válida para tipo date: «null»
LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ...
                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[22007]: Invalid datetime format: 7 ERROR:  la sintaxis de entrada no es válida para tipo date: «null»
LINE 130: AAAAAAAAAD//2Q==', 'null', 'null', null, 4, 20000, '80000', ...
                             ^

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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)
27 02 2025 11:25:51 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjczMjU2LCJleHAiOjE3NDA2ODIyNTZ9.B3H9FE7eVhl1zeRcBMntGYpCacgGzFK3j4zRDlyrg7Y -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 16:25:51 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%5B42804%5D%3A%20Datatype%20mismatch%3A%207%20ERROR%3A%20%20la%20columna%20%C3%82%C2%ABfechai%C3%82%C2%BB%20es%20de%20tipo%20date%20pero%20la%20expresi%C3%83%C2%B3n%20es%20de%20tipo%20integer%0ALINE%201%3A%20...9%27%2C%20%271002%27%2C%20%273323%27%2C%20%271%27%2C%20%271089%27%2C%20%27wada%27%2C%20%270%27%2C%20%27%27%2C%2027-02-2025...%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%0AHINT%3A%20%20Necesitar%C3%83%C2%A1%20reescribir%20la%20expresi%C3%83%C2%B3n%20o%20aplicarle%20una%20conversi%C3%83%C2%B3n%20de%20tipo. 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: 286350 An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo. (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025...
^
HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null";
  3.       if (empty($fechaf)) $fechaf = "null";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] DriverException 
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...9', '1002', '3323', '1', '1089', 'wada', '0', '', 27-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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)
27 02 2025 11:43:12 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzQwNjczNzY5LCJleHAiOjE3NDA2ODI3Njl9.F_8VyqCdJBmWgJ4NAIefbZOVG96T0wC_ZZl8nmXOEDw -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 27 Feb 2025 16:43:11 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%5B42804%5D%3A%20Datatype%20mismatch%3A%207%20ERROR%3A%20%20la%20columna%20%C3%82%C2%ABfechai%C3%82%C2%BB%20es%20de%20tipo%20date%20pero%20la%20expresi%C3%83%C2%B3n%20es%20de%20tipo%20integer%0ALINE%201%3A%20...%2717%27%2C%20%271%27%2C%20%274343%27%2C%20%271%27%2C%20%271091%27%2C%20%27reara%27%2C%20%270%27%2C%20%27%27%2C%2028-02-2025...%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%0AHINT%3A%20%20Necesitar%C3%83%C2%A1%20reescribir%20la%20expresi%C3%83%C2%B3n%20o%20aplicarle%20una%20conversi%C3%83%C2%B3n%20de%20tipo. 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: 287778 An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo. (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025...
^
HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

Exceptions 3

Doctrine\DBAL\Exception\ DriverException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 87)
  1.         // We have to match against the SQLSTATE in the error message in these cases.
  2.         if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) {
  3.             return new ConnectionException($exception, $query);
  4.         }
  6.         return new DriverException($exception, $query);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1908)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1851)
  1.         Driver\Exception $e,
  2.         string $sql,
  3.         array $params = [],
  4.         array $types = []
  5.     ): DriverException {
  6.         return $this->handleDriverException($e, new Query($sql, $params, $types));
  7.     }
  9.     /** @internal */
  10.     final public function convertException(Driver\Exception $e): DriverException
  11.     {
in vendor/doctrine/dbal/src/Statement.php -> convertExceptionDuringQuery (line 194)
  1.             return new Result(
  2.                 $this->stmt->execute($params),
  3.                 $this->conn,
  4.             );
  5.         } catch (Driver\Exception $ex) {
  6.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  7.         } finally {
  8.             if ($logger !== null) {
  9.                 $logger->stopQuery();
  10.             }
  11.         }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null"; else "'$fechai'";
  3.       if (empty($fechaf)) $fechaf = "null"; else "'$fechaf'";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 28)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 136)
  1.         }
  3.         try {
  4.             $this->stmt->execute($params);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Result($this->stmt);
  10.     }
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null"; else "'$fechai'";
  3.       if (empty($fechaf)) $fechaf = "null"; else "'$fechaf'";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

PDOException

SQLSTATE[42804]: Datatype mismatch: 7 ERROR: la columna «fechai» es de tipo date pero la expresión es de tipo integer LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025... ^ HINT: Necesitará reescribir la expresión o aplicarle una conversión de tipo.

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 134)
  1.                     . ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  5.         try {
  6.             $this->stmt->execute($params);
  7.         } catch (PDOException $exception) {
  8.             throw Exception::new($exception);
  9.         }
  11.         return new Result($this->stmt);
in vendor/doctrine/dbal/src/Statement.php -> execute (line 190)
  1.             $logger->startQuery($this->sql, $this->params, $this->types);
  2.         }
  4.         try {
  5.             return new Result(
  6.                 $this->stmt->execute($params),
  7.                 $this->conn,
  8.             );
  9.         } catch (Driver\Exception $ex) {
  10.             throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
  11.         } finally {
in vendor/doctrine/dbal/src/Statement.php -> execute (line 224)
  2.         if ($params === []) {
  3.             $params = null; // Workaround as long execute() exists and used internally.
  4.         }
  6.         return $this->execute($params);
  7.     }
  9.     /**
  10.      * Executes the statement with the currently bound parameters and return affected rows.
  11.      *
Statement->executeQuery() in src/Services/Conexion.php (line 574)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet = $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 533)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }
  9.       }
  10.     }
Conexion->query() in src/Controller/PtatController.php (line 5932)
  1.       if (empty($valor_u)) $valor_u = "null";
  2.       if (empty($fechai)) $fechai = "null"; else "'$fechai'";
  3.       if (empty($fechaf)) $fechaf = "null"; else "'$fechaf'";
  5.       $sql_ins = "INSERT INTO sem_ant_viat_reg_facturas (solicitud_id, nit, ticket_corr_id, tipo_gasto, ccostos, descripcion, tipo_soporte, url, fechai, fechaf, dias, cantidad, valor_u, total, tipo_fact, usuario_respuesta) VALUES ('$solicitud_id', '$nit', '$ticket_corr_id', '$tipo_gasto', '$ccostos', '$descripcion', '$tipo_soporte', '$base64', $fechai, $fechaf, $dias, $cantidad, $valor_u, '$total', '$tipo_fact', '$cc_jefe') RETURNING id";
  6.       $res_ins = $this->cnn->query('0', $sql_ins);
  7.       if (count($res_ins) <= 0)
  8.       {
  9.         $respuesta["info"] = $respuesta["message"] = "No se realizo el registro, intente nuevamente";
  10.         $response->headers->set('HTTP_AUTHENTICATION', $token_auth);
  11.         return $response->setContent(json_encode($respuesta));
in vendor/symfony/http-kernel/HttpKernel.php -> metodos (line 163)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 74)
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  4.         $this->requestStack->push($request);
  5.         try {
  6.             return $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 184)
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices = true;
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.         $this->request = $request;
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  7.         $response->send();
  9.         if ($this->kernel instanceof TerminableInterface) {
  10.             $this->kernel->terminate($this->request, $response);
  11.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in public/index.php (line 16)
  1. $method = $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  6. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  8. return function (array $context) {
  9.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  10. };

Logs

No log messages

Stack Traces 3

[3/3] DriverException 
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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[42804]: Datatype mismatch: 7 ERROR:  la columna «fechai» es de tipo date pero la expresión es de tipo integer
LINE 1: ...'17', '1', '4343', '1', '1091', 'reara', '0', '', 28-02-2025...
                                                             ^
HINT:  Necesitará reescribir la expresión o aplicarle una conversión de tipo.

  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:574)
  at App\Services\Conexion->query_normal()
     (src/Services/Conexion.php:533)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:5932)
  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)