2015-03-19 16:06:02 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority
2015-03-19 16:06:02 SQL: select language,name,text from site_text where (page='staticsync' or page='all') and (specific_to_group is null or specific_to_group=0)
2015-03-19 16:06:02 SQL: select file_path value from resource where length(file_path)>0 and file_path like '%/%'
2015-03-19 16:06:02 SQL: select ref,file_modified,file_path from resource where archive=0 and length(file_path)>0
2015-03-19 16:06:02 SQL: select value from sysvars where name='lastsync'
2015-03-19 16:06:02 SQL: insert into resource(resource_type,creation_date,archive,created_by) values ('1',now(),'2','')
2015-03-19 16:06:02 SQL: select resource_type value from resource where ref='10089'
2015-03-19 16:06:02 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0
2015-03-19 16:06:02 SQL: delete from resource_keyword where resource='10089' and keyword= ANY (select ref from keyword where keyword='10089') and resource_type_field='-1' limit 1
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count-1 where keyword='10089' limit 1
2015-03-19 16:06:02 adding 10089
2015-03-19 16:06:02 resolving keyword 10089. Create=true
2015-03-19 16:06:02 resolving normalized keyword 10089.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='10089'
2015-03-19 16:06:02 Creating new keyword for 10089
2015-03-19 16:06:02 SQL: insert into keyword (keyword,soundex,hit_count) values ('10089',left('0000',10),0)
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','23406','0','-1')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='23406'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23406'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Keyword added to resource','23406','1')
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Create resource' and object_ref='10089'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Create resource','10089','1')
2015-03-19 16:06:02 SQL: insert into resource_log(date,user,resource,type,resource_type_field,notes,diff,usageoption,purchase_size,purchase_price,access_key,previous_value) values (now(),null,'10089','c',null,'','','-1','','0',null,'')
2015-03-19 16:06:02 SQL: update resource set resource_type='1' where ref='10089'
2015-03-19 16:06:02 SQL: delete from resource_data where resource='10089' and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0)
2015-03-19 16:06:02 SQL: delete from resource_keyword where resource='10089' and resource_type_field!=-1 and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0)
2015-03-19 16:06:02 SQL: update resource set archive=0,file_path='2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg',file_extension='jpg',preview_extension='jpg',file_modified=now() where ref='10089'
2015-03-19 16:06:02 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='51'
2015-03-19 16:06:02 SQL: select value from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 SQL: select value from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 adding roadmap
2015-03-19 16:06:02 resolving keyword roadmap. Create=true
2015-03-19 16:06:02 resolving normalized keyword roadmap.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='roadmap'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3165','0','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='3165'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:02 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:02 adding slide2
2015-03-19 16:06:02 resolving keyword slide2. Create=true
2015-03-19 16:06:02 resolving normalized keyword slide2.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='slide2'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3167','1','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='3167'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:02 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,count) values ('2015','3','19','0','Keyword added to resource','3167','1')
2015-03-19 16:06:02 adding jpg
2015-03-19 16:06:02 resolving keyword jpg. Create=true
2015-03-19 16:06:02 resolving normalized keyword jpg.
2015-03-19 16:06:02 SQL: select ref value from keyword where keyword='jpg'
2015-03-19 16:06:02 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','45','2','51')
2015-03-19 16:06:02 SQL: update keyword set hit_count=hit_count+1 where ref='45'
2015-03-19 16:06:02 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='45'
2015-03-19 16:06:02 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='45'
2015-03-19 16:06:02 SQL: delete from resource_data where resource='10089' and resource_type_field='51'
2015-03-19 16:06:02 SQL: insert into resource_data(resource,resource_type_field,value) values ('10089','51','RoadMap_Slide2.jpg')
2015-03-19 16:06:02 SQL: update resource set field51='RoadMap_Slide2.jpg' where ref='10089'
2015-03-19 16:06:02 SQL: select file_path value from resource where ref='10089'
2015-03-19 16:06:02 SQL: select *,mapzoom from resource where ref='10089'
2015-03-19 16:06:02 SQL: select ref,type,exiftool_field,exiftool_filter,options,name from resource_type_field where length(exiftool_field)>0 and (resource_type='1' or resource_type='0') order by exiftool_field
2015-03-19 16:06:02 CLI command: '/usr/bin/exiftool' -s -s -f -m -d "%Y-%m-%d %H:%M:%S" -G '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'
2015-03-19 16:06:03 CLI output: [ExifTool] ExifToolVersion: 8.99
[File] FileName: RoadMap_Slide2.jpg
[File] Directory: /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills
[File] FileSize: 612 kB
[File] FileModifyDate: 2012-05-08 14:45:04
[File] FilePermissions: rw-r--r--
[File] FileType: JPEG
[File] MIMEType: image/jpeg
[File] ExifByteOrder: Big-endian (Motorola, MM)
[File] ImageWidth: 1920
[File] ImageHeight: 1440
[File] EncodingProcess: Baseline DCT, Huffman coding
[File] BitsPerSample: 8
[File] ColorComponents: 3
[File] YCbCrSubSampling: YCbCr4:2:0 (2 2)
[JFIF] JFIFVersion: 1.01
[EXIF] XResolution: 72
[EXIF] YResolution: 72
[EXIF] ResolutionUnit: inches
[EXIF] ModifyDate: 2012-05-08 14:44:54
[EXIF] ExifImageWidth: 1920
[EXIF] ExifImageHeight: 1440
[XMP] XMPToolkit: Adobe XMP Core 5.2-c003 61.141987, 2011/02/22-12:03:51
[XMP] InstanceID: xmp.iid:B0157BE51620681192B094CB94162DA0
[XMP] DocumentID: xmp.did:AE157BE51620681192B094CB94162DA0
[XMP] OriginalDocumentID: xmp.did:AE157BE51620681192B094CB94162DA0
[XMP] MetadataDate: 2012-05-08 14:45:04
[XMP] VideoAlphaMode: None
[XMP] VideoFrameRate: 0.000000
[XMP] HistoryAction: saved, saved
[XMP] HistoryInstanceID: xmp.iid:AF157BE51620681192B094CB94162DA0, xmp.iid:B0157BE51620681192B094CB94162DA0
[XMP] HistoryWhen: 2012-05-08 14:44:54, 2012-05-08 14:45:04
[XMP] HistorySoftwareAgent: Adobe Premiere Pro 5.5, Adobe Premiere Pro 5.5
[XMP] HistoryChanged: /metadata;/content, /metadata
[XMP] VideoFrameSizeW: 1920
[XMP] VideoFrameSizeH: 1440
[XMP] VideoFrameSizeUnit: pixel
[Photoshop] CopyrightFlag: False
[Photoshop] IPTCDigest: d41d8cd98f00b204e9800998ecf8427e
[ICC_Profile] ProfileCMMType: appl
[ICC_Profile] ProfileVersion: 2.2.0
[ICC_Profile] ProfileClass: Display Device Profile
[ICC_Profile] ColorSpaceData: RGB
[ICC_Profile] ProfileConnectionSpace: XYZ
[ICC_Profile] ProfileDateTime: 2009-02-25 11:26:11
[ICC_Profile] ProfileFileSignature: acsp
[ICC_Profile] PrimaryPlatform: Apple Computer Inc.
[ICC_Profile] CMMFlags: Not Embedded, Independent
[ICC_Profile] DeviceManufacturer: appl
[ICC_Profile] DeviceModel:
[ICC_Profile] DeviceAttributes: Reflective, Glossy, Positive, Color
[ICC_Profile] RenderingIntent: Perceptual
[ICC_Profile] ConnectionSpaceIlluminant: 0.9642 1 0.82491
[ICC_Profile] ProfileCreator: appl
[ICC_Profile] ProfileID: 0
[ICC_Profile] ProfileDescription: Generic RGB Profile
[ICC_Profile] ProfileDescriptionML-sk-SK: Všeobecný RGB profil
[ICC_Profile] ProfileDescriptionML-hr-HR: Generički RGB profil
[ICC_Profile] ProfileDescriptionML-ca-ES: Perfil RGB genèric
[ICC_Profile] ProfileDescriptionML-pt-BR: Perfil RGB Genérico
[ICC_Profile] ProfileDescriptionML-uk-UA: –ó–∞–≥–∞–ª—å–Ω–∏–π –ø—Ä–æ—Ñ–∞–π–ª RGB
[ICC_Profile] ProfileDescriptionML-fr-FU: Profil générique RVB
[ICC_Profile] ProfileDescriptionML-zh-TW: 通用 RGB 色彩描述
[ICC_Profile] ProfileDescriptionML-it-IT: Profilo RGB generico
[ICC_Profile] ProfileDescriptionML-nb-NO: Generisk RGB-profil
[ICC_Profile] ProfileDescriptionML-ko-KR: 일반 RGB 프로파일
[ICC_Profile] ProfileDescriptionML-cs-CZ: Obecn√Ω RGB profil
[ICC_Profile] ProfileDescriptionML-he-IL: פרופיל RGB כללי
[ICC_Profile] ProfileDescriptionML-de-DE: Allgemeines RGB-Profil
[ICC_Profile] ProfileDescriptionML-hu-HU: Általános RGB profil
[ICC_Profile] ProfileDescriptionML-sv-SE: Generisk RGB-profil
[ICC_Profile] ProfileDescriptionML-zh-CN: 普通 RGB 描述文件
[ICC_Profile] ProfileDescriptionML-ja-JP: 一般 RGB プロファイル
[ICC_Profile] ProfileDescriptionML-ro-RO: Profil RGB generic
[ICC_Profile] ProfileDescriptionML-el-GR: Γενικό προφίλ RGB
[ICC_Profile] ProfileDescriptionML-pt-PO: Perfil RGB genérico
[ICC_Profile] ProfileDescriptionML-nl-NL: Algemeen RGB-profiel
[ICC_Profile] ProfileDescriptionML-es-ES: Perfil RGB genérico
[ICC_Profile] ProfileDescriptionML-th-TH: โปรไฟล์ RGB ทั่วไป
[ICC_Profile] ProfileDescriptionML-tr-TR: Genel RGB Profili
[ICC_Profile] ProfileDescriptionML-fi-FI: Yleinen RGB-profiili
[ICC_Profile] ProfileDescriptionML-pl-PL: Uniwersalny profil RGB
[ICC_Profile] ProfileDescriptionML-ru-RU: –û–±—â–∏–π –ø—Ä–æ—Ñ–∏–ª—å RGB
[ICC_Profile] ProfileDescriptionML-ar-EG: ملف تعريف RGB العام
[ICC_Profile] ProfileDescriptionML: Generic RGB Profile
[ICC_Profile] ProfileDescriptionML-da-DK: Generel RGB-beskrivelse
[ICC_Profile] ProfileCopyright: Copyright 2007 Apple Inc., all rights reserved.
[ICC_Profile] MediaWhitePoint: 0.95047 1 1.0891
[ICC_Profile] RedMatrixColumn: 0.4543 0.24191 0.01489
[ICC_Profile] GreenMatrixColumn: 0.35335 0.67363 0.09064
[ICC_Profile] BlueMatrixColumn: 0.15665 0.08446 0.71957
[ICC_Profile] RedTRC: (Binary data 14 bytes, use -b option to extract)
[ICC_Profile] ChromaticAdaptation: 1.04788 0.02292 -0.0502 0.02957 0.99049 -0.01706 -0.00923 0.01508 0.75165
[ICC_Profile] BlueTRC: (Binary data 14 bytes, use -b option to extract)
[ICC_Profile] GreenTRC: (Binary data 14 bytes, use -b option to extract)
[Composite] ImageSize: 1920x1440
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 Exiftool: extracted field 'EXIFTOOL:EXIFTOOLVERSION', value is '8.99'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILENAME', value is 'RoadMap_Slide2.jpg'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:DIRECTORY', value is '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILESIZE', value is '612 kB'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILEMODIFYDATE', value is '2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILEPERMISSIONS', value is 'rw-r--r--'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:FILETYPE', value is 'JPEG'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:MIMETYPE', value is 'image/jpeg'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:EXIFBYTEORDER', value is 'Big-endian (Motorola, MM)'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:IMAGEWIDTH', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:IMAGEHEIGHT', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:ENCODINGPROCESS', value is 'Baseline DCT, Huffman coding'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:BITSPERSAMPLE', value is '8'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:COLORCOMPONENTS', value is '3'
2015-03-19 16:06:03 Exiftool: extracted field 'FILE:YCBCRSUBSAMPLING', value is 'YCbCr4:2:0 (2 2)'
2015-03-19 16:06:03 Exiftool: extracted field 'JFIF:JFIFVERSION', value is '1.01'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:XRESOLUTION', value is '72'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:YRESOLUTION', value is '72'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:RESOLUTIONUNIT', value is 'inches'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:MODIFYDATE', value is '2012-05-08 14:44:54'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:EXIFIMAGEWIDTH', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field 'EXIF:EXIFIMAGEHEIGHT', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:XMPTOOLKIT', value is 'Adobe XMP Core 5.2-c003 61.141987, 2011/02/22-12:03:51'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:INSTANCEID', value is 'xmp.iid:B0157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:DOCUMENTID', value is 'xmp.did:AE157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:ORIGINALDOCUMENTID', value is 'xmp.did:AE157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:METADATADATE', value is '2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:VIDEOALPHAMODE', value is 'None'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:VIDEOFRAMERATE', value is '0.000000'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:HISTORYACTION', value is 'saved, saved'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:HISTORYINSTANCEID', value is 'xmp.iid:AF157BE51620681192B094CB94162DA0, xmp.iid:B0157BE51620681192B094CB94162DA0'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:HISTORYWHEN', value is '2012-05-08 14:44:54, 2012-05-08 14:45:04'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:HISTORYSOFTWAREAGENT', value is 'Adobe Premiere Pro 5.5, Adobe Premiere Pro 5.5'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:HISTORYCHANGED', value is '/metadata;/content, /metadata'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:VIDEOFRAMESIZEW', value is '1920'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:VIDEOFRAMESIZEH', value is '1440'
2015-03-19 16:06:03 Exiftool: extracted field 'XMP:VIDEOFRAMESIZEUNIT', value is 'pixel'
2015-03-19 16:06:03 Exiftool: extracted field 'PHOTOSHOP:COPYRIGHTFLAG', value is 'False'
2015-03-19 16:06:03 Exiftool: extracted field 'PHOTOSHOP:IPTCDIGEST', value is 'd41d8cd98f00b204e9800998ecf8427e'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILECMMTYPE', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEVERSION', value is '2.2.0'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILECLASS', value is 'Display Device Profile'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:COLORSPACEDATA', value is 'RGB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILECONNECTIONSPACE', value is 'XYZ'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDATETIME', value is '2009-02-25 11:26:11'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEFILESIGNATURE', value is 'acsp'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PRIMARYPLATFORM', value is 'Apple Computer Inc.'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:CMMFLAGS', value is 'Not Embedded, Independent'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:DEVICEMANUFACTURER', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:DEVICEMODEL', value is ''
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:DEVICEATTRIBUTES', value is 'Reflective, Glossy, Positive, Color'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:RENDERINGINTENT', value is 'Perceptual'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:CONNECTIONSPACEILLUMINANT', value is '0.9642 1 0.82491'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILECREATOR', value is 'appl'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEID', value is '0'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTION', value is 'Generic RGB Profile'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-SK-SK', value is 'Všeobecný RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-HR-HR', value is 'Generički RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-CA-ES', value is 'Perfil RGB genèric'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-PT-BR', value is 'Perfil RGB Genérico'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-UK-UA', value is '–ó–∞–≥–∞–ª—å–Ω–∏–π –ø—Ä–æ—Ñ–∞–π–ª RGB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-FR-FU', value is 'Profil générique RVB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-ZH-TW', value is '通用 RGB 色彩描述'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-IT-IT', value is 'Profilo RGB generico'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-NB-NO', value is 'Generisk RGB-profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-KO-KR', value is '일반 RGB 프로파일'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-CS-CZ', value is 'Obecn√Ω RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-HE-IL', value is 'פרופיל RGB כללי'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-DE-DE', value is 'Allgemeines RGB-Profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-HU-HU', value is 'Általános RGB profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-SV-SE', value is 'Generisk RGB-profil'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-ZH-CN', value is '普通 RGB 描述文件'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-JA-JP', value is '一般 RGB プロファイル'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-RO-RO', value is 'Profil RGB generic'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-EL-GR', value is 'Γενικό προφίλ RGB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-PT-PO', value is 'Perfil RGB genérico'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-NL-NL', value is 'Algemeen RGB-profiel'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-ES-ES', value is 'Perfil RGB genérico'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-TH-TH', value is 'โปรไฟล์ RGB ทั่วไป'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-TR-TR', value is 'Genel RGB Profili'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-FI-FI', value is 'Yleinen RGB-profiili'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-PL-PL', value is 'Uniwersalny profil RGB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-RU-RU', value is '–û–±—â–∏–π –ø—Ä–æ—Ñ–∏–ª—å RGB'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-AR-EG', value is 'ملف تعريف RGB العام'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML', value is 'Generic RGB Profile'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILEDESCRIPTIONML-DA-DK', value is 'Generel RGB-beskrivelse'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:PROFILECOPYRIGHT', value is 'Copyright 2007 Apple Inc., all rights reserved.'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:MEDIAWHITEPOINT', value is '0.95047 1 1.0891'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:REDMATRIXCOLUMN', value is '0.4543 0.24191 0.01489'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:GREENMATRIXCOLUMN', value is '0.35335 0.67363 0.09064'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:BLUEMATRIXCOLUMN', value is '0.15665 0.08446 0.71957'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:REDTRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:CHROMATICADAPTATION', value is '1.04788 0.02292 -0.0502 0.02957 0.99049 -0.01706 -0.00923 0.01508 0.75165'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:BLUETRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field 'ICC_PROFILE:GREENTRC', value is '(Binary data 14 bytes, use -b option to extract)'
2015-03-19 16:06:03 Exiftool: extracted field 'COMPOSITE:IMAGESIZE', value is '1920x1440'
2015-03-19 16:06:03 SQL: SELECT resource.file_path FROM resource WHERE resource.ref = 10089
2015-03-19 16:06:03 EXIF - option for field 73 : yes
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='73'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='10089' and resource_type_field='73'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='10089' and resource_type_field='73'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('10089','73','0000626688')
2015-03-19 16:06:03 EXIF - option for field 71 : yes
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='71'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='10089' and resource_type_field='71'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='10089' and resource_type_field='71'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('10089','71','1920x1440')
2015-03-19 16:06:03 EXIF - custom option for filename field 51 : yes
2015-03-19 16:06:03 SQL: select file_extension value from resource where ref = '10089'
2015-03-19 16:06:03 SQL: select resource_type, name from resource left join resource_type on resource.resource_type = resource_type.ref where resource.ref = '10089'
2015-03-19 16:06:03 SQL: select resource_type value from resource where ref='10089'
2015-03-19 16:06:03 use perms: 1
2015-03-19 16:06:03 SQL: select d.value,d.resource_type_field,f.*,f.required frequired,f.ref fref from resource_type_field f left join (select * from resource_data where resource='10089') d on d.resource_type_field=f.ref and d.resource='10089' where ( f.resource_type=0 or f.resource_type=999 or f.resource_type='1') group by f.ref order by f.resource_type,f.order_by,f.ref
2015-03-19 16:06:03 SQL: select ref value from resource_type
2015-03-19 16:06:03 fieldProject Name=
2015-03-19 16:06:03 fieldSigned model release on file=
2015-03-19 16:06:03 fieldCCR Client=
2015-03-19 16:06:03 fieldTitle=
2015-03-19 16:06:03 fieldOriginal Filename=RoadMap_Slide2.jpg
2015-03-19 16:06:03 fieldKeywords=
2015-03-19 16:06:03 fieldCaption=
2015-03-19 16:06:03 fieldExtracted Text=
2015-03-19 16:06:03 fieldCountry=
2015-03-19 16:06:03 fieldNamed Person(s)=
2015-03-19 16:06:03 fieldDate=
2015-03-19 16:06:03 fieldCredit=
2015-03-19 16:06:03 fieldExpiry Date=
2015-03-19 16:06:03 fieldNotes=
2015-03-19 16:06:03 fieldWebsite=
2015-03-19 16:06:03 fieldFile Size=0000626688
2015-03-19 16:06:03 fieldCamera Make / Model=
2015-03-19 16:06:03 fieldSource=
2015-03-19 16:06:03 fieldImage Size=1920x1440
2015-03-19 16:06:03 SQL: select resource_type value from resource where ref='10089'
2015-03-19 16:06:03 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0
2015-03-19 16:06:03 SQL: select keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='8'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='10089' and resource_type_field='8'
2015-03-19 16:06:03 SQL: select value from resource_data where resource='10089' and resource_type_field='8'
2015-03-19 16:06:03 adding 2014
2015-03-19 16:06:03 resolving keyword 2014. Create=true
2015-03-19 16:06:03 resolving normalized keyword 2014.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='2014'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','1464','0','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='1464'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='1464'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='1464'
2015-03-19 16:06:03 adding pss
2015-03-19 16:06:03 resolving keyword pss. Create=true
2015-03-19 16:06:03 resolving normalized keyword pss.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='pss'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','2216','1','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='2216'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='2216'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='2216'
2015-03-19 16:06:03 adding pssproject1
2015-03-19 16:06:03 resolving keyword pssproject1. Create=true
2015-03-19 16:06:03 resolving normalized keyword pssproject1.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='pssproject1'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','23401','2','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='23401'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23401'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23401'
2015-03-19 16:06:03 adding stills
2015-03-19 16:06:03 resolving keyword stills. Create=true
2015-03-19 16:06:03 resolving normalized keyword stills.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='stills'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','23350','3','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='23350'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23350'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='23350'
2015-03-19 16:06:03 adding roadmap
2015-03-19 16:06:03 resolving keyword roadmap. Create=true
2015-03-19 16:06:03 resolving normalized keyword roadmap.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='roadmap'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3165','4','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='3165'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3165'
2015-03-19 16:06:03 adding slide2
2015-03-19 16:06:03 resolving keyword slide2. Create=true
2015-03-19 16:06:03 resolving normalized keyword slide2.
2015-03-19 16:06:03 SQL: select ref value from keyword where keyword='slide2'
2015-03-19 16:06:03 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('10089','3167','5','8')
2015-03-19 16:06:03 SQL: update keyword set hit_count=hit_count+1 where ref='3167'
2015-03-19 16:06:03 SQL: select count(*) value from daily_stat where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:03 SQL: update daily_stat set count=count+1 where year='2015' and month='3' and day='19' and usergroup='0' and activity_type='Keyword added to resource' and object_ref='3167'
2015-03-19 16:06:03 SQL: delete from resource_data where resource='10089' and resource_type_field='8'
2015-03-19 16:06:03 SQL: insert into resource_data(resource,resource_type_field,value) values ('10089','8','2014 - PSS - pssproject1 - stills - RoadMap Slide2')
2015-03-19 16:06:03 SQL: update resource set field8='2014 - PSS - pssproject1 - stills - RoadMap Slide2' where ref='10089'
2015-03-19 16:06:03 create_previews(ref=10089,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=)
2015-03-19 16:06:03 SQL: update resource set file_checksum='' where ref='10089'
2015-03-19 16:06:03 SQL: update resource set preview_tweaks = '0|1' where ref = '10089'
2015-03-19 16:06:03 File source is /Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg
2015-03-19 16:06:03 create_previews_using_im(ref=10089,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=)
2015-03-19 16:06:03 CLI command: '/usr/local/bin/identify' -format %wx%h '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'[0]
2015-03-19 16:06:03 CLI output: 1920x1440
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 SQL: select * from preview_size order by width desc, height desc
2015-03-19 16:06:03 Contemplating hpr (sw=1920, tw=999999, sh=1440, th=999999, extension=jpg)
2015-03-19 16:06:03 Contemplating lpr (sw=1920, tw=2000, sh=1440, th=2000, extension=jpg)
2015-03-19 16:06:03 Contemplating scr (sw=1920, tw=850, sh=1440, th=850, extension=jpg)
2015-03-19 16:06:03 Generating preview size scr to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg
2015-03-19 16:06:03 CLI command: '/usr/local/bin/convert' '/Volumes/ccfs_footage/archive/2014/PSS/pssproject1/stills/RoadMap_Slide2.jpg'[0] +matte -flatten -quality 90 +matte -strip -colorspace RGB -resize 850x850">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'
2015-03-19 16:06:03 CLI output:
2015-03-19 16:06:03 CLI errors:
2015-03-19 16:06:03 Contemplating pre (sw=1920, tw=350, sh=1440, th=350, extension=jpg)
2015-03-19 16:06:03 Generating preview size pre to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089pre_29fea14a79341a9.jpg
2015-03-19 16:06:03 CLI command: '/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90 +matte -strip -colorspace RGB -resize 350x350">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089pre_29fea14a79341a9.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 Contemplating thm (sw=1920, tw=150, sh=1440, th=150, extension=jpg)
2015-03-19 16:06:04 Generating preview size thm to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089thm_d7e4ab2d1deed46.jpg
2015-03-19 16:06:04 CLI command: '/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90 +matte -strip -colorspace RGB -resize 150x150">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089thm_d7e4ab2d1deed46.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 Contemplating col (sw=1920, tw=75, sh=1440, th=75, extension=jpg)
2015-03-19 16:06:04 Generating preview size col to /Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089col_a4db3c1096eaf66.jpg
2015-03-19 16:06:04 CLI command: '/usr/local/bin/convert' '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089scr_0435949e7055704.jpg'[0] +matte -flatten -quality 90 +matte -strip -colorspace RGB -resize 75x75">" '/Library/WebServer/Documents/resourceSpace/include/../filestore/1/0/0/8/9_62ead458a327a7d/10089col_a4db3c1096eaf66.jpg'
2015-03-19 16:06:04 CLI output:
2015-03-19 16:06:04 CLI errors:
2015-03-19 16:06:04 SQL: update resource set image_red='945', image_green='105', image_blue='96',colour_key='NEKWR',thumb_width='150', thumb_height='113' where ref='10089'
2015-03-19 16:06:04 SQL: update resource set has_image=1,preview_extension='jpg',preview_attempts=0,file_modified=now() where ref='10089'
2015-03-19 16:06:04 SQL: update resource set access = '0' where ref = '10089'
2015-03-19 16:06:04 SQL: select ref,file_path from resource where archive=0 and length(file_path)>0 and file_path like '%/%'
2015-03-19 16:06:04 SQL: delete from collection where theme is not null and length(theme)>0 and (select count(*) from collection_resource cr where cr.collection=collection.ref)=0;
2015-03-19 16:06:04 SQL: update sysvars set value=now() where name='lastsync'