TYPO3 Core

Uncaught TYPO3 Exception

An exception occurred while executing 'SELECT `uid`, `sys_language_uid` FROM `sys_file_metadata` WHERE (`uid` IN (?, ?)) AND (`sys_language_uid` IN (?, ?)) GROUP BY `sys_language_uid`' with params ["41", "3", "0", 0]: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'website.sys_file_metadata.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Doctrine\DBAL\Exception\DriverException thrown in file

/opt/website/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 115.

29 Doctrine\DBAL\Driver\AbstractMySQLDriver::convertException("An exception occurred while executing 'SELECT `uid…s is incompatible with sql_mode=only_full_group_by", Doctrine\DBAL\Driver\Mysqli\MysqliException)

/opt/website/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:

00126:

00127: if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DriverException) {

00128: return $driver->convertException($msg, $driverEx);

00129: }

00130:

28 Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\Mysqli\Driver, Doctrine\DBAL\Driver\Mysqli\MysqliException, "SELECT `uid`, `sys_language_uid` FROM `sys_file_me…nguage_uid` IN (?, ?)) GROUP BY `sys_language_uid`", array)

/opt/website/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:

00853: }

00854: } catch (\Exception $ex) {

00855: throw DBALException::driverExceptionDuringQuery($this->_driver, $ex, $query, $this->resolveParams($params, $types));

00856: }

00857:

27 Doctrine\DBAL\Connection::executeQuery("SELECT `uid`, `sys_language_uid` FROM `sys_file_me…nguage_uid` IN (?, ?)) GROUP BY `sys_language_uid`", array, array)

/opt/website/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php:

00204: {

00205: if ($this->type == self::SELECT) {

00206: return $this->connection->executeQuery($this->getSQL(), $this->params, $this->paramTypes);

00207: } else {

00208: return $this->connection->executeUpdate($this->getSQL(), $this->params, $this->paramTypes);

26 Doctrine\DBAL\Query\QueryBuilder::execute()

/opt/website/current/vendor/typo3/cms/typo3/sysext/core/Classes/Database/Query/QueryBuilder.php:

00185: $originalWhereConditions = $this->addAdditionalWhereConditions();

00186:

00187: $result = $this->concreteQueryBuilder->execute();

00188:

00189: // Restore the original query conditions in case the user keeps

25 TYPO3\CMS\Core\Database\Query\QueryBuilder::execute()

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php:

00245: )

00246: ->groupBy($languageField)

00247: ->execute()

00248: ->fetchAll();

00249:

24 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInputPlaceholders::getPossibleUidsByCurrentSysLanguage(array, "sys_file_metadata", "0")

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php:

00126: && isset($result['currentSysLanguage'])

00127: ) {

00128: $possibleUids = $this->getPossibleUidsByCurrentSysLanguage($possibleUids, $foreignTableName, $result['currentSysLanguage']);

00129: }

00130: $relatedFormData = $this->getRelatedFormData($foreignTableName, $possibleUids[0], $fieldNameArray[0]);

23 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInputPlaceholders::getPlaceholderValue(array, array, 1)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php:

00134: $relatedFormData['currentSysLanguage'] = $result['databaseRow'][$GLOBALS['TCA'][$result['tableName']]['ctrl']['languageField']][0];

00135: }

00136: $value = $this->getPlaceholderValue($fieldNameArray, $relatedFormData, $recursionLevel + 1);

00137: }

00138:

22 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInputPlaceholders::getPlaceholderValue(array, array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInputPlaceholders.php:

00056: 1

00057: );

00058: $result['processedTca']['columns'][$fieldName]['config']['placeholder'] = $this->getPlaceholderValue($fieldNameArray, $result);

00059: }

00060:

21 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInputPlaceholders::addData(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/OrderedProviderList.php:

00057: }

00058:

00059: $result = $provider->addData($result);

00060: }

00061:

20 TYPO3\CMS\Backend\Form\FormDataGroup\OrderedProviderList::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/TcaDatabaseRecord.php:

00037: );

00038:

00039: return $orderedProviderList->compile($result);

00040: }

00041: }

19 TYPO3\CMS\Backend\Form\FormDataGroup\TcaDatabaseRecord::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataCompiler.php:

00097: $resultKeysBeforeFormDataGroup = array_keys($result);

00098:

00099: $result = $this->formDataGroup->compile($result);

00100:

00101: if (!is_array($result)) {

18 TYPO3\CMS\Backend\Form\FormDataCompiler::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInline.php:

00387: // and $combinationChild is the child-child. For 1:n "normal" relations,

00388: // $mainChild is just the normal child record and $combinationChild is empty.

00389: $mainChild = $formDataCompiler->compile($formDataCompilerInput);

00390: if ($parentConfig['foreign_selector'] && $parentConfig['appearance']['useCombination']) {

00391: try {

17 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInline::compileChild(array, "image", 11)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInline.php:

00160: foreach ($connectedUids as $childUid) {

00161: try {

00162: $result['processedTca']['columns'][$fieldName]['children'][] = $this->compileChild($result, $fieldName, $childUid);

00163: } catch (DatabaseRecordException $e) {

00164: // The child could not be compiled, probably it was deleted and a dangling mm record exists

16 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInline::resolveRelatedRecords(array, "image")

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataProvider/TcaInline.php:

00056: }

00057: if ($result['inlineResolveExistingChildren']) {

00058: $result = $this->resolveRelatedRecords($result, $fieldName);

00059: $result = $this->addForeignSelectorAndUniquePossibleRecords($result, $fieldName);

00060: }

15 TYPO3\CMS\Backend\Form\FormDataProvider\TcaInline::addData(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/OrderedProviderList.php:

00057: }

00058:

00059: $result = $provider->addData($result);

00060: }

00061:

14 TYPO3\CMS\Backend\Form\FormDataGroup\OrderedProviderList::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataGroup/TcaDatabaseRecord.php:

00037: );

00038:

00039: return $orderedProviderList->compile($result);

00040: }

00041: }

13 TYPO3\CMS\Backend\Form\FormDataGroup\TcaDatabaseRecord::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Form/FormDataCompiler.php:

00097: $resultKeysBeforeFormDataGroup = array_keys($result);

00098:

00099: $result = $this->formDataGroup->compile($result);

00100:

00101: if (!is_array($result)) {

12 TYPO3\CMS\Backend\Form\FormDataCompiler::compile(array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:

01023: }

01024:

01025: $formData = $formDataCompiler->compile($formDataCompilerInput);

01026:

01027: // Set this->viewId if possible

11 TYPO3\CMS\Backend\Controller\EditDocumentController::makeEditForm()

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:

00929:

00930: // Creating the editing form, wrap it with buttons, document selector etc.

00931: $editForm = $this->makeEditForm();

00932: if ($editForm) {

00933: $this->firstEl = reset($this->elementsData);

10 TYPO3\CMS\Backend\Controller\EditDocumentController::main()

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Controller/EditDocumentController.php:

02111:

02112: $this->init();

02113: $this->main();

02114:

02115: $response->getBody()->write($this->moduleTemplate->renderContent());

9 TYPO3\CMS\Backend\Controller\EditDocumentController::mainAction(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)

8 call_user_func_array(array, array)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RouteDispatcher.php:

00052: $targetIdentifier = $route->getOption('target');

00053: $target = $this->getCallableFromTarget($targetIdentifier);

00054: return call_user_func_array($target, [$request, $response]);

00055: }

00056:

7 TYPO3\CMS\Backend\Http\RouteDispatcher::dispatch(TYPO3\CMS\Core\Http\ServerRequest, TYPO3\CMS\Core\Http\Response)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RequestHandler.php:

00137: /** @var RouteDispatcher $dispatcher */

00138: $dispatcher = GeneralUtility::makeInstance(RouteDispatcher::class);

00139: return $dispatcher->dispatch($request, $response);

00140: }

00141: }

6 TYPO3\CMS\Backend\Http\RequestHandler::dispatch(TYPO3\CMS\Core\Http\ServerRequest)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/RequestHandler.php:

00070: // Check if the router has the available route and dispatch.

00071: try {

00072: return $this->dispatch($request);

00073: } catch (InvalidRequestTokenException $e) {

00074: // When token was invalid redirect to login

5 TYPO3\CMS\Backend\Http\RequestHandler::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/opt/website/current/vendor/typo3/cms/typo3/sysext/core/Classes/Core/Bootstrap.php:

00313:

00314: // Execute the command which returns a Response object or NULL

00315: $this->response = $requestHandler->handleRequest($request);

00316: return $this;

00317: }

4 TYPO3\CMS\Core\Core\Bootstrap::handleRequest(TYPO3\CMS\Core\Http\ServerRequest)

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Classes/Http/Application.php:

00090: }

00091:

00092: $this->bootstrap->handleRequest($this->request);

00093:

00094: if ($execute !== null) {

3 TYPO3\CMS\Backend\Http\Application::run()

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php:

00022: $classLoader = require __DIR__ . '/../../../../../../vendor/autoload.php';

00023:

00024: (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();

00025: });

2 {closure}()

/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php:

00023:

00024: (new \TYPO3\CMS\Backend\Http\Application($classLoader))->run();

00025: });

1 require("/opt/website/current/vendor/typo3/cms/typo3/sysext/backend/Resources/Private/Php/backend.php")

/opt/website/current/vendor/typo3/cms/typo3/index.php:

00001: <?php

00002:

00003: require __DIR__ . '/sysext/backend/Resources/Private/Php/backend.php';