Project

General

Profile

Actions

Bug #63991

closed

FAL override checkboxes are always active, when DBAL is installed

Added by Armin Vieweg over 9 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
File Abstraction Layer (FAL)
Target version:
-
Start date:
2014-12-19
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
6.2
PHP Version:
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

In backend module "Filelist" you are able to set meta informations for any files. When inserting a file to content you are also able to override some meta informations (Title, Alt, Description) for this single use.

When DBAL is active the checkboxes 'Override "Default Value"?' are always active, even if the input below is empty:

This also affects the frontend and API. When you try to output eg. the "title" using the method TYPO3\CMS\Core\Resource\FileReference->getProperty() it is empty, because of set checkbox in backend and empty input field. If you fill in the value, then you will get it. But the default value, filled in Filelist module is not available, at all.

This bug seams to appear when saving the relation. Because when you have DBAL deactivated and add a file to content, and then activate DBAL, this problem does not appear (checkboxes keep as set before). Even when updating the relation after DBAL has been installed again this problem does not appear. It just appears for new relations, apparently.


Files

2014-12-19_1456.png (28.4 KB) 2014-12-19_1456.png Armin Vieweg, 2014-12-19 15:07

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #53662: DatabaseConnection INSERTquery does not allow NULL valuesClosed2013-11-15

Actions
Actions #1

Updated by Marc Bastian Heinrichs over 9 years ago

Seems like DBAL doesn't like the NULL value for the fields, which was introduced for this feature.

Actions #2

Updated by Andreas Kienast over 9 years ago

Which DBMS do you use with DBAL?

Actions #3

Updated by Armin Vieweg over 9 years ago

Andreas Fernandez wrote:

Which DBMS do you use with DBAL?

mysqli. We just use DBAL to define a different database for several tables.

Actions #4

Updated by Armin Vieweg about 9 years ago

The call of fullQuoteArray($row, $table, $no_quote_fields); looks typically like this in DBAL. The fourth parameter $allowNull will never be set. Its default is FALSE. That is the reason why NULL is always replaced by empty string.

Therefore all fields using mode=useOrOverridePlaceholder will fail, if DBAL is installed.

Actions #5

Updated by Gerrit Code Review about 9 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 http://review.typo3.org/36545

Actions #6

Updated by Gerrit Code Review about 9 years ago

Patch set 1 for branch TYPO3_6-2 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/37701

Actions #7

Updated by Armin Vieweg about 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #8

Updated by Benni Mack over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF