https://catainsales2.ht2.ipol.tech/app/order/widget/1183092/3908f84898504c72a91393dbd5dbbd54/94787220/refresh

Forwarded to
ErrorController (fa5d5d)
Method
GET
HTTP Status
500
IP
47.128.45.76
Profiled on
Token
0efad3

ApplicationController :: orderWidgetRefresh

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_controller 
"App\Controller\ApplicationController::orderWidgetRefresh"
_converters 
[
  Sensio\Bundle\FrameworkExtraBundle\Configuration\ParamConverter {#299
    -name: "shop"
    -class: "App\Entity\Shop"
    -options: [
      "mapping" => [
        "insalesId" => "insalesId"
      ]
      "repository_method" => "getByInsalesIdEx"
    ]
    -isOptional: false
    -converter: null
  }
]
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"app.order.widget.refresh"
_route_params 
[
  "orderId" => "94787220"
  "insalesId" => "1183092"
  "widgetPassword" => "3908f84898504c72a91393dbd5dbbd54"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"60f977"
insalesId 
"1183092"
orderId 
"94787220"
shop 
App\Entity\Shop {#771
  #insalesId: 1183092
  #shop: "myshop-btw489.myinsales.ru"
  #password: "80b053fedbaf9c46db385f3f8299247d"
  #passwordToken: "ce9a7872da1361c50db3a966e638a14e"
  #widgetPassword: "578753cf06aa9e4913fd9e9f2c471472"
  #deliveryId: 8116774
  #rateResultPropertyId: 20362968
  #updateStatuses: false
  #useCustomStatuses: false
  #connection: App\Entity\Configuration\Connection {#1256 …}
  #calculation: App\Entity\Configuration\Calculation {#1259 …}
  #statuses: Doctrine\ORM\PersistentCollection {#781 …}
  #catapultoOrders: Doctrine\ORM\PersistentCollection {#1245 …}
  #orders: Doctrine\ORM\PersistentCollection {#1254 …}
  #firstSync: false
  -markPayed: false
  -blockingStatus: null
  #id: 2
  #createAt: DateTime @1719487680 {#653
    date: 2024-06-27 14:28:00.0 Europe/Moscow (+03:00)
  }
  #updateAt: DateTime @1719567303 {#765
    date: 2024-06-28 12:35:03.0 Europe/Moscow (+03:00)
  }
}
widgetPassword 
"3908f84898504c72a91393dbd5dbbd54"

Request Headers

Header Value
accept 
"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8"
accept-encoding 
"gzip, deflate"
accept-language 
"en-US,en;q=0.5"
connection 
"close"
host 
"catainsales2.ht2.ipol.tech"
upgrade-insecure-requests 
"1"
user-agent 
"Mozilla/5.0 (compatible; Bytespider; spider-feedback@bytedance.com) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.0.0 Safari/537.36"
x-forwarded-port 
"443"
x-forwarded-proto 
"https"
x-php-ob-level 
"1"

Request Content

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

Response

Response Headers

Header Value
cache-control 
"private, must-revalidate"
content-type 
"text/html; charset=UTF-8"
date 
"Mon, 01 Jul 2024 00:04:48 GMT"
expires 
-1
pragma 
"no-cache"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B23000%5D%3A%20Integrity%20constraint%20violation%3A%201048%20Column%20%27manage_token_expire%27%20cannot%20be%20null"
x-debug-exception-file 
"%2Fvar%2Fwww%2Fcatapulto%2Fdata%2Fwww%2Fcatainsales2.ht2.ipol.tech%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:116"
x-debug-token 
"0efad3"
x-debug-token-link 
"https://catainsales2.ht2.ipol.tech/_profiler/fa5d5d"
x-previous-debug-token 
"fa5d5d"
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_ENV 
"dev"
APP_HOST 
"catainsales2.ht2.ipol.tech"
APP_SCHEME 
"https"
APP_SECRET 
"a7796ffabbc56573abf55a6d03186d18"
CATAPULTO_API_SYSTEM_API_KEY 
"9c78dab1bdad2407443ce568af6d64eac22584d52cd05ea53950fd8cccc6a1ec61e39a506684c60e438a4af323fc8a5d269443816e0863d852ee58925172e10b"
CATAPULTO_API_SYSTEM_CUSTOM_BASE_URL 
""
DATABASE_URL 
"mysql://catapulto-insales:5V2d9F7s2Q0c2B2a@localhost:3306/catapulto-insales?serverVersion=mariadb-10.3.32"
INSALES_APP_ID 
"catapulto_insales_test2"
INSALES_APP_SECRET 
"a522bbbc9dda1d564b13b509f053d503"
INSALES_PROPERTY_RATE_RESULT_HANDLE 
"catapulto_rate_result"
INSALES_PROPERTY_TRACK_NUMBER_HANDLE 
"catapulto_track_number"
MAILER_DSN 
"native://default"
MAILER_EMAIL 
"noreply@test.com"
MAILER_FROM_NAME 
"Catapulto Test Ipol 2"
SENDER_EMAIL 
"noreply@test.com"

Defined as regular env variables

Key Value
APP_DEBUG 
"1"
CONTEXT_DOCUMENT_ROOT 
"/var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/public"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/public"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8"
HTTP_ACCEPT_ENCODING 
"gzip, deflate"
HTTP_ACCEPT_LANGUAGE 
"en-US,en;q=0.5"
HTTP_CONNECTION 
"close"
HTTP_HOST 
"catainsales2.ht2.ipol.tech"
HTTP_UPGRADE_INSECURE_REQUESTS 
"1"
HTTP_USER_AGENT 
"Mozilla/5.0 (compatible; Bytespider; spider-feedback@bytedance.com) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.0.0 Safari/537.36"
HTTP_X_FORWARDED_PORT 
"443"
HTTP_X_FORWARDED_PROTO 
"https"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
PERL5LIB 
"/usr/share/awstats/lib:/usr/share/awstats/plugins"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_HTTPS 
"on"
REDIRECT_PERL5LIB 
"/usr/share/awstats/lib:/usr/share/awstats/plugins"
REDIRECT_STATUS 
"200"
REDIRECT_UNIQUE_ID 
"ZoHyn1crCnfD1RVRLLqECgAAABM"
REDIRECT_URL 
"/app/order/widget/1183092/3908f84898504c72a91393dbd5dbbd54/94787220/refresh"
REMOTE_ADDR 
"47.128.45.76"
REMOTE_PORT 
"47897"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"http"
REQUEST_TIME 
1719792287
REQUEST_TIME_FLOAT 
1719792287.515402
REQUEST_URI 
"/app/order/widget/1183092/3908f84898504c72a91393dbd5dbbd54/94787220/refresh"
SCRIPT_FILENAME 
"/var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/public/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"127.0.0.1"
SERVER_ADMIN 
"webmaster@catainsales2.ht2.ipol.tech"
SERVER_NAME 
"catainsales2.ht2.ipol.tech"
SERVER_PORT 
"80"
SERVER_PROTOCOL 
"HTTP/1.0"
SERVER_SIGNATURE 
""
SERVER_SOFTWARE 
"Apache/2.4.6 (CentOS) mpm-itk/2.4.7-04 OpenSSL/1.0.2k-fips"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,MAILER_DSN,MAILER_FROM_NAME,MAILER_EMAIL,SENDER_EMAIL,DATABASE_URL,INSALES_APP_ID,INSALES_APP_SECRET,APP_HOST,APP_SCHEME,CATAPULTO_API_SYSTEM_API_KEY,CATAPULTO_API_SYSTEM_CUSTOM_BASE_URL,INSALES_PROPERTY_TRACK_NUMBER_HANDLE,INSALES_PROPERTY_RATE_RESULT_HANDLE"
UNIQUE_ID 
"ZoHyn1crCnfD1RVRLLqECgAAABM"

Sub Requests 1

ErrorController (token = fa5d5d)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"bd967b"
exception 
Doctrine\DBAL\Exception\NotNullConstraintViolationException {#2047
  -query: Doctrine\DBAL\Query {#2043 …}
  #message: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'manage_token_expire' cannot be null"
  #code: 1048
  #file: "/var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 116
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#2045 …}
  trace: {
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:116 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      ›     case 1566:
      ›         return new NotNullConstraintViolationException($exception, $query);
      › }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Connection.php:1813 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › 
      › $exception = $this->exceptionConverter->convert($driverException, $query);
      › 
      arguments: {
        $exception: Doctrine\DBAL\Driver\PDO\Exception {#2045 …}
        $query: Doctrine\DBAL\Query {#2043 …}
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Connection.php:1748 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
      arguments: {
        $driverException: Doctrine\DBAL\Driver\PDO\Exception {#2045 …}
        $query: Doctrine\DBAL\Query {#2043 …}
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Statement.php:184 {
      Doctrine\DBAL\Statement->execute($params = null): Result …
      › } catch (Driver\Exception $ex) {
      ›     throw $this->conn->convertExceptionDuringQuery($ex, $this->sql, $this->params, $this->types);
      › } finally {
      arguments: {
        $e: Doctrine\DBAL\Driver\PDO\Exception {#2045 …}
        $sql: "INSERT INTO orders (order_id, order_key, number, payed, delivery_variant_id, delivery_information, products, shipping_address, field_values, client, price, comment, manager_comment, manage_token, manage_token_expire, create_at, update_at, shop_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        $params: [ …18]
        $types: [ …18]
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/dbal/src/Statement.php:221 {
      Doctrine\DBAL\Statement->executeStatement(array $params = []): int …
      › 
      ›     return $this->execute($params)->rowCount();
      › }
      arguments: {
        $params: null
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:276 {
      Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() …
      › 
      › $stmt->executeStatement();
      › 
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:1128 {
      Doctrine\ORM\UnitOfWork->executeInserts(ClassMetadata $class): void …
      › 
      › $postInsertIds = $persister->executeInserts();
      › 
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php:425 {
      Doctrine\ORM\UnitOfWork->commit($entity = null) …
      › foreach ($commitOrder as $class) {
      ›     $this->executeInserts($class);
      › }
      arguments: {
        $class: Doctrine\ORM\Mapping\ClassMetadata {#1463 …}
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php:392 {
      Doctrine\ORM\EntityManager->flush($entity = null) …
      › 
      ›     $this->unitOfWork->commit($entity);
      › }
      arguments: {
        $entity: null
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/var/cache/dev/ContainerJIhIXCQ/EntityManager_9a5be93.php:136 {
      ContainerJIhIXCQ\EntityManager_9a5be93->flush($entity = null) …
      › 
      ›     return $this->valueHolder224c7->flush($entity);
      › }
      arguments: {
        $entity: null
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/src/Services/Insales/Client.php:110 {
      App\Services\Insales\Client->downloadOrder(array $fields, bool $setManageToken = false): bool …
      › $this->entityManager->persist($order);
      › $this->entityManager->flush();
      › 
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/src/Services/Insales/Client.php:122 {
      App\Services\Insales\Client->getByOrderId($orderId, bool $setManageToken = false) …
      › {
      ›     $this->downloadOrder(['id' => $orderId],$setManageToken);
      › 
      arguments: {
        $fields: [ …1]
        $setManageToken: false
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/src/Controller/ApplicationController.php:491 {
      App\Controller\ApplicationController->orderWidgetRefresh(Shop $shop, $orderId, $widgetPassword, Client $insales, Package $package, Order $catapultoOrder) …
      › /** @var Entity\Order $order */
      › $order = $insales->setShop($shop)->getByOrderId($orderId);
      › 
      arguments: {
        $orderId: "94787220"
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/symfony/http-kernel/HttpKernel.php:152 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
      arguments: {
        $shop: App\Entity\Shop {#771 …}
        $orderId: "94787220"
        $widgetPassword: "3908f84898504c72a91393dbd5dbbd54"
        $insales: App\Services\Insales\Client {#1967 …}
        $package: App\Services\Catapulto\Package {#1974 …}
        $catapultoOrder: App\Services\Catapulto\Order {#1981 …}
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/vendor/symfony/http-kernel/HttpKernel.php:74 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true) …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Exception $e) {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#6 …}
        $type: 1
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/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 {
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#6 …}
        $type: 1
        $catch: true
      }
    }
    /var/www/catapulto/data/www/catainsales2.ht2.ipol.tech/public/index.php:30 {
      › $request = Request::createFromGlobals();
      › $response = $kernel->handle($request);
      › $response->send();
      arguments: {
        $request: Symfony\Component\HttpFoundation\Request {#6 …}
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#83 …6}