From: Stephan Großberndt <stephan@grossberndt.de>
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 <typo3@scripting-base.de>
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: Wouter Wolters <typo3@wouterwolters.nl>
---

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;