04:28:06.646
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.native " service is deprecated, use "session.storage.factory.native " instead.
04:28:06.646
deprecation
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag " service is deprecated, create your own "session.storage.factory " instead.
04:28:06.648
Matched route "seotasks_return " .
04:28:06.651
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.
04:28:06.652
deprecation
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\PasswordAuthenticatedInterface " class is deprecated, use the new authenticator system instead.
04:28:06.653
deprecation
User Deprecated: Since symfony/security-bundle 5.3: The ".container.private.security.password_encoder " service is deprecated, use "security.user_password_hasher " instead.
04:28:06.654
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.
04:28:06.654
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.
04:28:06.654
deprecation
User Deprecated: Since symfony/security-bundle 5.3: The "security.encoder_factory.generic " service is deprecated, use "security.password_hasher_factory " instead.
04:28:06.655
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.
04:28:06.655
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.
04:28:06.660
Checking for authenticator support.
04:28:06.660
Checking support on authenticator.
04:28:06.660
Authenticator does not support the request.
04:28:06.660
Checking support on authenticator.
04:28:06.660
Authenticator does not support the request.
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\QueryParameterValidateListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator " .
04:28:06.661
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\AddFormatListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurity " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\DeserializeListener::onKernelRequest " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurityPostDenormalize " .
04:28:06.661
Notified event "kernel.request " to listener "ApiPlatform\Core\Bridge\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest " .
04:28:06.732
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).
04:28:06.732
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.
04:28:06.750
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
04:28:06.759
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
04:28:06.760
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
04:28:06.761
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
04:28:06.761
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
04:28:06.763
Notified event "kernel.controller " to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController " .
04:28:06.763
Notified event "kernel.controller " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController " .
04:28:06.763
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController " .
04:28:06.763
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController " .
04:28:06.763
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController " .
04:28:06.763
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController " .
04:28:06.763
Notified event "kernel.controller_arguments " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments " .
04:28:06.763
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments " .
04:28:06.763
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments " .
04:28:06.764
deprecation
User Deprecated: Since symfony/framework-bundle 5.4: Method "Symfony\Bundle\FrameworkBundle\Controller\AbstractController::getDoctrine() " is deprecated, inject an instance of ManagerRegistry in your controller instead.
04:28:06.764
SELECT t0.id AS id_1, t0.purpose AS purpose_2, t0.task_id AS task_id_3, t0.d4id AS d4id_4, t0.api AS api_5, t0.function AS function_6, t0.se AS se_7, t0.language_code AS language_code_8, t0.location_code AS location_code_9, t0.keyword AS keyword_10, t0.se_type AS se_type_11, t0.device AS device_12, t0.os AS os_13, t0.status AS status_14, t0.created AS created_15 FROM seo_tasks t0 WHERE t0.task_id = ? LIMIT 1
04:28:07.652
Request: "GET https://api.dataforseo.com/v3/business_data/google/my_business_info/task_get/09012314-2792-0242-0000-d7a5588f9fd5 "
http_client
04:28:08.428
Response: "200 https://api.dataforseo.com/v3/business_data/google/my_business_info/task_get/09012314-2792-0242-0000-d7a5588f9fd5 "
http_client
04:28:08.429
Manual Fetch : 09012314-2792-0242-0000-d7a5588f9fd5/19821078-16a5-417e-899e-87c8c1ff8426 - taskreturn 282
seoinfo
04:28:08.429
Transferring 19821078-16a5-417e-899e-87c8c1ff8426 for discovery to businessDataStoreG - taskreturn 330
seoinfo
04:28:08.429
Updating data/gmb/d7/d7a5588f9fd5-gmbadvanced.json - businessDataStoreG 443
seoinfo
04:28:08.430
Keyword 'cid:16248670390628547028' - businessDataStoreG 470
seoinfo
04:28:08.443
SELECT t0.id AS id_1, t0.cid AS cid_2, t0.yid AS yid_3, t0.bizid AS bizid_4, t0.title AS title_5, t0.keyword AS keyword_6, t0.location AS location_7, t0.description AS description_8, t0.primarycat AS primarycat_9, t0.addcats AS addcats_10, t0.check_url AS check_url_11, t0.feature_id AS feature_id_12, t0.address AS address_13, t0.address_all AS address_all_14, t0.place_id AS place_id_15, t0.phone AS phone_16, t0.url AS url_17, t0.domain AS domain_18, t0.logo AS logo_19, t0.main_image AS main_image_20, t0.snippet AS snippet_21, t0.attributes AS attributes_22, t0.rating_type AS rating_type_23, t0.rating_value AS rating_value_24, t0.votes_count AS votes_count_25, t0.rating_max AS rating_max_26, t0.competitors AS competitors_27, t0.worktime AS worktime_28, t0.lat AS lat_29, t0.lng AS lng_30, t0.modified AS modified_31 FROM gplaces t0 WHERE t0.cid = ? LIMIT 1
04:28:10.128
Adding NEW Place 'Exterior Services LLC' 16248670390628547028 - businessDataStoreG 496
seoinfo
04:28:10.339
"START TRANSACTION "
doctrine
04:28:10.341
INSERT INTO gplaces (cid, yid, bizid, title, keyword, location, description, primarycat, addcats, check_url, feature_id, address, address_all, place_id, phone, url, domain, logo, main_image, snippet, attributes, rating_type, rating_value, votes_count, rating_max, competitors, worktime, lat, lng, modified) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
04:28:10.345
"ROLLBACK "
doctrine
04:28:10.352
critical
Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'lng' at row 1 " at /home/seopanelsurfside/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119
request
Show context
Show trace
{
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php:119 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
›
› return new DriverException($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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/home/seopanelsurfside/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 {#1819 …}
$sql : "INSERT INTO gplaces (cid, yid, bizid, title, keyword, location, description, primarycat, addcats, check_url, feature_id, address, address_all, place_id, phone, url, domain, logo, main_image, snippet, attributes, rating_type, rating_value, votes_count, rating_max, competitors, worktime, lat, lng, modified) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "
$params : [ …30]
$types : [ …30]
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Statement.php:221 {
Doctrine\DBAL \ Statement->executeStatement(array $params = []): int …
›
› return $this->execute($params)->rowCount();
› }
arguments : {
$params : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:276 {
Doctrine\ORM\Persisters\Entity \ BasicEntityPersister->executeInserts() …
›
› $stmt->executeStatement();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/UnitOfWork.php:1128 {
Doctrine\ORM \ UnitOfWork->executeInserts(ClassMetadata $class): void …
›
› $postInsertIds = $persister->executeInserts();
›
}
/home/seopanelsurfside/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 {#1646 …}
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/EntityManager.php:392 {
Doctrine\ORM \ EntityManager->flush($entity = null) …
›
› $this->unitOfWork->commit($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / var/cache/dev/ContainerADpVxC8/EntityManager_9a5be93.php:136 {
ContainerADpVxC8 \ EntityManager_9a5be93->flush($entity = null) …
›
› return $this->valueHolder416d0->flush($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:578 {
App\Controller\Seo \ SEOTasksController->businessDataStoreG($d4result, $d4taskid, $purpose) …
› $em->persist($place);
› $em->flush();
›
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:331 {
App\Controller\Seo \ SEOTasksController->taskreturn(string $purpose, string $api, string $se, string $function, string $task_id): Response …
› { $this->seologger->info("Transferring {$task_id} for {$purpose} to businessDataStoreG - ".__FUNCTION__." ".__LINE__);
› $this->businessDataStoreG($d4result, $d4taskid, $purpose); }
› elseif('my_business_updates' == $function)
arguments : {
$d4result : [ …1]
$d4taskid : "09012314-2792-0242-0000-d7a5588f9fd5 "
$purpose : "discovery "
}
}
/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);
›
arguments : {
$purpose : "discovery "
$api : "business_data "
$se : "google "
$function : "my_business_info "
$task_id : "19821078-16a5-417e-899e-87c8c1ff8426 "
}
}
/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 \ DriverException {#1829
#message : "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'lng' at row 1 "
#code : 1406
#file : "/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php "
#line : 119
-previous : Doctrine\DBAL\Driver\PDO \ Exception {#1819 …}
-query : Doctrine\DBAL \ Query {#1825 …}
trace : {
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Driver/API/MySQL/ExceptionConverter.php:119 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
›
› return new DriverException($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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/home/seopanelsurfside/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 {#1819 …}
$sql : "INSERT INTO gplaces (cid, yid, bizid, title, keyword, location, description, primarycat, addcats, check_url, feature_id, address, address_all, place_id, phone, url, domain, logo, main_image, snippet, attributes, rating_type, rating_value, votes_count, rating_max, competitors, worktime, lat, lng, modified) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "
$params : [ …30]
$types : [ …30]
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Statement.php:221 {
Doctrine\DBAL \ Statement->executeStatement(array $params = []): int …
›
› return $this->execute($params)->rowCount();
› }
arguments : {
$params : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:276 {
Doctrine\ORM\Persisters\Entity \ BasicEntityPersister->executeInserts() …
›
› $stmt->executeStatement();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/UnitOfWork.php:1128 {
Doctrine\ORM \ UnitOfWork->executeInserts(ClassMetadata $class): void …
›
› $postInsertIds = $persister->executeInserts();
›
}
/home/seopanelsurfside/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 {#1646 …}
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/EntityManager.php:392 {
Doctrine\ORM \ EntityManager->flush($entity = null) …
›
› $this->unitOfWork->commit($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / var/cache/dev/ContainerADpVxC8/EntityManager_9a5be93.php:136 {
ContainerADpVxC8 \ EntityManager_9a5be93->flush($entity = null) …
›
› return $this->valueHolder416d0->flush($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:578 {
App\Controller\Seo \ SEOTasksController->businessDataStoreG($d4result, $d4taskid, $purpose) …
› $em->persist($place);
› $em->flush();
›
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:331 {
App\Controller\Seo \ SEOTasksController->taskreturn(string $purpose, string $api, string $se, string $function, string $task_id): Response …
› { $this->seologger->info("Transferring {$task_id} for {$purpose} to businessDataStoreG - ".__FUNCTION__." ".__LINE__);
› $this->businessDataStoreG($d4result, $d4taskid, $purpose); }
› elseif('my_business_updates' == $function)
arguments : {
$d4result : [ …1]
$d4taskid : "09012314-2792-0242-0000-d7a5588f9fd5 "
$purpose : "discovery "
}
}
/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);
›
arguments : {
$purpose : "discovery "
$api : "business_data "
$se : "google "
$function : "my_business_info "
$task_id : "19821078-16a5-417e-899e-87c8c1ff8426 "
}
}
/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:119 {
Doctrine\DBAL\Driver\API\MySQL \ ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
›
› return new DriverException($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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/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 {#1819 …}
$query : Doctrine\DBAL \ Query {#1825 …}
}
}
/home/seopanelsurfside/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 {#1819 …}
$sql : "INSERT INTO gplaces (cid, yid, bizid, title, keyword, location, description, primarycat, addcats, check_url, feature_id, address, address_all, place_id, phone, url, domain, logo, main_image, snippet, attributes, rating_type, rating_value, votes_count, rating_max, competitors, worktime, lat, lng, modified) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "
$params : [ …30]
$types : [ …30]
}
}
/home/seopanelsurfside/vendor /doctrine/dbal/ src/Statement.php:221 {
Doctrine\DBAL \ Statement->executeStatement(array $params = []): int …
›
› return $this->execute($params)->rowCount();
› }
arguments : {
$params : null
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php:276 {
Doctrine\ORM\Persisters\Entity \ BasicEntityPersister->executeInserts() …
›
› $stmt->executeStatement();
›
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/UnitOfWork.php:1128 {
Doctrine\ORM \ UnitOfWork->executeInserts(ClassMetadata $class): void …
›
› $postInsertIds = $persister->executeInserts();
›
}
/home/seopanelsurfside/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 {#1646 …}
}
}
/home/seopanelsurfside/vendor /doctrine/orm/ lib/Doctrine/ORM/EntityManager.php:392 {
Doctrine\ORM \ EntityManager->flush($entity = null) …
›
› $this->unitOfWork->commit($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / var/cache/dev/ContainerADpVxC8/EntityManager_9a5be93.php:136 {
ContainerADpVxC8 \ EntityManager_9a5be93->flush($entity = null) …
›
› return $this->valueHolder416d0->flush($entity);
› }
arguments : {
$entity : null
}
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:578 {
App\Controller\Seo \ SEOTasksController->businessDataStoreG($d4result, $d4taskid, $purpose) …
› $em->persist($place);
› $em->flush();
›
}
/home/seopanelsurfside / src/Controller/Seo/SEOTasksController.php:331 {
App\Controller\Seo \ SEOTasksController->taskreturn(string $purpose, string $api, string $se, string $function, string $task_id): Response …
› { $this->seologger->info("Transferring {$task_id} for {$purpose} to businessDataStoreG - ".__FUNCTION__." ".__LINE__);
› $this->businessDataStoreG($d4result, $d4taskid, $purpose); }
› elseif('my_business_updates' == $function)
arguments : {
$d4result : [ …1]
$d4taskid : "09012314-2792-0242-0000-d7a5588f9fd5 "
$purpose : "discovery "
}
}
/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);
›
arguments : {
$purpose : "discovery "
$api : "business_data "
$se : "google "
$function : "my_business_info "
$task_id : "19821078-16a5-417e-899e-87c8c1ff8426 "
}
}
/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 …}
}
}
}
04:28:10.352
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\QueryParameterValidateListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator " .
04:28:10.353
Notified event "kernel.request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\AddFormatListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\ReadListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurity " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\EventListener\DeserializeListener::onKernelRequest " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\Security\EventListener\DenyAccessListener::onSecurityPostDenormalize " .
04:28:10.353
Notified event "kernel.request " to listener "ApiPlatform\Core\Bridge\Symfony\Bundle\EventListener\SwaggerUiListener::onKernelRequest " .
04:28:10.355
Notified event "kernel.controller " to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController " .
04:28:10.355
Notified event "kernel.controller " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController " .
04:28:10.355
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController " .
04:28:10.355
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController " .
04:28:10.355
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController " .
04:28:10.355
Notified event "kernel.controller " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController " .
04:28:10.355
Notified event "kernel.controller_arguments " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments " .
04:28:10.355
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments " .
04:28:10.355
Notified event "kernel.controller_arguments " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments " .
04:28:10.662
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.
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse " .
04:28:10.670
Notified event "kernel.response " to listener "ApiPlatform\Core\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "ApiPlatform\Core\HttpCache\EventListener\AddHeadersListener::onKernelResponse " .
04:28:10.670
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\Component\Security\Http\Firewall\ExceptionListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\WebpackEncoreBundle\EventListener\ExceptionListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "ApiPlatform\Core\Bridge\Symfony\Validator\EventListener\ValidationExceptionListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::logKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "ApiPlatform\Core\EventListener\ExceptionListener::onKernelException " .
04:28:10.671
Notified event "kernel.exception " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onKernelException " .
04:28:10.671
Listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onKernelException " stopped propagation of the event "kernel.exception " .
04:28:10.671
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader " .
04:28:10.671
Notified event "kernel.response " to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse " .
04:28:10.671
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse " .
04:28:10.671
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse " .
04:28:10.671
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse " .
04:28:10.671
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest " .
04:28:10.671
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest " .
04:28:10.671
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest " .
04:28:10.671
Notified event "kernel.finish_request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest " .
04:28:10.671
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest " .
04:28:10.679
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse " .
04:28:10.680
Notified event "kernel.response " to listener "ApiPlatform\Core\Hydra\EventListener\AddLinkHeaderListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "ApiPlatform\Core\HttpCache\EventListener\AddHeadersListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.response " to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse " .
04:28:10.680
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest " .
04:28:10.680
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onFinishRequest " .
04:28:10.680
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest " .
04:28:10.680
Notified event "kernel.finish_request " to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest " .
04:28:10.680
Notified event "kernel.finish_request " to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest " .