xperseguers / t3ext-extractor

TYPO3 Extension extractor
https://extensions.typo3.org/extension/extractor
GNU General Public License v2.0
14 stars 23 forks source link

Meta Data Problems #48

Closed MediKathi closed 1 year ago

MediKathi commented 2 years ago

Hello, the Problem given in https://github.com/xperseguers/t3ext-extractor/issues/39 still remains. This time there was an array given instead of a string.

Also I got several errors with the iso_speed

An exception occurred while executing 'INSERT INTO `sys_file_metadata` (`file`, `pid`, `crdate`, `tstamp`, `cruser_id`, `l10n_diffsource`, `color_space`, `height`, `width`, `unit`, `camera_make`, `camera_model`, `shutter_speed`, `focal_length`, `iso_speed`, `aperture`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [323, 0, 1651479325, 1651479325, 22, "", "RGB", 1280, 1920, "px", "Canon", "Canon PowerShot G3 X", "1\/640", 14.6, "125, 0", 5]: Data truncated for column 'iso_speed' at row 1 
davidlemaitre commented 1 year ago

Facing the same issue with some images imported from a custom import command. A workaround solution is to change column type to VARCHAR(10)

LeoniePhiline commented 1 year ago

This is fixed in #53.

@xperseguers Would you mind merging #53 and releasing v2.2.1?

Thanks!


@davidlemaitre

In the mean time, you can use my fork, containing the fix:

{
  "repositories": [
    {
      "type": "git",
      "url": "https://github.com/LeoniePhiline/t3ext-extractor.git"
    }
  ],
  "require": {
    "causal/extractor": "dev-master#ff54dd9893bda059c5da0d25c01a468233cff665"
  }
}