Website www.wirelessleiden.nl: geen thumbnails

[huub]

Er worden bij nieuwe foto's geen thumbnails gemaakt, foto's worden wel geupload. Zie album ​http://www.wirelessleiden.nl/album/index.php/AJSoft/Tijdelijke-ontmanteling-06-20

[rick]

Taak Exif-gegevens uitlezen gestart (taak id 66)
exception 'Database_Exception' with message '#1264: Out of range value for column 'captured' at row 1 [ UPDATE `items`
SET `captured` = 4102130139, `updated` = 1415089701
WHERE `id` = '14363' ]' in /usr/local/www/gallery3/system/libraries/Database_Mysqli_Result.php:27
Stack trace:
#0 /usr/local/www/gallery3/system/libraries/Database_Mysqli.php(79): Database_Mysqli_Result_Core->__construct(false, 'UPDATE `items`\n...', Object(mysqli), true)
#1 /usr/local/www/gallery3/system/libraries/Database.php(272): Database_Mysqli_Core->query_execute('UPDATE `items`\n...')
#2 /usr/local/www/gallery3/modules/gallery/libraries/MY_Database.php(48): Database_Core->query('UPDATE `items`\n...')
#3 /usr/local/www/gallery3/system/libraries/Database_Builder.php(973): Database->query('UPDATE `items`\n...')
#4 /usr/local/www/gallery3/system/libraries/ORM.php(804): Database_Builder_Core->execute(Object(Database_Mysqli))
#5 /usr/local/www/gallery3/modules/gallery/libraries/MY_ORM.php(34): ORM_Core->save()
#6 /usr/local/www/gallery3/modules/gallery/libraries/ORM_MPTT.php(79): ORM->save()
#7 /usr/local/www/gallery3/modules/gallery/models/item.php(457): ORM_MPTT_Core->save()
#8 /usr/local/www/gallery3/modules/exif/helpers/exif.php(70): Item_Model_Core->save()
#9 /usr/local/www/gallery3/modules/exif/helpers/exif_task.php(60): exif_Core::extract(Object(Item_Model))
#10 [internal function]: exif_task_Core::update_index(Object(Task_Model))
#11 /usr/local/www/gallery3/modules/gallery/helpers/task.php(90): call_user_func_array('exif_task::upda...', Array)
#12 /usr/local/www/gallery3/modules/gallery/controllers/admin_maintenance.php(195): task_Core::run('66')
#13 [internal function]: Admin_Maintenance_Controller->run('66')
#14 /usr/local/www/gallery3/modules/gallery/controllers/admin.php(62): call_user_func_array(Array, Array)
#15 [internal function]: Admin_Controller->__call('maintenance', Array)
#16 /usr/local/www/gallery3/system/core/Kohana.php(331): ReflectionMethod->invokeArgs(Object(Admin_Controller), Array)
#17 [internal function]: Kohana_Core::instance(NULL)
#18 /usr/local/www/gallery3/system/core/Event.php(208): call_user_func_array(Array, Array)
#19 /usr/local/www/gallery3/application/Bootstrap.php(67): Event_Core::run('system.execute')
#20 /usr/local/www/gallery3/index.php(116): require('/usr/local/www/...')
#21 {main}
#1264: Out of range value for column 'captured' at row 1 [ UPDATE `items`
SET `captured` = 4102130139, `updated` = 1415089701
WHERE `id` = '14363' ]

captured is geen geldige INT value, ga zoeken wat de column betekend en hoe dit aan te passen is.

[rick]

Een plaatje met capture stamp ver in de toekomst is de oorzaak:

[rvdzwet@wasus /usr/local/www/gallery3]$ date -r 4102130139
Mon Dec 28 08:35:39 UTC 2099

[rvdzwet@wasus /usr/local/www/gallery3]$  identify -format '%[EXIF:*]' var/albums/events/wirelesskaraman/008.jpg 
exif:ApertureValue=1198/256
exif:BrightnessValue=2645/256
exif:ColorSpace=1
exif:ComponentsConfiguration=0, 0, 0, 0
exif:Compression=6
exif:Contrast=0
exif:CustomRendered=0
exif:DateTime=                   
exif:DateTimeDigitized=2099:12:28 08:35:39
exif:DateTimeOriginal=2099:12:28 08:35:39
exif:ExifImageLength=2608
exif:ExifImageWidth=1952
exif:ExifOffset=202
exif:ExifVersion=48, 50, 50, 48
exif:ExposureBiasValue=0/256
exif:ExposureMode=0
exif:ExposureProgram=2
exif:ExposureTime=62/100000
exif:Flash=28
exif:FlashPixVersion=48, 48, 49, 48
exif:FNumber=500/100
exif:FocalLength=760/100
exif:GainControl=2
exif:InteroperabilityIndex=R98
exif:InteroperabilityOffset=664
exif:InteroperabilityVersion=0, 0, 0, 48
exif:ISOSpeedRatings=100
exif:JPEGInterchangeFormat=788
exif:JPEGInterchangeFormatLength=7875
exif:LightSource=23
exif:Make=Hewlett-Packard
exif:MakerNote=12
exif:MeteringMode=2
exif:Model=HP PhotoSmart C935 (V03.67)
exif:Orientation=1
exif:ResolutionUnit=2
exif:Saturation=0
exif:SceneCaptureType=0
exif:Sharpness=0
exif:ShutterSpeedValue=2727/256
exif:WhiteBalance=0
exif:XResolution=72/1
exif:YCbCrPositioning=1
exif:YResolution=72/1

[rvdzwet@wasus /usr/local/www/gallery3]$ ls -alh var/albums/events/wirelesskaraman/008.jpg 
-rw-r--r--  1 www  www   2.0M Aug 11  2013 var/albums/events/wirelesskaraman/008.jpg

EXIF informatie van defecte plaatje verwijderd:

[rvdzwet@wasus /usr/local/www/gallery3]$ sudo cp var/albums/events/wirelesskaraman/008.jpg /tmp 
[rvdzwet@wasus /usr/local/www/gallery3]$ sudo convert /tmp/008.jpg -strip var/albums/events/wirelesskaraman/008.jpg

Thumbnails komen weer tevoorschijn.