Bug #81751: LiveSearch in Backend broken using PostgreSQL - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #81751

closed

LiveSearch in Backend broken using PostgreSQL

Added by Stephan Großberndt almost 7 years ago. Updated over 5 years ago.

Status:

Closed

Priority:

Must have

Assignee:

Stephan Großberndt

Category:

Backend API

Target version:

Start date:

2017-06-30

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

Tags:

Complexity:

easy

Is Regression:

Sprint Focus:

On Location Sprint

Description

Using the Backend LiveSearch in PostgreSQL is currently not possible as invoking it creates an exception.

The search condition 'andWhere' => 'CType=\'text\' OR CType=\'textpic\' OR CType=\'textmedia\'' of field bodytext in table tt_content kills it when using PostgreSQL because the fieldname CType (note the uppercase letters) is not escaped, PostgreSQL assumes the field to be lowercase then and does not find a field named ctype. The correct escaping depends on the database driver (MySQL uses backticks, PostgreSQL uses double quotes).

        'bodytext' => [
            'l10n_mode' => 'prefixLangTitle',
            'label' => 'LLL:EXT:lang/Resources/Private/Language/locallang_general.xlf:LGL.text',
            'config' => [
                'type' => 'text',
                'cols' => '80',
                'rows' => '15',
                'softref' => 'typolink_tag,images,email[subst],url',
                'search' => [
                    'andWhere' => 'CType=\'text\' OR CType=\'textpic\' OR CType=\'textmedia\''
                ]
            ]
        ],

In issue #80506 a solution was implemented to fix such issues in TypoScript. This can be adapted to be used in TCA 'andWhere' conditions.

Related issues 3 (0 open — 3 closed)

Actions

Copy link

Updated by Stephan Großberndt almost 7 years ago

Related to Task #80506: Enable proper quoting of database fields in Typoscript added

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 5 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 6 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

Updated by Gerrit Code Review almost 7 years ago

Patch set 7 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#10

Updated by Susanne Moog almost 7 years ago

Sprint Focus set to On Location Sprint

Actions

Copy link

#11

Updated by Anja Leichsenring over 6 years ago

Sprint Focus deleted (~~On Location Sprint~~)

Actions

Copy link

#12

Updated by Benni Mack over 6 years ago

Sprint Focus set to On Location Sprint

Actions

Copy link

#13

Updated by Gerrit Code Review over 6 years ago

Patch set 8 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#14

Updated by Gerrit Code Review over 6 years ago

Patch set 9 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#15

Updated by Gerrit Code Review over 6 years ago

Patch set 10 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#16

Updated by Gerrit Code Review over 6 years ago

Patch set 11 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#17

Updated by Gerrit Code Review over 6 years ago

Patch set 12 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#18

Updated by Gerrit Code Review over 6 years ago

Patch set 13 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#19

Updated by Gerrit Code Review over 6 years ago

Patch set 14 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#20

Updated by Gerrit Code Review over 6 years ago

Patch set 15 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#21

Updated by Gerrit Code Review over 6 years ago

Patch set 16 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/53360

Actions

Copy link

#22

Updated by Gerrit Code Review over 6 years ago

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/54889

Actions

Copy link

#23