http://tehranabr.org/installCountries

Forwarded to
ErrorController (85c970)
Method
GET
HTTP Status
500
IP
104.22.24.222
Profiled on
Token
268ee2

DevController :: installCountries

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"App\Controller\DevController::installCountries"
_firewall_context 
"security.firewall.map.context.shop_owner_firewall"
_remove_csp_headers 
true
_route 
"app_dev_installcountries"
_route_params 
[]
_security_firewall_run 
"_security_shop_owner_context"
_stopwatch_token 
"0d7528"

Request Headers

Header Value
accept 
"*/*"
accept-encoding 
"gzip, br"
cdn-loop 
"cloudflare; loops=1"
cf-connecting-ip 
"74.7.243.242"
cf-ipcountry 
"US"
cf-ray 
"9aec3c7b1a0d461b-ATL"
cf-visitor 
"{"scheme":"https"}"
connection 
"Keep-Alive"
content-length 
""
content-type 
""
from 
"gptbot(at)openai.com"
host 
"tehranabr.org"
user-agent 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)"
x-forwarded-for 
"74.7.243.242"
x-forwarded-proto 
"https"
x-openai-host-hash 
"709760757"
x-php-ob-level 
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Tue, 16 Dec 2025 06:48:39 GMT"
vary 
"Accept"
x-debug-exception 
"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"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fhtml%2Fapp%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:56"
x-debug-token 
"268ee2"
x-debug-token-link 
"http://tehranabr.org/_profiler/85c970"
x-previous-debug-token 
"85c970"
x-robots-tag 
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_DOMAIN 
"msharp.ir"
APP_ENV 
"dev"
APP_NAME 
"TehranNetVPN"
APP_SECRET 
"e852e3832856bcc5113b10163e6591df"
CLIENTIDRANGE 
"100000,10000000"
DATABASE_NAME 
"telegramAdPanel"
DATABASE_PASSWORD 
"mast1391"
DATABASE_URL 
"mysql://root:[email protected]:5000/Hotnet"
DATABASE_USERNAME 
"root"
MAILER_ADDRESS 
""
MAILER_DSN 
"null://null"
SERVER_IP 
"37.32.26.113"
ZARINPAL 
"127.0.0.1"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTENT_LENGTH 
""
CONTENT_TYPE 
""
DOCUMENT_ROOT 
"/var/www/html/app/public"
DOCUMENT_URI 
"/index.php"
FCGI_ROLE 
"RESPONDER"
GATEWAY_INTERFACE 
"CGI/1.1"
HOME 
"/var/www"
HTTP_ACCEPT 
"*/*"
HTTP_ACCEPT_ENCODING 
"gzip, br"
HTTP_CDN_LOOP 
"cloudflare; loops=1"
HTTP_CF_CONNECTING_IP 
"74.7.243.242"
HTTP_CF_IPCOUNTRY 
"US"
HTTP_CF_RAY 
"9aec3c7b1a0d461b-ATL"
HTTP_CF_VISITOR 
"{"scheme":"https"}"
HTTP_CONNECTION 
"Keep-Alive"
HTTP_FROM 
"gptbot(at)openai.com"
HTTP_HOST 
"tehranabr.org"
HTTP_USER_AGENT 
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)"
HTTP_X_FORWARDED_FOR 
"74.7.243.242"
HTTP_X_FORWARDED_PROTO 
"https"
HTTP_X_OPENAI_HOST_HASH 
"709760757"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_STATUS 
"200"
REMOTE_ADDR 
"104.22.24.222"
REMOTE_PORT 
"13727"
REMOTE_USER 
""
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1765867719
REQUEST_TIME_FLOAT 
1765867719.0852
REQUEST_URI 
"/installCountries"
SCRIPT_FILENAME 
"/var/www/html/app/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"91.107.132.238"
SERVER_NAME 
"_"
SERVER_PORT 
"80"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SOFTWARE 
"nginx/1.24.0"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MAILER_DSN,DATABASE_URL,MAILER_ADDRESS,APP_DOMAIN,SERVER_IP,ZARINPAL,APP_NAME,DATABASE_USERNAME,DATABASE_PASSWORD,DATABASE_NAME,CLIENTIDRANGE"
USER 
"www-data"

Sub Requests 1

ErrorController (token = 85c970)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"512cd6"
exception 
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"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#381 …9}