https://msprapijwt.dev-altman.fr/data-orders

ErrorController

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller
"error_controller"
_links
Symfony\Component\WebLink\GenericLinkProvider {#1098
  -links: [
    1097 => Symfony\Component\WebLink\Link {#1097
      -href: "https://msprapijwt.dev-altman.fr/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_stopwatch_token
"fa009d"
exception
Doctrine\DBAL\Exception\SyntaxErrorException {#927
  #message: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order t0' at line 1"
  #code: 1064
  #file: "/var/www/msprapijwt/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 86
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#903 …}
  -query: Doctrine\DBAL\Query {#922 …}
  trace: {
    /var/www/msprapijwt/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:86 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1626:    return new SyntaxErrorException($exception, $query);}
    /var/www/msprapijwt/vendor/doctrine/dbal/src/Connection.php:1935 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();$exception                  = $this->exceptionConverter->convert($driverException, $query);}
    /var/www/msprapijwt/vendor/doctrine/dbal/src/Connection.php:1878 {
      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/msprapijwt/vendor/doctrine/dbal/src/Connection.php:1103 {
      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/msprapijwt/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:920 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(array $criteria = [], array $orderBy = null, $limit = null, $offset = null) …
      › [$params, $types] = $this->expandParameters($criteria);$stmt             = $this->conn->executeQuery($sql, $params, $types);}
    /var/www/msprapijwt/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:225 {
      Doctrine\ORM\EntityRepository->findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null) …
      › 
      ›     return $persister->loadAll($criteria, $orderBy, $limit, $offset);}
    }
    /var/www/msprapijwt/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php:207 {
      Doctrine\ORM\EntityRepository->findAll() …
      › {    return $this->findBy([]);}
    }
    /var/www/msprapijwt/src/Controller/DataController.php:181 {
      App\Controller\DataController->dataOrders(OrderRepository $repoO): Response …
      › {    $orders = $repoO->findAll();}
    /var/www/msprapijwt/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/msprapijwt/vendor/symfony/http-kernel/HttpKernel.php:75 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {    return $this->handleRaw($request, $type);} catch (\Exception $e) {
    }
    /var/www/msprapijwt/vendor/symfony/http-kernel/Kernel.php:202 {
      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/msprapijwt/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/msprapijwt/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)        ->run());
    }
    /var/www/msprapijwt/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';arguments: {
        "/var/www/msprapijwt/vendor/autoload_runtime.php"
      }
    }
  }
}
logger
Symfony\Bridge\Monolog\Logger {#145 …9}

Request Headers

Header Value
accept
"*/*"
accept-encoding
"gzip, br, zstd, deflate"
content-length
""
content-type
""
host
"msprapijwt.dev-altman.fr"
user-agent
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
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
"Thu, 22 Jan 2026 09:56:08 GMT"
x-debug-exception
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B42000%5D%3A%20Syntax%20error%20or%20access%20violation%3A%201064%20You%20have%20an%20error%20in%20your%20SQL%20syntax%3B%20check%20the%20manual%20that%20corresponds%20to%20your%20MySQL%20server%20version%20for%20the%20right%20syntax%20to%20use%20near%20%27order%20t0%27%20at%20line%201"
x-debug-exception-file
"%2Fvar%2Fwww%2Fmsprapijwt%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:86"
x-debug-token
"adf3c9"

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_ENV
"dev"
APP_SECRET
"e914363ec13cd91ea284e78cac3851d5"
CORS_ALLOW_ORIGIN
"^https?://(localhost|127\.0\.0\.1)(:[0-9]+)?$"
DATABASE_URL
"mysql://app_user:saXe34-g4569003@localhost/msprapijwt?serverVersion=10.6.17-MariaDB-cll-lve - MariaDB Server&charset=utf8mb4"
DB_HOST
"localhost"
DB_NAME
"msprapijwt"
DB_PASS
"saXe34-g4569003"
DB_USER
"app_user"
JWT_PASSPHRASE
"42b2aace389e5ce7a69022678492874ee639162b618a5991bfc394d9acdccc6a"
JWT_PUBLIC_KEY
"%kernel.project_dir%/config/jwt/public.pem"
JWT_SECRET_KEY
"%kernel.project_dir%/config/jwt/private.pem"
MAILER_DSN
"gmail+smtp://noreply.payetonkawa69:euwmoeexxhypfqto@default"
MESSENGER_TRANSPORT_DSN
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CONTENT_LENGTH
""
CONTENT_TYPE
""
DOCUMENT_ROOT
"/var/www/msprapijwt/public"
DOCUMENT_URI
"/index.php"
FCGI_ROLE
"RESPONDER"
GATEWAY_INTERFACE
"CGI/1.1"
HOME
"/var/www"
HTTPS
"on"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"gzip, br, zstd, deflate"
HTTP_HOST
"msprapijwt.dev-altman.fr"
HTTP_USER_AGENT
"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_STATUS
"200"
REMOTE_ADDR
"216.73.216.131"
REMOTE_PORT
"12100"
REMOTE_USER
""
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"https"
REQUEST_TIME
1769075768
REQUEST_TIME_FLOAT
1769075768.8024
REQUEST_URI
"/data-orders"
SCRIPT_FILENAME
"/var/www/msprapijwt/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"72.61.104.152"
SERVER_NAME
"msprapijwt.dev-altman.fr"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/1.1"
SERVER_SOFTWARE
"nginx/1.24.0"
SYMFONY_DOTENV_VARS
"APP_ENV,APP_SECRET,DATABASE_URL,DB_HOST,DB_NAME,DB_USER,DB_PASS,MESSENGER_TRANSPORT_DSN,MAILER_DSN,JWT_SECRET_KEY,JWT_PUBLIC_KEY,JWT_PASSPHRASE,CORS_ALLOW_ORIGIN"
USER
"www-data"

Parent Request

Return to parent request (token = 6eabdd)

Key Value
_controller
"App\Controller\DataController::dataOrders"
_firewall_context
"security.firewall.map.context.main"
_links
Symfony\Component\WebLink\GenericLinkProvider {#1229
  -links: [
    1228 => Symfony\Component\WebLink\Link {#1228
      -href: "https://msprapijwt.dev-altman.fr/api/docs.jsonld"
      -rel: [
        "http://www.w3.org/ns/hydra/core#apiDocumentation" => "http://www.w3.org/ns/hydra/core#apiDocumentation"
      ]
      -attributes: []
    }
  ]
}
_remove_csp_headers
true
_route
"app_dataOrders"
_route_params
[]
_security_firewall_run
"_security_main"
_stopwatch_token
"ccf431"