01 07 2025 10:21:25 El Archivo 2025-07-01 - log_error.txt se ha creado ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzUxMzgzMjQwLCJleHAiOjE3NTEzOTIyNDB9.V2msuSkzkBGvu1jBs8myLM13IUDEWzea5htGV0dAdws -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 01 Jul 2025 15:21:25 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: Attempted%20to%20call%20an%20undefined%20method%20named%20%22real_escape_string%22%20of%20class%20%22App%5CServices%5CConexion%22. X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fsrc%2FController%2FPtatController.php:7467 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: 88943 Attempted to call an undefined method named "real_escape_string" of class "App\Services\Conexion". (500 Internal Server Error)

Symfony Exception

Symfony Docs

UndefinedMethodError

HTTP 500 Internal Server Error

Attempted to call an undefined method named "real_escape_string" of class "App\Services\Conexion".

Exception

Symfony\Component\ErrorHandler\Error\ UndefinedMethodError

in src/Controller/PtatController.php (line 7467)
  1.       {
  2.         if ($campo === "cod_liquidador" || $campo === "novedades_agregadas") continue;
  3.         $campos[] = "$campo = '$valor'";
  4.       }
  6.       $cod_liquidador = $this->cnn->real_escape_string($datos['cod_liquidador']);
  7.       /* $sql_updt = "UPDATE liquidadores_vendedor_moto SET " . implode(", ", $campos) . ", estado = 'R', cajera = '$usuario', fecha_recaudo = now() WHERE cod_liquidador = '$cod_liquidador'";
  8.       $res_updt = $this->cnn->query('0', $sql_updt);
  9.       if (count($res_updt) <= 0)
  10.       {
  11.         $respuesta["info"] = $respuesta["message"] = "No se pudo actualizar, intente nuevamente";
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 Trace

UndefinedMethodError 
Symfony\Component\ErrorHandler\Error\UndefinedMethodError:
Attempted to call an undefined method named "real_escape_string" of class "App\Services\Conexion".

  at src/Controller/PtatController.php:7467
  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)
01 07 2025 10:56:13 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzUxMzg0ODM0LCJleHAiOjE3NTEzOTM4MzR9.lTghlsbGtUKkczAPD-XFLbCZsNUuiOwQhZHzzzboeQs -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 01 Jul 2025 15:56: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: Warning%3A%20foreach%28%29%20argument%20must%20be%20of%20type%20array%7Cobject%2C%20null%20given X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fsrc%2FController%2FPtatController.php:3337 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: 89719 Warning: foreach() argument must be of type array|object, null given (500 Internal Server Error)

Symfony Exception

Symfony Docs

ErrorException

HTTP 500 Internal Server Error

Warning: foreach() argument must be of type array|object, null given

Exception

ErrorException

in src/Controller/PtatController.php (line 3337)
  1.       $datos1 = mb_convert_encoding($datos1, 'UTF-8', mb_list_encodings());
  2.       $arreglo = json_decode($datos1, true);
  3.       $this->log = new Log('ptat_sgc', $usuario, $this->ruta);
  5.       $datos_limpios = $arreglo;
  6.       foreach ($datos_limpios as &$dato)
  7.       {
  8.         if (isset($dato['arr_informacion']))
  9.         {
  10.           $arr_informacion = json_decode($dato['arr_informacion'], true);
  11.           foreach ($arr_informacion as &$informacion)
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 Trace

ErrorException 
ErrorException:
Warning: foreach() argument must be of type array|object, null given

  at src/Controller/PtatController.php:3337
  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)
01 07 2025 11:58:58 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzUxMzg5MTAzLCJleHAiOjE3NTEzOTgxMDN9.vz6vEr1MQqauZ9FCbM0yK69sn4b5Qw9Tg9VB6eXGoxI -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 01 Jul 2025 16:58:58 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: Warning%3A%20Undefined%20array%20key%201 X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fsrc%2FController%2FPtatController.php:3366 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: 90994 Warning: Undefined array key 1 (500 Internal Server Error)

Symfony Exception

Symfony Docs

ErrorException

HTTP 500 Internal Server Error

Warning: Undefined array key 1

Exception

ErrorException

in src/Controller/PtatController.php (line 3366)
  1.       $code = "0";
  2.       $contador = "No se pudo realizar la operacion";
  3.       $estado = 2;
  4.       $control_ = explode("|", $string);
  5.       $pdv = str_replace($searchString, $replaceString, $control_[0]);
  6.       $latitud = str_replace($searchString, $replaceString, $control_[1]);
  7.       $longitud = str_replace($searchString, $replaceString, $control_[2]);
  8.       $usuario = str_replace($searchString, $replaceString, $control_[3]);
  9.       $this->log = new Log('ptat_sgc', $usuario, $this->ruta);
  10.     }
  11.     $permisos_array = array();
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 Trace

ErrorException 
ErrorException:
Warning: Undefined array key 1

  at src/Controller/PtatController.php:3366
  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)
01 07 2025 12:15:58 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzUxMzkwMTEwLCJleHAiOjE3NTEzOTkxMTB9.HRecUBmSaRPzeYn5xx_2lpc5HLhXqqUS4ORIDLIeVFk -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 01 Jul 2025 17:15:58 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%5B22003%5D%3A%20Numeric%20value%20out%20of%20range%3A%207%20ERROR%3A%20%20el%20valor%20%C3%82%C2%AB2406250006%C3%82%C2%BB%20est%C3%83%C2%A1%20fuera%20de%20rango%20para%20el%20tipo%20integer%0ALINE%202%3A%20%20%20%20%20%20%20%20%20VALUES%20%28%27CP1006820220%27%2C%272406250006%27%2C%272%27%2C%2712%27%2C%27NO%20ENV...%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%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: 277695 An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: el valor «2406250006» está fuera de rango para el tipo integer LINE 2: VALUES ('CP1006820220','2406250006','2','12','NO ENV... ^ (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: el valor «2406250006» está fuera de rango para el tipo integer
LINE 2: VALUES ('CP1006820220','2406250006','2','12','NO ENV...
^

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7495)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$cod_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22003]: Numeric value out of range: 7 ERROR: el valor «2406250006» está fuera de rango para el tipo integer LINE 2: VALUES ('CP1006820220','2406250006','2','12','NO ENV... ^

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7495)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$cod_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22003]: Numeric value out of range: 7 ERROR: el valor «2406250006» está fuera de rango para el tipo integer LINE 2: VALUES ('CP1006820220','2406250006','2','12','NO ENV... ^

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7495)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$cod_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22003]: Numeric value out of range: 7 ERROR:  el valor «2406250006» está fuera de rango para el tipo integer
LINE 2:         VALUES ('CP1006820220','2406250006','2','12','NO ENV...
                                       ^

  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:7495)
  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[22003]: Numeric value out of range: 7 ERROR:  el valor «2406250006» está fuera de rango para el tipo integer
LINE 2:         VALUES ('CP1006820220','2406250006','2','12','NO ENV...
                                       ^

  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:7495)
  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[22003]: Numeric value out of range: 7 ERROR:  el valor «2406250006» está fuera de rango para el tipo integer
LINE 2:         VALUES ('CP1006820220','2406250006','2','12','NO ENV...
                                       ^

  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:7495)
  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)
01 07 2025 14:36:44 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzUxMzkwMjk3LCJleHAiOjE3NTEzOTkyOTd9.SoAwvvafyp8o_ZSnzLx1DsOJWSBHsHCFwLUSqhCx0JA -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Tue, 01 Jul 2025 19:36:44 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%5B22P05%5D%3A%20Untranslatable%20character%3A%207%20ERROR%3A%20%20car%C3%83%C2%A1cter%20con%20secuencia%20de%20bytes%200xef%200xbe%200x8d%20en%20codificaci%C3%83%C2%B3n%20%C3%82%C2%ABUTF8%C3%82%C2%BB%20no%20tiene%20equivalente%20en%20la%20codificaci%C3%83%C2%B3n%20%C3%82%C2%ABLATIN1%C3%82%C2%BB 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: 277257 An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1» (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception DriverException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7496)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$id_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22P05]: Untranslatable character: 7 ERROR: carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7496)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$id_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22P05]: Untranslatable character: 7 ERROR: carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

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 578)
  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 537)
  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.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 7496)
  1.         $valor = $novedad['valor'];
  2.         $tipo = $novedad['tipo'];
  4.         $sql_insert_novedad = "INSERT INTO liquidadores_vendedor_novedades (usuario, id_liquidador, tipo_nov, id_nov, novedad, valor, serie)
  5.         VALUES ('$usuario','$id_liquidador','$tipo','$id_novedad','$nombre_novedad','$valor','$serie') RETURNING id";
  6.         $res_insert_novedad = $this->cnn->query('0', $sql_insert_novedad);
  8.         if (count($res_insert_novedad) <= 0)
  9.           $errores_novedades[] = "Error al insertar novedad: $id_novedad | $nombre_novedad | $serie | $valor";
  10.       }
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[22P05]: Untranslatable character: 7 ERROR:  carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

  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:7496)
  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[22P05]: Untranslatable character: 7 ERROR:  carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

  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:7496)
  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[22P05]: Untranslatable character: 7 ERROR:  carácter con secuencia de bytes 0xef 0xbe 0x8d en codificación «UTF8» no tiene equivalente en la codificación «LATIN1»

  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:7496)
  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)