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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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: 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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|
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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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. * // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql"); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); $resultSet = $stmt->executeQuery()->fetchAllAssociative();//execute(); // $this->log->logs("respuestaaa ",array($resultSet)); // $this->log->logs("respuestaaa ",array(mb_convert_encoding($resultSet,"UTF-8", "Windows-1252"))); $signup = false; if(is_object($stmt)) { $area_pertenece_jefe = ""; $sql_val_jefe_area = "SELECT aa.id,aa.nombre FROM th_personal_administrativo_asignaciones a, th_personal_administrativo_areas aa WHERE a.id_per_adm_usuario_encargado=(SELECT id FROM th_personal_administrativo WHERE cedula='$usu2' AND estado='0') AND aa.estado='0' AND aa.id=a.id_per_adm_area"; $result_val_jefe_area = $this->cnn->query('0', $sql_val_jefe_area); if ((count($result_val_jefe_area) > 0)) { $filtro = $result_val_jefe_area[0]['id']; $area_pertenece_jefe = $result_val_jefe_area[0]['nombre']; $consultar = 1; "solicitud_anulacion" => $row['solicitud_anulacion'])); } if (!($tipo_usu == "CV")) { $r_validar_jefe_supervisor_th = $this->validar_jefe_supervisor_th($usuario,$usu2); $this->log->logs("r_validar_jefe_supervisor_th: ",array($r_validar_jefe_supervisor_th)); $consultar = $r_validar_jefe_supervisor_th["consultar"]; $area_pertenece_jefe = $r_validar_jefe_supervisor_th["area_pertenece_jefe"]; $filtro = $r_validar_jefe_supervisor_th["filtro"]; $solicitudes = $this->cargar_solicitudes_th($usuario); array_push($datos, array("solicitudes" => $solicitudes, "tipo" => $tipo, "area" => $area)); $this->log->logs("datos: " . $tipo . " | " . $area); $aux_pendientes_th = $this->cargar_pendientes_th($usuario,$usu2,$tipo_usu); $pendientes_th = $aux_pendientes_th[0]; $notificaciones = $aux_pendientes_th[1]; $area_pertenece_jefe = $aux_pendientes_th[2]; $filtro = $aux_pendientes_th[3]; $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: 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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/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:162)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:762)
at App\Controller\PtatController->validar_jefe_supervisor_th()
(src/Controller/PtatController.php:930)
at App\Controller\PtatController->cargar_pendientes_th()
(src/Controller/PtatController.php:4047)
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('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|