2016-07-22 10:20:44 SQL: select LEFT(VERSION(),3) as ver
2016-07-22 10:20:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='transform'
2016-07-22 10:20:44 SQL: SELECT inst_version AS value FROM plugins WHERE name='rse_version'
2016-07-22 10:20:44 SQL: SELECT name,enabled_groups,config,config_json FROM plugins WHERE inst_version>=0 order by priority
2016-07-22 10:20:44 SQL: 
            SELECT parameter,
                   `value`
              FROM user_preferences
             WHERE user IS NULL;
        
2016-07-22 10:20:44 SQL: select language,name,text from site_text where (page='staticsync' or page='all' or page='') and (specific_to_group is null or specific_to_group=0)
2016-07-22 10:20:44 SQL: 
		SELECT `name`,
		       `text`,
		       `page`,
		       `language`, specific_to_group 
		  FROM site_text
		 WHERE (`language` = "fr" OR `language` = "fr")
		   AND (page = 'staticsync' OR page = 'all' OR page = '' )  #pagefilter
		   AND (specific_to_group IS NULL OR specific_to_group = 0);
	
2016-07-22 10:20:44 SQL: SELECT name, value FROM sysvars
2016-07-22 10:20:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_user'
2016-07-22 10:20:44 SQL: SELECT value FROM sysvars WHERE name='debug_override_expires'
2016-07-22 10:20:44 SQL: select u.*, g.permissions, g.fixed_theme, g.parent, 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,g.config_options,g.request_mode, g.derestrict_filter from user u left join usergroup g on u.usergroup=g.ref where u.ref='6'
2016-07-22 10:20:44 SQL: select ref value from collection where ref='30'
2016-07-22 10:20:44 SQL: SELECT user, `value` AS colour_theme FROM user_preferences WHERE user = '6' AND parameter = 'colour_theme';
2016-07-22 10:20:44 SQL: SELECT ref, file_path, file_modified, archive FROM resource WHERE LENGTH(file_path)>0 AND file_path LIKE '%/%'
2016-07-22 10:20:44 SQL: SELECT value FROM sysvars WHERE name='lastsync'
2016-07-22 10:20:44 SQL: SELECT ref value FROM collection WHERE name='' AND theme='Dudes.JPG'
2016-07-22 10:20:44 SQL: insert into resource(resource_type,creation_date,archive,created_by) values ('1',now(),'0','6')
2016-07-22 10:20:44 SQL: select resource_type value from resource where ref='3342'
2016-07-22 10:20: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:20:44 resolving keyword 3342. Create=true
2016-07-22 10:20:44 resolving normalized keyword 3342.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='3342'
2016-07-22 10:20:44 Creating new keyword for 3342
2016-07-22 10:20:44 SQL: insert into keyword (keyword,soundex,hit_count) values ('3342',left('0000',10),0)
2016-07-22 10:20:44 SQL: delete from resource_keyword where resource='3342' and keyword='4769' and resource_type_field='-1'
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count-1 where ref='4769' limit 1
2016-07-22 10:20:44 adding 3342
2016-07-22 10:20:44 resolving keyword 3342. Create=true
2016-07-22 10:20:44 resolving normalized keyword 3342.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='3342'
2016-07-22 10:20:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3342','4769','0','-1')
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count+1 where ref='4769'
2016-07-22 10:20: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='4769' and external='0'
2016-07-22 10:20: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','4769','0','1')
2016-07-22 10:20:44 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='3342' and external='0'
2016-07-22 10:20:44 SQL: insert into daily_stat(year,month,day,usergroup,activity_type,object_ref,external,count) values ('2016','7','22','3','Create resource','3342','0','1')
2016-07-22 10:20:44 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(),'6','3342','c',null,'','','-1','','0',null,'')
2016-07-22 10:20:44 SQL: update resource set resource_type='1' where ref='3342'
2016-07-22 10:20:44 SQL: delete from resource_data where resource='3342' 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:20:44 SQL: delete from resource_keyword where resource='3342' 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:20:44 SQL: select name value from resource_type where ref='1'
2016-07-22 10:20:44 SQL: delete from resource_keyword where resource='3342' and resource_type_field='-2'
2016-07-22 10:20:44 adding photo
2016-07-22 10:20:44 resolving keyword photo. Create=true
2016-07-22 10:20:44 resolving normalized keyword photo.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='photo'
2016-07-22 10:20:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3342','24','0','-2')
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count+1 where ref='24'
2016-07-22 10:20: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:20: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:20:44 SQL: update resource set archive=0,file_path='dudes.JPG',file_extension='jpg',preview_extension='jpg',file_modified=now() where ref='3342'
2016-07-22 10:20:44 SQL: select ref,keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='51'
2016-07-22 10:20:44 SQL: SELECT * FROM node WHERE resource_type_field = '51' AND parent IS NULL ORDER BY order_by ASC;
2016-07-22 10:20:44 SQL: select value from resource_data where resource='3342' and resource_type_field='51'
2016-07-22 10:20:44 SQL: select value from resource_data where resource='3342' and resource_type_field='51'
2016-07-22 10:20:44 adding dudes
2016-07-22 10:20:44 resolving keyword dudes. Create=true
2016-07-22 10:20:44 resolving normalized keyword dudes.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='dudes'
2016-07-22 10:20:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3342','4108','0','51')
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count+1 where ref='4108'
2016-07-22 10:20: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:20: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='4108' and external='0'
2016-07-22 10:20:44 adding jpg
2016-07-22 10:20:44 resolving keyword jpg. Create=true
2016-07-22 10:20:44 resolving normalized keyword jpg.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='jpg'
2016-07-22 10:20:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3342','73','1','51')
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count+1 where ref='73'
2016-07-22 10:20: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='73' and external='0'
2016-07-22 10:20: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='73' and external='0'
2016-07-22 10:20:44 SQL: delete from resource_data where resource='3342' and resource_type_field='51'
2016-07-22 10:20:44 SQL: insert into resource_data(resource,resource_type_field,value) values ('3342','51','dudes.JPG')
2016-07-22 10:20:44 SQL: select ref,keywords_index,resource_column,partial_index,type, onchange_macro from resource_type_field where ref='8'
2016-07-22 10:20:44 SQL: SELECT * FROM node WHERE resource_type_field = '8' AND parent IS NULL ORDER BY order_by ASC;
2016-07-22 10:20:44 SQL: select value from resource_data where resource='3342' and resource_type_field='8'
2016-07-22 10:20:44 SQL: select value from resource_data where resource='3342' and resource_type_field='8'
2016-07-22 10:20:44 adding dudes
2016-07-22 10:20:44 resolving keyword dudes. Create=true
2016-07-22 10:20:44 resolving normalized keyword dudes.
2016-07-22 10:20:44 SQL: select ref value from keyword where keyword='dudes'
2016-07-22 10:20:44 SQL: insert into resource_keyword(resource,keyword,position,resource_type_field) values ('3342','4108','0','8')
2016-07-22 10:20:44 SQL: update keyword set hit_count=hit_count+1 where ref='4108'
2016-07-22 10:20: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:20: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='4108' and external='0'
2016-07-22 10:20:44 SQL: delete from resource_data where resource='3342' and resource_type_field='8'
2016-07-22 10:20:44 SQL: insert into resource_data(resource,resource_type_field,value) values ('3342','8','Dudes')
2016-07-22 10:20:44 SQL: update resource set field8='Dudes' where ref='3342'
2016-07-22 10:20:44 SQL: select file_path value from resource where ref='3342'
2016-07-22 10:20:44 BANG C:\resourcespace\include/../filestore/3/3/4/2_2e3b59835f092eb/3342_6d02569c3e8145d.jpg
2016-07-22 10:20:44 SQL: select *,mapzoom from resource where ref='3342'
2016-07-22 10:20:44 BANG http://192.168.0.250/resourcespace/filestore/3/3/4/2_2e3b59835f092eb/3342pre_cdf4a803e131892.jpg?v=2016-07-22+12%3A20%3A44
2016-07-22 10:20:44 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(),'6','3342','t',null,'','Create previews','-1','','0',null,'')
2016-07-22 10:20:44 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,'
','create_previews(ref=3342,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=,checksum_required=1)') WHERE `ref`=7717
2016-07-22 10:20:44 create_previews(ref=3342,thumbonly=,extension=jpg,previewonly=,previewbased=,alternative=-1,ingested=,checksum_required=1)
2016-07-22 10:20:44 SQL: select file_extension value from resource where ref=3342
2016-07-22 10:20:44 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,'
','create_previews - generate checksum for 3342') WHERE `ref`=7717
2016-07-22 10:20:44 create_previews - generate checksum for 3342
2016-07-22 10:20:44 SQL: update resource set file_checksum='' where ref='3342'
2016-07-22 10:20:44 SQL: update resource set preview_tweaks = '0|1' where ref = '3342'
2016-07-22 10:20:44 BANG C:\resourcespace\include/../filestore/3/3/4/2_2e3b59835f092eb/3342_6d02569c3e8145d.jpg
2016-07-22 10:20:44 SQL: UPDATE `resource_log` SET `diff`=concat(`diff`,'
','File source is C:\resourcespaceinclude/../filestore/3/3/4/2_2e3b59835f092eb/3342_6d02569c3e8145d.jpg') WHERE `ref`=7717
2016-07-22 10:20:44 File source is C:\resourcespace\include/../filestore/3/3/4/2_2e3b59835f092eb/3342_6d02569c3e8145d.jpg
2016-07-22 10:20:44 SQL: update resource set preview_attempts=ifnull(preview_attempts,0) + 1 where ref='3342'
2016-07-22 10:20:44 SQL: UPDATE resource SET access = '0',archive='0' WHERE ref = '3342'
2016-07-22 10:20:44 SQL: SELECT * FROM collection_resource WHERE collection='29' AND resource='3342'
2016-07-22 10:20:44 SQL: INSERT INTO collection_resource (collection, resource, date_added) 
                                            VALUES ('29', '3342', NOW())
2016-07-22 10:20:44 SQL: DELETE FROM collection WHERE theme IS NOT NULL AND LENGTH(theme) > 0 AND 
                (SELECT count(*) FROM collection_resource cr WHERE cr.collection=collection.ref) = 0;
2016-07-22 10:20:44 SQL: UPDATE sysvars SET value=now() WHERE name='lastsync'