(1/2)
Doctrine\DBAL\Exception\DriverException
An exception occurred while executing 'SELECT `uid`, `sys_language_uid`, `l10n_parent`, `l18n_cfg`, `pid`, `slug`, `mount_pid`, `mount_pid_ol`, `t3ver_state`, `doktype`, `t3ver_wsid`, `t3ver_oid` FROM `pages` WHERE (`sys_language_uid` = ?) AND (`slug` IN (?, ?, ?, ?, ?)) AND ((`pages`.`deleted` = 0) AND ((`pages`.`t3ver_wsid` = 0) AND (`t3ver_state` <> 2))) ORDER BY `slug` desc, `t3ver_wsid` desc, `mount_pid_ol` asc, `mount_pid` asc' with params [0, "\/fichiers\/Affiche de\u0301bat BNF 26 nov soir-1.pdf\/", "\/fichiers\/Affiche de\u0301bat BNF 26 nov soir-1.pdf", "\/fichiers\/", "\/fichiers", "\/"]:
Illegal mix of collations for operation 'in'
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128
case '1566':
return new NotNullConstraintViolationException($message, $exception);
}
return new DriverException($message, $exception);
}
/**
* {@inheritdoc}
at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 182
return $driverEx;
}
if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
return $driver->convertException($msg, $driverEx);
}
return new Exception($msg, 0, $driverEx);
}
at Doctrine\DBAL\DBALException::wrapException()
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 159
}
$msg .= ":\n\n" . $driverEx->getMessage();
return self::wrapException($driver, $driverEx, $msg);
}
/**
* @deprecated
at Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 2226
Exception::driverExceptionDuringQuery(
$this->_driver,
$e,
$sql,
$this->resolveParams($params, $types)
)
);
}
at Doctrine\DBAL\Connection->handleExceptionDuringQuery()
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1313
$stmt = $connection->query($sql);
}
} catch (Throwable $e) {
$this->handleExceptionDuringQuery(
$e,
$sql,
$params,
$types
);
at Doctrine\DBAL\Connection->executeQuery()
in /sites/www/releases/20240320160426Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 212
public function execute()
{
if ($this->type === self::SELECT) {
return ForwardCompatibility\Result::ensure(
$this->connection->executeQuery($this->getSQL(), $this->params, $this->paramTypes)
);
}
return $this->connection->executeStatement($this->getSQL(), $this->params, $this->paramTypes);
at Doctrine\DBAL\Query\QueryBuilder->execute()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Database/Query/QueryBuilder.php line 300
$originalWhereConditions = $this->addAdditionalWhereConditions();
// @todo Call $this->concreteQueryBuilder->executeQuery()
// directly with doctrine/dbal:^3.2 raise in v12.
$return = $this->concreteQueryBuilder->execute();
// Restore the original query conditions in case the user keeps
// on modifying the state.
$this->concreteQueryBuilder->add('where', $originalWhereConditions, false);
at TYPO3\CMS\Core\Database\Query\QueryBuilder->executeQuery()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Routing/PageSlugCandidateProvider.php line 228
->addOrderBy('t3ver_wsid', 'desc')
// Sort pages that are not MountPoint pages before mount points
->addOrderBy('mount_pid_ol', 'asc')
->addOrderBy('mount_pid', 'asc')
->executeQuery();
$pages = [];
$siteFinder = GeneralUtility::makeInstance(SiteFinder::class);
$pageRepository = GeneralUtility::makeInstance(PageRepository::class, $this->context);
at TYPO3\CMS\Core\Routing\PageSlugCandidateProvider->getPagesFromDatabaseForCandidates()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Routing/PageSlugCandidateProvider.php line 82
$languages = array_merge($languages, $language->getFallbackLanguageIds());
}
// Iterate all defined languages in their configured order to get matching page candidates somewhere in the language fallback chain
foreach ($languages as $languageId) {
$pageCandidatesFromSlugsAndLanguage = $this->getPagesFromDatabaseForCandidates($slugCandidates, $languageId);
// Determine whether fetched page candidates qualify for the request. The incoming URL is checked against all
// pages found for the current URL and language.
foreach ($pageCandidatesFromSlugsAndLanguage as $candidate) {
$slugCandidate = '/' . trim($candidate['slug'], '/');
at TYPO3\CMS\Core\Routing\PageSlugCandidateProvider->getCandidatesForPath()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Routing/PageRouter.php line 153
// will handle this then.
// The prepended slash will ensure that the root page of the site tree will also be fetched
$prefixedUrlPath = '/' . ltrim($urlPath, '/');
$pageCandidates = $candidateProvider->getCandidatesForPath($prefixedUrlPath, $language);
// Stop if there are no candidates
if (empty($pageCandidates)) {
throw new RouteNotFoundException('No page candidates found for path "' . $prefixedUrlPath . '"', 1538389999);
at TYPO3\CMS\Core\Routing\PageRouter->matchRequest()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/PageResolver.php line 75
// Check for the route arguments or Query Parameter ID
try {
/** @var PageArguments $pageArguments */
$pageArguments = $site->getRouter()->matchRequest($request, $previousResult);
$request = $request->withAttribute('routing', $pageArguments);
} catch (RouteNotFoundException $e) {
return GeneralUtility::makeInstance(ErrorController::class)->pageNotFoundAction(
$request,
at TYPO3\CMS\Frontend\Middleware\PageResolver->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/workspaces/Classes/Middleware/WorkspacePreview.php line 128
$addInformationAboutDisabledCache = true;
$setCookieOnCurrentRequest = false;
}
$response = $handler->handle($request);
$tsfe = $this->getTypoScriptFrontendController();
if ($tsfe instanceof TypoScriptFrontendController && $addInformationAboutDisabledCache) {
$tsfe->set_no_cache('GET Parameter ADMCMD_prev=LIVE was given', true);
at TYPO3\CMS\Workspaces\Middleware\WorkspacePreview->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/StaticRouteResolver.php line 80
return new HtmlResponse($content, 200, ['Content-Type' => $contentType]);
}
}
return $handler->handle($request);
}
/**
* Find the proper configuration for the static route in the static route configuration. Mainly:
at TYPO3\CMS\Frontend\Middleware\StaticRouteResolver->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/SiteBaseRedirectResolver.php line 94
$uri = $requestedUri->withPath(rtrim($requestedUri->getPath(), '/'));
return new RedirectResponse($uri, 307);
}
}
return $handler->handle($request);
}
/**
* Checks if the language is allowed in Frontend, if not, check if there is valid BE user
at TYPO3\CMS\Frontend\Middleware\SiteBaseRedirectResolver->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/redirects/Classes/Http/Middleware/RedirectHandler.php line 89
return $response;
}
}
return $handler->handle($request);
}
protected function buildRedirectResponse(UriInterface $uri, array $redirectRecord): ResponseInterface
{
at TYPO3\CMS\Redirects\Http\Middleware\RedirectHandler->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/adminpanel/Classes/Middleware/AdminPanelInitiator.php line 55
MainController::class
);
$request = $adminPanelController->initialize($request);
}
return $handler->handle($request);
}
}
at TYPO3\CMS\Adminpanel\Middleware\AdminPanelInitiator->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/FrontendUserAuthenticator.php line 97
if ($this->context->getAspect('frontend.user')->isLoggedIn() && $rateLimiter) {
$rateLimiter->reset();
}
$response = $handler->handle($request);
// Store session data for fe_users if it still exists
if ($frontendUser instanceof FrontendUserAuthentication) {
$frontendUser->storeSessionData();
at TYPO3\CMS\Frontend\Middleware\FrontendUserAuthenticator->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/BackendUserAuthenticator.php line 78
Bootstrap::loadExtTables();
$this->setBackendUserAspect($GLOBALS['BE_USER']);
}
$response = $handler->handle($request);
// If, when building the response, the user is still available, then ensure that the headers are sent properly
if ($this->context->getAspect('backend.user')->isLoggedIn()) {
return $this->applyHeadersToResponse($response);
at TYPO3\CMS\Frontend\Middleware\BackendUserAuthenticator->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/MaintenanceMode.php line 55
) {
return GeneralUtility::makeInstance(ErrorController::class)->unavailableAction($request, 'This page is temporarily unavailable.');
}
// Continue the regular stack if no maintenance mode is active
return $handler->handle($request);
}
}
at TYPO3\CMS\Frontend\Middleware\MaintenanceMode->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/SiteResolver.php line 65
$request = $request->withAttribute('routing', $routeResult);
if ($routeResult->getLanguage() instanceof SiteLanguage) {
Locales::setSystemLocaleFromSiteLanguage($routeResult->getLanguage());
}
return $handler->handle($request);
}
}
at TYPO3\CMS\Frontend\Middleware\SiteResolver->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Middleware/NormalizedParamsAttribute.php line 45
*/
public function process(ServerRequestInterface $request, RequestHandlerInterface $handler): ResponseInterface
{
$request = $request->withAttribute('normalizedParams', NormalizedParams::createFromRequest($request));
return $handler->handle($request);
}
}
at TYPO3\CMS\Core\Middleware\NormalizedParamsAttribute->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3conf/ext/vhs/Classes/Middleware/RequestAvailability.php line 14
{
public function process(ServerRequestInterface $request, RequestHandlerInterface $handler): ResponseInterface
{
$GLOBALS['TYPO3_REQUEST'] = $GLOBALS['TYPO3_REQUEST'] ?? $request;
return $handler->handle($request);
}
}
at FluidTYPO3\Vhs\Middleware\RequestAvailability->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Middleware/VerifyHostHeader.php line 55
1396795884
);
}
return $handler->handle($request);
}
/**
* Checks if the provided host header value matches the trusted hosts pattern.
at TYPO3\CMS\Core\Middleware\VerifyHostHeader->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Middleware/TimeTrackerInitialization.php line 58
$this->timeTracker->setEnabled($timeTrackingEnabled);
$this->timeTracker->start(microtime(true));
$this->timeTracker->push('');
$response = $handler->handle($request);
// Finish time tracking
$this->timeTracker->pull();
$this->timeTracker->finish();
at TYPO3\CMS\Frontend\Middleware\TimeTrackerInitialization->process()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 172
if (!$middleware instanceof MiddlewareInterface) {
throw new \InvalidArgumentException(get_class($middleware) . ' does not implement ' . MiddlewareInterface::class, 1516821342);
}
return $middleware->process($request, $this->next);
}
};
}
}
at Psr\Http\Server\RequestHandlerInterface@anonymous /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php:138$35f->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/MiddlewareDispatcher.php line 78
* @return ResponseInterface
*/
public function handle(ServerRequestInterface $request): ResponseInterface
{
return $this->tip->handle($request);
}
/**
* Seed the middleware stack with the inner request handler
at TYPO3\CMS\Core\Http\MiddlewareDispatcher->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/AbstractApplication.php line 86
*/
public function handle(ServerRequestInterface $request): ResponseInterface
{
try {
$response = $this->requestHandler->handle($request);
} catch (ImmediateResponseException $exception) {
$response = $exception->getResponse();
}
return $response;
at TYPO3\CMS\Core\Http\AbstractApplication->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/frontend/Classes/Http/Application.php line 69
// Create new request object having applicationType "I am a frontend request" attribute.
$request = $request->withAttribute('applicationType', SystemEnvironmentBuilder::REQUESTTYPE_FE);
$this->initializeContext();
return parent::handle($request);
}
/**
* Create a PSR-7 Response that redirects to the install tool
at TYPO3\CMS\Frontend\Http\Application->handle()
in /sites/www/releases/20240320160426Z/web/typo3/sysext/core/Classes/Http/AbstractApplication.php line 100
* @param callable $execute Deprecated, will be removed in TYPO3 v12.0
*/
final public function run(callable $execute = null)
{
$response = $this->handle(ServerRequestFactory::fromGlobals());
if ($execute !== null) {
trigger_error('Custom execution of Application code will be removed in TYPO3 v12.0, use PSR-15 Middlewares instead.', E_USER_DEPRECATED);
$execute();
}
at TYPO3\CMS\Core\Http\AbstractApplication->run()
in /sites/www/releases/20240320160426Z/web/index.php line 20
// Set up the application for the frontend
call_user_func(static function () {
$classLoader = require dirname(__DIR__).'/vendor/autoload.php';
\TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::run(0, \TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::REQUESTTYPE_FE);
\TYPO3\CMS\Core\Core\Bootstrap::init($classLoader)->get(\TYPO3\CMS\Frontend\Http\Application::class)->run();
});
at {closure}()
in /sites/www/releases/20240320160426Z/web/index.php line 21
call_user_func(static function () {
$classLoader = require dirname(__DIR__).'/vendor/autoload.php';
\TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::run(0, \TYPO3\CMS\Core\Core\SystemEnvironmentBuilder::REQUESTTYPE_FE);
\TYPO3\CMS\Core\Core\Bootstrap::init($classLoader)->get(\TYPO3\CMS\Frontend\Http\Application::class)->run();
});