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