2020/03/09 08:04:58 [trace] [system.CModule] Loading "log" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "request" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "session" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "db" application component 2020/03/09 08:04:58 [trace] [system.db.CDbConnection] Opening DB connection 2020/03/09 08:04:58 [trace] [system.CModule] Loading "cache" application component 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_settings_global' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:04:58 [trace] [system.CModule] Loading "assetManager" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "urlManager" application component 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:04:58 [trace] [system.CModule] Loading "messages" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "clientScript" application component 2020/03/09 08:04:58 [trace] [system.CModule] Loading "pluginManager" application component 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_settings_global] [t] WHERE stg_name=:name 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_plugins' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_plugins] [t] WHERE [t].[active]=:yp0 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Survey.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys] [t] WHERE [t].[sid]=198559 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_templates' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_permissions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_languagesettings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_policy_notice] AS [t0_c6], [t].[surveyls_policy_error] AS [t0_c7], [t].[surveyls_policy_notice_label] AS [t0_c8], [t].[surveyls_url] AS [t0_c9], [t].[surveyls_urldescription] AS [t0_c10], [t].[surveyls_email_invite_subj] AS [t0_c11], [t].[surveyls_email_invite] AS [t0_c12], [t].[surveyls_email_remind_subj] AS [t0_c13], [t].[surveyls_email_remind] AS [t0_c14], [t].[surveyls_email_register_subj] AS [t0_c15], [t].[surveyls_email_register] AS [t0_c16], [t].[surveyls_email_confirm_subj] AS [t0_c17], [t].[surveyls_email_confirm] AS [t0_c18], [t].[surveyls_dateformat] AS [t0_c19], [t].[surveyls_attributecaptions] AS [t0_c20], [t].[email_admin_notification_subj] AS [t0_c21], [t].[email_admin_notification] AS [t0_c22], [t].[email_admin_responses_subj] AS [t0_c23], [t].[email_admin_responses] AS [t0_c24], [t].[surveyls_numberformat] AS [t0_c25], [t].[attachments] AS [t0_c26], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[lime_surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=198559 AND [t].[surveyls_language]='en') 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME FROM [INFORMATION_SCHEMA].[TABLES] WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in ('BASE TABLE','VIEW') 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_tokens_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading Survey.owner 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_users' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [owner].[uid] AS [t1_c0], [owner].[users_name] AS [t1_c1], [owner].[password] AS [t1_c2], [owner].[full_name] AS [t1_c3], [owner].[parent_id] AS [t1_c4], [owner].[lang] AS [t1_c5], [owner].[email] AS [t1_c6], [owner].[htmleditormode] AS [t1_c7], [owner].[templateeditormode] AS [t1_c8], [owner].[questionselectormode] AS [t1_c9], [owner].[one_time_pw] AS [t1_c10], [owner].[dateformat] AS [t1_c11], [owner].[created] AS [t1_c12], [owner].[modified] AS [t1_c13] FROM [dbo].[lime_users] [owner] WHERE ([owner].[uid]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:04:59') >= '2020-03-09 08:04:59' AND COALESCE(validfrom, '2020-03-09 08:04:59') <= '2020-03-09 08:04:59' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_groups WHERE sid=198559 AND language='en' ORDER BY group_order 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_template_configuration' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (sid=:sid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (gsid=:gsid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] SurveysGroups.findByPk() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys_groups] [t] WHERE [t].[gsid]=1 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Response_198559.findAllByAttributes() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[token]=:yp0 ORDER BY id DESC 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:04:59') >= '2020-03-09 08:04:59' AND COALESCE(validfrom, '2020-03-09 08:04:59') <= '2020-03-09 08:04:59' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_groups WHERE sid=198559 AND language='en' ORDER BY group_order 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_questions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: select count(*) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is null 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 AND [t].[type] IN ('X', '*') 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=0 AND b.sid = 198559 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=1 AND b.sid = 198559 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_questions as questions, lime_groups as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=198559 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_url_parameters' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: select '' as act, up.*,q.title, sq.title as sqtitle, q.question, sq.question as sqquestion from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid 2020/03/09 08:05:00 [trace] [survey.buildsurveysession] end 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] QuestionGroup.findAll() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_groups] [t] WHERE (sid=:ycp0 AND language=:ycp1) AND (randomization_group != '') 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT attr.qid, CAST(value as varchar(255)) as value FROM lime_question_attributes as attr right join lime_questions as quests on attr.qid=quests.qid WHERE attribute='random_group' and CAST(value as varchar(255)) <> '' and sid=198559 GROUP BY attr.qid, CAST(value as varchar(255)) 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=0 AND b.sid = 198559 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=1 AND b.sid = 198559 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_questions as questions, lime_groups as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=198559 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:01 [trace] [system.CModule] Loading "user" application component 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionGroup.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_groups] [t] WHERE sid=:sid and language=:language ORDER BY group_order 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT DISTINCT qid FROM [dbo].[lime_questions] [t] WHERE sid=:sid and parent_qid=0 GROUP BY qid 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_question_attributes' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.code, a.answer, a.scale_id, a.assessment_value FROM lime_answers AS a, lime_questions as q WHERE a.qid = q.qid and q.sid = 198559 and a.language='en' and q.language='en' ORDER BY a.qid, a.scale_id, a.sortorder 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:yp0 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] SurveyDynamic.insert() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO [dbo].[lime_survey_198559] ([startlanguage], [token], [datestamp], [startdate], [ipaddr], [seed], [lastpage]) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6) 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559_timings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] SurveyTimingDynamic.insert() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO [dbo].[lime_survey_198559_timings] ([id], [interviewtime]) VALUES (:yp0, :yp1) 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=7 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=7 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_answers WHERE qid='7' AND language='en' and scale_id=0 ORDER BY sortorder, answer 2020/03/09 08:05:03 [trace] [system.CModule] Loading "twigRenderer" application component 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=9 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=8 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_asset_version' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:04 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:04 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:04 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:04 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:04 [trace] [system.CModule] Loading "securityManager" application component 2020/03/09 08:04:49 [trace] [system.CModule] Loading "log" application component 2020/03/09 08:04:49 [trace] [system.CModule] Loading "request" application component 2020/03/09 08:04:49 [trace] [system.CModule] Loading "session" application component 2020/03/09 08:04:49 [trace] [system.CModule] Loading "db" application component 2020/03/09 08:04:49 [trace] [system.db.CDbConnection] Opening DB connection 2020/03/09 08:04:49 [trace] [system.CModule] Loading "cache" application component 2020/03/09 08:04:49 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_settings_global' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:51 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:04:51 [trace] [system.CModule] Loading "assetManager" application component 2020/03/09 08:04:51 [trace] [system.CModule] Loading "urlManager" application component 2020/03/09 08:04:51 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:04:51 [trace] [system.CModule] Loading "messages" application component 2020/03/09 08:04:51 [trace] [system.CModule] Loading "clientScript" application component 2020/03/09 08:04:51 [trace] [system.CModule] Loading "pluginManager" application component 2020/03/09 08:04:51 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find() 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_settings_global] [t] WHERE stg_name=:name 2020/03/09 08:04:51 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes() 2020/03/09 08:04:51 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_plugins' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_plugins] [t] WHERE [t].[active]=:yp0 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:52 [trace] [system.db.ar.CActiveRecord] Survey.findByPk() 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys] [t] WHERE [t].[sid]=198559 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:52 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_templates' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:53 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:53 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_permissions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:53 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:53 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:04:54 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:54 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:54 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:54 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:54 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_languagesettings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:54 [trace] [system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk() 2020/03/09 08:04:54 [trace] [system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_policy_notice] AS [t0_c6], [t].[surveyls_policy_error] AS [t0_c7], [t].[surveyls_policy_notice_label] AS [t0_c8], [t].[surveyls_url] AS [t0_c9], [t].[surveyls_urldescription] AS [t0_c10], [t].[surveyls_email_invite_subj] AS [t0_c11], [t].[surveyls_email_invite] AS [t0_c12], [t].[surveyls_email_remind_subj] AS [t0_c13], [t].[surveyls_email_remind] AS [t0_c14], [t].[surveyls_email_register_subj] AS [t0_c15], [t].[surveyls_email_register] AS [t0_c16], [t].[surveyls_email_confirm_subj] AS [t0_c17], [t].[surveyls_email_confirm] AS [t0_c18], [t].[surveyls_dateformat] AS [t0_c19], [t].[surveyls_attributecaptions] AS [t0_c20], [t].[email_admin_notification_subj] AS [t0_c21], [t].[email_admin_notification] AS [t0_c22], [t].[email_admin_responses_subj] AS [t0_c23], [t].[email_admin_responses] AS [t0_c24], [t].[surveyls_numberformat] AS [t0_c25], [t].[attachments] AS [t0_c26], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[lime_surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=198559 AND [t].[surveyls_language]='en') 2020/03/09 08:04:55 [trace] [system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME FROM [INFORMATION_SCHEMA].[TABLES] WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in ('BASE TABLE','VIEW') 2020/03/09 08:04:55 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:55 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:56 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_tokens_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:56 [trace] [system.db.ar.CActiveRecord] lazy loading Survey.owner 2020/03/09 08:04:56 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:56 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:56 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_users' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:56 [trace] [system.db.CDbCommand] Querying SQL: SELECT [owner].[uid] AS [t1_c0], [owner].[users_name] AS [t1_c1], [owner].[password] AS [t1_c2], [owner].[full_name] AS [t1_c3], [owner].[parent_id] AS [t1_c4], [owner].[lang] AS [t1_c5], [owner].[email] AS [t1_c6], [owner].[htmleditormode] AS [t1_c7], [owner].[templateeditormode] AS [t1_c8], [owner].[questionselectormode] AS [t1_c9], [owner].[one_time_pw] AS [t1_c10], [owner].[dateformat] AS [t1_c11], [owner].[created] AS [t1_c12], [owner].[modified] AS [t1_c13] FROM [dbo].[lime_users] [owner] WHERE ([owner].[uid]=:ypl0) 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:04:56') >= '2020-03-09 08:04:56' AND COALESCE(validfrom, '2020-03-09 08:04:56') <= '2020-03-09 08:04:56' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_groups WHERE sid=198559 AND language='en' ORDER BY group_order 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_template_configuration' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (sid=:sid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (gsid=:gsid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:04:57 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:57 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] SurveysGroups.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys_groups] [t] WHERE [t].[gsid]=1 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Response_198559.findAllByAttributes() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[token]=:yp0 ORDER BY id DESC 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:04:58') >= '2020-03-09 08:04:58' AND COALESCE(validfrom, '2020-03-09 08:04:58') <= '2020-03-09 08:04:58' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_groups WHERE sid=198559 AND language='en' ORDER BY group_order 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_questions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:58 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:04:58 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:04:59 [trace] [system.db.CDbCommand] Querying SQL: select count(*) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is null 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 AND [t].[type] IN ('X', '*') 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=0 AND b.sid = 198559 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=1 AND b.sid = 198559 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_questions as questions, lime_groups as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=198559 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_url_parameters' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: select '' as act, up.*,q.title, sq.title as sqtitle, q.question, sq.question as sqquestion from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid 2020/03/09 08:05:00 [trace] [survey.buildsurveysession] end 2020/03/09 08:05:00 [trace] [system.db.ar.CActiveRecord] QuestionGroup.findAll() 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_groups] [t] WHERE (sid=:ycp0 AND language=:ycp1) AND (randomization_group != '') 2020/03/09 08:05:00 [trace] [system.db.CDbCommand] Querying SQL: SELECT attr.qid, CAST(value as varchar(255)) as value FROM lime_question_attributes as attr right join lime_questions as quests on attr.qid=quests.qid WHERE attribute='random_group' and CAST(value as varchar(255)) <> '' and sid=198559 GROUP BY attr.qid, CAST(value as varchar(255)) 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=0 AND b.sid = 198559 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'en' AND b.same_default=1 AND b.sid = 198559 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_questions as questions, lime_groups as question_groups WHERE questions.gid=question_groups.gid AND questions.sid=198559 AND questions.language='en' AND questions.parent_qid=0 AND question_groups.language='en' ORDER BY group_order, question_order 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:01 [trace] [system.CModule] Loading "user" application component 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionGroup.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_groups] [t] WHERE sid=:sid and language=:language ORDER BY group_order 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT DISTINCT qid FROM [dbo].[lime_questions] [t] WHERE sid=:sid and parent_qid=0 GROUP BY qid 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_question_attributes' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] Question.find() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE qid=:qid 2020/03/09 08:05:01 [trace] [system.db.ar.CActiveRecord] QuestionAttribute.findAll() 2020/03/09 08:05:01 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_question_attributes] [t] WHERE qid=:qid 2020/03/09 08:05:02 [trace] [system.db.CDbCommand] Querying SQL: SELECT a.qid, a.code, a.answer, a.scale_id, a.assessment_value FROM lime_answers AS a, lime_questions as q WHERE a.qid = q.qid and q.sid = 198559 and a.language='en' and q.language='en' ORDER BY a.qid, a.scale_id, a.sortorder 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:yp0 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] SurveyDynamic.insert() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO [dbo].[lime_survey_198559] ([startlanguage], [token], [datestamp], [startdate], [ipaddr], [seed], [lastpage]) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6) 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559_timings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] SurveyTimingDynamic.insert() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Executing SQL: INSERT INTO [dbo].[lime_survey_198559_timings] ([id], [interviewtime]) VALUES (:yp0, :yp1) 2020/03/09 08:05:03 [trace] [system.CModule] Loading "coreMessages" application component 2020/03/09 08:05:03 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'PK__lime_sur__3213E83F53A3C52B'. Cannot insert duplicate key in object 'dbo.lime_survey_198559_timings'. The duplicate key value is (11014).. The SQL statement executed was: INSERT INTO [dbo].[lime_survey_198559_timings] ([id], [interviewtime]) VALUES (:yp0, :yp1). 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=7 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=7 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM lime_answers WHERE qid='7' AND language='en' and scale_id=0 ORDER BY sortorder, answer 2020/03/09 08:05:03 [trace] [system.CModule] Loading "twigRenderer" application component 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=9 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.ar.CActiveRecord] Question.findByPk() 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_questions] [t] WHERE [t].[qid]=8 AND [t].[language]='en' 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:03 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:04 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_asset_version' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:04 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:04 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:04 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:04 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:04 [trace] [system.CModule] Loading "securityManager" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "log" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "request" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "urlManager" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "session" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "messages" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "db" application component 2020/03/09 08:05:18 [trace] [system.db.CDbConnection] Opening DB connection 2020/03/09 08:05:18 [trace] [system.CModule] Loading "cache" application component 2020/03/09 08:05:18 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_settings_global' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:05:19 [trace] [system.CModule] Loading "assetManager" application component 2020/03/09 08:05:19 [trace] [system.CModule] Loading "securityManager" application component 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:05:19 [trace] [system.CModule] Loading "clientScript" application component 2020/03/09 08:05:19 [trace] [system.CModule] Loading "pluginManager" application component 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_settings_global] [t] WHERE stg_name=:name 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_plugins' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_plugins] [t] WHERE [t].[active]=:yp0 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:20 [trace] [system.db.ar.CActiveRecord] Survey.findByPk() 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys] [t] WHERE [t].[sid]=198559 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_templates' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:20 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:20 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_permissions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_languagesettings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:22 [trace] [system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk() 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_policy_notice] AS [t0_c6], [t].[surveyls_policy_error] AS [t0_c7], [t].[surveyls_policy_notice_label] AS [t0_c8], [t].[surveyls_url] AS [t0_c9], [t].[surveyls_urldescription] AS [t0_c10], [t].[surveyls_email_invite_subj] AS [t0_c11], [t].[surveyls_email_invite] AS [t0_c12], [t].[surveyls_email_remind_subj] AS [t0_c13], [t].[surveyls_email_remind] AS [t0_c14], [t].[surveyls_email_register_subj] AS [t0_c15], [t].[surveyls_email_register] AS [t0_c16], [t].[surveyls_email_confirm_subj] AS [t0_c17], [t].[surveyls_email_confirm] AS [t0_c18], [t].[surveyls_dateformat] AS [t0_c19], [t].[surveyls_attributecaptions] AS [t0_c20], [t].[email_admin_notification_subj] AS [t0_c21], [t].[email_admin_notification] AS [t0_c22], [t].[email_admin_responses_subj] AS [t0_c23], [t].[email_admin_responses] AS [t0_c24], [t].[surveyls_numberformat] AS [t0_c25], [t].[attachments] AS [t0_c26], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[lime_surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=198559 AND [t].[surveyls_language]='en') 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME FROM [INFORMATION_SCHEMA].[TABLES] WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in ('BASE TABLE','VIEW') 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:23 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_tokens_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:23 [trace] [system.db.ar.CActiveRecord] lazy loading Survey.owner 2020/03/09 08:05:23 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:23 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_users' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT [owner].[uid] AS [t1_c0], [owner].[users_name] AS [t1_c1], [owner].[password] AS [t1_c2], [owner].[full_name] AS [t1_c3], [owner].[parent_id] AS [t1_c4], [owner].[lang] AS [t1_c5], [owner].[email] AS [t1_c6], [owner].[htmleditormode] AS [t1_c7], [owner].[templateeditormode] AS [t1_c8], [owner].[questionselectormode] AS [t1_c9], [owner].[one_time_pw] AS [t1_c10], [owner].[dateformat] AS [t1_c11], [owner].[created] AS [t1_c12], [owner].[modified] AS [t1_c13] FROM [dbo].[lime_users] [owner] WHERE ([owner].[uid]=:ypl0) 2020/03/09 08:05:24 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:05:24') >= '2020-03-09 08:05:24' AND COALESCE(validfrom, '2020-03-09 08:05:24') <= '2020-03-09 08:05:24' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_template_configuration' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (sid=:sid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (gsid=:gsid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] SurveysGroups.findByPk() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys_groups] [t] WHERE [t].[gsid]=1 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_answers' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [answer] FROM [lime_answers] WHERE (qid=:qid) AND (code=:code) AND (scale_id=:scale_id) AND (language=:lang) 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.findByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_survey_198559] SET [lastpage]=:yp0, [datestamp]=:yp1, [ipaddr]=:yp2, [198559X3X7]=:yp3, [198559X3X9]=:yp4, [198559X3X8]=:yp5 WHERE [dbo].[lime_survey_198559].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE lime_survey_198559_timings SET interviewtime = (CASE WHEN interviewtime IS NULL THEN 0 ELSE interviewtime END) + 24.29 WHERE id = 11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_saved_control' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] SavedControl.find() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_saved_control] [t] WHERE (srid=:srid) AND (sid=:sid) 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.findByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_quota' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Quota.findAllByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_quota] [t] WHERE [t].[sid]=:yp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_survey_198559] SET [submitdate]=:yp0 WHERE [dbo].[lime_survey_198559].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:yp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] lazy loading Token_198559.survey 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys] [survey] WHERE (sid = 198559) 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.findAll() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 2 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:ycp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.update() 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_tokens_198559] SET [usesleft]=:yp0, [completed]=:yp1, [participant_id]=:yp2, [firstname]=:yp3, [lastname]=:yp4, [email]=:yp5, [emailstatus]=:yp6, [token]=:yp7, [language]=:yp8, [blacklisted]=:yp9, [sent]=:yp10, [remindersent]=:yp11, [remindercount]=:yp12, [validfrom]=:yp13, [validuntil]=:yp14, [mpid]=:yp15, [attribute_1]=:yp16, [attribute_2]=:yp17, [attribute_3]=:yp18, [attribute_4]=:yp19, [attribute_5]=:yp20 WHERE [dbo].[lime_tokens_198559].[tid]=49 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [submitdate] FROM [lime_survey_198559] WHERE id=:id 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_questions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:27 [trace] [system.CModule] Loading "user" application component 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:28 [trace] [system.CModule] Loading "twigRenderer" application component 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_asset_version' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:28 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:28 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:18 [trace] [system.CModule] Loading "log" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "request" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "urlManager" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "session" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "messages" application component 2020/03/09 08:05:18 [trace] [system.CModule] Loading "db" application component 2020/03/09 08:05:18 [trace] [system.db.CDbConnection] Opening DB connection 2020/03/09 08:05:19 [trace] [system.CModule] Loading "cache" application component 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_settings_global' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:05:19 [trace] [system.CModule] Loading "assetManager" application component 2020/03/09 08:05:19 [trace] [system.CModule] Loading "securityManager" application component 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_settings_global] [t] 2020/03/09 08:05:19 [trace] [system.CModule] Loading "clientScript" application component 2020/03/09 08:05:19 [trace] [system.CModule] Loading "pluginManager" application component 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] SettingGlobal.find() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_settings_global] [t] WHERE stg_name=:name 2020/03/09 08:05:19 [trace] [system.db.ar.CActiveRecord] Plugin.findAllByAttributes() 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:19 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_plugins' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_plugins] [t] WHERE [t].[active]=:yp0 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:20 [trace] [system.db.ar.CActiveRecord] Survey.findByPk() 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys] [t] WHERE [t].[sid]=198559 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:20 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_templates' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_permissions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:05:21 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:21 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_languagesettings' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:22 [trace] [system.db.ar.CActiveRecord] SurveyLanguageSetting.findByPk() 2020/03/09 08:05:22 [trace] [system.db.CDbCommand] Querying SQL: SELECT [t].[surveyls_survey_id] AS [t0_c0], [t].[surveyls_language] AS [t0_c1], [t].[surveyls_title] AS [t0_c2], [t].[surveyls_description] AS [t0_c3], [t].[surveyls_welcometext] AS [t0_c4], [t].[surveyls_endtext] AS [t0_c5], [t].[surveyls_policy_notice] AS [t0_c6], [t].[surveyls_policy_error] AS [t0_c7], [t].[surveyls_policy_notice_label] AS [t0_c8], [t].[surveyls_url] AS [t0_c9], [t].[surveyls_urldescription] AS [t0_c10], [t].[surveyls_email_invite_subj] AS [t0_c11], [t].[surveyls_email_invite] AS [t0_c12], [t].[surveyls_email_remind_subj] AS [t0_c13], [t].[surveyls_email_remind] AS [t0_c14], [t].[surveyls_email_register_subj] AS [t0_c15], [t].[surveyls_email_register] AS [t0_c16], [t].[surveyls_email_confirm_subj] AS [t0_c17], [t].[surveyls_email_confirm] AS [t0_c18], [t].[surveyls_dateformat] AS [t0_c19], [t].[surveyls_attributecaptions] AS [t0_c20], [t].[email_admin_notification_subj] AS [t0_c21], [t].[email_admin_notification] AS [t0_c22], [t].[email_admin_responses_subj] AS [t0_c23], [t].[email_admin_responses] AS [t0_c24], [t].[surveyls_numberformat] AS [t0_c25], [t].[attachments] AS [t0_c26], [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys_languagesettings] [t] LEFT OUTER JOIN [dbo].[lime_surveys] [survey] ON (t.surveyls_survey_id = survey.sid) WHERE ([t].[surveyls_survey_id]=198559 AND [t].[surveyls_language]='en') 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT TABLE_NAME FROM [INFORMATION_SCHEMA].[TABLES] WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in ('BASE TABLE','VIEW') 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_tokens_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:24 [trace] [system.db.ar.CActiveRecord] lazy loading Survey.owner 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_users' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT [owner].[uid] AS [t1_c0], [owner].[users_name] AS [t1_c1], [owner].[password] AS [t1_c2], [owner].[full_name] AS [t1_c3], [owner].[parent_id] AS [t1_c4], [owner].[lang] AS [t1_c5], [owner].[email] AS [t1_c6], [owner].[htmleditormode] AS [t1_c7], [owner].[templateeditormode] AS [t1_c8], [owner].[questionselectormode] AS [t1_c9], [owner].[one_time_pw] AS [t1_c10], [owner].[dateformat] AS [t1_c11], [owner].[created] AS [t1_c12], [owner].[modified] AS [t1_c13] FROM [dbo].[lime_users] [owner] WHERE ([owner].[uid]=:ypl0) 2020/03/09 08:05:24 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE ((COALESCE(validuntil, '2020-03-09 08:05:24') >= '2020-03-09 08:05:24' AND COALESCE(validfrom, '2020-03-09 08:05:24') <= '2020-03-09 08:05:24' AND usesleft > 0) AND (completed = 'N')) AND ([t].[token]=:yp0) 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:24 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_template_configuration' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (sid=:sid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='vanilla' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='fruity' 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE (gsid=:gsid) AND (template_name=:template_name) ORDER BY [t].[template_name] 2020/03/09 08:05:25 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:25 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_surveys_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] SurveysGroups.findByPk() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_surveys_groups] [t] WHERE [t].[gsid]=1 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] TemplateConfiguration.find() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_template_configuration] [t] WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY [t].[template_name] 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] lazy loading TemplateConfiguration.template 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT [template].[id] AS [t1_c0], [template].[name] AS [t1_c1], [template].[folder] AS [t1_c2], [template].[title] AS [t1_c3], [template].[creation_date] AS [t1_c4], [template].[author] AS [t1_c5], [template].[author_email] AS [t1_c6], [template].[author_url] AS [t1_c7], [template].[copyright] AS [t1_c8], [template].[license] AS [t1_c9], [template].[version] AS [t1_c10], [template].[api_version] AS [t1_c11], [template].[view_folder] AS [t1_c12], [template].[files_folder] AS [t1_c13], [template].[description] AS [t1_c14], [template].[last_update] AS [t1_c15], [template].[owner_id] AS [t1_c16], [template].[extends] AS [t1_c17] FROM [dbo].[lime_templates] [template] WHERE ([template].[name]=:ypl0) 2020/03/09 08:05:26 [trace] [system.db.ar.CActiveRecord] Template.findByPk() 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_templates] [t] WHERE [t].[name]='ndc_blue_fruity' 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_groups' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:26 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_answers' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [answer] FROM [lime_answers] WHERE (qid=:qid) AND (code=:code) AND (scale_id=:scale_id) AND (language=:lang) 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_survey_198559' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.findByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_survey_198559] SET [lastpage]=:yp0, [datestamp]=:yp1, [ipaddr]=:yp2, [198559X3X7]=:yp3, [198559X3X9]=:yp4, [198559X3X8]=:yp5 WHERE [dbo].[lime_survey_198559].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE lime_survey_198559_timings SET interviewtime = (CASE WHEN interviewtime IS NULL THEN 0 ELSE interviewtime END) + 24.27 WHERE id = 11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_saved_control' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] SavedControl.find() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_saved_control] [t] WHERE (srid=:srid) AND (sid=:sid) 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.findByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_survey_198559] [t] WHERE [t].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_quota' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Quota.findAllByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT * FROM [dbo].[lime_quota] [t] WHERE [t].[sid]=:yp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Response_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_survey_198559] SET [submitdate]=:yp0 WHERE [dbo].[lime_survey_198559].[id]=11014 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.findByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:yp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] lazy loading Token_198559.survey 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [survey].[sid] AS [t1_c0], [survey].[owner_id] AS [t1_c1], [survey].[gsid] AS [t1_c2], [survey].[admin] AS [t1_c3], [survey].[active] AS [t1_c4], [survey].[expires] AS [t1_c5], [survey].[startdate] AS [t1_c6], [survey].[adminemail] AS [t1_c7], [survey].[anonymized] AS [t1_c8], [survey].[faxto] AS [t1_c9], [survey].[format] AS [t1_c10], [survey].[savetimings] AS [t1_c11], [survey].[template] AS [t1_c12], [survey].[language] AS [t1_c13], [survey].[additional_languages] AS [t1_c14], [survey].[datestamp] AS [t1_c15], [survey].[usecookie] AS [t1_c16], [survey].[allowregister] AS [t1_c17], [survey].[allowsave] AS [t1_c18], [survey].[autonumber_start] AS [t1_c19], [survey].[autoredirect] AS [t1_c20], [survey].[allowprev] AS [t1_c21], [survey].[printanswers] AS [t1_c22], [survey].[ipaddr] AS [t1_c23], [survey].[refurl] AS [t1_c24], [survey].[datecreated] AS [t1_c25], [survey].[showsurveypolicynotice] AS [t1_c26], [survey].[publicstatistics] AS [t1_c27], [survey].[publicgraphs] AS [t1_c28], [survey].[listpublic] AS [t1_c29], [survey].[htmlemail] AS [t1_c30], [survey].[sendconfirmation] AS [t1_c31], [survey].[tokenanswerspersistence] AS [t1_c32], [survey].[assessments] AS [t1_c33], [survey].[usecaptcha] AS [t1_c34], [survey].[usetokens] AS [t1_c35], [survey].[bounce_email] AS [t1_c36], [survey].[attributedescriptions] AS [t1_c37], [survey].[emailresponseto] AS [t1_c38], [survey].[emailnotificationto] AS [t1_c39], [survey].[tokenlength] AS [t1_c40], [survey].[showxquestions] AS [t1_c41], [survey].[showgroupinfo] AS [t1_c42], [survey].[shownoanswer] AS [t1_c43], [survey].[showqnumcode] AS [t1_c44], [survey].[bouncetime] AS [t1_c45], [survey].[bounceprocessing] AS [t1_c46], [survey].[bounceaccounttype] AS [t1_c47], [survey].[bounceaccounthost] AS [t1_c48], [survey].[bounceaccountpass] AS [t1_c49], [survey].[bounceaccountencryption] AS [t1_c50], [survey].[bounceaccountuser] AS [t1_c51], [survey].[showwelcome] AS [t1_c52], [survey].[showprogress] AS [t1_c53], [survey].[questionindex] AS [t1_c54], [survey].[navigationdelay] AS [t1_c55], [survey].[nokeyboard] AS [t1_c56], [survey].[alloweditaftercompletion] AS [t1_c57], [survey].[googleanalyticsstyle] AS [t1_c58], [survey].[googleanalyticsapikey] AS [t1_c59] FROM [dbo].[lime_surveys] [survey] WHERE (sid = 198559) 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.findAll() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 2 * FROM [dbo].[lime_tokens_198559] [t] WHERE [t].[token]=:ycp0 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.update() 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Token_198559.updateByPk() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Executing SQL: UPDATE [dbo].[lime_tokens_198559] SET [usesleft]=:yp0, [completed]=:yp1, [participant_id]=:yp2, [firstname]=:yp3, [lastname]=:yp4, [email]=:yp5, [emailstatus]=:yp6, [token]=:yp7, [language]=:yp8, [blacklisted]=:yp9, [sent]=:yp10, [remindersent]=:yp11, [remindercount]=:yp12, [validfrom]=:yp13, [validuntil]=:yp14, [mpid]=:yp15, [attribute_1]=:yp16, [attribute_2]=:yp17, [attribute_3]=:yp18, [attribute_4]=:yp19, [attribute_5]=:yp20 WHERE [dbo].[lime_tokens_198559].[tid]=56 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT [submitdate] FROM [lime_survey_198559] WHERE id=:id 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_questions' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:27 [trace] [system.db.ar.CActiveRecord] Question.countByAttributes() 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: SELECT COUNT(*) FROM [dbo].[lime_questions] [t] WHERE [t].[sid]=:yp0 AND [t].[language]=:yp1 AND [t].[parent_qid]=:yp2 2020/03/09 08:05:27 [trace] [system.CModule] Loading "user" application component 2020/03/09 08:05:27 [trace] [system.db.CDbCommand] Querying SQL: select count(DISTINCT lime_groups.gid) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where lime_groups.sid=198559 and qid is not null 2020/03/09 08:05:28 [trace] [system.CModule] Loading "twigRenderer" application component 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_asset_version' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:05:28 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:05:28 [trace] [system.db.ar.CActiveRecord] AssetVersion.find() 2020/03/09 08:05:28 [trace] [system.db.CDbCommand] Querying SQL: SELECT TOP 1 * FROM [dbo].[lime_asset_version] [t] WHERE path = :path 2020/03/09 08:12:35 [trace] [system.CModule] Loading "log" application component 2020/03/09 08:12:35 [trace] [system.CModule] Loading "request" application component 2020/03/09 08:12:35 [trace] [system.CModule] Loading "session" application component 2020/03/09 08:12:35 [trace] [system.CModule] Loading "db" application component 2020/03/09 08:12:35 [trace] [system.db.CDbConnection] Opening DB connection 2020/03/09 08:12:35 [trace] [system.CModule] Loading "cache" application component 2020/03/09 08:12:35 [trace] [system.db.CDbCommand] Querying SQL: SELECT k.column_name field_name FROM [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] k LEFT JOIN [INFORMATION_SCHEMA].[TABLE_CONSTRAINTS] c ON k.table_name = c.table_name AND k.constraint_name = c.constraint_name WHERE c.constraint_type ='PRIMARY KEY' AND k.table_name = :table AND k.table_schema = :schema 2020/03/09 08:12:35 [trace] [system.db.CDbCommand] Querying SQL: SELECT KCU1.CONSTRAINT_NAME AS 'FK_CONSTRAINT_NAME' , KCU1.TABLE_NAME AS 'FK_TABLE_NAME' , KCU1.COLUMN_NAME AS 'FK_COLUMN_NAME' , KCU1.ORDINAL_POSITION AS 'FK_ORDINAL_POSITION' , KCU2.CONSTRAINT_NAME AS 'UQ_CONSTRAINT_NAME' , KCU2.TABLE_NAME AS 'UQ_TABLE_NAME' , KCU2.COLUMN_NAME AS 'UQ_COLUMN_NAME' , KCU2.ORDINAL_POSITION AS 'UQ_ORDINAL_POSITION' FROM [INFORMATION_SCHEMA].[REFERENTIAL_CONSTRAINTS] RC JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME JOIN [INFORMATION_SCHEMA].[KEY_COLUMN_USAGE] KCU2 ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION WHERE KCU1.TABLE_NAME = :table 2020/03/09 08:12:35 [trace] [system.db.CDbCommand] Querying SQL: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime_settings_global' AND t1.TABLE_SCHEMA='dbo' 2020/03/09 08:12:35 [trace] [system.db.ar.CActiveRecord] SettingGlobal.findAll()