Photo Organizer

  • Status Closed
  • Percent Complete
  • Task Type Bug Report
  • Category Backend / Core
  • Assigned To No-one
  • Operating System All
  • Severity Low
  • Priority Very Low
  • Reported Version Devel
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Photo Organizer
Opened by marcus - 2009-10-18
Last edited by pizza - 2010-03-03

FS#423 - Error importing photos

The import of photos containing metadata with german umlauts lead to an database error. Testet with your devel demo site.

* Queueing 'DSC_1796.NEF' (Nikon Raw Format) for import.

1 images queued for import.

Importing 'DSC_1796.NEF' (Nikon Raw Format) into folder Fotos 2007.

* Extracting Image Metadata (XMP) ... done
* Extracting Image Metadata (EXIF) ... done
* Extracting Image Metadata (IPTC) ... done
* ERROR: invalid byte sequence for encoding "UTF8": 0xfc HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
* Failed to update database.

insert into photo_tech (identifier, photo, camera, film, scan_resolution, aperture, focal_length, shutter, camera_metering, camera_program, flash_mode, exposure_comp, flash_comp, ev_difference, iso_override, scan_bitdepth, scan_multiscan, exif, iptc, latitude, longitude, altitude, img_direction, rdf)
values (nextval('photo_tech_id_sequence'), 542, null,
null, null, 6.3,
16.0 , 39, null,
null, null, 20,
21, 21, 15,
null, null,
'ExifTool Version Number7.67File Size14 MBFile Modification Date/Time2009:10:18 14:06:50-04:00File TypeTIFFMIME Typeimage/tiffExif Byte OrderBig-endian (Motorola, MM)Image DescriptionBlick vom Hafen �ber den M�llner StadtseeMakeNIKON CORPORATIONCamera Model NameNIKON D300OrientationHorizontal (normal)SoftwareVer.1.10Modify Date2009:10:18 17:03:31.92ArtistMarcus HinzJpg From Raw Start132848Jpg From Raw Length1003387Y Cb Cr PositioningCo-sitedSubfile TypeFull-resolution ImageImage Width4352Image Height2868Bits Per Sample14CompressionNikon NEF CompressedPhotometric InterpretationColor Filter ArrayStrip Offsets1136236Samples Per Pixel1Rows Per Strip2868Strip Byte Counts13188018X Resolution300Y Resolution300Planar ConfigurationChunkyResolution UnitinchesCFA Repeat Pattern Dim2 2CFA Pattern 20 1 1 2Reference Black White0 255 0 255 0 255Copyright(C)2009 Marcus HinzCurrent IPTC Digest3ef0b8e6b3ae48da64204656f724855bURLhttp://fotoblog.hinz-moelln.deExposure Time1/160F Number6.3Exposure ProgramProgram AEISO200Date/Time Original2009:10:18 17:03:31.92Create Date2009:10:18 17:03:31.92Exposure Compensation-1/3Max Aperture Value3.5Metering ModeMulti-segmentLight SourceFine WeatherFlashNo FlashFocal Length16.0 mm (35 mm equivalent: 24.0 mm)Maker Note Version2.10QualityRawWhite BalanceSunnyFocus ModeAF-SFlash SettingNormalFlash TypeWhite Balance Fine Tune0 0Color Balance 11.5625 1.30859375 1 1Program Shift0Exposure Difference0Preview Image Start10472Preview Image Length122077Flash Exposure Compensation0ISO Setting200Flash Exposure Bracket Value0.0Exposure Bracket Value0Crop Hi SpeedOff (4352x2868 cropped to 4352x2868 at pixel 0,0)Serial Number4039580Color SpacesRGBVR Info Version0100Vibration ReductionOnImage AuthenticationOffActive D-LightingOffPicture Control Version0100Picture Control NameVividPicture Control BaseVividPicture Control AdjustFull ControlPicture Control Quick AdjustNormalBrightnessNormalHue AdjustmentNoneFilter Effectn/aToning Effectn/aToning Saturationn/aTimezone+01:00Daylight SavingsYesDate Display FormatD/M/YISO ExpansionOffISO2200ISO Expansion 2OffLens TypeG VRLens16-85mm f/3.5-5.6 G VRFlash ModeDid Not FireShooting ModeSingle-FrameAuto Bracket ReleaseNoneContrast Curve(Binary data 578 bytes, use -b option to extract)Shot Info Version0210NEF CompressionLosslessNoise ReductionOffLinearization Table(Binary data 46 bytes, use -b option to extract)WB GRBG Levels256 400 335 256Lens Data Version0203Exit Pupil Position128.0 mmAF Aperture3.6Focus Position0x33Focus Distance2.00 mLens ID Number153Lens F Stops5.33Min Focal Length16.3 mmMax Focal Length84.8 mmMax Aperture At Min Focal3.6Max Aperture At Max Focal5.7MCU Version155Effective Max Aperture3.6Raw Image Center2176 1434Retouch HistoryNoneShutter Count1825Flash Info Version0103Flash Model(none)External Flash Flags(none)Flash Commander ModeOffFlash Control ModeOffFlash Group A Control ModeOffFlash Group B Control ModeOffFlash Group C Control ModeOffFlash Group A Exposure Comp0Flash Group B Exposure Comp0Flash Group C Exposure Comp0Multi Exposure Version0100Multi Exposure ModeOffMulti Exposure Shots0Multi Exposure Auto GainOffHigh ISO Noise ReductionOffAF Info 2 Version0100AF Area ModeSingle AreaAuto FocusOnAF Points UsedD6File Info Version0100Directory Number101File Number1796User Commenthttp://www.hinz-moelln.deSub Sec Time92Sub Sec Time Original92Sub Sec Time Digitized92Sensing MethodOne-chip color areaFile SourceDigital CameraScene TypeDirectly photographedCustom RenderedNormalExposure ModeAutoDigital Zoom Ratio1Focal Length In 35mm Format24 mmScene Capture TypeStandardGain ControlNoneContrastNormalSaturationNormalSharpnessHardSubject Distance RangeUnknownGPS Version ID2.2.0.0GPS Latitude RefNorthGPS Longitude RefEastGPS Altitude RefAbove Sea LevelGPS Time Stamp15:03:31GPS Satellites0GPS Map DatumWGS-84GPS Date Stamp2009:10:18TIFF-EP Standard ID1 0 0 0Aperture6.3Blue Balance1.308594CFA Pattern[Red,Green][Green,Blue]GPS Altitude14 m Above Sea LevelGPS Date/Time2009:10:18 15:03:31GPS Latitude53 deg 37'' 30.73" NGPS Longitude10 deg 40'' 42.90" EGPS Position53 deg 37'' 30.73" N, 10 deg 40'' 42.90" EImage Size4352x2868Jpg From Raw(Binary data 1003387 bytes, use -b option to extract)Lens IDAF-S DX VR Zoom-Nikkor 16-85mm f/3.5-5.6G EDPreview Image(Binary data 122077 bytes, use -b option to extract)Red Balance1.5625Scale Factor To 35 mm Equivalent1.5Shutter Speed1/160Circle Of Confusion0.020 mmDepth Of Field81.00 m (1.01 - 82.01)Field Of View73.3 deg (2.97 m)Hyperfocal Distance2.03 mLight Value11.6', 'Coded Character SetUTF8Envelope Record Version4Object NameMöllner StadtseeKeywordshafen, herbst, stadtseeBy-lineMarcus HinzCityMöllnSub-locationMöllnProvince-StateSchleswig-HolsteinCountry-Primary Location CodeDEUCountry-Primary Location NameDeutschlandHeadlineMöllner StadtseeCopyright Notice(C)2009 Marcus HinzCaption-AbstractBlick vom Hafen über den Möllner StadtseeWriter-EditorMarcus HinzApplication Record Version4', 53.625202777778, 10.678583333333, 14, 0, '')

* Cleaning up the mess.

All images imported.

Closed by  pizza
2010-03-03 19:46
Reason for closing:  Fixed
Additional comments about closing:  I just fixed this, or at least it's fixed well enough to handle the image you attached. Sorry it's taken so long... I had to step away from PO for a while.
pizza commented on 2009-10-23 17:21

Can you attach the file you tried to import?

Here it is... Sorry for the big size.


Available keyboard shortcuts


Task Details

Task Editing