Issue Bug Closed

#87873SQL error while saving sys_file_storage with strict_type

Stefan Froemken 03/10/19, 23:07 updated 04/06/20, 10:49

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

  1. Gerrit Code Review pushed patch set 1 for master to change 60032 status New Under Review 03/11/19, 07:13

  2. Gerrit Code Review pushed patch set 1 for 9.5 to change 60052 03/11/19, 11:32

  3. Georg Ringer commented and changed status Under Review Resolved done 0 % 100 % 03/11/19, 12:00

    Applied in changeset commit:890aa066df18c6d28551376b433832100a28a42a.

  4. Gerrit Code Review pushed patch set 1 for TYPO3_8-7 to change 60072 status Resolved Under Review 03/11/19, 12:36

  5. Georg Ringer commented and changed status Under Review Resolved 03/11/19, 14:00

    Applied in changeset commit:0292643294efb36791d2c7f0ab50fb626e9d0286.

  6. Benni Mack changed status Resolved Closed 05/07/19, 12:10

  7. 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',
                ]
            ],