4images Forum & Community
4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: flattley 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:
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