From: Stephan Großberndt Date: Tue, 26 Apr 2016 16:53:27 +0000 (+0200) Subject: [BUGFIX] Avoid SQL error in ProcessedFileChecksumUpdate X-Git-Tag: TYPO3_8-1-0~22 X-Git-Url: http://git.typo3.org/Packages/TYPO3.CMS.git/commitdiff_plain/c03be605def5fcb70f1e1d8ce2dadce51137cc21?ds=sidebyside [BUGFIX] Avoid SQL error in ProcessedFileChecksumUpdate Avoid an 'Illegal mix of collations'-SQL error when using collation utf8_unicode_ci and accessing the ProcessedFileChecksumUpdate wizard by casting both comparison arguments. Resolves: #75932 Related: #67708 Releases: master, 7.6 Change-Id: I3c7355eab35bf7d7301eaf10b87f7e5b00bd6908 Reviewed-on: https://review.typo3.org/47925 Reviewed-by: Andreas Fernandez Reviewed-by: Morton Jonuschat Tested-by: Morton Jonuschat Reviewed-by: Wouter Wolters Tested-by: Wouter Wolters --- diff --git a/typo3/sysext/install/Classes/Updates/ProcessedFileChecksumUpdate.php b/typo3/sysext/install/Classes/Updates/ProcessedFileChecksumUpdate.php index 214ea9f07934..aed94af13fbd 100644 --- a/typo3/sysext/install/Classes/Updates/ProcessedFileChecksumUpdate.php +++ b/typo3/sysext/install/Classes/Updates/ProcessedFileChecksumUpdate.php @@ -40,7 +40,7 @@ class ProcessedFileChecksumUpdate extends AbstractUpdate return false; } - $join = 'sys_file_processedfile LEFT JOIN sys_registry ON entry_key = CAST(sys_file_processedfile.uid AS CHAR) AND entry_namespace = \'ProcessedFileChecksumUpdate\''; + $join = 'sys_file_processedfile LEFT JOIN sys_registry ON CAST(entry_key AS CHAR) = CAST(sys_file_processedfile.uid AS CHAR) AND entry_namespace = \'ProcessedFileChecksumUpdate\''; $count = $this->getDatabaseConnection()->exec_SELECTcountRows('*', $join, '(entry_key IS NULL AND sys_file_processedfile.identifier <> \'\') OR sys_file_processedfile.width IS NULL'); if (!$count) { return false;