Bug #87855
Updated by Oliver Hader about 5 years ago
Hey, if we have our mysql configured that "sql_mode" has option ONLY_FULL_GROUP_BY enabled we get this error: <pre> Core: Exception handler (WEB): Uncaught TYPO3 Exception: An exception occurred while executing 'SELECT `ISEC`.*, `IP`.*, MAX(`IR`.`flags`) AS `order_val1`, SUM(`IR`.`freq`) AS `order_val2` FROM `index_phash` `IP`, `index_section` `ISEC`, `index_words` `IW`, `index_rel` `IR` WHERE (`IP`.`phash` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`IP`.`sys_language_uid` = 0) AND (`ISEC`.`phash` = `IP`.`phash`) AND (`ISEC`.`page_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`IW`.`wid` = `IR`.`wid`) AND (`ISEC`.`phash` = `IR`.`phash`) AND (`IW`.`metaphone` = '236360654') GROUP BY `IP`.`phash`, `ISEC`.`phash`, `ISEC`.`phash_t3`, `ISEC`.`rl0`, `ISEC`.`rl1`, `ISEC`.`rl2`, `ISEC`.`page_id`, `ISEC`.`uniqid`, `IP`.`phash_grouping`, `IP`.`data_filename`, `IP`.`data_page_id`, `IP`.`data_page_reg1`, `IP`.`data_page_type`, `IP`.`data_page_mp`, `IP`.`gr_list`, `IP`.`item_type`, `IP`.`item_title`, `IP`.`item_description`, `IP`.`item_mtime`, `IP`.`tstamp`, `IP`.`item_size`, `IP`.`contentHash`, `IP`.`crdate`, `IP`.`parsetime`, `IP`.`sys_language_uid`, `IP`.`item_crdate`, `IP`.`cHashParams`, `IP`.`externalUrl`, `IP`.`recordUid`, `IP`.`freeIndexUid`, `IP`.`freeIndexSetId` ORDER BY `order_val1` DESC, `order_val2` DESC' with params [9015782, 43437476, 64875351, 73643714, 81925491, 88605078, 95998721, 97287112, 118353222, 124077205, 126891362, 158985898, 170926166, 174990755, 180309938, 181055417, 225146476, 231739081, 246129675, 254429896, 260439973, 263170134, 131, 110, 20, 21, 22, 126, 23, 112, 115, 117, 113, 118, 119, 114, 133, 134, 111, 19, 24, 13, 120, 121, 132, 2, 3, 140, 4, 5, 6, 122, 11, 12, 1]: 'dbname.IP.static_page_arguments' isn't in GROUP BY | Doctrine\DBAL\Exception\DriverException thrown in file /var/www/typo3/typo3_source/typo3_src-9.5.5/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php in line 126. Requested URL: http://mydomain/iskanje?tx_indexedsearch_pi2%%5Baction%%5D=search&tx_indexedsearch_pi2%%5Bcontroller%%5D=Search&cHash=723567e661557f17c933efa0ccd4e9cc </pre> Is this something that needs to be fixed?