06 02 2025 10:07:27 El Archivo 2025-02-06 - log_error.txt se ha creado ************************************************************eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1A0MDM5NDk1NSIsImNsYXZlIjoiOThRQmRCaUJQSGEybzdrY3FURHJOUT09XG4iLCJleHAiOjE3Mzg4NTQ0NzMsImlhdCI6MTczODg1NDQyM30.0I-oLQsiNIFSe0Kl96sm4BFMpFf0gbAhhZVmLS26tMs -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 06 Feb 2025 15:07:22 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: syntax%20error%2C%20unexpected%20variable%20%22%24res_vendedor%22 X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fsrc%2FController%2FPtatController.php:391 Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 216958
$sqlVen = "SELECT ltrim(t.login,'CV') as cedula, (p.nombres || ' ' || p.apellido1) as nombres FROM CONTRATOSVENTA t, personas p,vinculado v, (SELECT LOGIN,max(FECHAINICIO) max_fecha FROM CONTRATOSVENTA GROUP BY LOGIN) maximo where maximo.LOGIN=t.LOGIN and maximo.max_fecha=t.FECHAINICIO and FECHAFINAL is null and p.DOCUMENTO = ltrim(t.login,'CV') and TRIM(v.VINCEDULA) = ltrim(t.login,'CV') and v.VINACTIVO ='1' $filtro"; $this->log->logs("") $res_vendedor = $this->cnn->query('5', $sqlVen); foreach ($res_vendedor as $row) array_push($vendedor, array("cedula" => $row['CEDULA'], "nombres" => $row['NOMBRES'])); return $vendedor; } */ public function loadClass($class) { if ($file = $this->findFile($class)) { $includeFile = self::$includeFile; $includeFile($file); return true; } return null; return; } elseif (false === include $file) { return; } } else { ($this->classLoader)($class); $file = ''; } } finally { error_reporting($e); } } $autoloadedClass = self::$autoloadedClass; self::$autoloadedClass = ltrim($this->resource, '\\'); try { $exists[0] = class_exists($this->resource) || interface_exists($this->resource, false) || trait_exists($this->resource, false); } catch (\Exception $e) { $exists[1] = $e->getMessage(); try { self::throwOnRequiredClass($this->resource, $e); try { if (isset($this->classReflectors[$class])) { $classReflector = $this->classReflectors[$class]; } elseif (class_exists(ClassExistenceResource::class)) { $resource = new ClassExistenceResource($class, false); $classReflector = $resource->isFresh(0) ? false : new \ReflectionClass($class); } else { $classReflector = class_exists($class) ? new \ReflectionClass($class) : false; } } catch (\ReflectionException $e) { if ($throw) { if (!preg_match('/^[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*+(?:\\\\[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*+)*+$/', $class)) { continue; } try { $r = $this->container->getReflectionClass($class); } catch (\ReflectionException $e) { $classes[$class] = $e->getMessage(); continue; } // check to make sure the expected class exists } $source = \func_num_args() > 4 ? func_get_arg(4) : null; $autoconfigureAttributes = new RegisterAutoconfigureAttributesPass(); $autoconfigureAttributes = $autoconfigureAttributes->accept($prototype) ? $autoconfigureAttributes : null; $classes = $this->findClasses($namespace, $resource, (array) $exclude, $autoconfigureAttributes, $source); // prepare for deep cloning $serializedPrototype = serialize($prototype); foreach ($classes as $class => $errorMessage) { if (null === $errorMessage && $autoconfigureAttributes && $this->env) { if (!\is_string($service['resource'])) { throw new InvalidArgumentException(sprintf('A "resource" attribute must be of type string for service "%s" in "%s". Check your YAML syntax.', $id, $file)); } $exclude = $service['exclude'] ?? null; $namespace = $service['namespace'] ?? $id; $this->registerClasses($definition, $namespace, $service['resource'], $exclude, $file); } else { $this->setDefinition($id, $definition); } } } $this->isLoadingInstanceof = false; $defaults = $this->parseDefaults($content, $file); foreach ($content['services'] as $id => $service) { $this->parseDefinition($id, $service, $file, $defaults, false, $trackBindings); } } /** * @throws InvalidArgumentException // services $this->anonymousServicesCount = 0; $this->anonymousServicesSuffix = '~'.ContainerBuilder::hash($path); $this->setCurrentDir(\dirname($path)); try { $this->parseDefinitions($content, $path); } finally { $this->instanceof = []; $this->registerAliasesForSinglyImplementedInterfaces(); } } // empty file if (null === $content) { return null; } $this->loadContent($content, $path); // per-env configuration if ($this->env && isset($content['when@'.$this->env])) { if (!\is_array($content['when@'.$this->env])) { throw new InvalidArgumentException(sprintf('The "when@%s" key should contain an array in "%s". Check your YAML syntax.', $this->env, $path)); } } self::$loading[$resource] = true; try { $ret = $loader->load($resource, $type); } finally { unset(self::$loading[$resource]); } return $ret; if ($isSubpath) { return isset($ret[1]) ? $ret : ($ret[0] ?? null); } } return $this->doImport($resource, $type, $ignoreErrors, $sourceResource); } /** * @internal */ } elseif (!\is_bool($ignoreErrors)) { throw new \TypeError(sprintf('Invalid argument $ignoreErrors provided to "%s::import()": boolean or "not_found" expected, "%s" given.', static::class, get_debug_type($ignoreErrors))); } try { return parent::import(...$args); } catch (LoaderLoadException $e) { if (!$ignoreNotFound || !($prev = $e->getPrevious()) instanceof FileLocatorFileNotFoundException) { throw $e; } } final public function import(string $resource, string $type = null, bool|string $ignoreErrors = false) { $this->loader->setCurrentDir(\dirname($this->path)); $this->loader->import($resource, $type, $ignoreErrors, $this->file); } final public function parameters(): ParametersConfigurator { return new ParametersConfigurator($this->container); $container->import($configDir.'/{packages}/*.{php,yaml}'); $container->import($configDir.'/{packages}/'.$this->environment.'/*.{php,yaml}'); if (is_file($configDir.'/services.yaml')) { $container->import($configDir.'/services.yaml'); $container->import($configDir.'/{services}_'.$this->environment.'.yaml'); } else { $container->import($configDir.'/{services}.php'); } } AbstractConfigurator::$valuePreProcessor = function ($value) { return $this === $value ? new Reference('kernel') : $value; }; try { $configureContainer->getClosure($this)(new ContainerConfigurator($container, $kernelLoader, $instanceof, $file, $file, $this->getEnvironment()), $loader, $container); } finally { $instanceof = []; $kernelLoader->registerAliasesForSinglyImplementedInterfaces(); AbstractConfigurator::$valuePreProcessor = $valuePreProcessor; } parent::__construct($env); } public function load(mixed $resource, string $type = null): mixed { return $resource($this->container, $this->env); } public function supports(mixed $resource, string $type = null): bool { return $resource instanceof \Closure; { if (false === $loader = $this->resolver->resolve($resource, $type)) { throw new LoaderLoadException($resource, null, 0, null, $type); } return $loader->load($resource, $type); } public function supports(mixed $resource, string $type = null): bool { return false !== $this->resolver->resolve($resource, $type); $kernelLoader->registerAliasesForSinglyImplementedInterfaces(); AbstractConfigurator::$valuePreProcessor = $valuePreProcessor; } $container->setAlias($kernelClass, 'kernel')->setPublic(true); }); } /** * @internal */ } $container = $this->getContainerBuilder(); $container->addObjectResource($this); $this->prepareContainer($container); $this->registerContainerConfiguration($this->getContainerLoader($container)); $container->addCompilerPass(new AddAnnotatedClassesToCachePass($this)); return $container; } }); } try { $container = null; $container = $this->buildContainer(); $container->compile(); } finally { if ($collectDeprecations) { restore_error_handler(); $_ENV['SHELL_VERBOSITY'] = 3; $_SERVER['SHELL_VERBOSITY'] = 3; } $this->initializeBundles(); $this->initializeContainer(); $container = $this->container; if ($container->hasParameter('kernel.trusted_hosts') && $trustedHosts = $container->getParameter('kernel.trusted_hosts')) { Request::setTrustedHosts($trustedHosts); } public function handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response { if (!$this->booted) { $container = $this->container ?? $this->preBoot(); if ($container->has('http_cache')) { return $container->get('http_cache')->handle($request, $type, $catch); } } $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']);};|
ParseError
|
|---|
ParseError:
syntax error, unexpected variable "$res_vendedor"
at /var/www/php81/serversoap/recaudos/src/Controller/PtatController.php:391
at Composer\Autoload\{closure}()
(/var/www/php81/serversoap/recaudos/vendor/composer/ClassLoader.php:427)
at Composer\Autoload\ClassLoader->loadClass()
(/var/www/php81/serversoap/recaudos/vendor/symfony/error-handler/DebugClassLoader.php:300)
at Symfony\Component\ErrorHandler\DebugClassLoader->loadClass()
at class_exists()
(/var/www/php81/serversoap/recaudos/vendor/symfony/config/Resource/ClassExistenceResource.php:76)
at Symfony\Component\Config\Resource\ClassExistenceResource->isFresh()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/ContainerBuilder.php:347)
at Symfony\Component\DependencyInjection\ContainerBuilder->getReflectionClass()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:222)
at Symfony\Component\DependencyInjection\Loader\FileLoader->findClasses()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:113)
at Symfony\Component\DependencyInjection\Loader\FileLoader->registerClasses()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:677)
at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->parseDefinition()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:250)
at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->parseDefinitions()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:173)
at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->loadContent()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/YamlFileLoader.php:129)
at Symfony\Component\DependencyInjection\Loader\YamlFileLoader->load()
(/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/FileLoader.php:163)
at Symfony\Component\Config\Loader\FileLoader->doImport()
(/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/FileLoader.php:94)
at Symfony\Component\Config\Loader\FileLoader->import()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/FileLoader.php:64)
at Symfony\Component\DependencyInjection\Loader\FileLoader->import()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/Configurator/ContainerConfigurator.php:64)
at Symfony\Component\DependencyInjection\Loader\Configurator\ContainerConfigurator->import()
(/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:57)
at App\Kernel->configureContainer()
(/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:179)
at App\Kernel->Symfony\Bundle\FrameworkBundle\Kernel\{closure}()
(/var/www/php81/serversoap/recaudos/vendor/symfony/dependency-injection/Loader/ClosureLoader.php:36)
at Symfony\Component\DependencyInjection\Loader\ClosureLoader->load()
(/var/www/php81/serversoap/recaudos/vendor/symfony/config/Loader/DelegatingLoader.php:37)
at Symfony\Component\Config\Loader\DelegatingLoader->load()
(/var/www/php81/serversoap/recaudos/vendor/symfony/framework-bundle/Kernel/MicroKernelTrait.php:187)
at App\Kernel->registerContainerConfiguration()
(/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:585)
at Symfony\Component\HttpKernel\Kernel->buildContainer()
(/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:486)
at Symfony\Component\HttpKernel\Kernel->initializeContainer()
(/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:709)
at Symfony\Component\HttpKernel\Kernel->preBoot()
(/var/www/php81/serversoap/recaudos/vendor/symfony/http-kernel/Kernel.php:172)
at Symfony\Component\HttpKernel\Kernel->handle()
(/var/www/php81/serversoap/recaudos/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php:29)
at require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(/var/www/php81/serversoap/recaudos/public/index.php:16)
|
case '42703': return new InvalidFieldNameException($exception, $query); case '42P01': return new TableNotFoundException($exception, $query); case '42P07': return new TableExistsException($exception, $query); case '08006': 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; } } } CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket, (SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres, savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs JOIN personas p ON p.documento::text = savrs.usuario_respuesta WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC"; $res_solicitudes = $this->cnn->query('0', $sql_solicitudes); foreach ($res_solicitudes as $res) { $ccostos_ordenado = $res['ccostos']; $ccostos_desordenado = $res['ccostos_nombres']; $ccostos_reordenado_str = null; $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; } } } CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket, (SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres, savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs JOIN personas p ON p.documento::text = savrs.usuario_respuesta WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC"; $res_solicitudes = $this->cnn->query('0', $sql_solicitudes); foreach ($res_solicitudes as $res) { $ccostos_ordenado = $res['ccostos']; $ccostos_desordenado = $res['ccostos_nombres']; $ccostos_reordenado_str = null; $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; } } } CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket, (SELECT string_agg(tn.codigo || ' - ' || tn.nombre, ', ') AS resultado FROM sem_ant_viat_reg_solicitud mt JOIN territorios tn ON tn.codigo = ANY(string_to_array(mt.ccostos , ',')::int[]) WHERE mt.id = savrs.id) AS ccostos_nombres, savrs.ccostos, savrs.estado, savrs.respuesta, to_char(savrs.fecha_sys, 'YYYY-MM-DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documento,' - ',p2.nombres,' ',p2.apellido1) AS usuario FROM sem_ant_viat_reg_solicitud savrs JOIN personas p ON p.documento::text = savrs.usuario_respuesta WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC"; $res_solicitudes = $this->cnn->query('0', $sql_solicitudes); foreach ($res_solicitudes as $res) { $ccostos_ordenado = $res['ccostos']; $ccostos_desordenado = $res['ccostos_nombres']; $ccostos_reordenado_str = null; $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]
TableNotFoundException
|
|---|
Doctrine\DBAL\Exception\TableNotFoundException:
An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM
LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen...
^
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:71
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:5502)
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[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM
LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen...
^
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:5502)
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[42P01]: Undefined table: 7 ERROR: falta una entrada para la tabla «p2» en la cláusula FROM
LINE 4: ...DD HH:II:SS') AS fecha, comentario_cambio, concat(p2.documen...
^
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:5502)
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)
|