Bug #58019: FAL Indexer for broken files: Column 'width' cannot be null - TYPO3 Core - TYPO3 Forge

Custom queries

Accessibility
Easy tasks
Forge Triage
JavaScript issues
JavaScript Issues (w/o Epics/Stories)
My open issues
No feedback within 90 days
Open Bugs
Open issues of 10
Recently modified
Regressions
Stabilization Issues
Usability or UX

Watchers (1)

Christian Ludwig

Actions

Copy link

Bug #58019

closed

FAL Indexer for broken files: Column 'width' cannot be null

Added by Philipp Gampe over 10 years ago. Updated almost 9 years ago.

Status:

Rejected

Priority:

Must have

Assignee:

Category:

File Abstraction Layer (FAL)

Target version:

7.1 (Cleanup)

Start date:

2014-04-17

Due date:

% Done:

Estimated time:

TYPO3 Version:

6.2

PHP Version:

5.5

Tags:

Complexity:

easy

Is Regression:

Yes

Sprint Focus:

Description

The FAL indexer fails to properly handle broken files.

To reproduce:
Create a text file with any content and name it test.jpg. Upload this via the backend or just place it in the fileadmin directory.
Visit the folder containing the file in the file module to trigger the indexing.
The indexing will fail and a NULL value is handled on to the database.

Note: I consider this to be a regression, because broken files did not break the file list before.

Files

fake-jpeg.jpeg (16 Bytes) fake-jpeg.jpeg

A text file

Philipp Gampe, 2014-09-16 01:23

Related issues 5 (0 open — 5 closed)

Related to TYPO3 Core - Bug #62400: Lot of entries in sys_file_processed with name=NULL and identifier empty

Rejected

Andreas Wolf

2014-10-22

Actions

Related to TYPO3 Core - Bug #61181: FAL: file maxW and maxH are ignored

Rejected

2014-08-25

Actions

Related to TYPO3 Core - Bug #44105: Image size does not get updated

Closed

2012-12-19

Actions

Related to TYPO3 Core - Bug #59216: Image dimensions (width/height) are 0 when not scaled

Closed

2014-05-30

Actions

Is duplicate of TYPO3 Core - Bug #64616: Compare Database does not remove 'NOT NULL'

Closed

2015-01-29

Actions

Issue # Delay: days Cancel

History
Notes
Property changes

Actions

Copy link

Updated by Oliver Hader over 10 years ago

Status changed from Accepted to Needs Feedback

What is breaking in this regard? I followed your suggestion and uploaded a text/plain file and faked the "jpg" file name extension.
The file list tries to show an image, which of course does not work (thus, instead of using the extension, the MIME type should be used).
However, I don't get any warnings, errors or exceptions. Besides that sys_file_metadata.width is set to "0" in my case...

Actions

Copy link

Updated by Alexander Opitz about 10 years ago

Status changed from Needs Feedback to Closed

No feedback within the last 90 days => closing this issue.

If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.

Actions

Copy link

Updated by Philipp Gampe about 10 years ago

Status changed from Closed to Accepted
PHP Version set to 5.5

Still present in master as of today: 424a9e331f45226bad2334af2ee97e9764351d5b

caller    TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR    Column 'width' cannot be null
lastBuiltQuery    INSERT INTO sys_file_processedfile (width,height,size,checksum,name,identifier,storage,configuration,task_type,configurationsha1,original,originalfilesha1,tstamp,crdate) VALUES (NULL,NULL,'0','13c99f5990','preview_fake-jpeg_13c99f5990.jpg','/_processed_/preview_fake-jpeg_13c99f5990.jpg','1','a:0:{}','Image.Preview','8739602554c7f3241958e3cc9b57fdecb474d508','14607','0828324174b10cc867b7255a84a8155cf89e1b8b','1410823214','1410823214')
debug_backtrace    require(o3/sysext/filelist/mod1/index.php),o3/mod.php#32 // TYPO3\CMS\Filelist\Controller\FileListController->main#21 // TYPO3\CMS\Filelist\FileList->generateList#308 // TYPO3\CMS\Filelist\FileList->getTable#189 // TYPO3\CMS\Filelist\FileList->formatFileList#339 // TYPO3\CMS\Core\Resource\File->process#657 // TYPO3\CMS\Core\Resource\ResourceStorage->processFile#307 // TYPO3\CMS\Core\Resource\Service\FileProcessingService->processFile#1224 // TYPO3\CMS\Core\Resource\Service\FileProcessingService->process#90 // TYPO3\CMS\Core\Resource\ProcessedFileRepository->add#127 // TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#131 // TYPO3\CMS\Core\Database\DatabaseConnection->debug#202

Actions

Copy link