Error 500 Internal Server Error

GET https://new.sakla.ru/users/list?alphabet=DESC&page=55

IP
192.168.80.1
Profiled on
Token
956619

Exceptions

InvalidFormat

HTTP 500 Internal Server Error

Could not convert database value "NULL" to Doctrine Type Doctrine\DBAL\Types\DateType. Expected format "Y-m-d".

Exception

Doctrine\DBAL\Types\Exception\ InvalidFormat

in vendor/doctrine/dbal/src/Types/Exception/InvalidFormat.php (line 26)
  1. string $value,
  2. string $toType,
  3. ?string $expectedFormat,
  4. ?Throwable $previous = null,
  5. ): self {
  6. return new self(
  7. sprintf(
  8. 'Could not convert database value "%s" to Doctrine Type %s. Expected format "%s".',
  9. strlen($value) > 32 ? substr($value, 0, 20) . '...' : $value,
  10. $toType,
  11. $expectedFormat ?? '',
in vendor/doctrine/dbal/src/Types/DateType.php :: new (line 63)
  1. $dateTime = DateTime::createFromFormat('!' . $platform->getDateFormatString(), $value);
  2. if ($dateTime !== false) {
  3. return $dateTime;
  4. }
  6. throw InvalidFormat::new(
  7. $value,
  8. static::class,
  9. $platform->getDateFormatString(),
  10. );
  11. }
in vendor/doctrine/orm/src/Internal/Hydration/AbstractHydrator.php -> convertToPHPValue (line 336)
  1. if (isset($rowData['data'][$dqlAlias][$fieldName])) {
  2. break;
  3. }
  5. $rowData['data'][$dqlAlias][$fieldName] = $type
  6. ? $type->convertToPHPValue($value, $this->platform)
  7. : $value;
  9. if ($rowData['data'][$dqlAlias][$fieldName] !== null && isset($cacheKeyInfo['enumType'])) {
  10. $rowData['data'][$dqlAlias][$fieldName] = $this->buildEnum($rowData['data'][$dqlAlias][$fieldName], $cacheKeyInfo['enumType']);
  11. }
in vendor/doctrine/orm/src/Internal/Hydration/ObjectHydrator.php -> gatherRowData (line 327)
  1. {
  2. // Initialize
  3. $id = $this->idTemplate; // initialize the id-memory
  4. $nonemptyComponents = [];
  5. // Split the row data into chunks of class data.
  6. $rowData = $this->gatherRowData($row, $id, $nonemptyComponents);
  8. // reset result pointers for each data row
  9. $this->resultPointers = [];
  11. // Hydrate the data chunks
in vendor/doctrine/orm/src/Internal/Hydration/ObjectHydrator.php -> hydrateRowData (line 147)
  1. protected function hydrateAllData(): array
  2. {
  3. $result = [];
  5. while ($row = $this->statement()->fetchAssociative()) {
  6. $this->hydrateRowData($row, $result);
  7. }
  9. // Take snapshots from all newly initialized collections
  10. foreach ($this->initializedCollections as $coll) {
  11. $coll->takeSnapshot();
in vendor/doctrine/orm/src/Internal/Hydration/AbstractHydrator.php -> hydrateAllData (line 171)
  2. $this->em->getEventManager()->addEventListener([Events::onClear], $this);
  3. $this->prepare();
  5. try {
  6. $result = $this->hydrateAllData();
  7. } finally {
  8. $this->cleanup();
  9. }
  11. return $result;
in vendor/doctrine/orm/src/AbstractQuery.php -> hydrateAll (line 948)
  1. $rsm = $this->getResultSetMapping();
  2. if ($rsm === null) {
  3. throw new LogicException('Uninitialized result set mapping.');
  4. }
  6. $data = $this->em->newHydrator($this->hydrationMode)->hydrateAll($stmt, $rsm, $this->hints);
  8. $setCacheEntry($data);
  10. return $data;
  11. }
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 891)
  1. ): mixed {
  2. if ($this->cacheable && $this->isCacheEnabled()) {
  3. return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4. }
  6. return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7. }
  9. /**
  10. * Execute query ignoring second level cache.
  11. *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 689)
  1. *
  2. * @phpstan-param string|AbstractQuery::HYDRATE_* $hydrationMode
  3. */
  4. public function getResult(string|int $hydrationMode = self::HYDRATE_OBJECT): mixed
  5. {
  6. return $this->execute(null, $hydrationMode);
  7. }
  9. /**
  10. * Gets the array of results for the query.
  11. *
AbstractQuery->getResult() in src/AdminBundle/Repository/UserRepository.php (line 50)
  1. $page = $count * ($context["page"] - 1);
  2. }
  4. $query->setFirstResult($page);
  6. return $query->getQuery()->getResult();
  7. }
  9. public function count(array $criteria = []): int
  10. {
  11. $query = $this->createQueryBuilder('t');
UserRepository->findBlog(array('page' => '55', 'max_results' => 20, 'filter' => array('alphabet' => 'DESC'))) in src/BlogBundle/Controller/UserController.php (line 193)
  1. } else {
  2. $v_a_d = ' style=display:inline-block';
  3. }
  6. $blogs = $blogRepository->findBlog(["page" => $page, 'max_results' => 20,'filter' => $filter]);
  8. if (empty($blogs)) {
  9. throw new NotFoundHttpException('Page not found');
  10. }
in vendor/symfony/http-kernel/HttpKernel.php -> listAction (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 182)
  1. $this->boot();
  2. ++$this->requestStackSize;
  3. $this->resetServices = true;
  5. try {
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. } finally {
  8. --$this->requestStackSize;
  9. }
  10. }
Kernel->handle(object(Request)) in public/index.php (line 32)
  1. Request::setTrustedHosts([$trustedHosts]);
  2. }
  4. $kernel = new Kernel($appEnv, $appDebug);
  5. $request = Request::createFromGlobals();
  6. $response = $kernel->handle($request);
  7. $response->send();
  8. $kernel->terminate($request, $response);

Logs

Level Channel Message
INFO 10:13:45 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "956619"
    },
    "request_uri": "https://new.sakla.ru/_profiler/956619",
    "method": "GET"
}
DEBUG 10:13:45 security Checking for authenticator support. 
{
    "firewall_name": "main",
    "authenticators": 1
}
DEBUG 10:13:45 security Checking support on authenticator. 
{
    "firewall_name": "main",
    "authenticator": "Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticator"
}
DEBUG 10:13:45 security Authenticator does not support the request. 
{
    "firewall_name": "main",
    "authenticator": "Symfony\\Component\\Security\\Http\\Authenticator\\Debug\\TraceableAuthenticator"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequestPrettyUrls"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "App\AdminBundle\EventListener\KernelListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "App\\AdminBundle\\EventListener\\KernelListener::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 10:13:45 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 10:13:45 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 10:13:45 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
INFO 10:13:45 deprecation User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:75 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal) 
{
    "exception": {}
}
DEBUG 10:13:45 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 10:13:45 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 10:13:45 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 10:13:45 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Trace

InvalidFormat 
Doctrine\DBAL\Types\Exception\InvalidFormat:
Could not convert database value "NULL" to Doctrine Type Doctrine\DBAL\Types\DateType. Expected format "Y-m-d".

  at vendor/doctrine/dbal/src/Types/Exception/InvalidFormat.php:26
  at Doctrine\DBAL\Types\Exception\InvalidFormat::new('NULL', 'Doctrine\\DBAL\\Types\\DateType', 'Y-m-d')
     (vendor/doctrine/dbal/src/Types/DateType.php:63)
  at Doctrine\DBAL\Types\DateType->convertToPHPValue('NULL', object(MySQL80Platform))
     (vendor/doctrine/orm/src/Internal/Hydration/AbstractHydrator.php:336)
  at Doctrine\ORM\Internal\Hydration\AbstractHydrator->gatherRowData(array('id_0' => 68861, 'username_1' => '68861minnakhmetovnalogin', 'username_canonical_2' => '68861minnakhmetovnalogin', 'email_3' => 'minnakhmetovna@mail.ru', 'email_canonical_4' => 'minnakhmetovna@mail.ru', 'roles_5' => '["ROLE_USER"]', 'password_6' => '$2y$13$p2oDoTeMq7KKMp8rRnKW9.Goh9HPbUHIgwxRRI.OKkLuwNkGB7xtG', 'enabled_7' => 1, 'locked_8' => 0, 'created_9' => 1764607154, 'rating_10' => null, 'avatar_11' => 'N;', 'game_count_12' => null, 'game_victory_13' => null, 'firstname_14' => 'Юлдуз', 'blogname_15' => 'minnakhmetovna', 'surname_16' => 'Нургалимова', 'birthday_17' => 'NULL', 'gender_18' => 'NULL', 'notification_19' => 0, 'school_20' => null, 'class_21' => null, 'city_22' => null, 'confirmation_token_23' => null, 'password_requested_at_24' => null, 'x1_25' => null, 'x2_26' => null, 'y1_27' => null, 'y2_28' => null, 'card_in_last_game_29' => null, 'district_id_30' => 27, 'game_id_31' => 41847), array('b' => '|68861'), array('b' => true))
     (vendor/doctrine/orm/src/Internal/Hydration/ObjectHydrator.php:327)
  at Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData(array('id_0' => 68861, 'username_1' => '68861minnakhmetovnalogin', 'username_canonical_2' => '68861minnakhmetovnalogin', 'email_3' => 'minnakhmetovna@mail.ru', 'email_canonical_4' => 'minnakhmetovna@mail.ru', 'roles_5' => '["ROLE_USER"]', 'password_6' => '$2y$13$p2oDoTeMq7KKMp8rRnKW9.Goh9HPbUHIgwxRRI.OKkLuwNkGB7xtG', 'enabled_7' => 1, 'locked_8' => 0, 'created_9' => 1764607154, 'rating_10' => null, 'avatar_11' => 'N;', 'game_count_12' => null, 'game_victory_13' => null, 'firstname_14' => 'Юлдуз', 'blogname_15' => 'minnakhmetovna', 'surname_16' => 'Нургалимова', 'birthday_17' => 'NULL', 'gender_18' => 'NULL', 'notification_19' => 0, 'school_20' => null, 'class_21' => null, 'city_22' => null, 'confirmation_token_23' => null, 'password_requested_at_24' => null, 'x1_25' => null, 'x2_26' => null, 'y1_27' => null, 'y2_28' => null, 'card_in_last_game_29' => null, 'district_id_30' => 27, 'game_id_31' => 41847), array(object(User)))
     (vendor/doctrine/orm/src/Internal/Hydration/ObjectHydrator.php:147)
  at Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData()
     (vendor/doctrine/orm/src/Internal/Hydration/AbstractHydrator.php:171)
  at Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll(object(Result), object(ResultSetMapping), array())
     (vendor/doctrine/orm/src/AbstractQuery.php:948)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:891)
  at Doctrine\ORM\AbstractQuery->execute(null, 1)
     (vendor/doctrine/orm/src/AbstractQuery.php:689)
  at Doctrine\ORM\AbstractQuery->getResult()
     (src/AdminBundle/Repository/UserRepository.php:50)
  at App\AdminBundle\Repository\UserRepository->findBlog(array('page' => '55', 'max_results' => 20, 'filter' => array('alphabet' => 'DESC')))
     (src/BlogBundle/Controller/UserController.php:193)
  at App\BlogBundle\Controller\UserController->listAction(object(Request))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:182)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (public/index.php:32)