05 05 2023 10:18:43 El Archivo 2023-05-05 - log.txt se ha creado 05 05 2023 10:18:43 ###############Datos recibidos -- 05 05 2023 10:18:43 Envio Login Movil: 05 05 2023 10:18:43 Url=http://10.1.1.11:8094/ptat/login/login_movil 05 05 2023 10:18:43 Contenido:POST http://10.1.1.11:8094/ptat/login/login_movil HTTP/1.1 AUTHENTICATION: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiY2xhdmUiOiJpdVNoZDFFK1Q3alIrVHlTOWh4TzRnPT1cbiIsImV4cCI6MTY4MzI5OTk0MCwiaWF0IjoxNjgzMjk5OTEwfQ.9BQbQ5mMSr6s5_Zxv2u3lwYc0f_HhkYNsDHydqFQm_Q Content-Length: 272 Content-Type: multipart/form-data; boundary="e2e050a0.3fd6b0db" --e2e050a0.3fd6b0db Content-Disposition: form-data; name="json" [{"imeis":"emBk5x0OtuE,ffffffff-b4a3-188c-0000-0000714a4f37,325b515bd0a8284e","ip":"10.0.2.15","name_device":"Google sdk_gphone_x86_64","operador":"T-Mobile","version_app":"8.2"}] --e2e050a0.3fd6b0db-- 05 05 2023 10:18:47 HTTP/1.1 500 Internal Server Error Date: Fri, 05 May 2023 15:18:47 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 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%20column%20a.id_per_adm_area%20does%20not%20exist%0ALINE%203%3A%20%20%20%20%20AND%20aa.estado%3D%270%27%20AND%20aa.id%3Da.id_per_adm_area%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%5E%0AHINT%3A%20%20Perhaps%20you%20meant%20to%20reference%20the%20column%20%22a.id_per_adm_cargo%22. X-Debug-Exception-File: %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: 304226 An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo". (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist
LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area
^
HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 68)
  2.             case '42702':
  3.                 return new NonUniqueFieldNameException($exception, $query);
  5.             case '42703':
  6.                 return new InvalidFieldNameException($exception, $query);
  8.             case '42P01':
  9.                 return new TableNotFoundException($exception, $query);
  11.             case '42P07':
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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/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:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[1/3] PDOException 
PDOException:
SQLSTATE[42703]: Undefined column: 7 ERROR:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
05 05 2023 10:18:47 Respuesta de conexion:HTTP/1.1 500 Internal Server Error Date: Fri, 05 May 2023 15:18:47 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.18 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%20column%20a.id_per_adm_area%20does%20not%20exist%0ALINE%203%3A%20%20%20%20%20AND%20aa.estado%3D%270%27%20AND%20aa.id%3Da.id_per_adm_area%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%5E%0AHINT%3A%20%20Perhaps%20you%20meant%20to%20reference%20the%20column%20%22a.id_per_adm_cargo%22. X-Debug-Exception-File: %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: 304226 An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo". (500 Internal Server Error)

Symfony Exception

Symfony Docs

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist
LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area
^
HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

in vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php (line 68)
  2.             case '42702':
  3.                 return new NonUniqueFieldNameException($exception, $query);
  5.             case '42703':
  6.                 return new InvalidFieldNameException($exception, $query);
  8.             case '42P01':
  9.                 return new TableNotFoundException($exception, $query);
  11.             case '42P07':
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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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[42703]: Undefined column: 7 ERROR: column a.id_per_adm_area does not exist LINE 3: AND aa.estado='0' AND aa.id=a.id_per_adm_area ^ HINT: Perhaps you meant to reference the column "a.id_per_adm_cargo".

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 154)
  1.       //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  2.       $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config);
  4.       //$sql = "SELECT * FROM articles";
  5.       $stmt = $this->cnn->prepare($sql);
  6.       $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute();
  8.       /* var_dump($resultSet);
  9.       die(); */
  10.       
  11.       /* $resultSet->toArray();
Conexion->query() in src/Controller/PtatController.php (line 762)
  1.     $area_pertenece_jefe = "";
  2.     $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa
  3.     WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0')
  4.     AND aa.estado='0' AND aa.id=a.id_per_adm_area";
  5.     
  6.     $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area);
  7.     if ((count($result_val_jefe_area) > 0)) 
  8.     {
  9.       $filtro = $result_val_jefe_area[0]['id'];
  10.       $area_pertenece_jefe = $result_val_jefe_area[0]['nombre'];
  11.       $consultar = 1;
PtatController->validar_jefe_supervisor_th() in src/Controller/PtatController.php (line 798)
  1.     $año = date("Y");
  2.     $fechai="01-01-".$año;
  3.     $fechaf="31-12-".$año;
  4.     $cant_1 = 0;
  5.     $cant_2 = 0;
  6.     $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2);
  7.     $consultar = $r_validar_jefe_supervisor_th["consultar"];
  8.     $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"];
  9.     $filtro = $r_validar_jefe_supervisor_th["filtro"];
  11.     if($consultar > 0)
PtatController->validar_notificaciones() in src/Controller/PtatController.php (line 1359)
  1.     }
  2.     $time_expire = $result_time_expire[0]['tiempo_sesion']/1000;
  4.     $notificaciones = "0";
  5.     if($tipo_usu == "CP")
  6.       $notificaciones = $this->validar_notificaciones($usuario,$usu2,$result[0]['nombre'],$correo,$this->email);
  8.     foreach ($result as $row) 
  9.     {
  10.       $nivel = $row['nivel'];
  11.       // array_push($datos, array("loginusr" => $row['loginusr'], "password" => $row['password'], "nivel" => $row['nivel'], "nombre" => $row['nombre'], "zona" => $zona));
in vendor/symfony/http-kernel/HttpKernel.php -> login_movil (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('/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] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/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:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)
[1/3] PDOException 
PDOException:
SQLSTATE[42703]: Undefined column: 7 ERROR:  column a.id_per_adm_area does not exist
LINE 3:     AND aa.estado='0' AND aa.id=a.id_per_adm_area
                                        ^
HINT:  Perhaps you meant to reference the column "a.id_per_adm_cargo".

  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:154)
  at App\Services\Conexion->query()
     (src/Controller/PtatController.php:762)
  at App\Controller\PtatController->validar_jefe_supervisor_th()
     (src/Controller/PtatController.php:798)
  at App\Controller\PtatController->validar_notificaciones()
     (src/Controller/PtatController.php:1359)
  at App\Controller\PtatController->login_movil()
     (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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
     (public/index.php:16)