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: