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 syntax error, unexpected variable "$res_vendedor" (500 Internal Server Error)

Symfony Exception

ParseError

HTTP 500 Internal Server Error

syntax error, unexpected variable "$res_vendedor"

Exception

ParseError

  1.     $sqlVen "SELECT ltrim(t.login,'CV') as cedula, (p.nombres || ' ' || p.apellido1) as nombres FROM CONTRATOSVENTA t, personas p,vinculado v,
  2.     (SELECT LOGIN,max(FECHAINICIO) max_fecha FROM CONTRATOSVENTA GROUP BY LOGIN) maximo
  3.     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";
  4.     $this->log->logs("")
  5.     $res_vendedor $this->cnn->query('5'$sqlVen);
  6.     foreach ($res_vendedor as $rowarray_push($vendedor, array("cedula" => $row['CEDULA'], "nombres" => $row['NOMBRES']));
  7.     return $vendedor;
  8.   }
  1.      */
  2.     public function loadClass($class)
  3.     {
  4.         if ($file $this->findFile($class)) {
  5.             $includeFile self::$includeFile;
  6.             $includeFile($file);
  7.             return true;
  8.         }
  9.         return null;
  1.                     return;
  2.                 } elseif (false === include $file) {
  3.                     return;
  4.                 }
  5.             } else {
  6.                 ($this->classLoader)($class);
  7.                 $file '';
  8.             }
  9.         } finally {
  10.             error_reporting($e);
  11.         }
DebugClassLoader->loadClass()
  1.             }
  2.             $autoloadedClass self::$autoloadedClass;
  3.             self::$autoloadedClass ltrim($this->resource'\\');
  4.             try {
  5.                 $exists[0] = class_exists($this->resource) || interface_exists($this->resourcefalse) || trait_exists($this->resourcefalse);
  6.             } catch (\Exception $e) {
  7.                 $exists[1] = $e->getMessage();
  8.                 try {
  9.                     self::throwOnRequiredClass($this->resource$e);
  1.         try {
  2.             if (isset($this->classReflectors[$class])) {
  3.                 $classReflector $this->classReflectors[$class];
  4.             } elseif (class_exists(ClassExistenceResource::class)) {
  5.                 $resource = new ClassExistenceResource($classfalse);
  6.                 $classReflector $resource->isFresh(0) ? false : new \ReflectionClass($class);
  7.             } else {
  8.                 $classReflector class_exists($class) ? new \ReflectionClass($class) : false;
  9.             }
  10.         } catch (\ReflectionException $e) {
  11.             if ($throw) {
  1.             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)) {
  2.                 continue;
  3.             }
  4.             try {
  5.                 $r $this->container->getReflectionClass($class);
  6.             } catch (\ReflectionException $e) {
  7.                 $classes[$class] = $e->getMessage();
  8.                 continue;
  9.             }
  10.             // check to make sure the expected class exists
  1.         }
  2.         $source \func_num_args() > func_get_arg(4) : null;
  3.         $autoconfigureAttributes = new RegisterAutoconfigureAttributesPass();
  4.         $autoconfigureAttributes $autoconfigureAttributes->accept($prototype) ? $autoconfigureAttributes null;
  5.         $classes $this->findClasses($namespace$resource, (array) $exclude$autoconfigureAttributes$source);
  6.         // prepare for deep cloning
  7.         $serializedPrototype serialize($prototype);
  8.         foreach ($classes as $class => $errorMessage) {
  9.             if (null === $errorMessage && $autoconfigureAttributes && $this->env) {
  1.             if (!\is_string($service['resource'])) {
  2.                 throw new InvalidArgumentException(sprintf('A "resource" attribute must be of type string for service "%s" in "%s". Check your YAML syntax.'$id$file));
  3.             }
  4.             $exclude $service['exclude'] ?? null;
  5.             $namespace $service['namespace'] ?? $id;
  6.             $this->registerClasses($definition$namespace$service['resource'], $exclude$file);
  7.         } else {
  8.             $this->setDefinition($id$definition);
  9.         }
  10.     }
  1.         }
  2.         $this->isLoadingInstanceof false;
  3.         $defaults $this->parseDefaults($content$file);
  4.         foreach ($content['services'] as $id => $service) {
  5.             $this->parseDefinition($id$service$file$defaultsfalse$trackBindings);
  6.         }
  7.     }
  8.     /**
  9.      * @throws InvalidArgumentException
  1.         // services
  2.         $this->anonymousServicesCount 0;
  3.         $this->anonymousServicesSuffix '~'.ContainerBuilder::hash($path);
  4.         $this->setCurrentDir(\dirname($path));
  5.         try {
  6.             $this->parseDefinitions($content$path);
  7.         } finally {
  8.             $this->instanceof = [];
  9.             $this->registerAliasesForSinglyImplementedInterfaces();
  10.         }
  11.     }
  1.         // empty file
  2.         if (null === $content) {
  3.             return null;
  4.         }
  5.         $this->loadContent($content$path);
  6.         // per-env configuration
  7.         if ($this->env && isset($content['when@'.$this->env])) {
  8.             if (!\is_array($content['when@'.$this->env])) {
  9.                 throw new InvalidArgumentException(sprintf('The "when@%s" key should contain an array in "%s". Check your YAML syntax.'$this->env$path));
  1.                 }
  2.             }
  3.             self::$loading[$resource] = true;
  4.             try {
  5.                 $ret $loader->load($resource$type);
  6.             } finally {
  7.                 unset(self::$loading[$resource]);
  8.             }
  9.             return $ret;
  1.             if ($isSubpath) {
  2.                 return isset($ret[1]) ? $ret : ($ret[0] ?? null);
  3.             }
  4.         }
  5.         return $this->doImport($resource$type$ignoreErrors$sourceResource);
  6.     }
  7.     /**
  8.      * @internal
  9.      */
  1.         } elseif (!\is_bool($ignoreErrors)) {
  2.             throw new \TypeError(sprintf('Invalid argument $ignoreErrors provided to "%s::import()": boolean or "not_found" expected, "%s" given.', static::class, get_debug_type($ignoreErrors)));
  3.         }
  4.         try {
  5.             return parent::import(...$args);
  6.         } catch (LoaderLoadException $e) {
  7.             if (!$ignoreNotFound || !($prev $e->getPrevious()) instanceof FileLocatorFileNotFoundException) {
  8.                 throw $e;
  9.             }
  1.     }
  2.     final public function import(string $resourcestring $type nullbool|string $ignoreErrors false)
  3.     {
  4.         $this->loader->setCurrentDir(\dirname($this->path));
  5.         $this->loader->import($resource$type$ignoreErrors$this->file);
  6.     }
  7.     final public function parameters(): ParametersConfigurator
  8.     {
  9.         return new ParametersConfigurator($this->container);
  1.         $container->import($configDir.'/{packages}/*.{php,yaml}');
  2.         $container->import($configDir.'/{packages}/'.$this->environment.'/*.{php,yaml}');
  3.         if (is_file($configDir.'/services.yaml')) {
  4.             $container->import($configDir.'/services.yaml');
  5.             $container->import($configDir.'/{services}_'.$this->environment.'.yaml');
  6.         } else {
  7.             $container->import($configDir.'/{services}.php');
  8.         }
  9.     }
  1.             AbstractConfigurator::$valuePreProcessor = function ($value) {
  2.                 return $this === $value ? new Reference('kernel') : $value;
  3.             };
  4.             try {
  5.                 $configureContainer->getClosure($this)(new ContainerConfigurator($container$kernelLoader$instanceof$file$file$this->getEnvironment()), $loader$container);
  6.             } finally {
  7.                 $instanceof = [];
  8.                 $kernelLoader->registerAliasesForSinglyImplementedInterfaces();
  9.                 AbstractConfigurator::$valuePreProcessor $valuePreProcessor;
  10.             }
  1.         parent::__construct($env);
  2.     }
  3.     public function load(mixed $resourcestring $type null): mixed
  4.     {
  5.         return $resource($this->container$this->env);
  6.     }
  7.     public function supports(mixed $resourcestring $type null): bool
  8.     {
  9.         return $resource instanceof \Closure;
  1.     {
  2.         if (false === $loader $this->resolver->resolve($resource$type)) {
  3.             throw new LoaderLoadException($resourcenull0null$type);
  4.         }
  5.         return $loader->load($resource$type);
  6.     }
  7.     public function supports(mixed $resourcestring $type null): bool
  8.     {
  9.         return false !== $this->resolver->resolve($resource$type);
  1.                 $kernelLoader->registerAliasesForSinglyImplementedInterfaces();
  2.                 AbstractConfigurator::$valuePreProcessor $valuePreProcessor;
  3.             }
  4.             $container->setAlias($kernelClass'kernel')->setPublic(true);
  5.         });
  6.     }
  7.     /**
  8.      * @internal
  9.      */
  1.         }
  2.         $container $this->getContainerBuilder();
  3.         $container->addObjectResource($this);
  4.         $this->prepareContainer($container);
  5.         $this->registerContainerConfiguration($this->getContainerLoader($container));
  6.         $container->addCompilerPass(new AddAnnotatedClassesToCachePass($this));
  7.         return $container;
  8.     }
  1.             });
  2.         }
  3.         try {
  4.             $container null;
  5.             $container $this->buildContainer();
  6.             $container->compile();
  7.         } finally {
  8.             if ($collectDeprecations) {
  9.                 restore_error_handler();
  1.             $_ENV['SHELL_VERBOSITY'] = 3;
  2.             $_SERVER['SHELL_VERBOSITY'] = 3;
  3.         }
  4.         $this->initializeBundles();
  5.         $this->initializeContainer();
  6.         $container $this->container;
  7.         if ($container->hasParameter('kernel.trusted_hosts') && $trustedHosts $container->getParameter('kernel.trusted_hosts')) {
  8.             Request::setTrustedHosts($trustedHosts);
  1.     }
  2.     public function handle(Request $requestint $type HttpKernelInterface::MAIN_REQUESTbool $catch true): Response
  3.     {
  4.         if (!$this->booted) {
  5.             $container $this->container ?? $this->preBoot();
  6.             if ($container->has('http_cache')) {
  7.                 return $container->get('http_cache')->handle($request$type$catch);
  8.             }
  9.         }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/www/php81/serversoap/recaudos/vendor/autoload_runtime.php') in /var/www/php81/serversoap/recaudos/public/index.php (line 16)
  1. $method $_SERVER['REQUEST_METHOD'];
  2. if($method == "OPTIONS") {
  3.     die();
  4. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Stack Trace

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)                
06 02 2025 10:50:55 ************************************************************CP1006820220 -- eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJ1c3VhcmlvIjoiQ1AxMDA2ODIwMjIwIiwiaWF0IjoxNzM4ODU3MDQ5LCJleHAiOjE3Mzg4NjYwNDl9.tUIFhmNVcTkiM6k3rBr7f30WG7vP_9x9_NOddgO1_rM -- MM-ERROR: HTTP/1.1 500 Internal Server Error Date: Thu, 06 Feb 2025 15:50:54 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42P01%5D%3A%20Undefined%20table%3A%207%20ERROR%3A%20%20falta%20una%20entrada%20para%20la%20tabla%20%C3%82%C2%ABp2%C3%82%C2%BB%20en%20la%20cl%C3%83%C2%A1usula%20FROM%0ALINE%204%3A%20...DD%20HH%3AII%3ASS%27%29%20AS%20fecha%2C%20comentario_cambio%2C%20concat%28p2.documen...%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5E X-Debug-Exception-File: %2Fvar%2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:71 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: 276514 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... ^ (500 Internal Server Error)

Symfony Exception

PDOException Exception TableNotFoundException

HTTP 500 Internal Server Error

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...
^

Exceptions 3

Doctrine\DBAL\Exception\ TableNotFoundException

  1.             case '42703':
  2.                 return new InvalidFieldNameException($exception$query);
  3.             case '42P01':
  4.                 return new TableNotFoundException($exception$query);
  5.             case '42P07':
  6.                 return new TableExistsException($exception$query);
  7.             case '08006':
  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);
  7.         if ($exception instanceof ConnectionLost) {
  8.             $this->close();
  9.         }
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.     }
  8.     /** @internal */
  9.     final public function convertException(Driver\Exception $e): DriverException
  10.     {
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.         }
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 566)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 525)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }  
  9.       }
  10.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 5502)
  1.       CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
  2.       (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,
  3.       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
  4.       JOIN personas p ON p.documento::text = savrs.usuario_respuesta
  5.       WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
  6.       $res_solicitudes $this->cnn->query('0'$sql_solicitudes);
  7.       foreach ($res_solicitudes as $res)
  8.       {
  9.         $ccostos_ordenado $res['ccostos'];
  10.         $ccostos_desordenado $res['ccostos_nombres'];
  11.         $ccostos_reordenado_str null;
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/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. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

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... ^

  1.         } else {
  2.             $code     $exception->getCode();
  3.             $sqlState null;
  4.         }
  5.         return new self($exception->getMessage(), $sqlState$code$exception);
  6.     }
  7. }
  1.         }
  2.         try {
  3.             $this->stmt->execute($params);
  4.         } catch (PDOException $exception) {
  5.             throw Exception::new($exception);
  6.         }
  7.         return new Result($this->stmt);
  8.     }
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 566)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 525)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }  
  9.       }
  10.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 5502)
  1.       CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
  2.       (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,
  3.       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
  4.       JOIN personas p ON p.documento::text = savrs.usuario_respuesta
  5.       WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
  6.       $res_solicitudes $this->cnn->query('0'$sql_solicitudes);
  7.       foreach ($res_solicitudes as $res)
  8.       {
  9.         $ccostos_ordenado $res['ccostos'];
  10.         $ccostos_desordenado $res['ccostos_nombres'];
  11.         $ccostos_reordenado_str null;
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/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. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

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... ^

  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.                     ' Statement::bindParam() or Statement::bindValue() instead.',
  2.             );
  3.         }
  4.         try {
  5.             $this->stmt->execute($params);
  6.         } catch (PDOException $exception) {
  7.             throw Exception::new($exception);
  8.         }
  9.         return new Result($this->stmt);
  1.             $logger->startQuery($this->sql$this->params$this->types);
  2.         }
  3.         try {
  4.             return new Result(
  5.                 $this->stmt->execute($params),
  6.                 $this->conn,
  7.             );
  8.         } catch (Driver\Exception $ex) {
  9.             throw $this->conn->convertExceptionDuringQuery($ex$this->sql$this->params$this->types);
  10.         } finally {
  1.         if ($params === []) {
  2.             $params null// Workaround as long execute() exists and used internally.
  3.         }
  4.         return $this->execute($params);
  5.     }
  6.     /**
  7.      * Executes the statement with the currently bound parameters and return affected rows.
  8.      *
Statement->executeQuery() in src/Services/Conexion.php (line 566)
  1.       } */
  2.       // $resultSet = $stmt->executeQuery();//execute();
  3.       /* try { */
  4.         // $resultSet_aux = $stmt->executeQuery();//execute();
  5.         // $resultSet = $resultSet_aux->fetchAllAssociative();//execute();
  6.         $resultSet $stmt->executeQuery()->fetchAllAssociative();
  7.         $this->cnn->close();
  8.       /* } catch (\Throwable $th)
  9.       {
  10.       } */
  11.       // $this->log->logs("respuestaaa ",array($resultSet));
Conexion->query_normal() in src/Services/Conexion.php (line 525)
  1.           case 24:
  2.           case 25:
  3.             return $this->consulta_socket($con,$sql);
  4.             break;
  5.           default:
  6.             return $this->query_normal($con,$sql);
  7.             break;
  8.         }  
  9.       }
  10.     }  
  11.         
Conexion->query() in src/Controller/PtatController.php (line 5502)
  1.       CASE savrs.tipo_solicitud WHEN 1 THEN 'VIATICOS' ELSE 'COMPRAS' END AS tipo_solicitud, savrs.valor, savrs.ticket,
  2.       (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,
  3.       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
  4.       JOIN personas p ON p.documento::text = savrs.usuario_respuesta
  5.       WHERE savrs.usuario = '$usu2' OR savrs.usuario_respuesta = '$usu2' ORDER BY savrs.estado, savrs.id DESC";
  6.       $res_solicitudes $this->cnn->query('0'$sql_solicitudes);
  7.       foreach ($res_solicitudes as $res)
  8.       {
  9.         $ccostos_ordenado $res['ccostos'];
  10.         $ccostos_desordenado $res['ccostos_nombres'];
  11.         $ccostos_reordenado_str null;
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response$event);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Throwable $e) {
  7.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  8.                 throw $e;
  9.             }
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
  1.         $this->request $request;
  2.     }
  3.     public function run(): int
  4.     {
  5.         $response $this->kernel->handle($this->request);
  6.         $response->send();
  7.         if ($this->kernel instanceof TerminableInterface) {
  8.             $this->kernel->terminate($this->request$response);
  9.         }
in vendor/autoload_runtime.php -> run (line 29)
  1. $app $app(...$args);
  2. exit(
  3.     $runtime
  4.         ->getRunner($app)
  5.         ->run()
  6. );
require_once('/var/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. }
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  6. return function (array $context) {
  7.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  8. };

Logs

No log messages

Stack Traces 3

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