2016-07-22 10:18:38 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:38 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:38 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:38 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:38 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:38 SQL: select language,name,text from site_text where (page='message' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:38 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:38 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:38 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:38 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:38 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:38 SQL: select ref value from collection where ref='67' 2016-07-22 10:18:38 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:38 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:38 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:38 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:38 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:38 SQL: SELECT user_message.ref, user.username AS owner, user_message.seen, message.created, message.expires, message.message, message.url FROM `user_message` INNER JOIN `message` ON user_message.message=message.ref LEFT OUTER JOIN `user` ON message.owner=user.ref WHERE user_message.user='4' AND message.expires > NOW() AND user_message.seen='0' ORDER BY user_message.ref ASC 2016-07-22 10:18:44 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:44 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:44 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:44 SQL: select language,name,text from site_text where (page='edit' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:44 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'edit' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:44 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:44 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:44 SQL: select ref value from collection where ref='67' 2016-07-22 10:18:44 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:44 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:44 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'edit' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:44 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:44 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:44 SQL: select *,mapzoom from resource where ref='-4' 2016-07-22 10:18:44 SQL: select config_options value from resource_type where ref='1' 2016-07-22 10:18:44 SQL: update resource set resource_type='1' where ref='-4' 2016-07-22 10:18:44 SQL: delete from resource_data where resource='-4' and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0) 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and resource_type_field>0 and resource_type_field not in (select ref from resource_type_field where resource_type='1' or resource_type=999 or resource_type=0) 2016-07-22 10:18:44 SQL: select name value from resource_type where ref='1' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and resource_type_field='-2' 2016-07-22 10:18:44 adding photo 2016-07-22 10:18:44 resolving keyword photo. Create=true 2016-07-22 10:18:44 resolving normalized keyword photo. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='photo' 2016-07-22 10:18:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('-4','24','0','-2') 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count+1 where ref='24' 2016-07-22 10:18:44 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:44 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:44 SQL: select *,mapzoom from resource where ref='-4' 2016-07-22 10:18:44 SQL: select resource_type value from resource where ref='-4' 2016-07-22 10:18:44 use perms: 2016-07-22 10:18:44 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='-4') d on d.resource_type_field=f.ref and d.resource='-4' 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 2016-07-22 10:18:44 SQL: select ref value from resource_type 2016-07-22 10:18:44 fieldMaitre=, 2016-07-22 10:18:44 fieldTitle=jpeg test after tif 2016-07-22 10:18:44 fieldCaption= 2016-07-22 10:18:44 fieldKeywords - Subject=, 2016-07-22 10:18:44 fieldKeywords - Emotion=, 2016-07-22 10:18:44 fieldKeywords - Event=, 2016-07-22 10:18:44 fieldKeywords - Other= 2016-07-22 10:18:44 fieldNamed person(s)=Lama Guendun 2016-07-22 10:18:44 fieldCountry=, 2016-07-22 10:18:44 fieldDate=2016-07-22 10:17 2016-07-22 10:18:44 fieldOriginal filename= 2016-07-22 10:18:44 fieldExtracted text= 2016-07-22 10:18:44 fieldCredit= 2016-07-22 10:18:44 fieldNotes= 2016-07-22 10:18:44 fieldCamera make / model= 2016-07-22 10:18:44 fieldSource=, 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '76' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 SQL: delete from resource_data where resource='-4' and resource_type_field='8' 2016-07-22 10:18:44 SQL: insert into resource_data(resource,resource_type_field,value) values('-4','8','dudes') 2016-07-22 10:18:44 resolving keyword jpeg. Create=true 2016-07-22 10:18:44 resolving normalized keyword jpeg. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='jpeg' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='4429' and resource_type_field='8' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='4429' limit 1 2016-07-22 10:18:44 resolving keyword test. Create=true 2016-07-22 10:18:44 resolving normalized keyword test. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='test' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='37' and resource_type_field='8' and position='1' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='37' limit 1 2016-07-22 10:18:44 resolving keyword after. Create=true 2016-07-22 10:18:44 resolving normalized keyword after. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='after' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='4280' and resource_type_field='8' and position='2' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='4280' limit 1 2016-07-22 10:18:44 resolving keyword tif. Create=true 2016-07-22 10:18:44 resolving normalized keyword tif. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='tif' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='122' and resource_type_field='8' and position='3' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='122' limit 1 2016-07-22 10:18:44 adding dudes 2016-07-22 10:18:44 resolving keyword dudes. Create=true 2016-07-22 10:18:44 resolving normalized keyword dudes. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='dudes' 2016-07-22 10:18:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('-4','4108','0','8') 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count+1 where ref='4108' 2016-07-22 10:18:44 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4108' and external='0' 2016-07-22 10:18:44 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','4108','0','1') 2016-07-22 10:18:44 SQL: update resource set field8='dudes' where ref='-4' 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '73' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '75' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '74' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 SQL: delete from resource_data where resource='-4' and resource_type_field='29' 2016-07-22 10:18:44 resolving keyword lama. Create=true 2016-07-22 10:18:44 resolving normalized keyword lama. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='lama' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='56' and resource_type_field='29' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='56' limit 1 2016-07-22 10:18:44 resolving keyword guendun. Create=true 2016-07-22 10:18:44 resolving normalized keyword guendun. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='guendun' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='4416' and resource_type_field='29' and position='1' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='4416' limit 1 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '3' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 SQL: SELECT * FROM node WHERE resource_type_field = '54' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:44 resolving keyword 4. Create=true 2016-07-22 10:18:44 resolving normalized keyword 4. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='4' 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and keyword='54' and resource_type_field='-1' 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count-1 where ref='54' limit 1 2016-07-22 10:18:44 adding 4 2016-07-22 10:18:44 resolving keyword 4. Create=true 2016-07-22 10:18:44 resolving normalized keyword 4. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='4' 2016-07-22 10:18:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('-4','54','0','-1') 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count+1 where ref='54' 2016-07-22 10:18:44 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='54' and external='0' 2016-07-22 10:18:44 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='54' and external='0' 2016-07-22 10:18:44 SQL: select name value from resource_type where ref in (select resource_type from resource where ref='-4') 2016-07-22 10:18:44 SQL: delete from resource_keyword where resource='-4' and resource_type_field='-2' 2016-07-22 10:18:44 adding photo 2016-07-22 10:18:44 resolving keyword photo. Create=true 2016-07-22 10:18:44 resolving normalized keyword photo. 2016-07-22 10:18:44 SQL: select ref value from keyword where keyword='photo' 2016-07-22 10:18:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('-4','24','0','-2') 2016-07-22 10:18:44 SQL: update keyword set hit_count=hit_count+1 where ref='24' 2016-07-22 10:18:44 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:44 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:44 SQL: delete from resource_related where resource='-4' or related='-4' 2016-07-22 10:18:44 SQL: select resource_type value from resource where ref='-4' 2016-07-22 10:18:44 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0 2016-07-22 10:18:44 SQL: delete from resource_node where resource ='-4' and node in ('278','279','280','282','281','283','250','251','252','258','259','257','256','255','272','273','275','276','254','253','274','267','268','269','270','271','260','261','262','263','264','265','277','266','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249') 2016-07-22 10:18:44 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:44 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:44 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:44 SQL: select language,name,text from site_text where (page='upload_plupload' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:44 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'upload_plupload' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:44 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:44 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:44 SQL: select ref value from collection where ref='67' 2016-07-22 10:18:44 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:44 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:44 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'upload_plupload' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:44 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:44 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:44 SQL: select config_options value from resource_type where ref='1' 2016-07-22 10:18:44 SQL: insert into collection (name,user,created,allow_changes,cant_delete,session_id) values ('Upload 20160722101844','4',now(),'0','0',NULL) 2016-07-22 10:18:44 SQL: delete from collection_keyword where collection='69' 2016-07-22 10:18:45 SQL: select c.ref,c.name,c.keywords,u.fullname from collection c left join user u on u.ref=c.user where c.ref = '69' 2016-07-22 10:18:45 resolving keyword 69. Create=true 2016-07-22 10:18:45 resolving normalized keyword 69. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='69' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','233') 2016-07-22 10:18:45 resolving keyword upload 20160722101844. Create=true 2016-07-22 10:18:45 resolving normalized keyword upload 20160722101844. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='upload 20160722101844' 2016-07-22 10:18:45 Creating new keyword for upload 20160722101844 2016-07-22 10:18:45 SQL: insert into keyword (keyword,soundex,hit_count) values ('upload 20160722101844',left('U143',10),0) 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4766') 2016-07-22 10:18:45 resolving keyword karma tsultrim tcheupel. Create=true 2016-07-22 10:18:45 resolving normalized keyword karma tsultrim tcheupel. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='karma tsultrim tcheupel' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4197') 2016-07-22 10:18:45 resolving keyword upload. Create=true 2016-07-22 10:18:45 resolving normalized keyword upload. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='upload' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','45') 2016-07-22 10:18:45 resolving keyword 20160722101844. Create=true 2016-07-22 10:18:45 resolving normalized keyword 20160722101844. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='20160722101844' 2016-07-22 10:18:45 Creating new keyword for 20160722101844 2016-07-22 10:18:45 SQL: insert into keyword (keyword,soundex,hit_count) values ('20160722101844',left('0000',10),0) 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4767') 2016-07-22 10:18:45 resolving keyword karma. Create=true 2016-07-22 10:18:45 resolving normalized keyword karma. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='karma' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4199') 2016-07-22 10:18:45 resolving keyword tsultrim. Create=true 2016-07-22 10:18:45 resolving normalized keyword tsultrim. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='tsultrim' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4200') 2016-07-22 10:18:45 resolving keyword tcheupel. Create=true 2016-07-22 10:18:45 resolving normalized keyword tcheupel. 2016-07-22 10:18:45 SQL: select ref value from keyword where keyword='tcheupel' 2016-07-22 10:18:45 SQL: insert into collection_keyword values ('69','4201') 2016-07-22 10:18:45 SQL: select allowed_extensions value from resource_type where ref='1' 2016-07-22 10:18:45 SQL: update user set current_collection='69' where ref='4' 2016-07-22 10:18:45 SQL: select access_key,group_concat(DISTINCT user ORDER BY user SEPARATOR ', ') users,group_concat(DISTINCT email ORDER BY email SEPARATOR ', ') emails,max(date) maxdate,max(lastused) lastused,access,expires,usergroup from external_access_keys where collection='69' group by access_key order by date 2016-07-22 10:18:45 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:45 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:45 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:45 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:45 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:45 SQL: select language,name,text from site_text where (page='collections' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:45 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'collections' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:45 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:45 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:45 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:45 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:45 SQL: select ref value from collection where ref='69' 2016-07-22 10:18:45 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:45 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:45 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'collections' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:45 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:45 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select * from (select c.*,u.username,u.fullname,count(r.resource) count from user u join collection c on u.ref=c.user and c.user='4' left outer join collection_resource r on c.ref=r.collection where (length(c.theme)=0 or c.theme is null) group by c.ref union select c.*,u.username,u.fullname,count(r.resource) count from user_collection uc join collection c on uc.collection=c.ref and uc.user='4' and c.user<>'4' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref where (length(c.theme)=0 or c.theme is null) group by c.ref union select c.*,u.username,u.fullname,count(r.resource) count from usergroup_collection gc join collection c on gc.collection=c.ref and gc.usergroup='3' and c.user<>'4' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref where (length(c.theme)=0 or c.theme is null) group by c.ref) clist group by ref 2016-07-22 10:18:45 SQL: select * from collection_savedsearch where collection='69' order by created 2016-07-22 10:18:45 search=!collection69 -1 restypes= archive=0 daylimit= 2016-07-22 10:18:45 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:18:45 SQL: select ref from resource_type_field where keywords_index=1 and length(name)>0 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:45 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:18:45 search=!collection69 150 restypes= archive=0 daylimit= 2016-07-22 10:18:45 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:45 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:18:45 SQL: select count(*) value from research_request where collection='69' 2016-07-22 10:18:45 search=!collection69 -1 restypes= archive=0 daylimit= 2016-07-22 10:18:45 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:45 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:45 SQL: select count(*) value from research_request where collection='69' 2016-07-22 10:18:45 search=!collection69 -1 restypes= archive=0 daylimit= 2016-07-22 10:18:45 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:45 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:18:45 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:45 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:45 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:45 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:45 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:48 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:48 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:48 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:48 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:48 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:48 SQL: select language,name,text from site_text where (page='message' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:48 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:48 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:48 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:48 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:48 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:48 SQL: select ref value from collection where ref='69' 2016-07-22 10:18:48 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:48 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:48 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:48 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:48 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:48 SQL: SELECT user_message.ref, user.username AS owner, user_message.seen, message.created, message.expires, message.message, message.url FROM `user_message` INNER JOIN `message` ON user_message.message=message.ref LEFT OUTER JOIN `user` ON message.owner=user.ref WHERE user_message.user='4' AND message.expires > NOW() AND user_message.seen='0' ORDER BY user_message.ref ASC 2016-07-22 10:18:52 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:52 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:52 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:52 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:52 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:52 SQL: select language,name,text from site_text where (page='upload_plupload' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:52 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'upload_plupload' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:52 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:52 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:52 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:52 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:52 SQL: select ref value from collection where ref='69' 2016-07-22 10:18:52 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:52 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:52 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'upload_plupload' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:52 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:52 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:52 SQL: select config_options value from resource_type where ref='1' 2016-07-22 10:18:52 SQL: select allowed_extensions value from resource_type where ref='1' 2016-07-22 10:18:52 SQL: update user set current_collection='69' where ref='4' 2016-07-22 10:18:52 PLUPLOAD - receiving file from user tcheupel, filename dudes.JPG, chunk 0 of 1 2016-07-22 10:18:52 PLUPLOAD - creating temporary folder C:\resourcespace\include/../filestore/tmp\plupload\0a7676cce1f20e60cecaa9e24eaf9673\dudes.JPG for file received from user tcheupel, filename dudes.JPG, chunk 1 of 1 2016-07-22 10:18:52 PLUPLOAD - handling non-multipart upload file received from user tcheupel, filename dudes.JPG, chunk 1 of 1 2016-07-22 10:18:52 PLUPLOAD - adding data from C:\wamp\tmp\phpE6FB.tmp to C:\resourcespace\include/../filestore/tmp\plupload\0a7676cce1f20e60cecaa9e24eaf9673\dudes.JPG.part. file received from user tcheupel, filename dudes.JPG, chunk 1 of 1 2016-07-22 10:18:52 PLUPLOAD - processing completed upload of file received from user tcheupel, filename dudes.JPG, chunk 1 of 1 2016-07-22 10:18:52 SQL: select count(*) value from resource where ref='-4' 2016-07-22 10:18:52 SQL: SELECT rtf.ref AS value FROM resource_type_field AS rtf INNER JOIN resource AS r ON (rtf.resource_type != r.resource_type AND rtf.resource_type != 0) WHERE r.ref = "-4"; 2016-07-22 10:18:52 SQL: select archive value from resource where ref='-4' 2016-07-22 10:18:52 SQL: insert into resource( resource_type,creation_date,rating,archive,access,created_by ,field12 ,field8 ,field3 ) select resource_type,now(),rating,'0',access,created_by ,field12 ,field8 ,field3 from resource where ref='-4'; 2016-07-22 10:18:52 SQL: update resource set created_by='4' where ref='3341' 2016-07-22 10:18:52 adding tcheupel 2016-07-22 10:18:52 resolving keyword tcheupel. Create=true 2016-07-22 10:18:52 resolving normalized keyword tcheupel. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='tcheupel' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4201','0','-1') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4201' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4201' and external='0' 2016-07-22 10:18:52 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','4201','0','1') 2016-07-22 10:18:52 adding karma 2016-07-22 10:18:52 resolving keyword karma. Create=true 2016-07-22 10:18:52 resolving normalized keyword karma. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='karma' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4199','1','-1') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4199' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4199' and external='0' 2016-07-22 10:18:52 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','4199','0','1') 2016-07-22 10:18:52 adding tsultrim 2016-07-22 10:18:52 resolving keyword tsultrim. Create=true 2016-07-22 10:18:52 resolving normalized keyword tsultrim. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='tsultrim' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4200','2','-1') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4200' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4200' and external='0' 2016-07-22 10:18:52 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','4200','0','1') 2016-07-22 10:18:52 adding tcheupel 2016-07-22 10:18:52 resolving keyword tcheupel. Create=true 2016-07-22 10:18:52 resolving normalized keyword tcheupel. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='tcheupel' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4201','3','-1') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4201' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4201' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4201' and external='0' 2016-07-22 10:18:52 SQL: insert into resource_data(resource,resource_type_field,value) select '3341',rd.resource_type_field,rd.value from resource_data rd join resource r on rd.resource=r.ref join resource_type_field rtf on rd.resource_type_field=rtf.ref and (rtf.resource_type=r.resource_type or rtf.resource_type=999 or rtf.resource_type=0) where rd.resource='-4' 2016-07-22 10:18:52 SQL: insert into resource_node (resource,node, hit_count, new_hit_count) select '3341', node, 0, 0 from resource_node where resource ='-4'; 2016-07-22 10:18:52 SQL: insert into resource_related(resource,related) select '3341',related from resource_related where resource='-4' 2016-07-22 10:18:52 SQL: insert into resource_custom_access(resource,usergroup,access) select '3341',usergroup,access from resource_custom_access where resource='-4' 2016-07-22 10:18:52 SQL: select resource_type value from resource where ref='3341' 2016-07-22 10:18:52 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0 2016-07-22 10:18:52 SQL: DELETE FROM resource_keyword WHERE resource = '3341' 2016-07-22 10:18:52 SQL: select resource_type value from resource where ref='3341' 2016-07-22 10:18:52 use perms: 1 2016-07-22 10:18:52 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='3341') d on d.resource_type_field=f.ref and d.resource='3341' 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 2016-07-22 10:18:52 SQL: select ref value from resource_type 2016-07-22 10:18:52 fieldMaitre=, 2016-07-22 10:18:52 fieldTitle=dudes 2016-07-22 10:18:52 fieldCaption= 2016-07-22 10:18:52 fieldKeywords - Subject=, 2016-07-22 10:18:52 fieldKeywords - Emotion=, 2016-07-22 10:18:52 fieldKeywords - Event=, 2016-07-22 10:18:52 fieldKeywords - Other= 2016-07-22 10:18:52 fieldNamed person(s)= 2016-07-22 10:18:52 fieldCountry=, 2016-07-22 10:18:52 fieldDate=2016-07-22 10:17 2016-07-22 10:18:52 fieldOriginal filename= 2016-07-22 10:18:52 fieldExtracted text= 2016-07-22 10:18:52 fieldCredit= 2016-07-22 10:18:52 fieldNotes= 2016-07-22 10:18:52 fieldCamera make / model= 2016-07-22 10:18:52 fieldSource=, 2016-07-22 10:18:52 adding dudes 2016-07-22 10:18:52 resolving keyword dudes. Create=true 2016-07-22 10:18:52 resolving normalized keyword dudes. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='dudes' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4108','0','8') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4108' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4108' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4108' and external='0' 2016-07-22 10:18:52 adding 2016 2016-07-22 10:18:52 resolving keyword 2016. Create=true 2016-07-22 10:18:52 resolving normalized keyword 2016. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='2016' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','39','0','12') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='39' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='39' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='39' and external='0' 2016-07-22 10:18:52 adding 2016-07 2016-07-22 10:18:52 resolving keyword 2016-07. Create=true 2016-07-22 10:18:52 resolving normalized keyword 2016-07. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='2016-07' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','58','1','12') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='58' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='58' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='58' and external='0' 2016-07-22 10:18:52 adding 2016-07-22 10:17 2016-07-22 10:18:52 resolving keyword 2016-07-22 10:17. Create=true 2016-07-22 10:18:52 resolving normalized keyword 2016-07-22 10:17. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='2016-07-22 10:17' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4765','2','12') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='4765' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4765' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4765' and external='0' 2016-07-22 10:18:52 SQL: select name value from resource_type where ref in (select resource_type from resource where ref='3341') 2016-07-22 10:18:52 adding photo 2016-07-22 10:18:52 resolving keyword photo. Create=true 2016-07-22 10:18:52 resolving normalized keyword photo. 2016-07-22 10:18:52 SQL: select ref value from keyword where keyword='photo' 2016-07-22 10:18:52 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','24','0','-2') 2016-07-22 10:18:52 SQL: update keyword set hit_count=hit_count+1 where ref='24' 2016-07-22 10:18:52 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:52 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='24' and external='0' 2016-07-22 10:18:53 adding 3341 2016-07-22 10:18:53 resolving keyword 3341. Create=true 2016-07-22 10:18:53 resolving normalized keyword 3341. 2016-07-22 10:18:53 SQL: select ref value from keyword where keyword='3341' 2016-07-22 10:18:53 Creating new keyword for 3341 2016-07-22 10:18:53 SQL: insert into keyword (keyword,soundex,hit_count) values ('3341',left('0000',10),0) 2016-07-22 10:18:53 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4768','0','-1') 2016-07-22 10:18:53 SQL: update keyword set hit_count=hit_count+1 where ref='4768' 2016-07-22 10:18:53 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4768' and external='0' 2016-07-22 10:18:53 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','4768','0','1') 2016-07-22 10:18:53 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Create resource' and object_ref='3341' and external='0' 2016-07-22 10:18:53 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Create resource','3341','0','1') 2016-07-22 10:18:53 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(),'4','3341','c',null,'','','-1','','0',null,'') 2016-07-22 10:18:53 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:18:53 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:18:53 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:18:53 SQL: select user value from user_collection where collection='69' 2016-07-22 10:18:53 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:18:53 collection session : 2016-07-22 10:18:53 collection user : 4 2016-07-22 10:18:53 anonymous_login : 2016-07-22 10:18:53 userref : 4 2016-07-22 10:18:53 username : tcheupel 2016-07-22 10:18:53 anonymous_user_session_collection : TRUE 2016-07-22 10:18:53 SQL: select access_key,group_concat(DISTINCT user ORDER BY user SEPARATOR ', ') users,group_concat(DISTINCT email ORDER BY email SEPARATOR ', ') emails,max(date) maxdate,max(lastused) lastused,access,expires,usergroup from external_access_keys where collection='69' group by access_key order by date 2016-07-22 10:18:53 SQL: delete from collection_resource where resource='3341' and collection='69' 2016-07-22 10:18:53 SQL: insert into collection_resource(resource,collection,purchase_size) values ('3341','69','') 2016-07-22 10:18:53 SQL: insert into collection_log(date,user,collection,type,resource, notes) values (now(),'4','69','a','3341', '') 2016-07-22 10:18:53 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Resource upload' and object_ref='3341' and external='0' 2016-07-22 10:18:53 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Resource upload','3341','0','1') 2016-07-22 10:18:53 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(),'4','3341','t',null,'','Upload file','-1','','0',null,'') 2016-07-22 10:18:53 SQL: select file_path value from resource where ref='3341' 2016-07-22 10:18:53 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:53 SQL: select file_extension value from resource where ref='3341' 2016-07-22 10:18:53 SQL: select file_extension value from resource where ref='3341' 2016-07-22 10:18:53 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:53 SQL: update resource set file_extension='jpg',preview_extension='jpg',file_modified=now() ,has_image=0 where ref='3341' 2016-07-22 10:18:53 SQL: delete from resource_dimensions where resource='3341' 2016-07-22 10:18:53 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:53 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(),'4','3341','t',null,'','Exiftool tag','-1','','0',null,'') 2016-07-22 10:18:53 SQL: select *,mapzoom from resource where ref='3341' 2016-07-22 10:18:53 SQL: select f.ref,f.type,f.exiftool_field,f.exiftool_filter,group_concat(n.name) as options,f.name from resource_type_field f left join node n on f.ref=n.resource_type_field where length(exiftool_field)>0 and (resource_type='1' or resource_type='0') group by f.ref order by exiftool_field 2016-07-22 10:18:53 CLI command: "C:\exiftool\exiftool.exe" -s -s -f -m -d "%Y-%m-%d %H:%M:%S" -G "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg" 2016-07-22 10:18:56 CLI output: [ExifTool] ExifToolVersion: 10.22 [File] FileName: 3341_36c8d8c98382132.jpg [File] Directory: C:/resourcespace/include/../filestore/3/3/4/1_124760848ecbb08 [File] FileSize: 1057 kB [File] FileModifyDate: 2016-07-22 12:18:52 [File] FileAccessDate: 2016-07-22 12:18:52 [File] FileCreateDate: 2016-07-22 12:18:52 [File] FilePermissions: rw-rw-rw- [File] FileType: JPEG [File] FileTypeExtension: jpg [File] MIMEType: image/jpeg [File] ExifByteOrder: Little-endian (Intel, II) [File] ImageWidth: 1936 [File] ImageHeight: 1288 [File] EncodingProcess: Baseline DCT, Huffman coding [File] BitsPerSample: 8 [File] ColorComponents: 3 [File] YCbCrSubSampling: YCbCr4:2:2 (2 1) [EXIF] Make: Canon [EXIF] Model: Canon EOS 1000D [EXIF] Orientation: Horizontal (normal) [EXIF] XResolution: 72 [EXIF] YResolution: 72 [EXIF] ResolutionUnit: inches [EXIF] ModifyDate: 2015-07-31 17:14:00 [EXIF] YCbCrPositioning: Co-sited [EXIF] ExposureTime: 1/400 [EXIF] FNumber: 4.0 [EXIF] ExposureProgram: Shutter speed priority AE [EXIF] ISO: 800 [EXIF] ExifVersion: 0221 [EXIF] DateTimeOriginal: 2015-07-31 17:14:00 [EXIF] CreateDate: 2015-07-31 17:14:00 [EXIF] ComponentsConfiguration: Y, Cb, Cr, - [EXIF] ShutterSpeedValue: 1/395 [EXIF] ApertureValue: 4.0 [EXIF] Flash: Off, Did not fire [EXIF] FocalLength: 30.0 mm [EXIF] UserComment: [EXIF] SubSecTime: 81 [EXIF] SubSecTimeOriginal: 81 [EXIF] SubSecTimeDigitized: 81 [EXIF] FlashpixVersion: 0100 [EXIF] ColorSpace: sRGB [EXIF] ExifImageWidth: 1936 [EXIF] ExifImageHeight: 1288 [EXIF] InteropIndex: R98 - DCF basic file (sRGB) [EXIF] InteropVersion: 0100 [EXIF] FocalPlaneXResolution: 2210.045662 [EXIF] FocalPlaneYResolution: 2209.262436 [EXIF] FocalPlaneResolutionUnit: inches [EXIF] CustomRendered: Normal [EXIF] ExposureMode: Auto [EXIF] SceneCaptureType: Standard [EXIF] Compression: JPEG (old-style) [EXIF] ThumbnailOffset: 9632 [EXIF] ThumbnailLength: 8499 [MakerNotes] MacroMode: Normal [MakerNotes] SelfTimer: Off [MakerNotes] Quality: Fine [MakerNotes] CanonFlashMode: Off [MakerNotes] ContinuousDrive: Single [MakerNotes] FocusMode: AI Focus AF [MakerNotes] RecordMode: JPEG [MakerNotes] CanonImageSize: Small [MakerNotes] EasyMode: Manual [MakerNotes] DigitalZoom: None [MakerNotes] Contrast: Normal [MakerNotes] Saturation: Normal [MakerNotes] MeteringMode: Evaluative [MakerNotes] FocusRange: Not Known [MakerNotes] CanonExposureMode: Shutter speed priority AE [MakerNotes] LensType: Canon EF-S 18-55mm f/3.5-5.6 [II] [MakerNotes] MaxFocalLength: 55 mm [MakerNotes] MinFocalLength: 18 mm [MakerNotes] FocalUnits: 1/mm [MakerNotes] MaxAperture: 4.2 [MakerNotes] MinAperture: 27 [MakerNotes] FlashActivity: 0 [MakerNotes] FlashBits: (none) [MakerNotes] ZoomSourceWidth: 0 [MakerNotes] ZoomTargetWidth: 0 [MakerNotes] ManualFlashOutput: n/a [MakerNotes] ColorTone: Normal [MakerNotes] AutoISO: 100 [MakerNotes] BaseISO: 800 [MakerNotes] MeasuredEV: 9.13 [MakerNotes] TargetAperture: 4 [MakerNotes] TargetExposureTime: 1/406 [MakerNotes] ExposureCompensation: 0 [MakerNotes] WhiteBalance: Auto [MakerNotes] SlowShutter: None [MakerNotes] SequenceNumber: 0 [MakerNotes] OpticalZoomCode: n/a [MakerNotes] CameraTemperature: 26 C [MakerNotes] FlashGuideNumber: 0 [MakerNotes] FlashExposureComp: 0 [MakerNotes] AutoExposureBracketing: Off [MakerNotes] AEBBracketValue: 0 [MakerNotes] ControlMode: Camera Local Control [MakerNotes] MeasuredEV2: 9.125 [MakerNotes] BulbDuration: 0 [MakerNotes] CameraType: EOS High-end [MakerNotes] NDFilter: n/a [MakerNotes] CanonImageType: Canon EOS 1000D [MakerNotes] CanonFirmwareVersion: Firmware Version 1.0.6 [MakerNotes] OwnerName: [MakerNotes] SerialNumber: 2050463834 [MakerNotes] FlashMeteringMode: Off [MakerNotes] CameraOrientation: Horizontal (normal) [MakerNotes] FirmwareVersion: 1.0.6 [MakerNotes] DirectoryIndex: 100 [MakerNotes] FileIndex: 4382 [MakerNotes] ContrastStandard: 0 [MakerNotes] SharpnessStandard: 3 [MakerNotes] SaturationStandard: 0 [MakerNotes] ColorToneStandard: 0 [MakerNotes] ContrastPortrait: 0 [MakerNotes] SharpnessPortrait: 2 [MakerNotes] SaturationPortrait: 0 [MakerNotes] ColorTonePortrait: 0 [MakerNotes] ContrastLandscape: 0 [MakerNotes] SharpnessLandscape: 4 [MakerNotes] SaturationLandscape: 0 [MakerNotes] ColorToneLandscape: 0 [MakerNotes] ContrastNeutral: 0 [MakerNotes] SharpnessNeutral: 0 [MakerNotes] SaturationNeutral: 0 [MakerNotes] ColorToneNeutral: 0 [MakerNotes] ContrastFaithful: 0 [MakerNotes] SharpnessFaithful: 0 [MakerNotes] SaturationFaithful: 0 [MakerNotes] ColorToneFaithful: 0 [MakerNotes] ContrastMonochrome: 0 [MakerNotes] SharpnessMonochrome: 3 [MakerNotes] FilterEffectMonochrome: Green [MakerNotes] ToningEffectMonochrome: None [MakerNotes] ContrastUserDef1: 1 [MakerNotes] SharpnessUserDef1: 4 [MakerNotes] SaturationUserDef1: -1 [MakerNotes] ColorToneUserDef1: 2 [MakerNotes] FilterEffectUserDef1: None [MakerNotes] ToningEffectUserDef1: None [MakerNotes] ContrastUserDef2: 0 [MakerNotes] SharpnessUserDef2: 3 [MakerNotes] SaturationUserDef2: 0 [MakerNotes] ColorToneUserDef2: 0 [MakerNotes] FilterEffectUserDef2: None [MakerNotes] ToningEffectUserDef2: None [MakerNotes] ContrastUserDef3: 0 [MakerNotes] SharpnessUserDef3: 3 [MakerNotes] SaturationUserDef3: 0 [MakerNotes] ColorToneUserDef3: 0 [MakerNotes] FilterEffectUserDef3: None [MakerNotes] ToningEffectUserDef3: None [MakerNotes] UserDef1PictureStyle: Standard [MakerNotes] UserDef2PictureStyle: Standard [MakerNotes] UserDef3PictureStyle: Standard [MakerNotes] CanonModelID: EOS Rebel XS / 1000D / Kiss F [MakerNotes] ThumbnailImageValidArea: 0 159 7 112 [MakerNotes] SerialNumberFormat: Format 2 [MakerNotes] AFAreaMode: Single-point AF [MakerNotes] NumAFPoints: 7 [MakerNotes] ValidAFPoints: 7 [MakerNotes] CanonImageWidth: 1936 [MakerNotes] CanonImageHeight: 1288 [MakerNotes] AFImageWidth: 3888 [MakerNotes] AFImageHeight: 2592 [MakerNotes] AFAreaWidths: 194 139 139 194 139 139 194 [MakerNotes] AFAreaHeights: 139 194 194 194 194 194 139 [MakerNotes] AFAreaXPositions: 0 -1283 -769 0 769 1283 0 [MakerNotes] AFAreaYPositions: -640 0 0 0 0 0 640 [MakerNotes] AFPointsInFocus: 4,5 [MakerNotes] AFPointsSelected: 0,1,2,3,4,5,6 [MakerNotes] OriginalDecisionDataOffset: 0 [MakerNotes] BracketMode: Off [MakerNotes] BracketValue: 0 [MakerNotes] BracketShotNumber: 0 [MakerNotes] RawJpgSize: Large [MakerNotes] LongExposureNoiseReduction2: Off [MakerNotes] WBBracketMode: Off [MakerNotes] WBBracketValueAB: 0 [MakerNotes] WBBracketValueGM: 0 [MakerNotes] LiveViewShooting: Off [MakerNotes] FocusDistanceUpper: 1.42 m [MakerNotes] FocusDistanceLower: 1.19 m [MakerNotes] LensModel: EF-S18-55mm f/3.5-5.6 [MakerNotes] InternalSerialNumber: L1516235UU [MakerNotes] DustRemovalData: (Binary data 1024 bytes, use -b option to extract) [MakerNotes] CropLeftMargin: 8 [MakerNotes] CropRightMargin: 8 [MakerNotes] CropTopMargin: 8 [MakerNotes] CropBottomMargin: 8 [MakerNotes] ExposureLevelIncrements: 1/3 Stop [MakerNotes] FlashSyncSpeedAv: Auto [MakerNotes] LongExposureNoiseReduction: Off [MakerNotes] HighISONoiseReduction: Off [MakerNotes] AutoLightingOptimizer: Enable [MakerNotes] AFAssistBeam: Emits [MakerNotes] AFDuringLiveView: Disable [MakerNotes] MirrorLockup: Disable [MakerNotes] Shutter-AELock: AF/AE lock [MakerNotes] SetButtonWhenShooting: LCD monitor On/Off [MakerNotes] LCDDisplayAtPowerOn: Display [MakerNotes] AddOriginalDecisionData: Off [MakerNotes] ToneCurve: Standard [MakerNotes] Sharpness: 4 [MakerNotes] SharpnessFrequency: n/a [MakerNotes] SensorRedLevel: 0 [MakerNotes] SensorBlueLevel: 0 [MakerNotes] WhiteBalanceRed: 0 [MakerNotes] WhiteBalanceBlue: 0 [MakerNotes] ColorTemperature: 5200 [MakerNotes] PictureStyle: Landscape [MakerNotes] DigitalGain: 0 [MakerNotes] WBShiftAB: 0 [MakerNotes] WBShiftGM: 0 [MakerNotes] MeasuredRGGB: 918 1024 1024 530 [MakerNotes] VRDOffset: 0 [MakerNotes] SensorWidth: 3948 [MakerNotes] SensorHeight: 2622 [MakerNotes] SensorLeftBorder: 52 [MakerNotes] SensorTopBorder: 23 [MakerNotes] SensorRightBorder: 3939 [MakerNotes] SensorBottomBorder: 2614 [MakerNotes] BlackMaskLeftBorder: 0 [MakerNotes] BlackMaskTopBorder: 0 [MakerNotes] BlackMaskRightBorder: 0 [MakerNotes] BlackMaskBottomBorder: 0 [MakerNotes] ColorDataVersion: 5 (450D/1000D) [MakerNotes] WB_RGGBLevelsAsShot: 1802 1024 1024 1935 [MakerNotes] ColorTempAsShot: 4014 [MakerNotes] WB_RGGBLevelsAuto: 1802 1024 1024 1935 [MakerNotes] ColorTempAuto: 4014 [MakerNotes] WB_RGGBLevelsMeasured: 1800 1023 1024 1936 [MakerNotes] ColorTempMeasured: 4014 [MakerNotes] WB_RGGBLevelsDaylight: 2171 1024 1024 1560 [MakerNotes] ColorTempDaylight: 5200 [MakerNotes] WB_RGGBLevelsShade: 2533 1024 1024 1288 [MakerNotes] ColorTempShade: 7000 [MakerNotes] WB_RGGBLevelsCloudy: 2346 1024 1024 1406 [MakerNotes] ColorTempCloudy: 6000 [MakerNotes] WB_RGGBLevelsTungsten: 1589 1112 1112 2671 [MakerNotes] ColorTempTungsten: 3200 [MakerNotes] WB_RGGBLevelsFluorescent: 1883 1024 1024 2194 [MakerNotes] ColorTempFluorescent: 3864 [MakerNotes] WB_RGGBLevelsKelvin: 2171 1024 1024 1560 [MakerNotes] ColorTempKelvin: 5211 [MakerNotes] WB_RGGBLevelsFlash: 2399 1024 1024 1398 [MakerNotes] ColorTempFlash: 6147 [MakerNotes] AverageBlackLevel: 1023 1023 1023 1023 [MakerNotes] RawMeasuredRGGB: 3049 3410 3477 1767 [MakerNotes] PerChannelBlackLevel: 1023 1022 1023 1022 [MakerNotes] SpecularWhiteLevel: 15120 [MakerNotes] LinearityUpperMargin: 10000 [MakerNotes] CustomPictureStyleFileName: [Composite] Aperture: 4.0 [Composite] DriveMode: Single-frame Shooting [Composite] FileNumber: 100-4382 [Composite] ImageSize: 1936x1288 [Composite] Lens: 18.0 - 55.0 mm [Composite] LensID: Canon EF-S 18-55mm f/3.5-5.6 [II] [Composite] Megapixels: 2.5 [Composite] ScaleFactor35efl: 1.6 [Composite] ShootingMode: Shutter speed priority AE [Composite] ShutterSpeed: 1/400 [Composite] SubSecCreateDate: 2015-07-31 17:14:00 [Composite] SubSecDateTimeOriginal: 2015-07-31 17:14:00 [Composite] SubSecModifyDate: 2015-07-31 17:14:00 [Composite] ThumbnailImage: (Binary data 8499 bytes, use -b option to extract) [Composite] WB_RGGBLevels: 1802 1024 1024 1935 [Composite] BlueBalance: 1.889648 [Composite] CircleOfConfusion: 0.019 mm [Composite] DOF: 0.28 m (1.18 - 1.46 m) [Composite] FOV: 40.7 deg [Composite] FocalLength35efl: 30.0 mm (35 mm equivalent: 48.6 mm) [Composite] HyperfocalDistance: 12.12 m [Composite] Lens35efl: 18.0 - 55.0 mm (35 mm equivalent: 29.1 - 89.0 mm) [Composite] LightValue: 9.6 [Composite] RedBalance: 1.759766 2016-07-22 10:18:56 CLI errors: 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:exiftoolexiftool.exe" -s -s -f -m -d "%Y-%m-%d %H:%M:%S" -G "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg":\n[ExifTool] ExifToolVersion: 10.22\r\n[File] FileName: 3341_36c8d8c98382132.jpg\r\n[File] Directory: C:/resourcespace/include/../filestore/3/3/4/1_124760848ecbb08\r\n[File] FileSize: 1057 kB\r\n[File] FileModifyDate: 2016-07-22 12:18:52\r\n[File] FileAccessDate: 2016-07-22 12:18:52\r\n[File] FileCreateDate: 2016-07-22 12:18:52\r\n[File] FilePermissions: rw-rw-rw-\r\n[File] FileType: JPEG\r\n[File] FileTypeExtension: jpg\r\n[File] MIMEType: image/jpeg\r\n[File] ExifByteOrder: Little-endian (Intel, II)\r\n[File] ImageWidth: 1936\r\n[File] ImageHeight: 1288\r\n[File] EncodingProcess: Baseline DCT, Huffman coding\r\n[File] BitsPerSample: 8\r\n[File] ColorComponents: 3\r\n[File] YCbCrSubSampling: YCbCr4:2:2 (2 1)\r\n[EXIF] Make: Canon\r\n[EXIF] Model: Canon EOS 1000D\r\n[EXIF] Orientation: Horizontal (normal)\r\n[EXIF] XResolution: 72\r\n[EXIF] YResolution: 72\r\n[EXIF] ResolutionUnit: inches\r\n[EXIF] ModifyDate: 2015-07-31 17:14:00\r\n[EXIF] YCbCrPositioning: Co-sited\r\n[EXIF] ExposureTime: 1/400\r\n[EXIF] FNumber: 4.0\r\n[EXIF] ExposureProgram: Shutter speed priority AE\r\n[EXIF] ISO: 800\r\n[EXIF] ExifVersion: 0221\r\n[EXIF] DateTimeOriginal: 2015-07-31 17:14:00\r\n[EXIF] CreateDate: 2015-07-31 17:14:00\r\n[EXIF] ComponentsConfiguration: Y, Cb, Cr, -\r\n[EXIF] ShutterSpeedValue: 1/395\r\n[EXIF] ApertureValue: 4.0\r\n[EXIF] Flash: Off, Did not fire\r\n[EXIF] FocalLength: 30.0 mm\r\n[EXIF] UserComment: \r\n[EXIF] SubSecTime: 81\r\n[EXIF] SubSecTimeOriginal: 81\r\n[EXIF] SubSecTimeDigitized: 81\r\n[EXIF] FlashpixVersion: 0100\r\n[EXIF] ColorSpace: sRGB\r\n[EXIF] ExifImageWidth: 1936\r\n[EXIF] ExifImageHeight: 1288\r\n[EXIF] InteropIndex: R98 - DCF basic file (sRGB)\r\n[EXIF] InteropVersion: 0100\r\n[EXIF] FocalPlaneXResolution: 2210.045662\r\n[EXIF] FocalPlaneYResolution: 2209.262436\r\n[EXIF] FocalPlaneResolutionUnit: inches\r\n[EXIF] CustomRendered: Normal\r\n[EXIF] ExposureMode: Auto\r\n[EXIF] SceneCaptureType: Standard\r\n[EXIF] Compression: JPEG (old-style)\r\n[EXIF] ThumbnailOffset: 9632\r\n[EXIF] ThumbnailLength: 8499\r\n[MakerNotes] MacroMode: Normal\r\n[MakerNotes] SelfTimer: Off\r\n[MakerNotes] Quality: Fine\r\n[MakerNotes] CanonFlashMode: Off\r\n[MakerNotes] ContinuousDrive: Single\r\n[MakerNotes] FocusMode: AI Focus AF\r\n[MakerNotes] RecordMode: JPEG\r\n[MakerNotes] CanonImageSize: Small\r\n[MakerNotes] EasyMode: Manual\r\n[MakerNotes] DigitalZoom: None\r\n[MakerNotes] Contrast: Normal\r\n[MakerNotes] Saturation: Normal\r\n[MakerNotes] MeteringMode: Evaluative\r\n[MakerNotes] FocusRange: Not Known\r\n[MakerNotes] CanonExposureMode: Shutter speed priority AE\r\n[MakerNotes] LensType: Canon EF-S 18-55mm f/3.5-5.6 [II]\r\n[MakerNotes] MaxFocalLength: 55 mm\r\n[MakerNotes] MinFocalLength: 18 mm\r\n[MakerNotes] FocalUnits: 1/mm\r\n[MakerNotes] MaxAperture: 4.2\r\n[MakerNotes] MinAperture: 27\r\n[MakerNotes] FlashActivity: 0\r\n[MakerNotes] FlashBits: (none)\r\n[MakerNotes] ZoomSourceWidth: 0\r\n[MakerNotes] ZoomTargetWidth: 0\r\n[MakerNotes] ManualFlashOutput: n/a\r\n[MakerNotes] ColorTone: Normal\r\n[MakerNotes] AutoISO: 100\r\n[MakerNotes] BaseISO: 800\r\n[MakerNotes] MeasuredEV: 9.13\r\n[MakerNotes] TargetAperture: 4\r\n[MakerNotes] TargetExposureTime: 1/406\r\n[MakerNotes] ExposureCompensation: 0\r\n[MakerNotes] WhiteBalance: Auto\r\n[MakerNotes] SlowShutter: None\r\n[MakerNotes] SequenceNumber: 0\r\n[MakerNotes] OpticalZoomCode: n/a\r\n[MakerNotes] CameraTemperature: 26 C\r\n[MakerNotes] FlashGuideNumber: 0\r\n[MakerNotes] FlashExposureComp: 0\r\n[MakerNotes] AutoExposureBracketing: Off\r\n[MakerNotes] AEBBracketValue: 0\r\n[MakerNotes] ControlMode: Camera Local Control\r\n[MakerNotes] MeasuredEV2: 9.125\r\n[MakerNotes] BulbDuration: 0\r\n[MakerNotes] CameraType: EOS High-end\r\n[MakerNotes] NDFilter: n/a\r\n[MakerNotes] CanonImageType: Canon EOS 1000D\r\n[MakerNotes] CanonFirmwareVersion: Firmware Version 1.0.6\r\n[MakerNotes] OwnerName: \r\n[MakerNotes] SerialNumber: 2050463834\r\n[MakerNotes] FlashMeteringMode: Off\r\n[MakerNotes] CameraOrientation: Horizontal (normal)\r\n[MakerNotes] FirmwareVersion: 1.0.6\r\n[MakerNotes] DirectoryIndex: 100\r\n[MakerNotes] FileIndex: 4382\r\n[MakerNotes] ContrastStandard: 0\r\n[MakerNotes] SharpnessStandard: 3\r\n[MakerNotes] SaturationStandard: 0\r\n[MakerNotes] ColorToneStandard: 0\r\n[MakerNotes] ContrastPortrait: 0\r\n[MakerNotes] SharpnessPortrait: 2\r\n[MakerNotes] SaturationPortrait: 0\r\n[MakerNotes] ColorTonePortrait: 0\r\n[MakerNotes] ContrastLandscape: 0\r\n[MakerNotes] SharpnessLandscape: 4\r\n[MakerNotes] SaturationLandscape: 0\r\n[MakerNotes] ColorToneLandscape: 0\r\n[MakerNotes] ContrastNeutral: 0\r\n[MakerNotes] SharpnessNeutral: 0\r\n[MakerNotes] SaturationNeutral: 0\r\n[MakerNotes] ColorToneNeutral: 0\r\n[MakerNotes] ContrastFaithful: 0\r\n[MakerNotes] SharpnessFaithful: 0\r\n[MakerNotes] SaturationFaithful: 0\r\n[MakerNotes] ColorToneFaithful: 0\r\n[MakerNotes] ContrastMonochrome: 0\r\n[MakerNotes] SharpnessMonochrome: 3\r\n[MakerNotes] FilterEffectMonochrome: Green\r\n[MakerNotes] ToningEffectMonochrome: None\r\n[MakerNotes] ContrastUserDef1: 1\r\n[MakerNotes] SharpnessUserDef1: 4\r\n[MakerNotes] SaturationUserDef1: -1\r\n[MakerNotes] ColorToneUserDef1: 2\r\n[MakerNotes] FilterEffectUserDef1: None\r\n[MakerNotes] ToningEffectUserDef1: None\r\n[MakerNotes] ContrastUserDef2: 0\r\n[MakerNotes] SharpnessUserDef2: 3\r\n[MakerNotes] SaturationUserDef2: 0\r\n[MakerNotes] ColorToneUserDef2: 0\r\n[MakerNotes] FilterEffectUserDef2: None\r\n[MakerNotes] ToningEffectUserDef2: None\r\n[MakerNotes] ContrastUserDef3: 0\r\n[MakerNotes] SharpnessUserDef3: 3\r\n[MakerNotes] SaturationUserDef3: 0\r\n[MakerNotes] ColorToneUserDef3: 0\r\n[MakerNotes] FilterEffectUserDef3: None\r\n[MakerNotes] ToningEffectUserDef3: None\r\n[MakerNotes] UserDef1PictureStyle: Standard\r\n[MakerNotes] UserDef2PictureStyle: Standard\r\n[MakerNotes] UserDef3PictureStyle: Standard\r\n[MakerNotes] CanonModelID: EOS Rebel XS / 1000D / Kiss F\r\n[MakerNotes] ThumbnailImageValidArea: 0 159 7 112\r\n[MakerNotes] SerialNumberFormat: Format 2\r\n[MakerNotes] AFAreaMode: Single-point AF\r\n[MakerNotes] NumAFPoints: 7\r\n[MakerNotes] ValidAFPoints: 7\r\n[MakerNotes] CanonImageWidth: 1936\r\n[MakerNotes] CanonImageHeight: 1288\r\n[MakerNotes] AFImageWidth: 3888\r\n[MakerNotes] AFImageHeight: 2592\r\n[MakerNotes] AFAreaWidths: 194 139 139 194 139 139 194\r\n[MakerNotes] AFAreaHeights: 139 194 194 194 194 194 139\r\n[MakerNotes] AFAreaXPositions: 0 -1283 -769 0 769 1283 0\r\n[MakerNotes] AFAreaYPositions: -640 0 0 0 0 0 640\r\n[MakerNotes] AFPointsInFocus: 4,5\r\n[MakerNotes] AFPointsSelected: 0,1,2,3,4,5,6\r\n[MakerNotes] OriginalDecisionDataOffset: 0\r\n[MakerNotes] BracketMode: Off\r\n[MakerNotes] BracketValue: 0\r\n[MakerNotes] BracketShotNumber: 0\r\n[MakerNotes] RawJpgSize: Large\r\n[MakerNotes] LongExposureNoiseReduction2: Off\r\n[MakerNotes] WBBracketMode: Off\r\n[MakerNotes] WBBracketValueAB: 0\r\n[MakerNotes] WBBracketValueGM: 0\r\n[MakerNotes] LiveViewShooting: Off\r\n[MakerNotes] FocusDistanceUpper: 1.42 m\r\n[MakerNotes] FocusDistanceLower: 1.19 m\r\n[MakerNotes] LensModel: EF-S18-55mm f/3.5-5.6\r\n[MakerNotes] InternalSerialNumber: L1516235UU\r\n[MakerNotes] DustRemovalData: (Binary data 1024 bytes, use -b option to extract)\r\n[MakerNotes] CropLeftMargin: 8\r\n[MakerNotes] CropRightMargin: 8\r\n[MakerNotes] CropTopMargin: 8\r\n[MakerNotes] CropBottomMargin: 8\r\n[MakerNotes] ExposureLevelIncrements: 1/3 Stop\r\n[MakerNotes] FlashSyncSpeedAv: Auto\r\n[MakerNotes] LongExposureNoiseReduction: Off\r\n[MakerNotes] HighISONoiseReduction: Off\r\n[MakerNotes] AutoLightingOptimizer: Enable\r\n[MakerNotes] AFAssistBeam: Emits\r\n[MakerNotes] AFDuringLiveView: Disable\r\n[MakerNotes] MirrorLockup: Disable\r\n[MakerNotes] Shutter-AELock: AF/AE lock\r\n[MakerNotes] SetButtonWhenShooting: LCD monitor On/Off\r\n[MakerNotes] LCDDisplayAtPowerOn: Display\r\n[MakerNotes] AddOriginalDecisionData: Off\r\n[MakerNotes] ToneCurve: Standard\r\n[MakerNotes] Sharpness: 4\r\n[MakerNotes] SharpnessFrequency: n/a\r\n[MakerNotes] SensorRedLevel: 0\r\n[MakerNotes] SensorBlueLevel: 0\r\n[MakerNotes] WhiteBalanceRed: 0\r\n[MakerNotes] WhiteBalanceBlue: 0\r\n[MakerNotes] ColorTemperature: 5200\r\n[MakerNotes] PictureStyle: Landscape\r\n[MakerNotes] DigitalGain: 0\r\n[MakerNotes] WBShiftAB: 0\r\n[MakerNotes] WBShiftGM: 0\r\n[MakerNotes] MeasuredRGGB: 918 1024 1024 530\r\n[MakerNotes] VRDOffset: 0\r\n[MakerNotes] SensorWidth: 3948\r\n[MakerNotes] SensorHeight: 2622\r\n[MakerNotes] SensorLeftBorder: 52\r\n[MakerNotes] SensorTopBorder: 23\r\n[MakerNotes] SensorRightBorder: 3939\r\n[MakerNotes] SensorBottomBorder: 2614\r\n[MakerNotes] BlackMaskLeftBorder: 0\r\n[MakerNotes] BlackMaskTopBorder: 0\r\n[MakerNotes] BlackMaskRightBorder: 0\r\n[MakerNotes] BlackMaskBottomBorder: 0\r\n[MakerNotes] ColorDataVersion: 5 (450D/1000D)\r\n[MakerNotes] WB_RGGBLevelsAsShot: 1802 1024 1024 1935\r\n[MakerNotes] ColorTempAsShot: 4014\r\n[MakerNotes] WB_RGGBLevelsAuto: 1802 1024 1024 1935\r\n[MakerNotes] ColorTempAuto: 4014\r\n[MakerNotes] WB_RGGBLevelsMeasured: 1800 1023 1024 1936\r\n[MakerNotes] ColorTempMeasured: 4014\r\n[MakerNotes] WB_RGGBLevelsDaylight: 2171 1024 1024 1560\r\n[MakerNotes] ColorTempDaylight: 5200\r\n[MakerNotes] WB_RGGBLevelsShade: 2533 1024 1024 1288\r\n[MakerNotes] ColorTempShade: 7000\r\n[MakerNotes] WB_RGGBLevelsCloudy: 2346 1024 1024 1406\r\n[MakerNotes] ColorTempCloudy: 6000\r\n[MakerNotes] WB_RGGBLevelsTungsten: 1589 1112 1112 2671\r\n[MakerNotes] ColorTempTungsten: 3200\r\n[MakerNotes] WB_RGGBLevelsFluorescent: 1883 1024 1024 2194\r\n[MakerNotes] ColorTempFluorescent: 3864\r\n[MakerNotes] WB_RGGBLevelsKelvin: 2171 1024 1024 1560\r\n[MakerNotes] ColorTempKelvin: 5211\r\n[MakerNotes] WB_RGGBLevelsFlash: 2399 1024 1024 1398\r\n[MakerNotes] ColorTempFlash: 6147\r\n[MakerNotes] AverageBlackLevel: 1023 1023 1023 1023\r\n[MakerNotes] RawMeasuredRGGB: 3049 3410 3477 1767\r\n[MakerNotes] PerChannelBlackLevel: 1023 1022 1023 1022\r\n[MakerNotes] SpecularWhiteLevel: 15120\r\n[MakerNotes] LinearityUpperMargin: 10000\r\n[MakerNotes] CustomPictureStyleFileName: \r\n[Composite] Aperture: 4.0\r\n[Composite] DriveMode: Single-frame Shooting\r\n[Composite] FileNumber: 100-4382\r\n[Composite] ImageSize: 1936x1288\r\n[Composite] Lens: 18.0 - 55.0 mm\r\n[Composite] LensID: Canon EF-S 18-55mm f/3.5-5.6 [II]\r\n[Composite] Megapixels: 2.5\r\n[Composite] ScaleFactor35efl: 1.6\r\n[Composite] ShootingMode: Shutter speed priority AE\r\n[Composite] ShutterSpeed: 1/400\r\n[Composite] SubSecCreateDate: 2015-07-31 17:14:00\r\n[Composite] SubSecDateTimeOriginal: 2015-07-31 17:14:00\r\n[Composite] SubSecModifyDate: 2015-07-31 17:14:00\r\n[Composite] ThumbnailImage: (Binary data 8499 bytes, use -b option to extract)\r\n[Composite] WB_RGGBLevels: 1802 1024 1024 1935\r\n[Composite] BlueBalance: 1.889648\r\n[Composite] CircleOfConfusion: 0.019 mm\r\n[Composite] DOF: 0.28 m (1.18 - 1.46 m)\r\n[Composite] FOV: 40.7 deg\r\n[Composite] FocalLength35efl: 30.0 mm (35 mm equivalent: 48.6 mm)\r\n[Composite] HyperfocalDistance: 12.12 m\r\n[Composite] Lens35efl: 18.0 - 55.0 mm (35 mm equivalent: 29.1 - 89.0 mm)\r\n[Composite] LightValue: 9.6\r\n[Composite] RedBalance: 1.759766') WHERE `ref`=7712 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIFTOOL:EXIFTOOLVERSION\', value is \'10.22\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIFTOOL:EXIFTOOLVERSION', value is '10.22' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILENAME\', value is \'3341_36c8d8c98382132.jpg\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILENAME', value is '3341_36c8d8c98382132.jpg' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:DIRECTORY\', value is \'C:/resourcespace/include/\n/filestore/3/3/4/1_124760848ecbb08\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:DIRECTORY', value is 'C:/resourcespace/include/\n/filestore/3/3/4/1_124760848ecbb08' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILESIZE\', value is \'1057 kB\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILESIZE', value is '1057 kB' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILEMODIFYDATE\', value is \'2016-07-22 12:18:52\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILEMODIFYDATE', value is '2016-07-22 12:18:52' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILEACCESSDATE\', value is \'2016-07-22 12:18:52\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILEACCESSDATE', value is '2016-07-22 12:18:52' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILECREATEDATE\', value is \'2016-07-22 12:18:52\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILECREATEDATE', value is '2016-07-22 12:18:52' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILEPERMISSIONS\', value is \'rw-rw-rw-\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILEPERMISSIONS', value is 'rw-rw-rw-' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILETYPE\', value is \'JPEG\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILETYPE', value is 'JPEG' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:FILETYPEEXTENSION\', value is \'jpg\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:FILETYPEEXTENSION', value is 'jpg' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:MIMETYPE\', value is \'image/jpeg\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:MIMETYPE', value is 'image/jpeg' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:EXIFBYTEORDER\', value is \'Little-endian (Intel, II)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:EXIFBYTEORDER', value is 'Little-endian (Intel, II)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:IMAGEWIDTH\', value is \'1936\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:IMAGEWIDTH', value is '1936' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:IMAGEHEIGHT\', value is \'1288\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:IMAGEHEIGHT', value is '1288' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:ENCODINGPROCESS\', value is \'Baseline DCT, Huffman coding\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:ENCODINGPROCESS', value is 'Baseline DCT, Huffman coding' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:BITSPERSAMPLE\', value is \'8\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:BITSPERSAMPLE', value is '8' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:COLORCOMPONENTS\', value is \'3\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:COLORCOMPONENTS', value is '3' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'FILE:YCBCRSUBSAMPLING\', value is \'YCbCr4:2:2 (2 1)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'FILE:YCBCRSUBSAMPLING', value is 'YCbCr4:2:2 (2 1)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:MAKE\', value is \'Canon\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:MAKE', value is 'Canon' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:MODEL\', value is \'Canon EOS 1000D\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:MODEL', value is 'Canon EOS 1000D' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:ORIENTATION\', value is \'Horizontal (normal)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:ORIENTATION', value is 'Horizontal (normal)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:XRESOLUTION\', value is \'72\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:XRESOLUTION', value is '72' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:YRESOLUTION\', value is \'72\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:YRESOLUTION', value is '72' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:RESOLUTIONUNIT\', value is \'inches\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:RESOLUTIONUNIT', value is 'inches' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:MODIFYDATE\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:MODIFYDATE', value is '2015-07-31 17:14:00' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:YCBCRPOSITIONING\', value is \'Co-sited\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:YCBCRPOSITIONING', value is 'Co-sited' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXPOSURETIME\', value is \'1/400\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXPOSURETIME', value is '1/400' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FNUMBER\', value is \'4.0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FNUMBER', value is '4.0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXPOSUREPROGRAM\', value is \'Shutter speed priority AE\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXPOSUREPROGRAM', value is 'Shutter speed priority AE' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:ISO\', value is \'800\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:ISO', value is '800' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXIFVERSION\', value is \'0221\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXIFVERSION', value is '0221' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:DATETIMEORIGINAL\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:DATETIMEORIGINAL', value is '2015-07-31 17:14:00' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:CREATEDATE\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:CREATEDATE', value is '2015-07-31 17:14:00' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:COMPONENTSCONFIGURATION\', value is \'Y, Cb, Cr, -\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:COMPONENTSCONFIGURATION', value is 'Y, Cb, Cr, -' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:SHUTTERSPEEDVALUE\', value is \'1/395\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:SHUTTERSPEEDVALUE', value is '1/395' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:APERTUREVALUE\', value is \'4.0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:APERTUREVALUE', value is '4.0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FLASH\', value is \'Off, Did not fire\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FLASH', value is 'Off, Did not fire' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FOCALLENGTH\', value is \'30.0 mm\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FOCALLENGTH', value is '30.0 mm' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:USERCOMMENT\', value is \'\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:USERCOMMENT', value is '' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:SUBSECTIME\', value is \'81\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:SUBSECTIME', value is '81' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:SUBSECTIMEORIGINAL\', value is \'81\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:SUBSECTIMEORIGINAL', value is '81' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:SUBSECTIMEDIGITIZED\', value is \'81\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:SUBSECTIMEDIGITIZED', value is '81' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FLASHPIXVERSION\', value is \'0100\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FLASHPIXVERSION', value is '0100' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:COLORSPACE\', value is \'sRGB\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:COLORSPACE', value is 'sRGB' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXIFIMAGEWIDTH\', value is \'1936\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXIFIMAGEWIDTH', value is '1936' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXIFIMAGEHEIGHT\', value is \'1288\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXIFIMAGEHEIGHT', value is '1288' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:INTEROPINDEX\', value is \'R98 - DCF basic file (sRGB)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:INTEROPINDEX', value is 'R98 - DCF basic file (sRGB)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:INTEROPVERSION\', value is \'0100\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:INTEROPVERSION', value is '0100' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FOCALPLANEXRESOLUTION\', value is \'2210.045662\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FOCALPLANEXRESOLUTION', value is '2210.045662' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FOCALPLANEYRESOLUTION\', value is \'2209.262436\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FOCALPLANEYRESOLUTION', value is '2209.262436' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:FOCALPLANERESOLUTIONUNIT\', value is \'inches\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:FOCALPLANERESOLUTIONUNIT', value is 'inches' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:CUSTOMRENDERED\', value is \'Normal\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:CUSTOMRENDERED', value is 'Normal' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:EXPOSUREMODE\', value is \'Auto\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:EXPOSUREMODE', value is 'Auto' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:SCENECAPTURETYPE\', value is \'Standard\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:SCENECAPTURETYPE', value is 'Standard' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:COMPRESSION\', value is \'JPEG (old-style)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:COMPRESSION', value is 'JPEG (old-style)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:THUMBNAILOFFSET\', value is \'9632\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:THUMBNAILOFFSET', value is '9632' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'EXIF:THUMBNAILLENGTH\', value is \'8499\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'EXIF:THUMBNAILLENGTH', value is '8499' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MACROMODE\', value is \'Normal\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MACROMODE', value is 'Normal' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SELFTIMER\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SELFTIMER', value is 'Off' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:QUALITY\', value is \'Fine\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:QUALITY', value is 'Fine' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONFLASHMODE\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CANONFLASHMODE', value is 'Off' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTINUOUSDRIVE\', value is \'Single\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTINUOUSDRIVE', value is 'Single' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FOCUSMODE\', value is \'AI Focus AF\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FOCUSMODE', value is 'AI Focus AF' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:RECORDMODE\', value is \'JPEG\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:RECORDMODE', value is 'JPEG' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONIMAGESIZE\', value is \'Small\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CANONIMAGESIZE', value is 'Small' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:EASYMODE\', value is \'Manual\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:EASYMODE', value is 'Manual' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:DIGITALZOOM\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:DIGITALZOOM', value is 'None' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRAST\', value is \'Normal\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRAST', value is 'Normal' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATION\', value is \'Normal\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATION', value is 'Normal' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:METERINGMODE\', value is \'Evaluative\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:METERINGMODE', value is 'Evaluative' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FOCUSRANGE\', value is \'Not Known\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FOCUSRANGE', value is 'Not Known' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONEXPOSUREMODE\', value is \'Shutter speed priority AE\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CANONEXPOSUREMODE', value is 'Shutter speed priority AE' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LENSTYPE\', value is \'Canon EF-S 18-55mm f/3.5-5.6 [II]\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:LENSTYPE', value is 'Canon EF-S 18-55mm f/3.5-5.6 [II]' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MAXFOCALLENGTH\', value is \'55 mm\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MAXFOCALLENGTH', value is '55 mm' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MINFOCALLENGTH\', value is \'18 mm\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MINFOCALLENGTH', value is '18 mm' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FOCALUNITS\', value is \'1/mm\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FOCALUNITS', value is '1/mm' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MAXAPERTURE\', value is \'4.2\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MAXAPERTURE', value is '4.2' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MINAPERTURE\', value is \'27\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MINAPERTURE', value is '27' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHACTIVITY\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FLASHACTIVITY', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHBITS\', value is \'(none)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FLASHBITS', value is '(none)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:ZOOMSOURCEWIDTH\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:ZOOMSOURCEWIDTH', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:ZOOMTARGETWIDTH\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:ZOOMTARGETWIDTH', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MANUALFLASHOUTPUT\', value is \'n/a\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MANUALFLASHOUTPUT', value is 'n/a' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONE\', value is \'Normal\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONE', value is 'Normal' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AUTOISO\', value is \'100\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:AUTOISO', value is '100' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BASEISO\', value is \'800\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:BASEISO', value is '800' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MEASUREDEV\', value is \'9.13\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MEASUREDEV', value is '9.13' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TARGETAPERTURE\', value is \'4\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:TARGETAPERTURE', value is '4' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TARGETEXPOSURETIME\', value is \'1/406\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:TARGETEXPOSURETIME', value is '1/406' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:EXPOSURECOMPENSATION\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:EXPOSURECOMPENSATION', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WHITEBALANCE\', value is \'Auto\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:WHITEBALANCE', value is 'Auto' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SLOWSHUTTER\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SLOWSHUTTER', value is 'None' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SEQUENCENUMBER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SEQUENCENUMBER', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:OPTICALZOOMCODE\', value is \'n/a\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:OPTICALZOOMCODE', value is 'n/a' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CAMERATEMPERATURE\', value is \'26 C\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CAMERATEMPERATURE', value is '26 C' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHGUIDENUMBER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FLASHGUIDENUMBER', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHEXPOSURECOMP\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FLASHEXPOSURECOMP', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AUTOEXPOSUREBRACKETING\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:AUTOEXPOSUREBRACKETING', value is 'Off' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AEBBRACKETVALUE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:AEBBRACKETVALUE', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTROLMODE\', value is \'Camera Local Control\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTROLMODE', value is 'Camera Local Control' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MEASUREDEV2\', value is \'9.125\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:MEASUREDEV2', value is '9.125' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BULBDURATION\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:BULBDURATION', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CAMERATYPE\', value is \'EOS High-end\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CAMERATYPE', value is 'EOS High-end' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:NDFILTER\', value is \'n/a\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:NDFILTER', value is 'n/a' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONIMAGETYPE\', value is \'Canon EOS 1000D\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CANONIMAGETYPE', value is 'Canon EOS 1000D' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONFIRMWAREVERSION\', value is \'Firmware Version 1.0.6\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CANONFIRMWAREVERSION', value is 'Firmware Version 1.0.6' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:OWNERNAME\', value is \'\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:OWNERNAME', value is '' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SERIALNUMBER\', value is \'2050463834\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SERIALNUMBER', value is '2050463834' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHMETERINGMODE\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FLASHMETERINGMODE', value is 'Off' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CAMERAORIENTATION\', value is \'Horizontal (normal)\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CAMERAORIENTATION', value is 'Horizontal (normal)' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FIRMWAREVERSION\', value is \'1.0.6\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FIRMWAREVERSION', value is '1.0.6' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:DIRECTORYINDEX\', value is \'100\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:DIRECTORYINDEX', value is '100' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FILEINDEX\', value is \'4382\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FILEINDEX', value is '4382' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTSTANDARD\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTSTANDARD', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSSTANDARD\', value is \'3\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSSTANDARD', value is '3' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONSTANDARD\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONSTANDARD', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONESTANDARD\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONESTANDARD', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTPORTRAIT\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTPORTRAIT', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSPORTRAIT\', value is \'2\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSPORTRAIT', value is '2' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONPORTRAIT\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONPORTRAIT', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONEPORTRAIT\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONEPORTRAIT', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTLANDSCAPE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTLANDSCAPE', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSLANDSCAPE\', value is \'4\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSLANDSCAPE', value is '4' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONLANDSCAPE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONLANDSCAPE', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONELANDSCAPE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONELANDSCAPE', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTNEUTRAL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTNEUTRAL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSNEUTRAL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSNEUTRAL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONNEUTRAL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONNEUTRAL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONENEUTRAL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONENEUTRAL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTFAITHFUL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTFAITHFUL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSFAITHFUL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSFAITHFUL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONFAITHFUL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONFAITHFUL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONEFAITHFUL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONEFAITHFUL', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTMONOCHROME\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTMONOCHROME', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSMONOCHROME\', value is \'3\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSMONOCHROME', value is '3' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FILTEREFFECTMONOCHROME\', value is \'Green\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FILTEREFFECTMONOCHROME', value is 'Green' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TONINGEFFECTMONOCHROME\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:TONINGEFFECTMONOCHROME', value is 'None' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTUSERDEF1\', value is \'1\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTUSERDEF1', value is '1' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSUSERDEF1\', value is \'4\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SHARPNESSUSERDEF1', value is '4' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONUSERDEF1\', value is \'-1\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:SATURATIONUSERDEF1', value is '-1' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONEUSERDEF1\', value is \'2\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:COLORTONEUSERDEF1', value is '2' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FILTEREFFECTUSERDEF1\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:FILTEREFFECTUSERDEF1', value is 'None' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TONINGEFFECTUSERDEF1\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:TONINGEFFECTUSERDEF1', value is 'None' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTUSERDEF2\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:56 Exiftool: extracted field 'MAKERNOTES:CONTRASTUSERDEF2', value is '0' 2016-07-22 10:18:56 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSUSERDEF2\', value is \'3\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SHARPNESSUSERDEF2', value is '3' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONUSERDEF2\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SATURATIONUSERDEF2', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONEUSERDEF2\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTONEUSERDEF2', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FILTEREFFECTUSERDEF2\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:FILTEREFFECTUSERDEF2', value is 'None' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TONINGEFFECTUSERDEF2\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:TONINGEFFECTUSERDEF2', value is 'None' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CONTRASTUSERDEF3\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CONTRASTUSERDEF3', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSUSERDEF3\', value is \'3\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SHARPNESSUSERDEF3', value is '3' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SATURATIONUSERDEF3\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SATURATIONUSERDEF3', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTONEUSERDEF3\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTONEUSERDEF3', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FILTEREFFECTUSERDEF3\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:FILTEREFFECTUSERDEF3', value is 'None' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TONINGEFFECTUSERDEF3\', value is \'None\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:TONINGEFFECTUSERDEF3', value is 'None' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:USERDEF1PICTURESTYLE\', value is \'Standard\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:USERDEF1PICTURESTYLE', value is 'Standard' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:USERDEF2PICTURESTYLE\', value is \'Standard\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:USERDEF2PICTURESTYLE', value is 'Standard' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:USERDEF3PICTURESTYLE\', value is \'Standard\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:USERDEF3PICTURESTYLE', value is 'Standard' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONMODELID\', value is \'EOS Rebel XS / 1000D / Kiss F\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CANONMODELID', value is 'EOS Rebel XS / 1000D / Kiss F' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:THUMBNAILIMAGEVALIDAREA\', value is \'0 159 7 112\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:THUMBNAILIMAGEVALIDAREA', value is '0 159 7 112' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SERIALNUMBERFORMAT\', value is \'Format 2\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SERIALNUMBERFORMAT', value is 'Format 2' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFAREAMODE\', value is \'Single-point AF\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFAREAMODE', value is 'Single-point AF' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:NUMAFPOINTS\', value is \'7\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:NUMAFPOINTS', value is '7' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:VALIDAFPOINTS\', value is \'7\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:VALIDAFPOINTS', value is '7' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONIMAGEWIDTH\', value is \'1936\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CANONIMAGEWIDTH', value is '1936' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CANONIMAGEHEIGHT\', value is \'1288\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CANONIMAGEHEIGHT', value is '1288' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFIMAGEWIDTH\', value is \'3888\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFIMAGEWIDTH', value is '3888' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFIMAGEHEIGHT\', value is \'2592\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFIMAGEHEIGHT', value is '2592' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFAREAWIDTHS\', value is \'194 139 139 194 139 139 194\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFAREAWIDTHS', value is '194 139 139 194 139 139 194' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFAREAHEIGHTS\', value is \'139 194 194 194 194 194 139\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFAREAHEIGHTS', value is '139 194 194 194 194 194 139' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFAREAXPOSITIONS\', value is \'0 -1283 -769 0 769 1283 0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFAREAXPOSITIONS', value is '0 -1283 -769 0 769 1283 0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFAREAYPOSITIONS\', value is \'-640 0 0 0 0 0 640\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFAREAYPOSITIONS', value is '-640 0 0 0 0 0 640' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFPOINTSINFOCUS\', value is \'4,5\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFPOINTSINFOCUS', value is '4,5' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFPOINTSSELECTED\', value is \'0,1,2,3,4,5,6\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFPOINTSSELECTED', value is '0,1,2,3,4,5,6' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:ORIGINALDECISIONDATAOFFSET\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:ORIGINALDECISIONDATAOFFSET', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BRACKETMODE\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BRACKETMODE', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BRACKETVALUE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BRACKETVALUE', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BRACKETSHOTNUMBER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BRACKETSHOTNUMBER', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:RAWJPGSIZE\', value is \'Large\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:RAWJPGSIZE', value is 'Large' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LONGEXPOSURENOISEREDUCTION2\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LONGEXPOSURENOISEREDUCTION2', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WBBRACKETMODE\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WBBRACKETMODE', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WBBRACKETVALUEAB\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WBBRACKETVALUEAB', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WBBRACKETVALUEGM\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WBBRACKETVALUEGM', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LIVEVIEWSHOOTING\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LIVEVIEWSHOOTING', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FOCUSDISTANCEUPPER\', value is \'1.42 m\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:FOCUSDISTANCEUPPER', value is '1.42 m' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FOCUSDISTANCELOWER\', value is \'1.19 m\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:FOCUSDISTANCELOWER', value is '1.19 m' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LENSMODEL\', value is \'EF-S18-55mm f/3.5-5.6\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LENSMODEL', value is 'EF-S18-55mm f/3.5-5.6' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:INTERNALSERIALNUMBER\', value is \'L1516235UU\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:INTERNALSERIALNUMBER', value is 'L1516235UU' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:DUSTREMOVALDATA\', value is \'(Binary data 1024 bytes, use -b option to extract)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:DUSTREMOVALDATA', value is '(Binary data 1024 bytes, use -b option to extract)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CROPLEFTMARGIN\', value is \'8\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CROPLEFTMARGIN', value is '8' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CROPRIGHTMARGIN\', value is \'8\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CROPRIGHTMARGIN', value is '8' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CROPTOPMARGIN\', value is \'8\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CROPTOPMARGIN', value is '8' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CROPBOTTOMMARGIN\', value is \'8\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CROPBOTTOMMARGIN', value is '8' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:EXPOSURELEVELINCREMENTS\', value is \'1/3 Stop\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:EXPOSURELEVELINCREMENTS', value is '1/3 Stop' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:FLASHSYNCSPEEDAV\', value is \'Auto\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:FLASHSYNCSPEEDAV', value is 'Auto' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LONGEXPOSURENOISEREDUCTION\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LONGEXPOSURENOISEREDUCTION', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:HIGHISONOISEREDUCTION\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:HIGHISONOISEREDUCTION', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AUTOLIGHTINGOPTIMIZER\', value is \'Enable\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AUTOLIGHTINGOPTIMIZER', value is 'Enable' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFASSISTBEAM\', value is \'Emits\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFASSISTBEAM', value is 'Emits' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AFDURINGLIVEVIEW\', value is \'Disable\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AFDURINGLIVEVIEW', value is 'Disable' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MIRRORLOCKUP\', value is \'Disable\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:MIRRORLOCKUP', value is 'Disable' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHUTTER-AELOCK\', value is \'AF/AE lock\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SHUTTER-AELOCK', value is 'AF/AE lock' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SETBUTTONWHENSHOOTING\', value is \'LCD monitor On/Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SETBUTTONWHENSHOOTING', value is 'LCD monitor On/Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LCDDISPLAYATPOWERON\', value is \'Display\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LCDDISPLAYATPOWERON', value is 'Display' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:ADDORIGINALDECISIONDATA\', value is \'Off\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:ADDORIGINALDECISIONDATA', value is 'Off' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:TONECURVE\', value is \'Standard\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:TONECURVE', value is 'Standard' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESS\', value is \'4\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SHARPNESS', value is '4' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SHARPNESSFREQUENCY\', value is \'n/a\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SHARPNESSFREQUENCY', value is 'n/a' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORREDLEVEL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORREDLEVEL', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORBLUELEVEL\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORBLUELEVEL', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WHITEBALANCERED\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WHITEBALANCERED', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WHITEBALANCEBLUE\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WHITEBALANCEBLUE', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPERATURE\', value is \'5200\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPERATURE', value is '5200' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:PICTURESTYLE\', value is \'Landscape\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:PICTURESTYLE', value is 'Landscape' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:DIGITALGAIN\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:DIGITALGAIN', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WBSHIFTAB\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WBSHIFTAB', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WBSHIFTGM\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WBSHIFTGM', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:MEASUREDRGGB\', value is \'918 1024 1024 530\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:MEASUREDRGGB', value is '918 1024 1024 530' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:VRDOFFSET\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:VRDOFFSET', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORWIDTH\', value is \'3948\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORWIDTH', value is '3948' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORHEIGHT\', value is \'2622\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORHEIGHT', value is '2622' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORLEFTBORDER\', value is \'52\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORLEFTBORDER', value is '52' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORTOPBORDER\', value is \'23\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORTOPBORDER', value is '23' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORRIGHTBORDER\', value is \'3939\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORRIGHTBORDER', value is '3939' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SENSORBOTTOMBORDER\', value is \'2614\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SENSORBOTTOMBORDER', value is '2614' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BLACKMASKLEFTBORDER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BLACKMASKLEFTBORDER', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BLACKMASKTOPBORDER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BLACKMASKTOPBORDER', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BLACKMASKRIGHTBORDER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BLACKMASKRIGHTBORDER', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:BLACKMASKBOTTOMBORDER\', value is \'0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:BLACKMASKBOTTOMBORDER', value is '0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORDATAVERSION\', value is \'5 (450D/1000D)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORDATAVERSION', value is '5 (450D/1000D)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSASSHOT\', value is \'1802 1024 1024 1935\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSASSHOT', value is '1802 1024 1024 1935' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPASSHOT\', value is \'4014\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPASSHOT', value is '4014' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSAUTO\', value is \'1802 1024 1024 1935\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSAUTO', value is '1802 1024 1024 1935' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPAUTO\', value is \'4014\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPAUTO', value is '4014' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSMEASURED\', value is \'1800 1023 1024 1936\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSMEASURED', value is '1800 1023 1024 1936' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPMEASURED\', value is \'4014\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPMEASURED', value is '4014' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSDAYLIGHT\', value is \'2171 1024 1024 1560\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSDAYLIGHT', value is '2171 1024 1024 1560' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPDAYLIGHT\', value is \'5200\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPDAYLIGHT', value is '5200' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSSHADE\', value is \'2533 1024 1024 1288\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSSHADE', value is '2533 1024 1024 1288' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPSHADE\', value is \'7000\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPSHADE', value is '7000' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSCLOUDY\', value is \'2346 1024 1024 1406\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSCLOUDY', value is '2346 1024 1024 1406' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPCLOUDY\', value is \'6000\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPCLOUDY', value is '6000' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSTUNGSTEN\', value is \'1589 1112 1112 2671\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSTUNGSTEN', value is '1589 1112 1112 2671' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPTUNGSTEN\', value is \'3200\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPTUNGSTEN', value is '3200' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSFLUORESCENT\', value is \'1883 1024 1024 2194\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSFLUORESCENT', value is '1883 1024 1024 2194' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPFLUORESCENT\', value is \'3864\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPFLUORESCENT', value is '3864' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSKELVIN\', value is \'2171 1024 1024 1560\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSKELVIN', value is '2171 1024 1024 1560' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPKELVIN\', value is \'5211\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPKELVIN', value is '5211' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:WB_RGGBLEVELSFLASH\', value is \'2399 1024 1024 1398\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:WB_RGGBLEVELSFLASH', value is '2399 1024 1024 1398' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:COLORTEMPFLASH\', value is \'6147\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:COLORTEMPFLASH', value is '6147' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:AVERAGEBLACKLEVEL\', value is \'1023 1023 1023 1023\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:AVERAGEBLACKLEVEL', value is '1023 1023 1023 1023' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:RAWMEASUREDRGGB\', value is \'3049 3410 3477 1767\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:RAWMEASUREDRGGB', value is '3049 3410 3477 1767' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:PERCHANNELBLACKLEVEL\', value is \'1023 1022 1023 1022\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:PERCHANNELBLACKLEVEL', value is '1023 1022 1023 1022' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:SPECULARWHITELEVEL\', value is \'15120\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:SPECULARWHITELEVEL', value is '15120' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:LINEARITYUPPERMARGIN\', value is \'10000\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:LINEARITYUPPERMARGIN', value is '10000' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'MAKERNOTES:CUSTOMPICTURESTYLEFILENAME\', value is \'\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'MAKERNOTES:CUSTOMPICTURESTYLEFILENAME', value is '' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:APERTURE\', value is \'4.0\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:APERTURE', value is '4.0' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:DRIVEMODE\', value is \'Single-frame Shooting\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:DRIVEMODE', value is 'Single-frame Shooting' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:FILENUMBER\', value is \'100-4382\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:FILENUMBER', value is '100-4382' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:IMAGESIZE\', value is \'1936x1288\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:IMAGESIZE', value is '1936x1288' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:LENS\', value is \'18.0 - 55.0 mm\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:LENS', value is '18.0 - 55.0 mm' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:LENSID\', value is \'Canon EF-S 18-55mm f/3.5-5.6 [II]\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:LENSID', value is 'Canon EF-S 18-55mm f/3.5-5.6 [II]' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:MEGAPIXELS\', value is \'2.5\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:MEGAPIXELS', value is '2.5' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SCALEFACTOR35EFL\', value is \'1.6\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SCALEFACTOR35EFL', value is '1.6' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SHOOTINGMODE\', value is \'Shutter speed priority AE\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SHOOTINGMODE', value is 'Shutter speed priority AE' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SHUTTERSPEED\', value is \'1/400\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SHUTTERSPEED', value is '1/400' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SUBSECCREATEDATE\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SUBSECCREATEDATE', value is '2015-07-31 17:14:00' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SUBSECDATETIMEORIGINAL\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SUBSECDATETIMEORIGINAL', value is '2015-07-31 17:14:00' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:SUBSECMODIFYDATE\', value is \'2015-07-31 17:14:00\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:SUBSECMODIFYDATE', value is '2015-07-31 17:14:00' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:THUMBNAILIMAGE\', value is \'(Binary data 8499 bytes, use -b option to extract)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:THUMBNAILIMAGE', value is '(Binary data 8499 bytes, use -b option to extract)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:WB_RGGBLEVELS\', value is \'1802 1024 1024 1935\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:WB_RGGBLEVELS', value is '1802 1024 1024 1935' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:BLUEBALANCE\', value is \'1.889648\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:BLUEBALANCE', value is '1.889648' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:CIRCLEOFCONFUSION\', value is \'0.019 mm\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:CIRCLEOFCONFUSION', value is '0.019 mm' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:DOF\', value is \'0.28 m (1.18 - 1.46 m)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:DOF', value is '0.28 m (1.18 - 1.46 m)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:FOV\', value is \'40.7 deg\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:FOV', value is '40.7 deg' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:FOCALLENGTH35EFL\', value is \'30.0 mm (35 mm equivalent: 48.6 mm)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:FOCALLENGTH35EFL', value is '30.0 mm (35 mm equivalent: 48.6 mm)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:HYPERFOCALDISTANCE\', value is \'12.12 m\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:HYPERFOCALDISTANCE', value is '12.12 m' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:LENS35EFL\', value is \'18.0 - 55.0 mm (35 mm equivalent: 29.1 - 89.0 mm)\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:LENS35EFL', value is '18.0 - 55.0 mm (35 mm equivalent: 29.1 - 89.0 mm)' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:LIGHTVALUE\', value is \'9.6\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:LIGHTVALUE', value is '9.6' 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Exiftool: extracted field \'COMPOSITE:REDBALANCE\', value is \'1.759766\'') WHERE `ref`=7712 2016-07-22 10:18:57 Exiftool: extracted field 'COMPOSITE:REDBALANCE', value is '1.759766' 2016-07-22 10:18:57 SQL: SELECT resource.file_path FROM resource WHERE resource.ref = 3341 2016-07-22 10:18:57 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','EXIF - option for field 12 : yes') WHERE `ref`=7712 2016-07-22 10:18:57 EXIF - option for field 12 : yes 2016-07-22 10:18:57 SQL: select ref,keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='12' 2016-07-22 10:18:57 SQL: SELECT * FROM node WHERE resource_type_field = '12' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:57 SQL: select value from resource_data where resource='3341' and resource_type_field='12' 2016-07-22 10:18:57 SQL: select value from resource_data where resource='3341' and resource_type_field='12' 2016-07-22 10:18:57 resolving keyword 2016. Create=true 2016-07-22 10:18:57 resolving normalized keyword 2016. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='2016' 2016-07-22 10:18:57 SQL: delete from resource_keyword where resource='3341' and keyword='39' and resource_type_field='12' 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count-1 where ref='39' limit 1 2016-07-22 10:18:57 resolving keyword 07. Create=true 2016-07-22 10:18:57 resolving normalized keyword 07. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='07' 2016-07-22 10:18:57 SQL: delete from resource_keyword where resource='3341' and keyword='99' and resource_type_field='12' and position='1' 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count-1 where ref='99' limit 1 2016-07-22 10:18:57 resolving keyword 22. Create=true 2016-07-22 10:18:57 resolving normalized keyword 22. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='22' 2016-07-22 10:18:57 SQL: delete from resource_keyword where resource='3341' and keyword='125' and resource_type_field='12' and position='2' 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count-1 where ref='125' limit 1 2016-07-22 10:18:57 resolving keyword 10. Create=true 2016-07-22 10:18:57 resolving normalized keyword 10. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='10' 2016-07-22 10:18:57 SQL: delete from resource_keyword where resource='3341' and keyword='85' and resource_type_field='12' and position='3' 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count-1 where ref='85' limit 1 2016-07-22 10:18:57 resolving keyword 17. Create=true 2016-07-22 10:18:57 resolving normalized keyword 17. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='17' 2016-07-22 10:18:57 SQL: delete from resource_keyword where resource='3341' and keyword='42' and resource_type_field='12' and position='4' 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count-1 where ref='42' limit 1 2016-07-22 10:18:57 adding 2015 2016-07-22 10:18:57 resolving keyword 2015. Create=true 2016-07-22 10:18:57 resolving normalized keyword 2015. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='2015' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','2348','0','12') 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count+1 where ref='2348' 2016-07-22 10:18:57 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='2348' and external='0' 2016-07-22 10:18:57 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','2348','0','1') 2016-07-22 10:18:57 adding 07 2016-07-22 10:18:57 resolving keyword 07. Create=true 2016-07-22 10:18:57 resolving normalized keyword 07. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='07' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','99','1','12') 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count+1 where ref='99' 2016-07-22 10:18:57 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='99' and external='0' 2016-07-22 10:18:57 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','99','0','1') 2016-07-22 10:18:57 adding 31 2016-07-22 10:18:57 resolving keyword 31. Create=true 2016-07-22 10:18:57 resolving normalized keyword 31. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='31' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','104','2','12') 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count+1 where ref='104' 2016-07-22 10:18:57 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='104' and external='0' 2016-07-22 10:18:57 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','104','0','1') 2016-07-22 10:18:57 adding 17 2016-07-22 10:18:57 resolving keyword 17. Create=true 2016-07-22 10:18:57 resolving normalized keyword 17. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='17' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','42','3','12') 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count+1 where ref='42' 2016-07-22 10:18:57 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='42' and external='0' 2016-07-22 10:18:57 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','42','0','1') 2016-07-22 10:18:57 adding 14 2016-07-22 10:18:57 resolving keyword 14. Create=true 2016-07-22 10:18:57 resolving normalized keyword 14. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='14' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','94','4','12') 2016-07-22 10:18:57 SQL: update keyword set hit_count=hit_count+1 where ref='94' 2016-07-22 10:18:57 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='94' and external='0' 2016-07-22 10:18:57 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','94','0','1') 2016-07-22 10:18:57 adding 00 2016-07-22 10:18:57 resolving keyword 00. Create=true 2016-07-22 10:18:57 resolving normalized keyword 00. 2016-07-22 10:18:57 SQL: select ref value from keyword where keyword='00' 2016-07-22 10:18:57 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','154','5','12') 2016-07-22 10:18:58 SQL: update keyword set hit_count=hit_count+1 where ref='154' 2016-07-22 10:18:58 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='154' and external='0' 2016-07-22 10:18:58 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','154','0','1') 2016-07-22 10:18:58 SQL: delete from resource_data where resource='3341' and resource_type_field='12' 2016-07-22 10:18:58 SQL: insert into resource_data(resource,resource_type_field,value) values ('3341','12','2015-07-31 17:14:00') 2016-07-22 10:18:58 SQL: update resource set field12='2015-07-31 17:14:00' where ref='3341' 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','EXIF - option for field 52 : yes') WHERE `ref`=7712 2016-07-22 10:18:58 EXIF - option for field 52 : yes 2016-07-22 10:18:58 SQL: select ref,keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='52' 2016-07-22 10:18:58 SQL: SELECT * FROM node WHERE resource_type_field = '52' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:58 SQL: select value from resource_data where resource='3341' and resource_type_field='52' 2016-07-22 10:18:58 SQL: delete from resource_data where resource='3341' and resource_type_field='52' 2016-07-22 10:18:58 SQL: insert into resource_data(resource,resource_type_field,value) values ('3341','52','Canon EOS 1000D') 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','EXIF - custom option for filename field 51 : yes') WHERE `ref`=7712 2016-07-22 10:18:58 EXIF - custom option for filename field 51 : yes 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg 2016-07-22 10:18:58 SQL: select file_extension value from resource where ref = '3341' 2016-07-22 10:18:58 SQL: select resource_type, name from resource left join resource_type on resource.resource_type = resource_type.ref where resource.ref = '3341' 2016-07-22 10:18:58 SQL: select resource_type value from resource where ref='3341' 2016-07-22 10:18:58 use perms: 1 2016-07-22 10:18:58 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='3341') d on d.resource_type_field=f.ref and d.resource='3341' 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 2016-07-22 10:18:58 SQL: select ref value from resource_type 2016-07-22 10:18:58 fieldMaitre=, 2016-07-22 10:18:58 fieldTitle=dudes 2016-07-22 10:18:58 fieldCaption= 2016-07-22 10:18:58 fieldKeywords - Subject=, 2016-07-22 10:18:58 fieldKeywords - Emotion=, 2016-07-22 10:18:58 fieldKeywords - Event=, 2016-07-22 10:18:58 fieldKeywords - Other= 2016-07-22 10:18:58 fieldNamed person(s)= 2016-07-22 10:18:58 fieldCountry=, 2016-07-22 10:18:58 fieldDate=2015-07-31 17:14:00 2016-07-22 10:18:58 fieldOriginal filename= 2016-07-22 10:18:58 fieldExtracted text= 2016-07-22 10:18:58 fieldCredit= 2016-07-22 10:18:58 fieldNotes= 2016-07-22 10:18:58 fieldCamera make / model=Canon EOS 1000D 2016-07-22 10:18:58 fieldSource=, 2016-07-22 10:18:58 SQL: select resource_type value from resource where ref='3341' 2016-07-22 10:18:58 SQL: select ref,autocomplete_macro from resource_type_field where (resource_type=0 || resource_type='1') and length(autocomplete_macro)>0 2016-07-22 10:18:58 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(),'4','3341','t',null,'','Extract','-1','','0',null,'') 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:58 SQL: select ref,keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='51' 2016-07-22 10:18:58 SQL: SELECT * FROM node WHERE resource_type_field = '51' AND parent IS NULL ORDER BY order_by ASC; 2016-07-22 10:18:58 SQL: select value from resource_data where resource='3341' and resource_type_field='51' 2016-07-22 10:18:58 SQL: select value from resource_data where resource='3341' and resource_type_field='51' 2016-07-22 10:18:58 adding dudes 2016-07-22 10:18:58 resolving keyword dudes. Create=true 2016-07-22 10:18:58 resolving normalized keyword dudes. 2016-07-22 10:18:58 SQL: select ref value from keyword where keyword='dudes' 2016-07-22 10:18:58 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','4108','0','51') 2016-07-22 10:18:58 SQL: update keyword set hit_count=hit_count+1 where ref='4108' 2016-07-22 10:18:58 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4108' and external='0' 2016-07-22 10:18:58 SQL: update daily_stat set count=count+1 where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='4108' and external='0' 2016-07-22 10:18:58 adding jpg 2016-07-22 10:18:58 resolving keyword jpg. Create=true 2016-07-22 10:18:58 resolving normalized keyword jpg. 2016-07-22 10:18:58 SQL: select ref value from keyword where keyword='jpg' 2016-07-22 10:18:58 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3341','73','1','51') 2016-07-22 10:18:58 SQL: update keyword set hit_count=hit_count+1 where ref='73' 2016-07-22 10:18:58 SQL: select count(*) value from daily_stat where year='2016' and month='7' and day='22' and usergroup='3' and activity_type='Keyword added to resource' and object_ref='73' and external='0' 2016-07-22 10:18:58 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Keyword added to resource','73','0','1') 2016-07-22 10:18:58 SQL: delete from resource_data where resource='3341' and resource_type_field='51' 2016-07-22 10:18:58 SQL: insert into resource_data(resource,resource_type_field,value) values ('3341','51','dudes.JPG') 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_2_a2fc2272bb95717.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_2_wm_3e6e9dfb3f80fa0.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_3_eec74af7fb16c54.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_3_wm_846876dea3ee605.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_4_319e9dfdc718164.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_4_wm_f0c0eb31c0e9a34.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_5_d8d3b4dfafc4eca.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_5_wm_27aa2ecf3077627.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_6_ba1af479c9de17d.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_6_wm_e263447ea67fbda.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_7_39f1f040f4ce2a1.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_7_wm_e778a705e1539ca.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_8_bc10e13485ab9d2.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_8_wm_aace8a46341c788.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_9_35359b3c2a0ca84.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_9_wm_008735f6c7b7143.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_10_a69215240bd78e2.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_10_wm_4f0e00fedf13380.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_11_ca7b89f443d7268.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_11_wm_ad1945a1575c14c.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_12_04d5ea73f85e913.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_12_wm_fe5211b017cb7bc.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_13_a3e63fbbcae7c3f.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_13_wm_451952d3bc8ebf4.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_14_7695e51225fffb3.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_14_wm_d885627db420dfa.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_15_8a8927afb0e7c74.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_15_wm_1740fe4fa82fbad.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_16_7f1c4f652e1c398.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_16_wm_0dff390020d1e63.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_17_d0728d132199aab.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_17_wm_7e244a12e85e50b.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_18_38e9ec367686428.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_18_wm_fda16090d36624b.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_19_00d978274859057.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_19_wm_fa2fb02d15641f2.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_20_c0425c3f35e9429.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_20_wm_a8f4b2342597cd7.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_21_7e31c5b494eb662.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_21_wm_5563e2444bef364.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_22_7787b833b9995dc.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_22_wm_8bf6aa0174fac5d.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_23_86c1156d77a6a95.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_23_wm_29be17bcd5abdf5.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_24_bf8080420121749.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_24_wm_cf44644cc5f58ab.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_25_08b63095552b5f4.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_25_wm_ee66b258c32f622.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_26_a7a7d0b908fce18.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_26_wm_8e298a1b34625d1.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_27_5b81a6b8ab5aea2.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_27_wm_054fe5a8fe3666f.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_28_812dcecda3354a4.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_28_wm_c69ce6de425eef3.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_29_f80eff8d72854d8.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_29_wm_f9af32a317c3fbd.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_30_7d3be8b932e319b.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_30_wm_de23a0e78985704.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.flv 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.flv 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.mp3 2016-07-22 10:18:58 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(),'4','3341','t',null,'','Create previews','-1','','0',null,'') 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','create_previews(ref=3341,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=,checksum_required=1)') WHERE `ref`=7714 2016-07-22 10:18:58 create_previews(ref=3341,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=,checksum_required=1) 2016-07-22 10:18:58 SQL: select file_extension value from resource where ref=3341 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','create_previews - generate checksum for 3341') WHERE `ref`=7714 2016-07-22 10:18:58 create_previews - generate checksum for 3341 2016-07-22 10:18:58 SQL: update resource set file_checksum='' where ref='3341' 2016-07-22 10:18:58 SQL: update resource set preview_tweaks = '0|1' where ref = '3341' 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','File source is C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg') WHERE `ref`=7714 2016-07-22 10:18:58 File source is C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','create_previews_using_im(ref=3341,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=)') WHERE `ref`=7714 2016-07-22 10:18:58 create_previews_using_im(ref=3341,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=) 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341hpr_4054e4c9413eaa0.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341lpr_7dee45e21073838.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_wm_6cb6ea9dae7f79a.jpg 2016-07-22 10:18:58 CLI command: "C:\imagemagick\identify.exe" -format %wx%h "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg"[0] 2016-07-22 10:18:58 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:18:58 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:18:58 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:18:58 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:18:58 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:18:58 SQL: select language,name,text from site_text where (page='message' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:18:58 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:18:58 SQL: SELECT name, value FROM sysvars 2016-07-22 10:18:58 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:18:58 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:18:58 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:18:58 SQL: select ref value from collection where ref='69' 2016-07-22 10:18:58 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:18:58 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:18:58 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:18:58 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:18:58 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:18:58 SQL: SELECT user_message.ref, user.username AS owner, user_message.seen, message.created, message.expires, message.message, message.url FROM `user_message` INNER JOIN `message` ON user_message.message=message.ref LEFT OUTER JOIN `user` ON message.owner=user.ref WHERE user_message.user='4' AND message.expires > NOW() AND user_message.seen='0' ORDER BY user_message.ref ASC 2016-07-22 10:18:58 CLI output: 1936x1288 2016-07-22 10:18:58 CLI errors: 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:imagemagickidentify.exe" -format %wx%h "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg"[0]:\n1936x1288') WHERE `ref`=7714 2016-07-22 10:18:58 SQL: select * from preview_size order by width desc, height desc 2016-07-22 10:18:58 convert: preview quality for hpr=90 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating hpr (sw=1936, tw=999999, sh=1288, th=999999, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:18:58 Contemplating hpr (sw=1936, tw=999999, sh=1288, th=999999, extension=jpg) 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341hpr_4054e4c9413eaa0.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341hpr_wm_ff276e7c695545b.jpg 2016-07-22 10:18:58 convert: preview quality for lpr=90 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating lpr (sw=1936, tw=2000, sh=1288, th=2000, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:18:58 Contemplating lpr (sw=1936, tw=2000, sh=1288, th=2000, extension=jpg) 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341lpr_7dee45e21073838.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341lpr_wm_2f66b3819a0784b.jpg 2016-07-22 10:18:58 convert: preview quality for scr=90 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating scr (sw=1936, tw=1400, sh=1288, th=800, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:18:58 Contemplating scr (sw=1936, tw=1400, sh=1288, th=800, extension=jpg) 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg 2016-07-22 10:18:58 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_wm_6cb6ea9dae7f79a.jpg 2016-07-22 10:18:58 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Generating preview size scr to C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg') WHERE `ref`=7714 2016-07-22 10:18:58 Generating preview size scr to C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg 2016-07-22 10:18:58 CLI command: "C:\imagemagick\convert.exe" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 1400x800">" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg" 2016-07-22 10:18:59 CLI output: 2016-07-22 10:18:59 CLI errors: 2016-07-22 10:18:59 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:imagemagickconvert.exe" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 1400x800">" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg":\n') WHERE `ref`=7714 2016-07-22 10:18:59 convert: preview quality for pre=90 2016-07-22 10:18:59 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating pre (sw=1936, tw=700, sh=1288, th=450, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:18:59 Contemplating pre (sw=1936, tw=700, sh=1288, th=450, extension=jpg) 2016-07-22 10:18:59 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg 2016-07-22 10:18:59 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_wm_84b8f1263578859.jpg 2016-07-22 10:18:59 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Generating preview size pre to C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg') WHERE `ref`=7714 2016-07-22 10:18:59 Generating preview size pre to C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg 2016-07-22 10:18:59 CLI command: "C:\imagemagick\convert.exe" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 700x450">" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg" 2016-07-22 10:19:00 CLI output: 2016-07-22 10:19:00 CLI errors: 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:imagemagickconvert.exe" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 700x450">" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341pre_d8e4cad775dad85.jpg":\n') WHERE `ref`=7714 2016-07-22 10:19:00 convert: preview quality for thm=90 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating thm (sw=1936, tw=150, sh=1288, th=150, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:19:00 Contemplating thm (sw=1936, tw=150, sh=1288, th=150, extension=jpg) 2016-07-22 10:19:00 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg 2016-07-22 10:19:00 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341thm_wm_2600a0407a72213.jpg 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Generating preview size thm to C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg') WHERE `ref`=7714 2016-07-22 10:19:00 Generating preview size thm to C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg 2016-07-22 10:19:00 CLI command: "C:\imagemagick\convert.exe" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 150x150">" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg" 2016-07-22 10:19:00 CLI output: 2016-07-22 10:19:00 CLI errors: 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:imagemagickconvert.exe" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 150x150">" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg":\n') WHERE `ref`=7714 2016-07-22 10:19:00 convert: preview quality for col=90 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Contemplating col (sw=1936, tw=75, sh=1288, th=75, extension=jpg)') WHERE `ref`=7714 2016-07-22 10:19:00 Contemplating col (sw=1936, tw=75, sh=1288, th=75, extension=jpg) 2016-07-22 10:19:00 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg 2016-07-22 10:19:00 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341col_wm_114db121a46c524.jpg 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','Generating preview size col to C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg') WHERE `ref`=7714 2016-07-22 10:19:00 Generating preview size col to C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg 2016-07-22 10:19:00 CLI command: "C:\imagemagick\convert.exe" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 75x75">" "C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg" 2016-07-22 10:19:00 CLI output: 2016-07-22 10:19:00 CLI errors: 2016-07-22 10:19:00 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,' ','"C:imagemagickconvert.exe" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341scr_c3de79b10b927f4.jpg"[0] +matte -flatten -quality 90 +matte -strip -colorspace sRGB -resize 75x75">" "C:\resourcespaceinclude/../filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg":\n') WHERE `ref`=7714 2016-07-22 10:19:00 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg 2016-07-22 10:19:01 SQL: update resource set image_red='864', image_green='226', image_blue='150',colour_key='KEWNP',thumb_width='150', thumb_height='100' where ref='3341' 2016-07-22 10:19:01 SQL: update resource set has_image=1,preview_extension='jpg',preview_attempts=0,file_modified=now() where ref='3341' 2016-07-22 10:19:01 SQL: select * from resource_dimensions where resource=3341 2016-07-22 10:19:01 SQL: insert into resource_dimensions (resource, width, height, file_size) values('3341', '1936', '1288', '1081880') 2016-07-22 10:19:01 SQL: select file_extension value from resource where ref = '3341' 2016-07-22 10:19:01 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:19:01 BANG C:\resourcespace\include/../filestore/3/3/4/1_124760848ecbb08/3341_36c8d8c98382132.jpg 2016-07-22 10:19:01 SQL: update resource set disk_usage='1340548',disk_usage_last_updated=now(),file_size='1081880' where ref='3341' 2016-07-22 10:19:01 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(),'4','3341','u',null,'','','-1','','0',null,'') 2016-07-22 10:19:01 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:19:01 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:19:01 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:19:01 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:19:01 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:19:01 SQL: select language,name,text from site_text where (page='collections' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:19:01 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'collections' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:19:01 SQL: SELECT name, value FROM sysvars 2016-07-22 10:19:01 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:19:01 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:19:01 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:19:02 SQL: select ref value from collection where ref='69' 2016-07-22 10:19:02 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:19:02 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:19:02 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'collections' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:19:02 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:19:02 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select * from (select c.*,u.username,u.fullname,count(r.resource) count from user u join collection c on u.ref=c.user and c.user='4' left outer join collection_resource r on c.ref=r.collection where (length(c.theme)=0 or c.theme is null) group by c.ref union select c.*,u.username,u.fullname,count(r.resource) count from user_collection uc join collection c on uc.collection=c.ref and uc.user='4' and c.user<>'4' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref where (length(c.theme)=0 or c.theme is null) group by c.ref union select c.*,u.username,u.fullname,count(r.resource) count from usergroup_collection gc join collection c on gc.collection=c.ref and gc.usergroup='3' and c.user<>'4' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref where (length(c.theme)=0 or c.theme is null) group by c.ref) clist group by ref 2016-07-22 10:19:02 SQL: select * from collection_savedsearch where collection='69' order by created 2016-07-22 10:19:02 search=!collection69 -1 restypes= archive=0 daylimit= 2016-07-22 10:19:02 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:19:02 SQL: select ref from resource_type_field where keywords_index=1 and length(name)>0 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:19:02 search=!collection69 150 restypes= archive=0 daylimit= 2016-07-22 10:19:02 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 SQL: select distinct c.date_added,c.comment,c.purchase_size,c.purchase_complete,r.hit_count score,length(c.comment) commentset, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 from resource r join collection_resource c on r.ref=c.resource where c.collection='69' and r.ref>0 group by r.ref order by c.sortorder ASC, c.date_added DESC, r.ref DESC 2016-07-22 10:19:02 SQL: select count(*) value from research_request where collection='69' 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 collection session : 2016-07-22 10:19:02 collection user : 4 2016-07-22 10:19:02 anonymous_login : 2016-07-22 10:19:02 userref : 4 2016-07-22 10:19:02 username : tcheupel 2016-07-22 10:19:02 anonymous_user_session_collection : TRUE 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 collection session : 2016-07-22 10:19:02 collection user : 4 2016-07-22 10:19:02 anonymous_login : 2016-07-22 10:19:02 userref : 4 2016-07-22 10:19:02 username : tcheupel 2016-07-22 10:19:02 anonymous_user_session_collection : TRUE 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 SQL: select ref value from collection where user=4 and name='My Collection' order by ref limit 1 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 BANG http://192.168.0.250/resourcespace/filestore/3/3/4/1_124760848ecbb08/3341col_7baef13eeffe64e.jpg?v=2016-07-22+12%3A19%3A01 2016-07-22 10:19:02 SQL: select type value from resource_type_field where ref=8 2016-07-22 10:19:02 SQL: select count(*) value from research_request where collection='69' 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 collection session : 2016-07-22 10:19:02 collection user : 4 2016-07-22 10:19:02 anonymous_login : 2016-07-22 10:19:02 userref : 4 2016-07-22 10:19:02 username : tcheupel 2016-07-22 10:19:02 anonymous_user_session_collection : TRUE 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 collection session : 2016-07-22 10:19:02 collection user : 4 2016-07-22 10:19:02 anonymous_login : 2016-07-22 10:19:02 userref : 4 2016-07-22 10:19:02 username : tcheupel 2016-07-22 10:19:02 anonymous_user_session_collection : TRUE 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:02 SQL: select ref value from collection where user=4 and name='My Collection' order by ref limit 1 2016-07-22 10:19:02 SQL: select c.*, c.theme2, c.theme3, c.keywords, u.fullname, u.username, c.home_page_publish, c.home_page_text, c.home_page_image,c.session_id from collection c left outer join user u on u.ref = c.user where c.ref = '69' 2016-07-22 10:19:02 SQL: select u.username value from user u,user_collection c where u.ref=c.user and c.collection='69' order by u.username 2016-07-22 10:19:02 SQL: select concat('Group (Smart): ',u.name) value from usergroup u,usergroup_collection c where u.ref=c.usergroup and c.collection='69' order by u.name 2016-07-22 10:19:02 SQL: select user value from user_collection where collection='69' 2016-07-22 10:19:02 SQL: select usergroup value from usergroup_collection where collection='69' 2016-07-22 10:19:06 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:19:06 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:19:06 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:19:06 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:19:06 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:19:06 SQL: select language,name,text from site_text where (page='search' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:19:06 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'search' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:19:06 SQL: SELECT name, value FROM sysvars 2016-07-22 10:19:06 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:19:06 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:19:06 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:19:06 SQL: select ref value from collection where ref='69' 2016-07-22 10:19:06 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:19:06 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:19:06 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'search' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:19:06 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:19:06 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:19:06 SQL: select *, ref, name, type, title, keywords_index, partial_index, value_filter from resource_type_field where ref in ('12','8','3') 2016-07-22 10:19:06 search=!last1000 48 restypes= archive=0 daylimit= 2016-07-22 10:19:06 SQL: select ref as value from resource_type_field where keywords_index=1 2016-07-22 10:19:06 SQL: select ref from resource_type_field where keywords_index=1 and length(name)>0 2016-07-22 10:19:06 SQL: select distinct *,r2.hit_count score from (select r.ref, r.resource_type, r.has_image, r.is_transcoding, r.hit_count, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path ,null group_access, null user_access ,r.field12 ,r.field8 ,r.field3 from resource r where archive = '0' and r.ref>0 order by ref desc limit 1000 ) r2 order by r2.ref DESC 2016-07-22 10:19:06 SQL: select * from resource_type order by order_by,ref 2016-07-22 10:19:06 SQL: select config_options value from resource_type where ref='1' 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/4/1_124760848ecbb08/3341thm_c8508fe1c0e46b9.jpg?v=2016-07-22+12%3A19%3A01 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/4/0_30a9c2b0ffaff22/3340thm_4f6715f802fd189.png?v=2016-07-21+23%3A41%3A05 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/9_4abba8451d9b6c8/3339thm_ef3bdc46c0924b3.png?v=2016-07-21+23%3A41%3A05 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/8_f6565d29d7965b5/3338thm_a81198bc3e85558.png?v=2016-07-21+23%3A41%3A04 2016-07-22 10:19:06 SQL: select config_options value from resource_type where ref='3' 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/7_c093492da2a6c84/3337thm_a67b671af03b52d.jpg?v=2016-07-21+23%3A37%3A06 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/6_dc3e8168c94fbb2/3336thm_1351998039dc2b2.jpg?v=2016-07-21+23%3A35%3A44 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/5_529476abdd34a15/3335thm_8ef8181404cc750.jpg?v=2016-07-21+23%3A35%3A10 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/4_89d13d612deb681/3334thm_1f51c7a8e835978.jpg?v=2016-07-21+23%3A23%3A44 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/3_267eba360304f2c/3333thm_1443d8e4f573ec9.jpg?v=2016-07-21+23%3A17%3A37 2016-07-22 10:19:06 SQL: select config_options value from resource_type where ref='1' 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/2_e70e65d055087ba/3332thm_fb89d0ee1be5193.jpg?v=2016-07-21+17%3A12%3A55 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/1_47af8f125317767/3331thm_9d6df6c775981f5.jpg?v=2016-07-21+17%3A12%3A47 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/3/0_903a7ac8309ab85/3330thm_3ddf5434815613c.jpg?v=2016-07-21+17%3A12%3A38 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/9_46533a4e966e9c3/3329thm_4b4433e95e14e2c.jpg?v=2016-07-21+17%3A12%3A31 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/8_a34fd758f3f03d4/3328thm_492d6cfb92bdba5.jpg?v=2016-07-21+17%3A12%3A24 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/7_67393debbfb1583/3327thm_7785cf3559613a7.jpg?v=2016-07-21+17%3A12%3A16 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/6_e1d1e29f7e4c60d/3326thm_de94a34c827dfd1.jpg?v=2016-07-21+17%3A12%3A08 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/5_fe20d1f4a3658a8/3325thm_9534e62cf0f868f.jpg?v=2016-07-21+17%3A12%3A01 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/4_3ec5cf09ddac300/3324thm_b107117431ed212.jpg?v=2016-07-21+17%3A11%3A54 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/3_2566a935bf98269/3323thm_9c4e607d67b8656.jpg?v=2016-07-21+17%3A11%3A46 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/2_a3384ee7a3e1a05/3322thm_4efbb8c543f8ec4.jpg?v=2016-07-21+17%3A11%3A39 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/1_f2b3820bb92cae9/3321thm_2c19815dfd9a659.jpg?v=2016-07-21+17%3A11%3A31 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/2/0_d3bb5f6f4661d64/3320thm_25d9f1527ae8585.jpg?v=2016-07-21+17%3A11%3A23 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/9_8ab47e5379e3862/3319thm_6e8e621251d591b.jpg?v=2016-07-21+17%3A11%3A16 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/8_7a952d0917ec5ea/3318thm_160bba3801cfb39.jpg?v=2016-07-21+17%3A11%3A09 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/7_8f015c4ba6b226e/3317thm_0ad33726c5ed774.jpg?v=2016-07-21+17%3A11%3A02 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/6_756dbea5a33620f/3316thm_3f70666815e88ac.jpg?v=2016-07-21+17%3A10%3A55 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/5_4e4981adffa224b/3315thm_934672520b30d4b.jpg?v=2016-07-21+17%3A10%3A47 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/4_1c80359b4b7b1c8/3314thm_9482f0b84a8f7ca.jpg?v=2016-07-21+17%3A10%3A40 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/3_f3401d5dad388b9/3313thm_058b19d6ea272fa.jpg?v=2016-07-21+17%3A10%3A33 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/2_816c071c7e634f8/3312thm_a1810e997cb2264.jpg?v=2016-07-21+17%3A10%3A25 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/1_e8d5995865f75ed/3311thm_31962864407bd11.jpg?v=2016-07-21+17%3A10%3A18 2016-07-22 10:19:06 BANG http://192.168.0.250/resourcespace/filestore/3/3/1/0_506fa862036b212/3310thm_2d97fff1ce4d2fd.jpg?v=2016-07-21+17%3A10%3A11 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/9_53bb46b482175a3/3309thm_511b0103a5e8fd4.jpg?v=2016-07-21+17%3A10%3A04 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/8_b599617fa5d6293/3308thm_2a840aea2becbec.jpg?v=2016-07-21+17%3A09%3A56 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/7_6abfeb232875dea/3307thm_6b195cf62b2b2ce.jpg?v=2016-07-21+17%3A09%3A49 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/6_753cf3ab5bb4584/3306thm_c02c0130f9cb1e7.jpg?v=2016-07-21+17%3A04%3A40 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/5_d19bb2a4d3c8a98/3305thm_edee493da27b651.jpg?v=2016-07-21+17%3A02%3A19 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/4_1753562e4de219d/3304thm_5754a440ad512fa.jpg?v=2016-07-21+16%3A40%3A33 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/3_c39cba03f2b0635/3303thm_e3ad9f8795bcab7.jpg?v=2016-07-21+16%3A38%3A57 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/2_2d4d02a3c3e80bc/3302thm_96325dd16caa9b6.jpg?v=2016-07-21+16%3A37%3A57 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/1_3553476ec9d4bec/3301thm_da77653fc51b24d.jpg?v=2016-07-21+16%3A25%3A21 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/3/0/0_74b731adfef39c1/3300thm_f9c0d6fffa1661d.jpg?v=2016-07-21+16%3A24%3A03 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/9_72cf9659567fbd1/3299thm_0e7d466a1e0574c.jpg?v=2016-07-21+16%3A22%3A31 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/8_926bd2fab5c6f62/3298thm_8694ebdf5fe029d.jpg?v=2016-07-21+16%3A20%3A42 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/7_64877fec18af276/3297thm_b4a0d63ea9096f6.jpg?v=2016-07-21+16%3A19%3A18 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/6_06037c6206da1ed/3296thm_2a6aaa3574ec1fd.jpg?v=2016-07-21+16%3A18%3A19 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/5_097abd9a4537e03/3295thm_e4b709f394940a2.jpg?v=2016-07-21+16%3A17%3A27 2016-07-22 10:19:07 BANG http://192.168.0.250/resourcespace/filestore/3/2/9/4_e201b56a3b8a511/3294thm_71fdad7e0ce3c34.jpg?v=2016-07-21+16%3A16%3A41 2016-07-22 10:19:07 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:19:07 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:19:07 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:19:07 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:19:07 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:19:07 SQL: select language,name,text from site_text where (page='reload_links' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:19:07 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'reload_links' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:19:07 SQL: SELECT name, value FROM sysvars 2016-07-22 10:19:07 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:19:07 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:19:07 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:19:07 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:19:07 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:19:07 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:19:07 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:19:07 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:19:07 SQL: select ref value from collection where ref='69' 2016-07-22 10:19:07 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:19:07 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:19:07 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'reload_links' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:19:07 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:19:07 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:19:07 SQL: select language,name,text from site_text where (page='search' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:19:07 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'search' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:19:07 SQL: SELECT name, value FROM sysvars 2016-07-22 10:19:07 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:19:07 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:19:07 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:19:07 SQL: select ref value from collection where ref='69' 2016-07-22 10:19:07 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:19:07 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:19:07 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'search' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:19:07 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:19:07 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:19:07 SQL: select *, ref, name, title, type, order_by, keywords_index, partial_index, resource_type, resource_column, display_field, use_for_similar, iptc_equiv, display_template, tab_name, required, smart_theme_name, exiftool_field, advanced_search, simple_search, help_text, display_as_dropdown, external_user_access, autocomplete_macro, hide_when_uploading, hide_when_restricted, value_filter, exiftool_filter, omit_when_copying, tooltip_text, display_condition from resource_type_field where (simple_search=1 ) and keywords_index=1 order by resource_type,order_by 2016-07-22 10:19:07 SQL: select * from resource_type order by order_by,ref 2016-07-22 10:19:08 SQL: select LEFT(VERSION(),3) as ver 2016-07-22 10:19:08 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform' 2016-07-22 10:19:08 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version' 2016-07-22 10:19:08 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority 2016-07-22 10:19:08 SQL: SELECT parameter, `value` FROM user_preferences WHERE user IS NULL; 2016-07-22 10:19:08 SQL: select language,name,text from site_text where (page='message' or page='all' or page='') and (specific_to_group is null or specific_to_group=0) 2016-07-22 10:19:08 SQL: SELECT `name`, `text`, `page`, `language`, specific_to_group FROM site_text WHERE (`language` = "en-US" OR `language` = "fr") AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND (specific_to_group IS NULL OR specific_to_group = 0); 2016-07-22 10:19:08 SQL: SELECT name, value FROM sysvars 2016-07-22 10:19:08 SQL: SELECT u.ref, u.username, g.permissions, g.fixed_theme, g.parent, u.usergroup, u.current_collection, u.last_active, timestampdiff(second, u.last_active, now()) idle_seconds, u.email, u.password, u.fullname, g.search_filter, g.edit_filter, g.ip_restrict ip_restrict_group, g.name groupname, u.ip_restrict ip_restrict_user, u.search_filter_override, resource_defaults, u.password_last_change, g.config_options, g.request_mode, g.derestrict_filter, u.hidden_collections, u.accepted_terms FROM user u, usergroup g WHERE u.usergroup = g.ref and u.session='0a7676cce1f20e60cecaa9e24eaf9673' AND u.approved = 1 AND (u.account_expires IS NULL OR u.account_expires = '0000-00-00 00:00:00' OR u.account_expires > now()) 2016-07-22 10:19:08 SQL: SELECT value FROM sysvars WHERE name='debug_override_user' 2016-07-22 10:19:08 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires' 2016-07-22 10:19:08 SQL: select ref value from collection where ref='69' 2016-07-22 10:19:08 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '4' AND parameter = 'colour_theme'; 2016-07-22 10:19:08 SQL: update user set lang='en-US', last_active=now(),logged_in=1,last_ip='192.168.0.250',last_browser='Mozilla/5.0 (Windows NT 6.1; rv:47.0) Gecko/20100101 Firefox/47.0' where ref='4' 2016-07-22 10:19:08 SQL: SELECT `name`, `text`, `page` FROM site_text WHERE language = 'en-US' AND (page = 'message' OR page = 'all' OR page = '' ) #pagefilter AND specific_to_group = '3'; 2016-07-22 10:19:08 SQL: SELECT name,enabled_groups, config, config_json FROM plugins WHERE inst_version>=0 ORDER BY priority 2016-07-22 10:19:08 SQL: SELECT parameter, `value` FROM user_preferences WHERE user = '4'; 2016-07-22 10:19:08 SQL: SELECT user_message.ref, user.username AS owner, user_message.seen, message.created, message.expires, message.message, message.url FROM `user_message` INNER JOIN `message` ON user_message.message=message.ref LEFT OUTER JOIN `user` ON message.owner=user.ref WHERE user_message.user='4' AND message.expires > NOW() AND user_message.seen='0' ORDER BY user_message.ref ASC