[BUGFIX] Change DB field folder for sys_file_collection to allow NULL 46/45346/3
authorMorton Jonuschat <m.jonuschat@mojocode.de>
Fri, 18 Dec 2015 08:15:42 +0000 (09:15 +0100)
committerWouter Wolters <typo3@wouterwolters.nl>
Wed, 30 Dec 2015 16:59:58 +0000 (17:59 +0100)
Change the database schema to not require a value in the optional folder
column of the sys_file_collection table. Data for this field is only
provided when the type of collection created in the backend is based on
a folder, leading to errors in MySQL strict mode.

Resolves: #72305
Releases: master, 7.6
Change-Id: I35520061d5194db8328a43fe6e0d1887972ab889
Reviewed-on: https://review.typo3.org/45346
Reviewed-by: Benni Mack <benni@typo3.org>
Tested-by: Benni Mack <benni@typo3.org>
Reviewed-by: Oliver Hader <oliver.hader@typo3.org>
Reviewed-by: Wouter Wolters <typo3@wouterwolters.nl>
Tested-by: Wouter Wolters <typo3@wouterwolters.nl>
typo3/sysext/core/Configuration/TCA/sys_file_collection.php
typo3/sysext/core/ext_tables.sql

index e7cf8a2..9326060 100644 (file)
@@ -160,6 +160,7 @@ return array(
                 'renderType' => 'selectSingle',
                 'items' => array(),
                 'itemsProcFunc' => 'typo3/sysext/core/Classes/Resource/Service/UserFileMountService.php:TYPO3\CMS\Core\Resource\Service\UserFileMountService->renderTceformsSelectDropdown',
+                'default' => '',
             )
         ),
         'recursive' => array(
index 9435672..bcc8812 100644 (file)
@@ -464,7 +464,7 @@ CREATE TABLE sys_file_collection (
 
        # for type=folder:
        storage int(11) DEFAULT '0' NOT NULL,
-       folder text NOT NULL,
+       folder text,
        recursive tinyint(4) DEFAULT '0' NOT NULL,
 
        # for type=category: