14:28:56.495
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native " service is deprecated, use "session.storage.factory.native " instead.
14:28:56.496
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag " service is deprecated, create your own "session.storage.factory " instead.
14:28:56.498
Matched route "crons6hourly " .
14:28:56.502
deprecation
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Authenticator\GuardBridgeAuthenticator " class is deprecated, use the new authenticator system instead.
14:28:56.502
deprecation
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\PasswordAuthenticatedInterface " class is deprecated, use the new authenticator system instead.
14:28:56.504
deprecation
User Deprecated: Since symfony/security-bundle 5.3: The ".container.private.security.password_encoder " service is deprecated, use "security.user_password_hasher " instead.
14:28:56.505
deprecation
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoder " class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasher " instead.
14:28:56.505
deprecation
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface " interface is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface " instead.
14:28:56.506
deprecation
User Deprecated: Since symfony/security-bundle 5.3: The "security.encoder_factory.generic " service is deprecated, use "security.password_hasher_factory " instead.
14:28:56.507
deprecation
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactory " class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactory " instead.
14:28:56.507
deprecation
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface " class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactoryInterface " instead.
14:28:56.513
Checking for authenticator support.
14:28:56.513
Checking support on authenticator.
14:28:56.513
Authenticator does not support the request.
14:28:56.513
Checking support on authenticator.
14:28:56.513
Authenticator does not support the request.
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\QueryParameterValidateListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator " .
14:28:56.514
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\AddFormatListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest " .
14:28:56.514
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurity " .
14:28:56.514
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\DeserializeListener::onKernelRequest " .
14:28:56.515
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurityPostDenormalize " .
14:28:56.515
Notified event "kernel.request " to listener "ApiPlatform\Core\Bridge\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest " .
14:28:56.612
deprecation
User Deprecated: Class "App\Entity\System\User " should implement method "Symfony\Component\Security\Core\User\UserInterface::getUserIdentifier(): string ": returns the identifier for this user (e.g. its username or email address).
14:28:56.612
deprecation
User Deprecated: Method "Symfony\Component\Security\Core\User\UserInterface::getSalt() " might add "?string " as a native return type declaration in the future. Do the same in implementation "App\Entity\System\User " now to avoid errors or add an explicit @return annotation to suppress this message.
14:28:56.641
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
doctrine
14:28:56.701
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
doctrine
14:28:56.702
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
doctrine
14:28:56.702
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.note AS note_4 FROM options t0
doctrine
14:28:56.705
Notified event "kernel.controller " to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController " .
14:28:56.705
Notified event "kernel.controller " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController " .
14:28:56.705
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController " .
14:28:56.705
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController " .
14:28:56.705
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController " .
14:28:56.705
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController " .
14:28:56.705
Notified event "kernel.controller_arguments " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments " .
14:28:56.705
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments " .
14:28:56.705
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments " .
14:28:56.729
SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20
14:28:56.737
critical
Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'seopanelsurfside_bigseo2.seo_tasks' doesn't exist " at /home/seopanelsurfside/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 51
request
Show context
Show trace
{
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php:51 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
› case 1146:
› return new TableNotFoundException($exception, $query);
›
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1767 {
Doctrine\DBAL \ Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
›
› $exception = $this->exceptionConverter->convert($driverException, $query);
›
arguments : {
$exception : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1706 {
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 {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1039 {
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 {
arguments : {
$e : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31 {
Doctrine\ORM\Query\Exec \ SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
› {
› return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
› }
arguments : {
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
$qcp : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query.php:325 {
Doctrine\ORM \ Query->_doExecute() …
›
› return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
› }
arguments : {
$conn : Doctrine\DBAL \ Connection {#656 …}
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1181 {
Doctrine\ORM \ AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
›
› $stmt = $this->_doExecute();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1135 {
Doctrine\ORM \ AbstractQuery->execute($parameters = null, $hydrationMode = null) …
›
› return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:871 {
Doctrine\ORM \ AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
› {
› return $this->execute(null, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside / src/Repository/Seo/SEOTasksRepository.php:56 {
App\Repository\Seo \ SEOTasksRepository->chkOrphanTasks($status) …
› ->getQuery()
› ->getResult()
› ;
}
/home/seopanelsurfside / src/Service/D4SeoService.php:305 {
App\Service \ D4SeoService->retrieveOrphanTasks() …
› $em = $this->entityManager;
› $tasks = $em->getRepository(SEOTasks::class)->chkOrphanTasks('sent');
› //dd($tasks);
arguments : {
$status : "sent "
}
}
/home/seopanelsurfside / src/Service/DiscoveryService.php:40 {
App\Service \ DiscoveryService->lostSeoTasks() …
› public function lostSeoTasks() {
› $this->d4seo->retrieveOrphanTasks();
› }
}
/home/seopanelsurfside / src/Controller/System/CronController.php:84 {
App\Controller\System \ CronController->hours6(): Response …
› // IntelQueue Discovery
› $this->discovery->lostSeoTasks();
›
}
/home/seopanelsurfside/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);
›
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside / public_html/index.php:28 {
› $request = Request::createFromGlobals();\r
› $response = $kernel->handle($request);\r
› $response->send();\r
arguments : {
$request : Symfony\Component\HttpFoundation \ Request {#6 …}
}
}
}
[
"exception " => Doctrine\DBAL\Exception \ TableNotFoundException {#2415
#message : "An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'seopanelsurfside_bigseo2.seo_tasks' doesn't exist "
#code : 1146
#file : "/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php "
#line : 51
-previous : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
-query : Doctrine\DBAL \ Query {#2414 …}
trace : {
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php:51 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
› case 1146:
› return new TableNotFoundException($exception, $query);
›
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1767 {
Doctrine\DBAL \ Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
›
› $exception = $this->exceptionConverter->convert($driverException, $query);
›
arguments : {
$exception : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1706 {
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 {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1039 {
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 {
arguments : {
$e : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31 {
Doctrine\ORM\Query\Exec \ SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
› {
› return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
› }
arguments : {
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
$qcp : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query.php:325 {
Doctrine\ORM \ Query->_doExecute() …
›
› return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
› }
arguments : {
$conn : Doctrine\DBAL \ Connection {#656 …}
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1181 {
Doctrine\ORM \ AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
›
› $stmt = $this->_doExecute();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1135 {
Doctrine\ORM \ AbstractQuery->execute($parameters = null, $hydrationMode = null) …
›
› return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:871 {
Doctrine\ORM \ AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
› {
› return $this->execute(null, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside / src/Repository/Seo/SEOTasksRepository.php:56 {
App\Repository\Seo \ SEOTasksRepository->chkOrphanTasks($status) …
› ->getQuery()
› ->getResult()
› ;
}
/home/seopanelsurfside / src/Service/D4SeoService.php:305 {
App\Service \ D4SeoService->retrieveOrphanTasks() …
› $em = $this->entityManager;
› $tasks = $em->getRepository(SEOTasks::class)->chkOrphanTasks('sent');
› //dd($tasks);
arguments : {
$status : "sent "
}
}
/home/seopanelsurfside / src/Service/DiscoveryService.php:40 {
App\Service \ DiscoveryService->lostSeoTasks() …
› public function lostSeoTasks() {
› $this->d4seo->retrieveOrphanTasks();
› }
}
/home/seopanelsurfside / src/Controller/System/CronController.php:84 {
App\Controller\System \ CronController->hours6(): Response …
› // IntelQueue Discovery
› $this->discovery->lostSeoTasks();
›
}
/home/seopanelsurfside/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);
›
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside / public_html/index.php:28 {
› $request = Request::createFromGlobals();\r
› $response = $kernel->handle($request);\r
› $response->send();\r
arguments : {
$request : Symfony\Component\HttpFoundation \ Request {#6 …}
}
}
}
}
]
{
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php:51 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
› case 1146:
› return new TableNotFoundException($exception, $query);
›
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1767 {
Doctrine\DBAL \ Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
›
› $exception = $this->exceptionConverter->convert($driverException, $query);
›
arguments : {
$exception : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1706 {
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 {#2391 …}
$query : Doctrine\DBAL \ Query {#2414 …}
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Connection.php:1039 {
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 {
arguments : {
$e : Doctrine\DBAL\Driver\PDO \ Exception {#2391 …}
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31 {
Doctrine\ORM\Query\Exec \ SingleSelectExecutor->execute(Connection $conn, array $params, array $types) …
› {
› return $conn->executeQuery($this->_sqlStatements, $params, $types, $this->queryCacheProfile);
› }
arguments : {
$sql : "SELECT s0_.id AS id_0, s0_.purpose AS purpose_1, s0_.task_id AS task_id_2, s0_.d4id AS d4id_3, s0_.api AS api_4, s0_.function AS function_5, s0_.se AS se_6, s0_.language_code AS language_code_7, s0_.location_code AS location_code_8, s0_.keyword AS keyword_9, s0_.se_type AS se_type_10, s0_.device AS device_11, s0_.os AS os_12, s0_.status AS status_13, s0_.created AS created_14 FROM seo_tasks s0_ WHERE s0_.created < ? AND s0_.status = ? ORDER BY s0_.created DESC LIMIT 20 "
$params : [ …2]
$types : [ …2]
$qcp : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Query.php:325 {
Doctrine\ORM \ Query->_doExecute() …
›
› return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
› }
arguments : {
$conn : Doctrine\DBAL \ Connection {#656 …}
$params : [ …2]
$types : [ …2]
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1181 {
Doctrine\ORM \ AbstractQuery->executeIgnoreQueryCache($parameters = null, $hydrationMode = null) …
›
› $stmt = $this->_doExecute();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:1135 {
Doctrine\ORM \ AbstractQuery->execute($parameters = null, $hydrationMode = null) …
›
› return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/AbstractQuery.php:871 {
Doctrine\ORM \ AbstractQuery->getResult($hydrationMode = self::HYDRATE_OBJECT) …
› {
› return $this->execute(null, $hydrationMode);
› }
arguments : {
$parameters : null
$hydrationMode : 1
}
}
/home/seopanelsurfside / src/Repository/Seo/SEOTasksRepository.php:56 {
App\Repository\Seo \ SEOTasksRepository->chkOrphanTasks($status) …
› ->getQuery()
› ->getResult()
› ;
}
/home/seopanelsurfside / src/Service/D4SeoService.php:305 {
App\Service \ D4SeoService->retrieveOrphanTasks() …
› $em = $this->entityManager;
› $tasks = $em->getRepository(SEOTasks::class)->chkOrphanTasks('sent');
› //dd($tasks);
arguments : {
$status : "sent "
}
}
/home/seopanelsurfside / src/Service/DiscoveryService.php:40 {
App\Service \ DiscoveryService->lostSeoTasks() …
› public function lostSeoTasks() {
› $this->d4seo->retrieveOrphanTasks();
› }
}
/home/seopanelsurfside / src/Controller/System/CronController.php:84 {
App\Controller\System \ CronController->hours6(): Response …
› // IntelQueue Discovery
› $this->discovery->lostSeoTasks();
›
}
/home/seopanelsurfside/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);
›
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside/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
}
}
/home/seopanelsurfside / public_html/index.php:28 {
› $request = Request::createFromGlobals();\r
› $response = $kernel->handle($request);\r
› $response->send();\r
arguments : {
$request : Symfony\Component\HttpFoundation \ Request {#6 …}
}
}
}
14:28:56.738
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure " .
14:28:56.738
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\QueryParameterValidateListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator " .
14:28:56.739
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\AddFormatListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurity " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\DeserializeListener::onKernelRequest " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurityPostDenormalize " .
14:28:56.739
Notified event "kernel.request " to listener "ApiPlatform\Core\Bridge\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest " .
14:28:56.742
Notified event "kernel.controller " to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController " .
14:28:56.742
Notified event "kernel.controller " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController " .
14:28:56.742
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController " .
14:28:56.742
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController " .
14:28:56.742
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController " .
14:28:56.742
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController " .
14:28:56.743
Notified event "kernel.controller_arguments " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments " .
14:28:56.743
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments " .
14:28:56.743
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments " .
14:28:56.948
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service " service is deprecated, use "session.storage.factory.native ", "session.storage.factory.php_bridge " or "session.storage.factory.mock_file " instead.
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse " .
14:28:56.953
Notified event "kernel.response " to listener "ApiPlatform\Core\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "ApiPlatform\Core\HttpCache\EventListener\AddHeadersListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse " .
14:28:56.953
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\Component\Security\Http\Firewall\ExceptionListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\WebpackEncoreBundle\EventListener\ExceptionListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "ApiPlatform\Core\Bridge\Symfony\Validator\EventListener\ValidationExceptionListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::logKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "ApiPlatform\Core\EventListener\ExceptionListener::onKernelException " .
14:28:56.954
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onKernelException " .
14:28:56.954
Listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onKernelException " stopped propagation of the event "kernel.exception " .
14:28:56.954
Notified event "kernel.response " to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse " .
14:28:56.954
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse " .
14:28:56.954
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse " .
14:28:56.954
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse " .
14:28:56.954
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest " .
14:28:56.954
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest " .
14:28:56.954
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest " .
14:28:56.954
Notified event "kernel.finish_request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest " .
14:28:56.954
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse " .
14:28:56.962
Notified event "kernel.response " to listener "ApiPlatform\Core\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "ApiPlatform\Core\HttpCache\EventListener\AddHeadersListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse " .
14:28:56.962
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest " .
14:28:56.962
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest " .
14:28:56.962
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest " .
14:28:56.962
Notified event "kernel.finish_request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest " .
14:28:56.962
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest " .