Symfony Profiler

"error_controller"

"512cd6"

Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException {#3467
  #message: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`Hotnet`.`ovpn_server`, CONSTRAINT `FK_580CBA9AF92F3E70` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`))"
  #code: 1451
  #file: "/var/www/html/app/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 56
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#3463 …}
  -query: Doctrine\DBAL\Query {#3465 …}
  trace: {
    /var/www/html/app/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:56 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1701:
      ›     return new ForeignKeyConstraintViolationException($exception, $query);
      › 
    }
    /var/www/html/app/vendor/doctrine/dbal/src/Connection.php:1938 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /var/www/html/app/vendor/doctrine/dbal/src/Connection.php:1880 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
    }
    /var/www/html/app/vendor/doctrine/dbal/src/Connection.php:1208 {
      Doctrine\DBAL\Connection->executeStatement($sql, array $params = [], array $types = []) …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
    }
    /var/www/html/app/vendor/doctrine/dbal/src/Connection.php:697 {
      Doctrine\DBAL\Connection->delete($table, array $criteria, array $types = []) …
      › 
      › return $this->executeStatement(
      ›     'DELETE FROM ' . $table . ' WHERE ' . implode(' AND ', $conditions),
    }
    /var/www/html/app/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:604 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->delete($entity) …
      › 
      ›     return (bool) $this->conn->delete($tableName, $id, $types);
      › }
    }
    /var/www/html/app/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1299 {
      Doctrine\ORM\UnitOfWork->executeDeletions(): void …
      › 
      › $persister->delete($entity);
      › 
    }
    /var/www/html/app/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:471 {
      Doctrine\ORM\UnitOfWork->commit($entity = null) …
      › if ($this->entityDeletions) {
      ›     $this->executeDeletions();
      › }
    }
    /var/www/html/app/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:403 {
      Doctrine\ORM\EntityManager->flush($entity = null) …
      › 
      ›     $this->unitOfWork->commit($entity);
      › }
    }
    /var/www/html/app/var/cache/dev/ContainerTHGq40j/EntityManager_9a5be93.php:136 {
      ContainerTHGq40j\EntityManager_9a5be93->flush($entity = null) …
      › 
      ›     return $this->valueHolderfe57b->flush($entity);
      › }
    }
    /var/www/html/app/src/Controller/DevController.php:70 {
      App\Controller\DevController->installCountries(CountryRepository $countryRepository) …
      ›     $this->getDoctrine()->getManager()->remove($item);
      ›     $this->getDoctrine()->getManager()->flush();
      › }
    }
    /var/www/html/app/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/html/app/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
    }
    /var/www/html/app/vendor/symfony/http-kernel/Kernel.php:202 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/html/app/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /var/www/html/app/vendor/autoload_runtime.php:35 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/html/app/public/index.php:10 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/var/www/html/app/vendor/autoload_runtime.php"
      }
    }
  }
}

Symfony\Bridge\Monolog\Logger {#381 …9}

"*/*"

"gzip, br"

"cloudflare; loops=1"

"74.7.243.242"

"US"

"9aec3c7b1a0d461b-ATL"

"{"scheme":"https"}"

"Keep-Alive"

""

""

"gptbot(at)openai.com"

"tehranabr.org"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)"

"74.7.243.242"

"https"

"709760757"

"1"

"no-cache, private"

"text/html; charset=UTF-8"

"Tue, 16 Dec 2025 06:48:39 GMT"

"Accept"

"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B23000%5D%3A%20Integrity%20constraint%20violation%3A%201451%20Cannot%20delete%20or%20update%20a%20parent%20row%3A%20a%20foreign%20key%20constraint%20fails%20%28%60Hotnet%60.%60ovpn_server%60%2C%20CONSTRAINT%20%60FK_580CBA9AF92F3E70%60%20FOREIGN%20KEY%20%28%60country_id%60%29%20REFERENCES%20%60country%60%20%28%60id%60%29%29"

"%2Fvar%2Fwww%2Fhtml%2Fapp%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:56"

"85c970"

"msharp.ir"

"dev"

"TehranNetVPN"

"e852e3832856bcc5113b10163e6591df"

"100000,10000000"

"telegramAdPanel"

"mast1391"

"mysql://root:[email protected]:5000/Hotnet"

"root"

""

"null://null"

"37.32.26.113"

"127.0.0.1"

"1"

""

""

"/var/www/html/app/public"

"/index.php"

"RESPONDER"

"CGI/1.1"

"/var/www"

"*/*"

"gzip, br"

"cloudflare; loops=1"

"74.7.243.242"

"US"

"9aec3c7b1a0d461b-ATL"

"{"scheme":"https"}"

"Keep-Alive"

"gptbot(at)openai.com"

"tehranabr.org"

"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)"

"74.7.243.242"

"https"

"709760757"

"/index.php"

""

"200"

"104.22.24.222"

"13727"

""

"GET"

"http"

1765867719

1765867719.0852

"/installCountries"

"/var/www/html/app/public/index.php"

"/index.php"

"91.107.132.238"

"_"

"80"

"HTTP/1.1"

"nginx/1.24.0"

"APP_ENV,APP_SECRET,MAILER_DSN,DATABASE_URL,MAILER_ADDRESS,APP_DOMAIN,SERVER_IP,ZARINPAL,APP_NAME,DATABASE_USERNAME,DATABASE_PASSWORD,DATABASE_NAME,CLIENTIDRANGE"

"www-data"

"App\Controller\DevController::installCountries"

"security.firewall.map.context.shop_owner_firewall"

true

"app_dev_installcountries"

[]

"_security_shop_owner_context"

"0d7528"