#87873SQL error while saving sys_file_storage with strict_type
Description
Hello Core-Team,
I have created my development environment in ddev container where MariaDB 10.2 is configured with strict_type on.
While saving a sys_file_storage record I get following error:
2: SQL error: 'Incorrect integer value: '' for column 'is_public' at row 1
For now I have deactivated strict_type, but I think it’s up to you, to store the correct value.
Stefan
Reviews 3
History 47
-
Gerrit Code Review pushed patch set 1 for master to change 60032 status
NewUnder Review 03/11/19, 07:13 -
Gerrit Code Review pushed patch set 1 for 9.5 to change 60052 03/11/19, 11:32
-
Georg Ringer commented and changed status
Under ReviewResolved done0 %100 % 03/11/19, 12:00 -
Gerrit Code Review pushed patch set 1 for TYPO3_8-7 to change 60072 status
ResolvedUnder Review 03/11/19, 12:36 -
Georg Ringer commented and changed status
Under ReviewResolved 03/11/19, 14:00Applied in changeset commit:0292643294efb36791d2c7f0ab50fb626e9d0286.
-
Benni Mack changed status
ResolvedClosed 05/07/19, 12:10 -
Rémy DANIEL commented 04/06/20, 10:49
Hi
I have this error on a 9.5.14:
SQL error: ‘Incorrect integer value: ‘’ for column `xxx`.`sys_file_storage`.`is_public` at row 1’ (sys_file_storage:2) (msg#1.2.12)
The TCA default for sys_file_storage.is_public is 1, so the issue is elsewhere.
Could it be the missing “items” definition? All the other “boolean” columns of this table have “items” but not “is_public”.'is_online' => [ 'label' => 'LLL:EXT:core/Resources/Private/Language/locallang_tca.xlf:sys_file_storage.is_online', 'config' => [ 'type' => 'check', 'renderType' => 'checkboxToggle', 'default' => 1, 'items' => [ [ 0 => '', 1 => '', ] ], ] ],'is_public' => [ 'label' => 'LLL:EXT:core/Resources/Private/Language/locallang_tca.xlf:sys_file_storage.is_public', 'config' => [ 'default' => 1, 'type' => 'user', 'renderType' => 'userSysFileStorageIsPublic', ] ],
Applied in changeset commit:890aa066df18c6d28551376b433832100a28a42a.