Author Topic: Issue with EXIF  (Read 2725 times)

0 Members and 1 Guest are viewing this topic.

Offline flattley

  • Newbie
  • *
  • Posts: 19
    • View Profile
Issue with EXIF
« on: January 13, 2017, 07:49:16 PM »
Has anyone else had a problem recently with EXIF data not being written to the database?

This has been running fine up until tonight and my EXIF data is not being written to the database since upgrading to 1.8

The info is there in the photo properties when I view it outside of the gallery.

-- EDIT --

I get the following error when trying to update the EXIF data:

Code: [Select]
DB Error: Bad SQL Query: UPDATE cwgal_images SET image_id = '29647',image_Make = 'Apple',image_Model = 'iPhone 7 Plus',image_ExposureTime = '1/1008 sec(s)',image_FNumber = 'F/1.8',image_ISOSpeedRatings = '32',image_DateTimeOriginal = '11.01.2017 12:10:41',image_ApertureValue = 'F/1.7',image_ExposureBiasValue = '0 EV',image_MeteringMode = 'Multi-Segment',image_Flash = 'Forced Light',image_FocalLength = '4 mm',image_WhiteBalance = 'Automatic',image_GPSLatitudeRef = 'North',image_GPSLatitude = 'North 50� 6' 35.99'' (50.109997222222)',image_GPSLongitudeRef = 'East',image_GPSLongitude = 'East 8� 40' 55.33'' (8.6820361111111)',image_GPSAltitude = '134.50165016502 metres above sea level' WHERE image_id = 29647
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '35.99'' (50.109997222222)',image_GPSLongitudeRef = 'East',image_GPSLongitude = '' at line 1
... EXIF UPDATE

I can't find the file where this is pulling the code from and I am unsure how I would escape the ' in the Lat/Lng also
« Last Edit: January 13, 2017, 10:57:02 PM by wilcochris »