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