Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 1
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Debug
• Serializer
• Configuration

AddressDeltaController :: index

"App\Controller\AddressDeltaController::index"

"security.firewall.map.context.main"

true

"delta_addresses"

[]

"_security_main"

"a97a72"

"*/*"

"gzip, br, deflate"

"gptbot(at)openai.com"

"209.38.40.80"

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

"146358698"

"1"

"no-cache, private"

"text/html; charset=UTF-8"

"Wed, 29 Oct 2025 02:27:29 GMT"

"Accept"

"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42S22%5D%3A%20Column%20not%20found%3A%201054%20Unknown%20column%20%27presta_address_id%27%20in%20%27field%20list%27"

"%2Fvar%2Fwww%2Fsymfony%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:69"

"944552"

"https://209.38.40.80/_profiler/efa92c"

"efa92c"

"noindex"

"dev"

"56ec9bb975538f89cb23cf802e0ff372"

"postgresql://app:!ChangeMe!@mariadb:5432/app?serverVersion=16&charset=utf8"

"info"

"mysql://root:root@mariadb:3306/magento242?serverVersion=10.11.2-MariaDB"

"1000"

"3600"

"8.2"

"mysql://root:root@mariadb:3306/cerise?serverVersion=10.11.2-MariaDB"

"1"

""

""

"/var/www/symfony/public"

"/index.php"

"RESPONDER"

"CGI/1.1"

"/var/www"

"on"

"*/*"

"gzip, br, deflate"

"gptbot(at)openai.com"

"209.38.40.80"

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

"146358698"

""

"/index.php"

""

"200"

"20.171.207.155"

"56434"

""

"GET"

"https"

1761704849

1761704849.168

"/delta/addresses"

"/var/www/symfony/public/index.php"

"/index.php"

"209.38.40.80"

"p2m.dev"

"443"

"HTTP/1.1"

"nginx/1.24.0"

"APP_ENV,APP_SECRET,PRESTASHOP_DATABASE_URL,MAGENTO_DATABASE_URL,LOG_LEVEL,PHP_VERSION,MIGRATION_BATCH_SIZE,MIGRATION_TIMEOUT,DATABASE_URL"

"www-data"

"error_controller"

"494d49"

Doctrine\DBAL\Exception\InvalidFieldNameException {#485
  #message: "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'presta_address_id' in 'field list'"
  #code: 1054
  #file: "/var/www/symfony/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 69
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#482 …}
  -query: Doctrine\DBAL\Query {#483 …}
  trace: {
    /var/www/symfony/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1611:
      ›     return new InvalidFieldNameException($exception, $query);
      › 
    }
    /var/www/symfony/vendor/doctrine/dbal/src/Connection.php:1976 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /var/www/symfony/vendor/doctrine/dbal/src/Connection.php:1918 {
      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/symfony/vendor/doctrine/dbal/src/Connection.php:1111 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
    }
    /var/www/symfony/src/Controller/AddressDeltaController.php:230 {
      App\Controller\AddressDeltaController->calculateGlobalStats(string $searchQuery): array …
      › // Get all migrated addresses from Magento (those with presta_address_id)
      › $migratedAddressIds = $magentoConnection->executeQuery("
      ›     SELECT DISTINCT presta_address_id 
    }
    /var/www/symfony/src/Controller/AddressDeltaController.php:38 {
      App\Controller\AddressDeltaController->index(Request $request): Response …
      › // Calculate global statistics FIRST
      › $stats = $this->calculateGlobalStats($searchQuery);
      › 
    }
    /var/www/symfony/vendor/symfony/http-kernel/HttpKernel.php:181 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/symfony/vendor/symfony/http-kernel/HttpKernel.php:76 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $response = $this->handleRaw($request, $type);
      › } catch (\Throwable $e) {
    }
    /var/www/symfony/vendor/symfony/http-kernel/Kernel.php:197 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/symfony/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/symfony/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/symfony/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › 
      arguments: {
        "/var/www/symfony/vendor/autoload_runtime.php"
      }
    }
  }
}

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