05 02 2025 11:32:36 El Archivo 2025-02-05 - log_error.txt se ha creado ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzM4NzcyNDQ0LCJleHAiOjE3Mzg3ODE0NDR9.Ss70wF9jo5UYY5milHoy6Xdm85YHb5LHdJSSQ1p5WZ0 -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Wed, 05 Feb 2025 16:32:35 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%5B42703%5D%3A%20Undefined%20column%3A%207%20ERROR%3A%20%20no%20existe%20la%20columna%20%C3%82%C2%ABobs_anula%C3%82%C2%BB%20en%20la%20relaci%C3%83%C2%B3n%20%C3%82%C2%ABsem_ant_viat_reg_solicitud%C3%82%C2%BB%0ALINE%201%3A%20...viat_reg_solicitud%20SET%20estado%3D4%2C%20fecha_mod%3Dnow%28%29%2C%20obs_anula%3D...%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:68 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: 279512
case '42702': return new NonUniqueFieldNameException($exception, $query); case '42703': return new InvalidFieldNameException($exception, $query); case '42P01': return new TableNotFoundException($exception, $query); case '42P07': 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; } } } $id = !empty($arreglo['id']) ? $arreglo['id'] : 0; $usuario = !empty($arreglo['usuario']) ? $arreglo['usuario'] : 0; $motivo_a = !empty($arreglo['motivo_a']) ? $arreglo['motivo_a'] : ""; $sql_upd = "UPDATE sem_ant_viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula='$motivo_a' WHERE id=$id returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue anulada"; $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; } } } $id = !empty($arreglo['id']) ? $arreglo['id'] : 0; $usuario = !empty($arreglo['usuario']) ? $arreglo['usuario'] : 0; $motivo_a = !empty($arreglo['motivo_a']) ? $arreglo['motivo_a'] : ""; $sql_upd = "UPDATE sem_ant_viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula='$motivo_a' WHERE id=$id returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue anulada"; $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; } } } $id = !empty($arreglo['id']) ? $arreglo['id'] : 0; $usuario = !empty($arreglo['usuario']) ? $arreglo['usuario'] : 0; $motivo_a = !empty($arreglo['motivo_a']) ? $arreglo['motivo_a'] : ""; $sql_upd = "UPDATE sem_ant_viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula='$motivo_a' WHERE id=$id returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue anulada"; $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]
InvalidFieldNameException
|
|---|
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: no existe la columna «obs_anula» en la relación «sem_ant_viat_reg_solicitud»
LINE 1: ...viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula=...
^
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:68
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:566)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:525)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:5514)
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[42703]: Undefined column: 7 ERROR: no existe la columna «obs_anula» en la relación «sem_ant_viat_reg_solicitud»
LINE 1: ...viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula=...
^
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:566)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:525)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:5514)
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[42703]: Undefined column: 7 ERROR: no existe la columna «obs_anula» en la relación «sem_ant_viat_reg_solicitud»
LINE 1: ...viat_reg_solicitud SET estado=4, fecha_mod=now(), obs_anula=...
^
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:566)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:525)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:5514)
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)
|
$orden = explode(",", $ccostos_ordenado); $desordenado = explode(", ", $ccostos_desordenado); $desordenado_map = []; foreach ($desordenado as $item) { list($id, $nombre) = explode(" - ", $item); $desordenado_map[$id] = $nombre; } $ccostos_reordenado = []; foreach ($orden as $id) if (isset($desordenado_map[$id])) $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
|
ErrorException
|
|---|
ErrorException:
Warning: Undefined array key 1
at src/Controller/PtatController.php:5478
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)
|