View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
12492Bug reportsSurvey participants (Tokens)public2017-09-21 15:05
Reporterrobertofranchi Assigned Tomarkusfluer 
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.65.x 
Fixed in Version2.67.x 
Summary12492: Use of "text fields" as filter in "Partecipants" and "Answers"
Description

In Version 2.64.7+170404 I can use the text fields above the column as filter in partecipants and answers table and works with survey 872291.

When I Installed version 2.65.3+170607 and Version 2.67.1+170626 errors appear... (see Error with more than 45 fields.PNG)
If I use up to 45 attribute it works but If I use 46 attributes the error appear (below the log)

I've more survey with more that 45 attributes....

Steps To Reproduce

Joint you'll find 872291.lsa, 872291.lss file and token.cvs and answer.csv

1) load the joint survey files
2) go to partecipant,

  • showed it
  • try to filer by name or surname or other fields (error appear)
    3) go to attributes...
  • deleted the attribute_46
    4) repeat step 2 and now the search works
Additional Information

LOG

Sommario di Profiling (Tempo: 0.22324s, Memoria: 13,523KB)
Procedura Cont. Totale (s) Med. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SHOW TABLES) 1 0.00351 0.00351 0.00351 0.00351
system.db.CDbCommand.query(SELECT survey.sid AS t1_c0, survey.owner_id AS t1_c1, survey.admin AS t1_c2, survey.active AS t1_c3, survey.expires AS t1_c4, survey.startdate AS t1_c5, survey.adminemail AS t1_c6, survey.anonymized AS t1_c7, survey.faxto AS t1_c8, survey.format AS t1_c9, survey.savetimings AS t1_c10, survey.template AS t1_c11, survey.language AS t1_c12, survey.additional_languages AS t1_c13, survey.datestamp AS t1_c14, survey.usecookie AS t1_c15, survey.allowregister AS t1_c16, survey.allowsave AS t1_c17, survey.autonumber_start AS t1_c18, survey.autoredirect AS t1_c19, survey.allowprev AS t1_c20, survey.printanswers AS t1_c21, survey.ipaddr AS t1_c22, survey.refurl AS t1_c23, survey.datecreated AS t1_c24, survey.publicstatistics AS t1_c25, survey.publicgraphs AS t1_c26, survey.listpublic AS t1_c27, survey.htmlemail AS t1_c28, survey.sendconfirmation AS t1_c29, survey.tokenanswerspersistence AS t1_c30, survey.assessments AS t1_c31, survey.usecaptcha AS t1_c32, survey.usetokens AS t1_c33, survey.bounce_email AS t1_c34, survey.attributedescriptions AS t1_c35, survey.emailresponseto AS t1_c36, survey.emailnotificationto AS t1_c37, survey.tokenlength AS t1_c38, survey.showxquestions AS t1_c39, survey.showgroupinfo AS t1_c40, survey.shownoanswer AS t1_c41, survey.showqnumcode AS t1_c42, survey.bouncetime AS t1_c43, survey.bounceprocessing AS t1_c44, survey.bounceaccounttype AS t1_c45, survey.bounceaccounthost AS t1_c46, survey.bounceaccountpass AS t1_c47, survey.bounceaccountencryption AS t1_c48, survey.bounceaccountuser AS t1_c49, survey.showwelcome AS t1_c50, survey.showprogress AS t1_c51, survey.questionindex AS t1_c52, survey.navigationdelay AS t1_c53, survey.nokeyboard AS t1_c54, survey.alloweditaftercompletion AS t1_c55, survey.googleanalyticsstyle AS t1_c56, survey.googleanalyticsapikey AS t1_c57 FROM lime_surveys survey WHERE (sid=872291)) 16 0.00280 0.00018 0.00015 0.00046
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys) 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_tokens_872291) 1 0.00081 0.00081 0.00081 0.00081
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_survey_872291) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT FROM lime_tokens_872291 t ORDER BY tid ASC LIMIT 250) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_settings_global) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_languagesettings) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT defaultlanguage.surveyls_survey_id AS t1_c0, defaultlanguage.surveyls_language AS t1_c1, defaultlanguage.surveyls_title AS t1_c2, defaultlanguage.surveyls_description AS t1_c3, defaultlanguage.surveyls_welcometext AS t1_c4, defaultlanguage.surveyls_endtext AS t1_c5, defaultlanguage.surveyls_url AS t1_c6, defaultlanguage.surveyls_urldescription AS t1_c7, defaultlanguage.surveyls_email_invite_subj AS t1_c8, defaultlanguage.surveyls_email_invite AS t1_c9, defaultlanguage.surveyls_email_remind_subj AS t1_c10, defaultlanguage.surveyls_email_remind AS t1_c11, defaultlanguage.surveyls_email_register_subj AS t1_c12, defaultlanguage.surveyls_email_register AS t1_c13, defaultlanguage.surveyls_email_confirm_subj AS t1_c14, defaultlanguage.surveyls_email_confirm AS t1_c15, defaultlanguage.surveyls_dateformat AS t1_c16, defaultlanguage.surveyls_attributecaptions AS t1_c17, defaultlanguage.email_admin_notification_subj AS t1_c18, defaultlanguage.email_admin_notification AS t1_c19, defaultlanguage.email_admin_responses_subj AS t1_c20, defaultlanguage.email_admin_responses AS t1_c21, defaultlanguage.surveyls_numberformat AS t1_c22, defaultlanguage.attachments AS t1_c23 FROM lime_surveys_languagesettings defaultlanguage WHERE (defaultlanguage.surveyls_language=:ypl0) AND (defaultlanguage.surveyls_survey_id=:ypl1). Bound with :ypl0='it', :ypl1='872291') 3 0.00052 0.00017 0.00016 0.00018
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_users) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_questions) 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_notifications) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_permissions) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_groups) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_plugins) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_question_attributes) 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_templates) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(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 = 872291 and a.language='it' and q.language='it' ORDER BY a.qid, a.scale_id, a.sortorder) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT t.sid AS t0_c0, t.owner_id AS t0_c1, t.admin AS t0_c2, t.active AS t0_c3, t.expires AS t0_c4, t.startdate AS t0_c5, t.adminemail AS t0_c6, t.anonymized AS t0_c7, t.faxto AS t0_c8, t.format AS t0_c9, t.savetimings AS t0_c10, t.template AS t0_c11, t.language AS t0_c12, t.additional_languages AS t0_c13, t.datestamp AS t0_c14, t.usecookie AS t0_c15, t.allowregister AS t0_c16, t.allowsave AS t0_c17, t.autonumber_start AS t0_c18, t.autoredirect AS t0_c19, t.allowprev AS t0_c20, t.printanswers AS t0_c21, t.ipaddr AS t0_c22, t.refurl AS t0_c23, t.datecreated AS t0_c24, t.publicstatistics AS t0_c25, t.publicgraphs AS t0_c26, t.listpublic AS t0_c27, t.htmlemail AS t0_c28, t.sendconfirmation AS t0_c29, t.tokenanswerspersistence AS t0_c30, t.assessments AS t0_c31, t.usecaptcha AS t0_c32, t.usetokens AS t0_c33, t.bounce_email AS t0_c34, t.attributedescriptions AS t0_c35, t.emailresponseto AS t0_c36, t.emailnotificationto AS t0_c37, t.tokenlength AS t0_c38, t.showxquestions AS t0_c39, t.showgroupinfo AS t0_c40, t.shownoanswer AS t0_c41, t.showqnumcode AS t0_c42, t.bouncetime AS t0_c43, t.bounceprocessing AS t0_c44, t.bounceaccounttype AS t0_c45, t.bounceaccounthost AS t0_c46, t.bounceaccountpass AS t0_c47, t.bounceaccountencryption AS t0_c48, t.bounceaccountuser AS t0_c49, t.showwelcome AS t0_c50, t.showprogress AS t0_c51, t.questionindex AS t0_c52, t.navigationdelay AS t0_c53, t.nokeyboard AS t0_c54, t.alloweditaftercompletion AS t0_c55, t.googleanalyticsstyle AS t0_c56, t.googleanalyticsapikey AS t0_c57, languagesettings.surveyls_survey_id AS t1_c0, languagesettings.surveyls_language AS t1_c1, languagesettings.surveyls_title AS t1_c2, languagesettings.surveyls_description AS t1_c3, languagesettings.surveyls_welcometext AS t1_c4, languagesettings.surveyls_endtext AS t1_c5, languagesettings.surveyls_url AS t1_c6, languagesettings.surveyls_urldescription AS t1_c7, languagesettings.surveyls_email_invite_subj AS t1_c8, languagesettings.surveyls_email_invite AS t1_c9, languagesettings.surveyls_email_remind_subj AS t1_c10, languagesettings.surveyls_email_remind AS t1_c11, languagesettings.surveyls_email_register_subj AS t1_c12, languagesettings.surveyls_email_register AS t1_c13, languagesettings.surveyls_email_confirm_subj AS t1_c14, languagesettings.surveyls_email_confirm AS t1_c15, languagesettings.surveyls_dateformat AS t1_c16, languagesettings.surveyls_attributecaptions AS t1_c17, languagesettings.email_admin_notification_subj AS t1_c18, languagesettings.email_admin_notification AS t1_c19, languagesettings.email_admin_responses_subj AS t1_c20, languagesettings.email_admin_responses AS t1_c21, languagesettings.surveyls_numberformat AS t1_c22, languagesettings.attachments AS t1_c23 FROM lime_surveys t LEFT OUTER JOIN lime_surveys_languagesettings languagesettings ON (languagesettings.surveyls_survey_id=t.sid) WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid='872291') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT COUNT(
) FROM lime_tokens_872291 t) 2 0.00025 0.00012 0.00010 0.00015
system.db.CDbCommand.query(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_url AS t0_c6, t.surveyls_urldescription AS t0_c7, t.surveyls_email_invite_subj AS t0_c8, t.surveyls_email_invite AS t0_c9, t.surveyls_email_remind_subj AS t0_c10, t.surveyls_email_remind AS t0_c11, t.surveyls_email_register_subj AS t0_c12, t.surveyls_email_register AS t0_c13, t.surveyls_email_confirm_subj AS t0_c14, t.surveyls_email_confirm AS t0_c15, t.surveyls_dateformat AS t0_c16, t.surveyls_attributecaptions AS t0_c17, t.email_admin_notification_subj AS t0_c18, t.email_admin_notification AS t0_c19, t.email_admin_responses_subj AS t0_c20, t.email_admin_responses AS t0_c21, t.surveyls_numberformat AS t0_c22, t.attachments AS t0_c23, survey.sid AS t1_c0, survey.owner_id AS t1_c1, survey.admin AS t1_c2, survey.active AS t1_c3, survey.expires AS t1_c4, survey.startdate AS t1_c5, survey.adminemail AS t1_c6, survey.anonymized AS t1_c7, survey.faxto AS t1_c8, survey.format AS t1_c9, survey.savetimings AS t1_c10, survey.template AS t1_c11, survey.language AS t1_c12, survey.additional_languages AS t1_c13, survey.datestamp AS t1_c14, survey.usecookie AS t1_c15, survey.allowregister AS t1_c16, survey.allowsave AS t1_c17, survey.autonumber_start AS t1_c18, survey.autoredirect AS t1_c19, survey.allowprev AS t1_c20, survey.printanswers AS t1_c21, survey.ipaddr AS t1_c22, survey.refurl AS t1_c23, survey.datecreated AS t1_c24, survey.publicstatistics AS t1_c25, survey.publicgraphs AS t1_c26, survey.listpublic AS t1_c27, survey.htmlemail AS t1_c28, survey.sendconfirmation AS t1_c29, survey.tokenanswerspersistence AS t1_c30, survey.assessments AS t1_c31, survey.usecaptcha AS t1_c32, survey.usetokens AS t1_c33, survey.bounce_email AS t1_c34, survey.attributedescriptions AS t1_c35, survey.emailresponseto AS t1_c36, survey.emailnotificationto AS t1_c37, survey.tokenlength AS t1_c38, survey.showxquestions AS t1_c39, survey.showgroupinfo AS t1_c40, survey.shownoanswer AS t1_c41, survey.showqnumcode AS t1_c42, survey.bouncetime AS t1_c43, survey.bounceprocessing AS t1_c44, survey.bounceaccounttype AS t1_c45, survey.bounceaccounthost AS t1_c46, survey.bounceaccountpass AS t1_c47, survey.bounceaccountencryption AS t1_c48, survey.bounceaccountuser AS t1_c49, survey.showwelcome AS t1_c50, survey.showprogress AS t1_c51, survey.questionindex AS t1_c52, survey.navigationdelay AS t1_c53, survey.nokeyboard AS t1_c54, survey.alloweditaftercompletion AS t1_c55, survey.googleanalyticsstyle AS t1_c56, survey.googleanalyticsapikey AS t1_c57 FROM lime_surveys_languagesettings t LEFT OUTER JOIN lime_surveys survey ON (t.surveyls_survey_id = survey.sid) WHERE (t.surveyls_survey_id=872291 AND t.surveyls_language='it')) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT t.sid AS t0_c0, t.owner_id AS t0_c1, t.admin AS t0_c2, t.active AS t0_c3, t.expires AS t0_c4, t.startdate AS t0_c5, t.adminemail AS t0_c6, t.anonymized AS t0_c7, t.faxto AS t0_c8, t.format AS t0_c9, t.savetimings AS t0_c10, t.template AS t0_c11, t.language AS t0_c12, t.additional_languages AS t0_c13, t.datestamp AS t0_c14, t.usecookie AS t0_c15, t.allowregister AS t0_c16, t.allowsave AS t0_c17, t.autonumber_start AS t0_c18, t.autoredirect AS t0_c19, t.allowprev AS t0_c20, t.printanswers AS t0_c21, t.ipaddr AS t0_c22, t.refurl AS t0_c23, t.datecreated AS t0_c24, t.publicstatistics AS t0_c25, t.publicgraphs AS t0_c26, t.listpublic AS t0_c27, t.htmlemail AS t0_c28, t.sendconfirmation AS t0_c29, t.tokenanswerspersistence AS t0_c30, t.assessments AS t0_c31, t.usecaptcha AS t0_c32, t.usetokens AS t0_c33, t.bounce_email AS t0_c34, t.attributedescriptions AS t0_c35, t.emailresponseto AS t0_c36, t.emailnotificationto AS t0_c37, t.tokenlength AS t0_c38, t.showxquestions AS t0_c39, t.showgroupinfo AS t0_c40, t.shownoanswer AS t0_c41, t.showqnumcode AS t0_c42, t.bouncetime AS t0_c43, t.bounceprocessing AS t0_c44, t.bounceaccounttype AS t0_c45, t.bounceaccounthost AS t0_c46, t.bounceaccountpass AS t0_c47, t.bounceaccountencryption AS t0_c48, t.bounceaccountuser AS t0_c49, t.showwelcome AS t0_c50, t.showprogress AS t0_c51, t.questionindex AS t0_c52, t.navigationdelay AS t0_c53, t.nokeyboard AS t0_c54, t.alloweditaftercompletion AS t0_c55, t.googleanalyticsstyle AS t0_c56, t.googleanalyticsapikey AS t0_c57, languagesettings.surveyls_survey_id AS t1_c0, languagesettings.surveyls_language AS t1_c1, languagesettings.surveyls_title AS t1_c2, languagesettings.surveyls_description AS t1_c3, languagesettings.surveyls_welcometext AS t1_c4, languagesettings.surveyls_endtext AS t1_c5, languagesettings.surveyls_url AS t1_c6, languagesettings.surveyls_urldescription AS t1_c7, languagesettings.surveyls_email_invite_subj AS t1_c8, languagesettings.surveyls_email_invite AS t1_c9, languagesettings.surveyls_email_remind_subj AS t1_c10, languagesettings.surveyls_email_remind AS t1_c11, languagesettings.surveyls_email_register_subj AS t1_c12, languagesettings.surveyls_email_register AS t1_c13, languagesettings.surveyls_email_confirm_subj AS t1_c14, languagesettings.surveyls_email_confirm AS t1_c15, languagesettings.surveyls_dateformat AS t1_c16, languagesettings.surveyls_attributecaptions AS t1_c17, languagesettings.email_admin_notification_subj AS t1_c18, languagesettings.email_admin_notification AS t1_c19, languagesettings.email_admin_responses_subj AS t1_c20, languagesettings.email_admin_responses AS t1_c21, languagesettings.surveyls_numberformat AS t1_c22, languagesettings.attachments AS t1_c23 FROM lime_surveys t LEFT OUTER JOIN lime_surveys_languagesettings languagesettings ON (languagesettings.surveyls_survey_id=t.sid) WHERE (sid = :surveyid) AND (surveyls_language = language). Bound with :surveyid='872291') 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys) 1 0.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE lime_tokens_872291) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT FROM lime_settings_global t) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT
FROM lime_surveys t WHERE t.sid=872291 LIMIT 1) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_languagesettings) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW CREATE TABLE lime_survey_872291) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT FROM lime_surveys t WHERE t.sid=:yp0 LIMIT 1. Bound with :yp0=872291) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE lime_settings_global) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE lime_questions) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE lime_users) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE lime_notifications) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SHOW CREATE TABLE lime_permissions) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='Pom2ge0UalTI2Hz') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE lime_groups) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SHOW CREATE TABLE lime_question_attributes) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='h8h7NiQlYn0OW6J') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='RbGTgGbYFyEUjoU') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='QRfkN11DFa3kL39') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE t.sid=:yp0 AND t.gid=:yp1 AND t.language=:yp2 ORDER BY question_order ASC. Bound with :yp0='872291', :yp1='8', :yp2='it') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='D5u2WiqFfZlyAjv') 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='tLCj6AVQxbks1EJ') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='HfN7hSkI5RTIaM9') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=79) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE lime_plugins) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='XpPWOa9wDgYcMXs') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='23mD2ASzO2RMGaz') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE t.sid=:yp0 AND t.gid=:yp1 AND t.language=:yp2 ORDER BY question_order ASC. Bound with :yp0='872291', :yp1='9', :yp2='it') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SHOW CREATE TABLE lime_templates) 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='iUusXlzCnmaOAWk') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='UzYDaLWir65J0CW') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE t.sid=:yp0 AND t.gid=:yp1 AND t.language=:yp2 ORDER BY question_order ASC. Bound with :yp0='872291', :yp1='7', :yp2='it') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='6IBvi6ELSrzeWKe') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT t.uid, t.users_name, t.password, t.full_name, t.parent_id, t.lang, t.email, t.htmleditormode, t.templateeditormode, t.questionselectormode, t.one_time_pw, t.dateformat, t.created, t.modified FROM lime_users t JOIN lime_permissions AS p ON p.uid = t.uid WHERE p.permission = 'superadmin') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='wctDPi5wxhoqyrV') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='jtxtAhlXi92PPXi') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='12zYwQgOHefq0Hm') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT responses.id AS t1_c0, responses.token AS t1_c1, responses.submitdate AS t1_c2, responses.lastpage AS t1_c3, responses.startlanguage AS t1_c4, responses.startdate AS t1_c5, responses.datestamp AS t1_c6, responses.ipaddr AS t1_c7, responses.refurl AS t1_c8, responses.872291X7X67 AS t1_c9, responses.872291X7X76 AS t1_c10, responses.872291X7X75 AS t1_c11, responses.872291X7X78 AS t1_c12, responses.872291X7X79 AS t1_c13, responses.872291X8X71 AS t1_c14, responses.872291X8X73 AS t1_c15, responses.872291X8X74 AS t1_c16, responses.872291X8X80 AS t1_c17, responses.872291X8X81 AS t1_c18, responses.872291X9X68 AS t1_c19, responses.872291X9X69 AS t1_c20, responses.872291X9X70 AS t1_c21, responses.872291X9X72 AS t1_c22, responses.872291X9X77 AS t1_c23 FROM lime_survey_872291 responses WHERE (responses.token=:ypl0). Bound with :ypl0='HRh8N5aJGfFygsr') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT COUNT(
) FROM lime_surveys t WHERE active = 'Y') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT FROM lime_settings_global t WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT
FROM lime_groups t WHERE t.sid=:yp0 AND t.language=:yp1 ORDER BY group_order ASC. Bound with :yp0='872291', :yp1='it') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT FROM lime_groups t WHERE sid=:sid and language=:language ORDER BY group_order. Bound with :sid='872291', :language='it') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=80) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT FROM lime_permissions t WHERE t.entity_id=:yp0 AND t.entity=:yp1 AND t.uid=:yp2 AND t.permission=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=67) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=71) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT DISTINCT qid FROM lime_questions t WHERE sid=:sid and parent_qid=0 GROUP BY qid. Bound with :sid='872291') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=67) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=81) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=70) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=68) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=75) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=69) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=79) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=74) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=73) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=72) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=76) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT COUNT() FROM lime_notifications t WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (status = 'new'). Bound with :sentity='survey', :sentity_id='872291', :uentity='user', :uentity_id='1') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=78) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=68) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=77) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_plugins t WHERE t.active=:yp0. Bound with :yp0=1) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=80) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=72) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=74) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=69) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=81) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=71) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT COUNT(
) FROM lime_users t) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=73) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=75) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=78) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=76) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=70) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT
FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid=77) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT COUNT() FROM lime_notifications t WHERE (entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id). Bound with :sentity='survey', :sentity_id='872291', :uentity='user', :uentity_id='1') 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT COUNT(
) FROM lime_surveys t) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SELECT COUNT(*) FROM lime_notifications t WHERE ((entity =:sentity AND entity_id=:sentity_id) OR (entity =:uentity AND entity_id=:uentity_id)) AND (importance = 3). Bound with :sentity='survey', :sentity_id='872291', :uentity='user', :uentity_id='1') 1 0.00008 0.00008 0.00008 0.00008

TagsNo tags attached.
Attached Files
tokens_872291.csv (23,456 bytes)
vvexport_872291.csv (11,369 bytes)
Bug heat6
Complete LimeSurvey version number (& build)Versione 2.67.1+170626
I will donate to the project if issue is resolvedYes
BrowserChrome, Firefox, Maxthon
Database type & versionMy Sql 5,6
Server OS (if known)Windows server 2012 R2
Webserver software & version (if known)IIS 8.5.9600.16384
PHP Version7.0.15

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2017-06-29 13:21

administrator   ~43986

This happens because on filtering the URL gets extraordinary long (>2300 characters) and depending on the webserver/browser this is denied.
We will think of a solutions that instead uses a POST.

markusfluer

markusfluer

2017-07-20 15:03

administrator   ~44120

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=23536

ollehar

ollehar

2017-07-28 16:51

administrator   ~44265

Version 2.67.3+170728 released.

c_schmitz

c_schmitz

2017-09-21 15:05

administrator   ~44438

Version 2.70.0 released

Related Changesets

LimeSurvey: master 081d467c

2017-07-20 15:03:09

markusfluer

Details Diff
Fixed issue 12492 Use of "text fields" as filter in "Participants" and "Answers"
Dev: Set the request type to post and simplified
Affected Issues
12492
mod - application/controllers/admin/tokens.php Diff File
mod - application/views/admin/token/browse.php Diff File

Issue History

Date Modified Username Field Change
2017-06-28 10:46 robertofranchi New Issue
2017-06-28 10:46 robertofranchi File Added: Error with more than 45 fields.PNG
2017-06-28 10:46 robertofranchi File Added: limesurvey_survey_872291.lss
2017-06-28 10:46 robertofranchi File Added: survey_archive_872291.lsa
2017-06-28 10:46 robertofranchi File Added: tokens_872291.csv
2017-06-28 10:46 robertofranchi File Added: vvexport_872291.csv
2017-06-29 13:21 c_schmitz Note Added: 43986
2017-06-29 13:22 c_schmitz Assigned To => markusfluer
2017-06-29 13:22 c_schmitz Status new => assigned
2017-07-04 10:01 ollehar Priority none => high
2017-07-20 15:03 markusfluer Changeset attached => LimeSurvey master 081d467c
2017-07-20 15:03 markusfluer Note Added: 44120
2017-07-20 15:03 markusfluer Resolution open => fixed
2017-07-20 15:03 markusfluer Status assigned => resolved
2017-07-20 15:03 markusfluer Fixed in Version => 2.67.x
2017-07-28 16:51 ollehar Status resolved => closed
2017-07-28 16:51 ollehar Note Added: 44265
2017-08-15 16:59 markusfluer Status closed => resolved
2017-09-21 15:05 c_schmitz Note Added: 44438
2017-09-21 15:05 c_schmitz Status resolved => closed