While working on a recent Typo3 project, I used an Amazon S3 bucket to store all media files, in my case these were images and videos. As a driver I used the following extension. Until recently, it didn’t support extracting metadata like height and width when uploading images. This problems was fixed in one of the releases, see the information here.
After installing the update, metadata extraction worked for newly uploaded files, but the images, which were uploaded before the fix, still had width and height 0 in the table “sys_file_metadata”. In order to extract the metadata also from those files, I had to add two tasks using the scheduler: “File Abstraction Layer: Extract metadata in storage (scheduler)” and “File Abstraction Layer: Update storage index (scheduler)”.
After running the two tasks from the scheduler, I still didn’t have the metadata for any files in the table “sys_file_metadata”. I assume that this happened, because the scheduler ignored all files, probably depending on a previous run of the task. The only thing I had to do is overwriting the column “last_indexed” of the table “sys_file”. Use the following SQL statement on the typo3 database:
UPDATE `sys_file` SET `last_indexed`= 0 WHERE `storage` = 3
Note: I used the where statement, because the storage I used is a Amazon S3 bucket, identified as number “3” of the storages managed by typo3.
After overwriting the value of the column “last_indexed”, I was able to run the two tasks of the scheduler and the images were indexed and the metadata extracted.