// We have to match against the SQLSTATE in the error message in these cases. if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) { return new ConnectionException($exception, $query); } return new DriverException($exception, $query); }} 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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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]
DriverException
|
|---|
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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)
|
// We have to match against the SQLSTATE in the error message in these cases. if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) { return new ConnectionException($exception, $query); } return new DriverException($exception, $query); }} 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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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]
DriverException
|
|---|
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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)
|
// We have to match against the SQLSTATE in the error message in these cases. if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) { return new ConnectionException($exception, $query); } return new DriverException($exception, $query); }} 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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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]
DriverException
|
|---|
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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)
|
// We have to match against the SQLSTATE in the error message in these cases. if ($exception->getCode() === 7 && strpos($exception->getMessage(), 'SQLSTATE[08006]') !== false) { return new ConnectionException($exception, $query); } return new DriverException($exception, $query); }} 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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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)) { $asesora = $arreglo['asesora']; $id = $arreglo['id']; $novedad = $arreglo['novedad']; $sql_upd = "UPDATE horarios_eventos_betplay_asesoras SET estado='1', fecha_mod=now(), usuario_mod='$usuario', novedad='$novedad' WHERE id_evento='$id' and cedula='$asesora' and estado='0' returning id"; $upd = $this->cnn->query('0', $sql_upd); if (count($upd) > 0) { $code = "1"; $mensaje = "Su solicitud fue realizada"; } $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]
DriverException
|
|---|
Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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[22P05]: Untranslatable character: 7 ERROR: character with byte sequence 0xe5 0x8c 0xbe in encoding "UTF8" has no equivalent in encoding "LATIN1"
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:4430)
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)
|