View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 19255 | Bug reports | Survey editing | public | 2023-11-20 17:08 | 2023-11-27 17:30 |
| Reporter | DenisChenu | Assigned To | tibor.pacalat | ||
| Priority | none | Severity | minor | ||
| Status | resolved | Resolution | fixed | ||
| Product Version | 6.3.x | ||||
| Summary | 19255: PHP8.1 + debug=2 : survey with only stardate broke survey listing | ||||
| Description | When a survey have a startdate but no expires : it broke Admin Survey listing | ||||
| Steps To Reproduce | Steps to reproduceSet debug=2 Go to surey listing ( surveyAdministration/listsurveys) Expected resultSee the survey list Actual resultPHP Error | ||||
| Tags | No tags attached. | ||||
| Attached Files | limesurvey_survey_391583.lss (19,900 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>617</DBVersion>
<languages>
<language>en</language>
</languages>
<answers>
<fields>
<fieldname>aid</fieldname>
<fieldname>qid</fieldname>
<fieldname>code</fieldname>
<fieldname>sortorder</fieldname>
<fieldname>assessment_value</fieldname>
<fieldname>scale_id</fieldname>
</fields>
<rows>
<row>
<aid><![CDATA[9230]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[0]]></code>
<sortorder><![CDATA[1]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9231]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[1]]></code>
<sortorder><![CDATA[2]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9232]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[2]]></code>
<sortorder><![CDATA[3]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9233]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[3]]></code>
<sortorder><![CDATA[4]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9234]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[4]]></code>
<sortorder><![CDATA[5]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9235]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[5]]></code>
<sortorder><![CDATA[6]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9236]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[6]]></code>
<sortorder><![CDATA[7]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<aid><![CDATA[9237]]></aid>
<qid><![CDATA[1295]]></qid>
<code><![CDATA[7]]></code>
<sortorder><![CDATA[8]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<scale_id><![CDATA[0]]></scale_id>
</row>
</rows>
</answers>
<answer_l10ns>
<fields>
<fieldname>id</fieldname>
<fieldname>aid</fieldname>
<fieldname>answer</fieldname>
<fieldname>language</fieldname>
</fields>
<rows>
<row>
<id><![CDATA[15152]]></id>
<aid><![CDATA[9230]]></aid>
<answer><![CDATA[0]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15153]]></id>
<aid><![CDATA[9231]]></aid>
<answer><![CDATA[1]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15154]]></id>
<aid><![CDATA[9232]]></aid>
<answer><![CDATA[2]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15155]]></id>
<aid><![CDATA[9233]]></aid>
<answer><![CDATA[3]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15156]]></id>
<aid><![CDATA[9234]]></aid>
<answer><![CDATA[4]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15157]]></id>
<aid><![CDATA[9235]]></aid>
<answer><![CDATA[5]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15158]]></id>
<aid><![CDATA[9236]]></aid>
<answer><![CDATA[6]]></answer>
<language><![CDATA[en]]></language>
</row>
<row>
<id><![CDATA[15159]]></id>
<aid><![CDATA[9237]]></aid>
<answer><![CDATA[7]]></answer>
<language><![CDATA[en]]></language>
</row>
</rows>
</answer_l10ns>
<groups>
<fields>
<fieldname>gid</fieldname>
<fieldname>sid</fieldname>
<fieldname>group_order</fieldname>
<fieldname>randomization_group</fieldname>
<fieldname>grelevance</fieldname>
</fields>
<rows>
<row>
<gid><![CDATA[125]]></gid>
<sid><![CDATA[391583]]></sid>
<group_order><![CDATA[1]]></group_order>
<randomization_group/>
<grelevance><![CDATA[1]]></grelevance>
</row>
</rows>
</groups>
<group_l10ns>
<fields>
<fieldname>id</fieldname>
<fieldname>gid</fieldname>
<fieldname>group_name</fieldname>
<fieldname>description</fieldname>
<fieldname>language</fieldname>
<fieldname>sid</fieldname>
<fieldname>group_order</fieldname>
<fieldname>randomization_group</fieldname>
<fieldname>grelevance</fieldname>
</fields>
<rows>
<row>
<id><![CDATA[307]]></id>
<gid><![CDATA[125]]></gid>
<group_name><![CDATA[My first question group]]></group_name>
<language><![CDATA[en]]></language>
<sid><![CDATA[391583]]></sid>
<group_order><![CDATA[1]]></group_order>
<randomization_group/>
<grelevance><![CDATA[1]]></grelevance>
</row>
</rows>
</group_l10ns>
<questions>
<fields>
<fieldname>qid</fieldname>
<fieldname>parent_qid</fieldname>
<fieldname>sid</fieldname>
<fieldname>gid</fieldname>
<fieldname>type</fieldname>
<fieldname>title</fieldname>
<fieldname>preg</fieldname>
<fieldname>other</fieldname>
<fieldname>mandatory</fieldname>
<fieldname>question_order</fieldname>
<fieldname>scale_id</fieldname>
<fieldname>same_default</fieldname>
<fieldname>relevance</fieldname>
<fieldname>modulename</fieldname>
<fieldname>encrypted</fieldname>
<fieldname>question_theme_name</fieldname>
<fieldname>same_script</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1295]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[391583]]></sid>
<gid><![CDATA[125]]></gid>
<type><![CDATA[L]]></type>
<title><![CDATA[r474q0]]></title>
<preg/>
<other><![CDATA[N]]></other>
<mandatory><![CDATA[Y]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
<modulename/>
<encrypted><![CDATA[N]]></encrypted>
<question_theme_name><![CDATA[listradio]]></question_theme_name>
<same_script><![CDATA[0]]></same_script>
</row>
</rows>
</questions>
<question_l10ns>
<fields>
<fieldname>id</fieldname>
<fieldname>qid</fieldname>
<fieldname>question</fieldname>
<fieldname>help</fieldname>
<fieldname>language</fieldname>
<fieldname>script</fieldname>
</fields>
<rows>
<row>
<id><![CDATA[3504]]></id>
<qid><![CDATA[1295]]></qid>
<question><![CDATA[How many days a week do you exercise?]]></question>
<help/>
<language><![CDATA[en]]></language>
</row>
</rows>
</question_l10ns>
<question_attributes>
<fields>
<fieldname>qid</fieldname>
<fieldname>attribute</fieldname>
<fieldname>value</fieldname>
<fieldname>language</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[1295]]></qid>
<attribute><![CDATA[display_columns]]></attribute>
<value><![CDATA[6]]></value>
<language/>
</row>
<row>
<qid><![CDATA[1295]]></qid>
<attribute><![CDATA[hide_tip]]></attribute>
<value><![CDATA[1]]></value>
<language/>
</row>
</rows>
</question_attributes>
<surveys>
<fields>
<fieldname>sid</fieldname>
<fieldname>gsid</fieldname>
<fieldname>admin</fieldname>
<fieldname>expires</fieldname>
<fieldname>startdate</fieldname>
<fieldname>adminemail</fieldname>
<fieldname>anonymized</fieldname>
<fieldname>format</fieldname>
<fieldname>savetimings</fieldname>
<fieldname>template</fieldname>
<fieldname>language</fieldname>
<fieldname>additional_languages</fieldname>
<fieldname>datestamp</fieldname>
<fieldname>usecookie</fieldname>
<fieldname>allowregister</fieldname>
<fieldname>allowsave</fieldname>
<fieldname>autonumber_start</fieldname>
<fieldname>autoredirect</fieldname>
<fieldname>allowprev</fieldname>
<fieldname>printanswers</fieldname>
<fieldname>ipaddr</fieldname>
<fieldname>refurl</fieldname>
<fieldname>showsurveypolicynotice</fieldname>
<fieldname>publicstatistics</fieldname>
<fieldname>publicgraphs</fieldname>
<fieldname>listpublic</fieldname>
<fieldname>htmlemail</fieldname>
<fieldname>sendconfirmation</fieldname>
<fieldname>tokenanswerspersistence</fieldname>
<fieldname>assessments</fieldname>
<fieldname>usecaptcha</fieldname>
<fieldname>usetokens</fieldname>
<fieldname>bounce_email</fieldname>
<fieldname>attributedescriptions</fieldname>
<fieldname>emailresponseto</fieldname>
<fieldname>emailnotificationto</fieldname>
<fieldname>tokenlength</fieldname>
<fieldname>showxquestions</fieldname>
<fieldname>showgroupinfo</fieldname>
<fieldname>shownoanswer</fieldname>
<fieldname>showqnumcode</fieldname>
<fieldname>bouncetime</fieldname>
<fieldname>bounceprocessing</fieldname>
<fieldname>bounceaccounttype</fieldname>
<fieldname>bounceaccounthost</fieldname>
<fieldname>bounceaccountpass</fieldname>
<fieldname>bounceaccountencryption</fieldname>
<fieldname>bounceaccountuser</fieldname>
<fieldname>showwelcome</fieldname>
<fieldname>showprogress</fieldname>
<fieldname>questionindex</fieldname>
<fieldname>navigationdelay</fieldname>
<fieldname>nokeyboard</fieldname>
<fieldname>alloweditaftercompletion</fieldname>
<fieldname>googleanalyticsstyle</fieldname>
<fieldname>googleanalyticsapikey</fieldname>
<fieldname>tokenencryptionoptions</fieldname>
<fieldname>ipanonymize</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[391583]]></sid>
<gsid><![CDATA[1]]></gsid>
<admin><![CDATA[inherit]]></admin>
<startdate><![CDATA[2023-11-01 17:01:00]]></startdate>
<adminemail><![CDATA[inherit]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<format><![CDATA[I]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[inherit]]></template>
<language><![CDATA[en]]></language>
<additional_languages/>
<datestamp><![CDATA[N]]></datestamp>
<usecookie><![CDATA[I]]></usecookie>
<allowregister><![CDATA[I]]></allowregister>
<allowsave><![CDATA[I]]></allowsave>
<autonumber_start><![CDATA[0]]></autonumber_start>
<autoredirect><![CDATA[I]]></autoredirect>
<allowprev><![CDATA[I]]></allowprev>
<printanswers><![CDATA[I]]></printanswers>
<ipaddr><![CDATA[N]]></ipaddr>
<refurl><![CDATA[N]]></refurl>
<showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
<publicstatistics><![CDATA[I]]></publicstatistics>
<publicgraphs><![CDATA[I]]></publicgraphs>
<listpublic><![CDATA[I]]></listpublic>
<htmlemail><![CDATA[I]]></htmlemail>
<sendconfirmation><![CDATA[I]]></sendconfirmation>
<tokenanswerspersistence><![CDATA[I]]></tokenanswerspersistence>
<assessments><![CDATA[I]]></assessments>
<usecaptcha><![CDATA[E]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[inherit]]></bounce_email>
<emailresponseto><![CDATA[inherit]]></emailresponseto>
<emailnotificationto><![CDATA[inherit]]></emailnotificationto>
<tokenlength><![CDATA[-1]]></tokenlength>
<showxquestions><![CDATA[I]]></showxquestions>
<showgroupinfo><![CDATA[I]]></showgroupinfo>
<shownoanswer><![CDATA[I]]></shownoanswer>
<showqnumcode><![CDATA[I]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[I]]></showwelcome>
<showprogress><![CDATA[I]]></showprogress>
<questionindex><![CDATA[-1]]></questionindex>
<navigationdelay><![CDATA[-1]]></navigationdelay>
<nokeyboard><![CDATA[I]]></nokeyboard>
<alloweditaftercompletion><![CDATA[I]]></alloweditaftercompletion>
<googleanalyticsapikey><![CDATA[9999useGlobal9999]]></googleanalyticsapikey>
<tokenencryptionoptions><![CDATA[{ "enabled":"Y","columns":{ "firstname":"N","lastname":"N","email":"N" } }]]></tokenencryptionoptions>
<ipanonymize><![CDATA[N]]></ipanonymize>
</row>
</rows>
</surveys>
<surveys_languagesettings>
<fields>
<fieldname>surveyls_survey_id</fieldname>
<fieldname>surveyls_language</fieldname>
<fieldname>surveyls_title</fieldname>
<fieldname>surveyls_description</fieldname>
<fieldname>surveyls_welcometext</fieldname>
<fieldname>surveyls_endtext</fieldname>
<fieldname>surveyls_policy_notice</fieldname>
<fieldname>surveyls_policy_error</fieldname>
<fieldname>surveyls_policy_notice_label</fieldname>
<fieldname>surveyls_url</fieldname>
<fieldname>surveyls_urldescription</fieldname>
<fieldname>surveyls_email_invite_subj</fieldname>
<fieldname>surveyls_email_invite</fieldname>
<fieldname>surveyls_email_remind_subj</fieldname>
<fieldname>surveyls_email_remind</fieldname>
<fieldname>surveyls_email_register_subj</fieldname>
<fieldname>surveyls_email_register</fieldname>
<fieldname>surveyls_email_confirm_subj</fieldname>
<fieldname>surveyls_email_confirm</fieldname>
<fieldname>surveyls_dateformat</fieldname>
<fieldname>surveyls_attributecaptions</fieldname>
<fieldname>email_admin_notification_subj</fieldname>
<fieldname>email_admin_notification</fieldname>
<fieldname>email_admin_responses_subj</fieldname>
<fieldname>email_admin_responses</fieldname>
<fieldname>surveyls_numberformat</fieldname>
<fieldname>attachments</fieldname>
<fieldname>surveyls_alias</fieldname>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[391583]]></surveyls_survey_id>
<surveyls_language><![CDATA[en]]></surveyls_language>
<surveyls_title><![CDATA[test2]]></surveyls_title>
<surveyls_description/>
<surveyls_welcometext/>
<surveyls_endtext/>
<surveyls_policy_notice/>
<surveyls_policy_notice_label/>
<surveyls_url/>
<surveyls_urldescription/>
<surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Dear {FIRSTNAME},<br />
<br />
you have been invited to participate in a survey.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}<br />
<br />
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br />
{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Dear {FIRSTNAME},<br />
<br />
Recently we invited you to participate in a survey.<br />
<br />
We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Dear {FIRSTNAME},<br />
<br />
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br />
<br />
To complete this survey, click on the following URL:<br />
<br />
{SURVEYURL}<br />
<br />
If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]></surveyls_email_register>
<surveyls_email_confirm_subj><![CDATA[Confirmation of your participation in our survey]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Dear {FIRSTNAME},<br />
<br />
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br />
<br />
If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[9]]></surveyls_dateformat>
<email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Hello,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Hello,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{STATISTICSURL}<br />
<br />
<br />
The following answers were given by the participant:<br />
{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
</row>
</rows>
</surveys_languagesettings>
<themes>
<theme>
<sid>391583</sid>
<template_name>fruity</template_name>
<config>
<options>inherit</options>
</config>
</theme>
<theme>
<sid>391583</sid>
<template_name>fruity_twentythree</template_name>
<config>
<options>inherit</options>
</config>
</theme>
</themes>
<themes_inherited>
<theme>
<sid>391583</sid>
<template_name>fruity</template_name>
<config>
<options>
<hideprivacyinfo>off</hideprivacyinfo>
<showpopups>1</showpopups>
<showclearall>off</showclearall>
<questionhelptextposition>top</questionhelptextposition>
<fixnumauto>enable</fixnumauto>
<backgroundimage>off</backgroundimage>
<backgroundimagefile>./files/pattern.png</backgroundimagefile>
<brandlogo>off</brandlogo>
<brandlogofile>image::theme::files/logo.png</brandlogofile>
<font>ibm-sans</font>
<cssframework>Apple</cssframework>
</options>
</config>
</theme>
<theme>
<sid>391583</sid>
<template_name>fruity_twentythree</template_name>
<config>
<options>
<hideprivacyinfo>off</hideprivacyinfo>
<showpopups>1</showpopups>
<showclearall>off</showclearall>
<questionhelptextposition>top</questionhelptextposition>
<fixnumauto>enable</fixnumauto>
<backgroundimage>off</backgroundimage>
<backgroundimagefile>./files/pattern.png</backgroundimagefile>
<brandlogo>off</brandlogo>
<brandlogofile>image::theme::files/logo.png</brandlogofile>
<font>ibm-sans</font>
<cssframework>Apple</cssframework>
</options>
</config>
</theme>
</themes_inherited>
</document>
PHP error.html (82,364 bytes)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>PHP error</title>
<style type="text/css">
/*<![CDATA[*/
html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;}
body{line-height:1;}
ol,ul{list-style:none;}
blockquote,q{quotes:none;}
blockquote:before,blockquote:after,q:before,q:after{content:none;}
:focus{outline:0;}
ins{text-decoration:none;}
del{text-decoration:line-through;}
table{border-collapse:collapse;border-spacing:0;}
body {
font: normal 9pt "Verdana";
color: #000;
background: #fff;
}
h1 {
font: normal 18pt "Verdana";
color: #f00;
margin-bottom: .5em;
}
h2 {
font: normal 14pt "Verdana";
color: #800000;
margin-bottom: .5em;
}
h3 {
font: bold 11pt "Verdana";
}
pre {
font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace;
}
pre span.error {
display: block;
background: #fce3e3;
}
pre span.ln {
color: #999;
padding-right: 0.5em;
border-right: 1px solid #ccc;
}
pre span.error-ln {
font-weight: bold;
}
.container {
margin: 1em 4em;
}
.version {
color: gray;
font-size: 8pt;
border-top: 1px solid #aaa;
padding-top: 1em;
margin-bottom: 1em;
}
.message {
color: #000;
padding: 1em;
font-size: 11pt;
background: #f3f3f3;
-webkit-border-radius: 10px;
-moz-border-radius: 10px;
border-radius: 10px;
margin-bottom: 1em;
line-height: 160%;
}
.source {
margin-bottom: 1em;
}
.code pre {
background-color: #ffe;
margin: 0.5em 0;
padding: 0.5em;
line-height: 125%;
border: 1px solid #eee;
}
.source .file {
margin-bottom: 1em;
font-weight: bold;
}
.traces {
margin: 2em 0;
}
.trace {
margin: 0.5em 0;
padding: 0.5em;
}
.trace.app {
border: 1px dashed #c00;
}
.trace .number {
text-align: right;
width: 2em;
padding: 0.5em;
}
.trace .content {
padding: 0.5em;
}
.trace .plus,
.trace .minus {
display:inline;
vertical-align:middle;
text-align:center;
border:1px solid #000;
color:#000;
font-size:10px;
line-height:10px;
margin:0;
padding:0 1px;
width:10px;
height:10px;
}
.trace.collapsed .minus,
.trace.expanded .plus,
.trace.collapsed pre {
display: none;
}
.trace-file {
cursor: pointer;
padding: 0.2em;
}
.trace-file:hover {
background: #f0ffff;
}
/*]]>*/
</style>
</head>
<body>
<div class="container">
<h1>PHP error</h1>
<p class="message">
DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated </p>
<div class="source">
<p class="file">/media/shnoulle/data/webdev/master/application/models/Survey.php(1166)</p>
<div class="code"><pre><span class="ln">1154</span> // If the survey is not active, no date test is needed
<span class="ln">1155</span> if ($this->active === 'N') {
<span class="ln">1156</span> $running = '<a href="' . App()->createUrl('/surveyAdministration/view/surveyid/' . $this->sid) . '" class="survey-state" data-bs-toggle="tooltip" title="' . gT('Inactive') . '"><i class="ri-stop-fill text-secondary me-1"></i>' . gT('Inactive') . '</a>';
<span class="ln">1157</span> } elseif ($this->expires != '' || $this->startdate != '') {
<span class="ln">1158</span> // If it's active, then we check if not expired
<span class="ln">1159</span> // Time adjust
<span class="ln">1160</span> $sNow = date("Y-m-d H:i:s", strtotime((string) Yii::app()->getConfig('timeadjust'), strtotime(date("Y-m-d H:i:s"))));
<span class="ln">1161</span> $sStop = ($this->expires != '') ? date("Y-m-d H:i:s", strtotime((string) Yii::app()->getConfig('timeadjust'), strtotime($this->expires))) : null;
<span class="ln">1162</span> $sStart = ($this->startdate != '') ? date("Y-m-d H:i:s", strtotime((string) Yii::app()->getConfig('timeadjust'), strtotime($this->startdate))) : null;
<span class="ln">1163</span>
<span class="ln">1164</span> // Time comparaison
<span class="ln">1165</span> $oNow = new DateTime($sNow);
<span class="error"><span class="ln error-ln">1166</span> $oStop = new DateTime($sStop);
</span><span class="ln">1167</span> $oStart = new DateTime($sStart);
<span class="ln">1168</span>
<span class="ln">1169</span> $bExpired = (!is_null($sStop) && $oStop < $oNow);
<span class="ln">1170</span> $bWillRun = (!is_null($sStart) && $oStart > $oNow);
<span class="ln">1171</span>
<span class="ln">1172</span> $sStop = $sStop != null ? convertToGlobalSettingFormat($sStop) : null;
<span class="ln">1173</span> $sStart = convertToGlobalSettingFormat($sStart);
<span class="ln">1174</span>
<span class="ln">1175</span> // Icon generaton (for CGridView)
<span class="ln">1176</span> $sIconRunNoEx = '<a href="' . App()->createUrl('/surveyAdministration/view/surveyid/' . $this->sid) . '" class="survey-state" data-bs-toggle="tooltip" title="' . gT('End: Never') . '"><i class="ri-play-fill text-primary me-1"></i>' . gT('End: Never') . '</a>';
<span class="ln">1177</span> $sIconRunning = '<a href="' . App()->createUrl('/surveyAdministration/view/surveyid/' . $this->sid) . '" class="survey-state" data-bs-toggle="tooltip" title="' . sprintf(gT('End: %s'), $sStop) . '"><i class="ri-play-fill text-primary me-1"></i>' . sprintf(gT('End: %s'), $sStop) . '</a>';
<span class="ln">1178</span> $sIconExpired = '<a href="' . App()->createUrl('/surveyAdministration/view/surveyid/' . $this->sid) . '" class="survey-state" data-bs-toggle="tooltip" title="' . sprintf(gT('Expired: %s'), $sStop) . '"><i class="ri-skip-forward-fill text-secondary me-1"></i>' . sprintf(gT('Expired: %s'), $sStop) . '</a>';
</pre></div> </div>
<div class="traces">
<h2>Stack Trace</h2>
<table style="width:100%;">
<tbody><tr class="trace app expanded">
<td class="number">
#0 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/models/Survey.php(1166): <strong>DateTime</strong>-><strong>__construct</strong>(null) </div>
<div class="code"><pre><span class="ln">1161</span> $sStop = ($this->expires != '') ? date("Y-m-d H:i:s", strtotime((string) Yii::app()->getConfig('timeadjust'), strtotime($this->expires))) : null;
<span class="ln">1162</span> $sStart = ($this->startdate != '') ? date("Y-m-d H:i:s", strtotime((string) Yii::app()->getConfig('timeadjust'), strtotime($this->startdate))) : null;
<span class="ln">1163</span>
<span class="ln">1164</span> // Time comparaison
<span class="ln">1165</span> $oNow = new DateTime($sNow);
<span class="error"><span class="ln error-ln">1166</span> $oStop = new DateTime($sStop);
</span><span class="ln">1167</span> $oStart = new DateTime($sStart);
<span class="ln">1168</span>
<span class="ln">1169</span> $bExpired = (!is_null($sStop) && $oStop < $oNow);
<span class="ln">1170</span> $bWillRun = (!is_null($sStart) && $oStart > $oNow);
<span class="ln">1171</span>
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#1 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/base/CComponent.php(111): <strong>Survey</strong>-><strong>getRunning</strong>() </div>
<div class="code"><pre><span class="ln">106</span> */
<span class="ln">107</span> public function __get($name)
<span class="ln">108</span> {
<span class="ln">109</span> $getter='get'.$name;
<span class="ln">110</span> if(method_exists($this,$getter))
<span class="error"><span class="ln error-ln">111</span> return $this->$getter();
</span><span class="ln">112</span> elseif(strncasecmp($name,'on',2)===0 && method_exists($this,$name))
<span class="ln">113</span> {
<span class="ln">114</span> // duplicating getEventHandlers() here for performance
<span class="ln">115</span> $name=strtolower($name);
<span class="ln">116</span> if(!isset($this->_e[$name]))
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#2 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(145): <strong>CComponent</strong>-><strong>__get</strong>("running") </div>
<div class="code"><pre><span class="ln">140</span> elseif(isset($this->_related[$name]))
<span class="ln">141</span> return $this->_related[$name];
<span class="ln">142</span> elseif(isset($this->getMetaData()->relations[$name]))
<span class="ln">143</span> return $this->getRelated($name);
<span class="ln">144</span> else
<span class="error"><span class="ln error-ln">145</span> return parent::__get($name);
</span><span class="ln">146</span> }
<span class="ln">147</span>
<span class="ln">148</span> /**
<span class="ln">149</span> * PHP setter magic method.
<span class="ln">150</span> * This method is overridden so that AR attributes can be accessed like properties.
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#3 </td>
<td class="content">
<div class="trace-file">
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/base/CComponent.php(614) : eval()'d code(1): <strong>CActiveRecord</strong>-><strong>__get</strong>("running") </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#4 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/base/CComponent.php(614): <strong>eval</strong>() </div>
<div class="code"><pre><span class="ln">609</span> if(is_string($_expression_))
<span class="ln">610</span> {
<span class="ln">611</span> extract($_data_);
<span class="ln">612</span> try
<span class="ln">613</span> {
<span class="error"><span class="ln error-ln">614</span> return eval('return ' . $_expression_ . ';');
</span><span class="ln">615</span> }
<span class="ln">616</span> catch (ParseError $e)
<span class="ln">617</span> {
<span class="ln">618</span> return false;
<span class="ln">619</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#5 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CDataColumn.php(148): <strong>CComponent</strong>-><strong>evaluateExpression</strong>("$data->running", array("data" => Survey, "row" => 1)) </div>
<div class="code"><pre><span class="ln">143</span> */
<span class="ln">144</span> public function getDataCellContent($row)
<span class="ln">145</span> {
<span class="ln">146</span> $data=$this->grid->dataProvider->data[$row];
<span class="ln">147</span> if($this->value!==null)
<span class="error"><span class="ln error-ln">148</span> $value=$this->evaluateExpression($this->value,array('data'=>$data,'row'=>$row));
</span><span class="ln">149</span> elseif($this->name!==null)
<span class="ln">150</span> $value=CHtml::value($data,$this->name);
<span class="ln">151</span> return $value===null ? $this->grid->nullDisplay : $this->grid->getFormatter()->format($value,$this->type);
<span class="ln">152</span> }
<span class="ln">153</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#6 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridColumn.php(237): <strong>CDataColumn</strong>-><strong>getDataCellContent</strong>(1) </div>
<div class="code"><pre><span class="ln">232</span> * @param mixed $data the data associated with the row
<span class="ln">233</span> * @deprecated since 1.1.16. Use {@link getDataCellContent()} instead.
<span class="ln">234</span> */
<span class="ln">235</span> protected function renderDataCellContent($row,$data)
<span class="ln">236</span> {
<span class="error"><span class="ln error-ln">237</span> echo $this->getDataCellContent($row);
</span><span class="ln">238</span> }
<span class="ln">239</span>
<span class="ln">240</span> /**
<span class="ln">241</span> * Returns the filter cell content.
<span class="ln">242</span> * The default implementation simply returns an empty column.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#7 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridColumn.php(160): <strong>CGridColumn</strong>-><strong>renderDataCellContent</strong>(1, Survey) </div>
<div class="code"><pre><span class="ln">155</span> else
<span class="ln">156</span> $options['class']=$class;
<span class="ln">157</span> }
<span class="ln">158</span> }
<span class="ln">159</span> echo CHtml::openTag('td',$options);
<span class="error"><span class="ln error-ln">160</span> $this->renderDataCellContent($row,$data);
</span><span class="ln">161</span> echo '</td>';
<span class="ln">162</span> }
<span class="ln">163</span>
<span class="ln">164</span> /**
<span class="ln">165</span> * Renders the footer cell.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(655): <strong>CGridColumn</strong>-><strong>renderDataCell</strong>(1) </div>
<div class="code"><pre><span class="ln">650</span> * @param integer $row
<span class="ln">651</span> * @since 1.1.16
<span class="ln">652</span> */
<span class="ln">653</span> protected function renderDataCell($column, $row)
<span class="ln">654</span> {
<span class="error"><span class="ln error-ln">655</span> $column->renderDataCell($row);
</span><span class="ln">656</span> }
<span class="ln">657</span>
<span class="ln">658</span> /**
<span class="ln">659</span> * @return boolean whether the table should render a footer.
<span class="ln">660</span> * This is true if any of the {@link columns} has a true {@link CGridColumn::hasFooter} value.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#9 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(639): <strong>CGridView</strong>-><strong>renderDataCell</strong>(TbDataColumn, 1) </div>
<div class="code"><pre><span class="ln">634</span> $htmlOptions['class']=$class;
<span class="ln">635</span> }
<span class="ln">636</span>
<span class="ln">637</span> echo CHtml::openTag('tr', $htmlOptions)."\n";
<span class="ln">638</span> foreach($this->columns as $column)
<span class="error"><span class="ln error-ln">639</span> $this->renderDataCell($column, $row);
</span><span class="ln">640</span> echo "</tr>\n";
<span class="ln">641</span> }
<span class="ln">642</span>
<span class="ln">643</span> /**
<span class="ln">644</span> * A seam for people extending CGridView to be able to hook onto the data cell rendering process.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(595): <strong>CGridView</strong>-><strong>renderTableRow</strong>(1) </div>
<div class="code"><pre><span class="ln">590</span> echo "<tbody>\n";
<span class="ln">591</span>
<span class="ln">592</span> if($n>0)
<span class="ln">593</span> {
<span class="ln">594</span> for($row=0;$row<$n;++$row)
<span class="error"><span class="ln error-ln">595</span> $this->renderTableRow($row);
</span><span class="ln">596</span> }
<span class="ln">597</span> else
<span class="ln">598</span> {
<span class="ln">599</span> echo '<tr><td colspan="'.count($this->columns).'" class="empty">';
<span class="ln">600</span> $this->renderEmptyText();
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#11 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/grid/CGridView.php(505): <strong>CGridView</strong>-><strong>renderTableBody</strong>() </div>
<div class="code"><pre><span class="ln">500</span> if($this->dataProvider->getItemCount()>0 || $this->showTableOnEmpty)
<span class="ln">501</span> {
<span class="ln">502</span> echo "<table class=\"{$this->itemsCssClass}\">\n";
<span class="ln">503</span> $this->renderTableHeader();
<span class="ln">504</span> ob_start();
<span class="error"><span class="ln error-ln">505</span> $this->renderTableBody();
</span><span class="ln">506</span> $body=ob_get_clean();
<span class="ln">507</span> $this->renderTableFooter();
<span class="ln">508</span> echo $body; // TFOOT must appear before TBODY according to the standard.
<span class="ln">509</span> echo "</table>";
<span class="ln">510</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(181): <strong>CGridView</strong>-><strong>renderItems</strong>() </div>
<div class="code"><pre><span class="ln">176</span> protected function renderSection($matches)
<span class="ln">177</span> {
<span class="ln">178</span> $method='render'.$matches[1];
<span class="ln">179</span> if(method_exists($this,$method))
<span class="ln">180</span> {
<span class="error"><span class="ln error-ln">181</span> $this->$method();
</span><span class="ln">182</span> $html=ob_get_contents();
<span class="ln">183</span> ob_clean();
<span class="ln">184</span> return $html;
<span class="ln">185</span> }
<span class="ln">186</span> else
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#13 </td>
<td class="content">
<div class="trace-file">
unknown(0): <strong>CBaseListView</strong>-><strong>renderSection</strong>(array("{items}", "items")) </div>
</td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(164): <strong>preg_replace_callback</strong>("/{(\w+)}/", array(CLSGridView, "renderSection"), "
<div id="bottom-scroller" class="content-right scrolling-wrappe...") </div>
<div class="code"><pre><span class="ln">159</span> * The rendering results will replace the corresponding placeholders in {@link template}.
<span class="ln">160</span> */
<span class="ln">161</span> public function renderContent()
<span class="ln">162</span> {
<span class="ln">163</span> ob_start();
<span class="error"><span class="ln error-ln">164</span> echo preg_replace_callback("/{(\w+)}/",array($this,'renderSection'),$this->template);
</span><span class="ln">165</span> ob_end_flush();
<span class="ln">166</span> }
<span class="ln">167</span>
<span class="ln">168</span> /**
<span class="ln">169</span> * Renders a section.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#15 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/CBaseListView.php(149): <strong>CBaseListView</strong>-><strong>renderContent</strong>() </div>
<div class="code"><pre><span class="ln">144</span> {
<span class="ln">145</span> $this->registerClientScript();
<span class="ln">146</span>
<span class="ln">147</span> echo CHtml::openTag($this->tagName,$this->htmlOptions)."\n";
<span class="ln">148</span>
<span class="error"><span class="ln error-ln">149</span> $this->renderContent();
</span><span class="ln">150</span> $this->renderKeys();
<span class="ln">151</span>
<span class="ln">152</span> echo CHtml::closeTag($this->tagName);
<span class="ln">153</span> }
<span class="ln">154</span>
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#16 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(182): <strong>CBaseListView</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">177</span> return ob_get_clean();
<span class="ln">178</span> }
<span class="ln">179</span> else
<span class="ln">180</span> {
<span class="ln">181</span> $widget=$this->createWidget($className,$properties);
<span class="error"><span class="ln error-ln">182</span> $widget->run();
</span><span class="ln">183</span> return $widget;
<span class="ln">184</span> }
<span class="ln">185</span> }
<span class="ln">186</span>
<span class="ln">187</span> /**
</pre></div> </td>
</tr>
<tr class="trace app expanded">
<td class="number">
#17 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/extensions/admin/survey/ListSurveysWidget/views/listSurveys.php(22):
<strong>CBaseController</strong>-><strong>widget</strong>("application.extensions.admin.grid.CLSGridView",
array("dataProvider" => CActiveDataProvider, "id" =>
"survey-grid", "emptyText" => "Aucun questionnaire trouvé.",
"summaryText" => "Affichage de {start}-{end} sur {count} résultat(s).
<select cla...", ...)) </div>
<div class="code"><pre><span class="ln">17</span> <!-- Grid -->
<span class="ln">18</span> <div class="row">
<span class="ln">19</span> <div class="col-12">
<span class="ln">20</span> <?php
<span class="ln">21</span> $surveyGrid = $this->widget('application.extensions.admin.grid.CLSGridView', [
<span class="error"><span class="ln error-ln">22</span> 'dataProvider' => $this->model->search(),
</span><span class="ln">23</span> // Number of row per page selection
<span class="ln">24</span> 'id' => 'survey-grid',
<span class="ln">25</span> 'emptyText' => gT('No surveys found.'),
<span class="ln">26</span> 'summaryText' => gT('Displaying {start}-{end} of {count} result(s).') . ' ' . sprintf(
<span class="ln">27</span> gT('%s rows per page'),
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#18 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(130): <strong>require</strong>("/media/shnoulle/data/webdev/master/application/extensions/admin/...") </div>
<div class="code"><pre><span class="ln">125</span> ob_implicit_flush(false);
<span class="ln">126</span> require($_viewFile_);
<span class="ln">127</span> return ob_get_clean();
<span class="ln">128</span> }
<span class="ln">129</span> else
<span class="error"><span class="ln error-ln">130</span> require($_viewFile_);
</span><span class="ln">131</span> }
<span class="ln">132</span>
<span class="ln">133</span> /**
<span class="ln">134</span> * Creates a widget and initializes it.
<span class="ln">135</span> * This method first creates the specified widget instance.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#19 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(95): <strong>CBaseController</strong>-><strong>renderInternal</strong>("/media/shnoulle/data/webdev/master/application/extensions/admin/...", null, false) </div>
<div class="code"><pre><span class="ln">090</span> {
<span class="ln">091</span> $widgetCount=count($this->_widgetStack);
<span class="ln">092</span> if(($renderer=Yii::app()->getViewRenderer())!==null && $renderer->fileExtension==='.'.CFileHelper::getExtension($viewFile))
<span class="ln">093</span> $content=$renderer->renderFile($this,$viewFile,$data,$return);
<span class="ln">094</span> else
<span class="error"><span class="ln error-ln">095</span> $content=$this->renderInternal($viewFile,$data,$return);
</span><span class="ln">096</span> if(count($this->_widgetStack)===$widgetCount)
<span class="ln">097</span> return $content;
<span class="ln">098</span> else
<span class="ln">099</span> {
<span class="ln">100</span> $widget=end($this->_widgetStack);
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#20 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/widgets/CWidget.php(244): <strong>CBaseController</strong>-><strong>renderFile</strong>("/media/shnoulle/data/webdev/master/application/extensions/admin/...", null, false) </div>
<div class="code"><pre><span class="ln">239</span> * @see getViewFile
<span class="ln">240</span> */
<span class="ln">241</span> public function render($view,$data=null,$return=false)
<span class="ln">242</span> {
<span class="ln">243</span> if(($viewFile=$this->getViewFile($view))!==false)
<span class="error"><span class="ln error-ln">244</span> return $this->renderFile($viewFile,$data,$return);
</span><span class="ln">245</span> else
<span class="ln">246</span> throw new CException(Yii::t('yii','{widget} cannot find the view "{view}".',
<span class="ln">247</span> array('{widget}'=>get_class($this), '{view}'=>$view)));
<span class="ln">248</span> }
<span class="ln">249</span> }</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#21 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/extensions/admin/survey/ListSurveysWidget/ListSurveysWidget.php(73):
<strong>CWidget</strong>-><strong>render</strong>("listSurveys") </div>
<div class="code"><pre><span class="ln">68</span>
<span class="ln">69</span> if ($this->bRenderSearchBox) {
<span class="ln">70</span> $this->render('searchBox');
<span class="ln">71</span> }
<span class="ln">72</span>
<span class="error"><span class="ln error-ln">73</span> $this->render('listSurveys');
</span><span class="ln">74</span> }
<span class="ln">75</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#22 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(182): <strong>ListSurveysWidget</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">177</span> return ob_get_clean();
<span class="ln">178</span> }
<span class="ln">179</span> else
<span class="ln">180</span> {
<span class="ln">181</span> $widget=$this->createWidget($className,$properties);
<span class="error"><span class="ln error-ln">182</span> $widget->run();
</span><span class="ln">183</span> return $widget;
<span class="ln">184</span> }
<span class="ln">185</span> }
<span class="ln">186</span>
<span class="ln">187</span> /**
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#23 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/views/surveyAdministration/listSurveys_view.php(23): <strong>CBaseController</strong>-><strong>widget</strong>("ext.admin.survey.ListSurveysWidget.ListSurveysWidget", array("pageSize" => 10, "model" => Survey)) </div>
<div class="code"><pre><span class="ln">18</span> <div class="tab-content">
<span class="ln">19</span> <div id="surveys" class="tab-pane show active">
<span class="ln">20</span> <!-- Survey List widget -->
<span class="ln">21</span> <?php $this->widget('ext.admin.survey.ListSurveysWidget.ListSurveysWidget', array(
<span class="ln">22</span> 'pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize']),
<span class="error"><span class="ln error-ln">23</span> 'model' => $model,
</span><span class="ln">24</span> ));
<span class="ln">25</span> ?>
<span class="ln">26</span> </div>
<span class="ln">27</span>
<span class="ln">28</span> <div id="surveygroups" class="tab-pane">
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#24 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(126): <strong>require</strong>("/media/shnoulle/data/webdev/master/application/views/surveyAdmin...") </div>
<div class="code"><pre><span class="ln">121</span> $data=$_data_;
<span class="ln">122</span> if($_return_)
<span class="ln">123</span> {
<span class="ln">124</span> ob_start();
<span class="ln">125</span> ob_implicit_flush(false);
<span class="error"><span class="ln error-ln">126</span> require($_viewFile_);
</span><span class="ln">127</span> return ob_get_clean();
<span class="ln">128</span> }
<span class="ln">129</span> else
<span class="ln">130</span> require($_viewFile_);
<span class="ln">131</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#25 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CBaseController.php(95): <strong>CBaseController</strong>-><strong>renderInternal</strong>("/media/shnoulle/data/webdev/master/application/views/surveyAdmin...",
array("issuperadmin" => true, "model" => Survey, "groupModel"
=> SurveysGroups, "topbar" => array("title" => "Liste des
questionnaires", "backLink" => "/master/index.php?r=admin/index",
"middleButtons" => " <a class="btn btn-primary
tab-dependent-button d-none" data-...")), true) </div>
<div class="code"><pre><span class="ln">090</span> {
<span class="ln">091</span> $widgetCount=count($this->_widgetStack);
<span class="ln">092</span> if(($renderer=Yii::app()->getViewRenderer())!==null && $renderer->fileExtension==='.'.CFileHelper::getExtension($viewFile))
<span class="ln">093</span> $content=$renderer->renderFile($this,$viewFile,$data,$return);
<span class="ln">094</span> else
<span class="error"><span class="ln error-ln">095</span> $content=$this->renderInternal($viewFile,$data,$return);
</span><span class="ln">096</span> if(count($this->_widgetStack)===$widgetCount)
<span class="ln">097</span> return $content;
<span class="ln">098</span> else
<span class="ln">099</span> {
<span class="ln">100</span> $widget=end($this->_widgetStack);
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#26 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CController.php(872): <strong>CBaseController</strong>-><strong>renderFile</strong>("/media/shnoulle/data/webdev/master/application/views/surveyAdmin...",
array("issuperadmin" => true, "model" => Survey, "groupModel"
=> SurveysGroups, "topbar" => array("title" => "Liste des
questionnaires", "backLink" => "/master/index.php?r=admin/index",
"middleButtons" => " <a class="btn btn-primary
tab-dependent-button d-none" data-...")), true) </div>
<div class="code"><pre><span class="ln">867</span> */
<span class="ln">868</span> public function renderPartial($view,$data=null,$return=false,$processOutput=false)
<span class="ln">869</span> {
<span class="ln">870</span> if(($viewFile=$this->getViewFile($view))!==false)
<span class="ln">871</span> {
<span class="error"><span class="ln error-ln">872</span> $output=$this->renderFile($viewFile,$data,true);
</span><span class="ln">873</span> if($processOutput)
<span class="ln">874</span> $output=$this->processOutput($output);
<span class="ln">875</span> if($return)
<span class="ln">876</span> return $output;
<span class="ln">877</span> else
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#27 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CController.php(785): <strong>CController</strong>-><strong>renderPartial</strong>("listSurveys_view",
array("issuperadmin" => true, "model" => Survey, "groupModel"
=> SurveysGroups, "topbar" => array("title" => "Liste des
questionnaires", "backLink" => "/master/index.php?r=admin/index",
"middleButtons" => " <a class="btn btn-primary
tab-dependent-button d-none" data-...")), true) </div>
<div class="code"><pre><span class="ln">780</span> */
<span class="ln">781</span> public function render($view,$data=null,$return=false)
<span class="ln">782</span> {
<span class="ln">783</span> if($this->beforeRender($view))
<span class="ln">784</span> {
<span class="error"><span class="ln error-ln">785</span> $output=$this->renderPartial($view,$data,true);
</span><span class="ln">786</span> if(($layoutFile=$this->getLayoutFile($this->layout))!==false)
<span class="ln">787</span> $output=$this->renderFile($layoutFile,array('content'=>$output),true);
<span class="ln">788</span>
<span class="ln">789</span> $this->afterRender($view,$output);
<span class="ln">790</span>
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#28 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/controllers/SurveyAdministrationController.php(247): <strong>CController</strong>-><strong>render</strong>("listSurveys_view",
array("issuperadmin" => true, "model" => Survey, "groupModel"
=> SurveysGroups, "topbar" => array("title" => "Liste des
questionnaires", "backLink" => "/master/index.php?r=admin/index",
"middleButtons" => " <a class="btn btn-primary
tab-dependent-button d-none" data-..."))) </div>
<div class="code"><pre><span class="ln">242</span> $aData['topbar']['backLink'] = App()->createUrl('admin/index');
<span class="ln">243</span>
<span class="ln">244</span> $aData['topbar']['middleButtons'] = $this->renderPartial('partial/topbarBtns/leftSideButtons', [], true);
<span class="ln">245</span>
<span class="ln">246</span> $this->aData = $aData;
<span class="error"><span class="ln error-ln">247</span> $this->render('listSurveys_view', $aData);
</span><span class="ln">248</span> }
<span class="ln">249</span>
<span class="ln">250</span> /**
<span class="ln">251</span> * Delete multiple survey
<span class="ln">252</span> *
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#29 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(49): <strong>SurveyAdministrationController</strong>-><strong>actionListsurveys</strong>() </div>
<div class="code"><pre><span class="ln">44</span> $controller=$this->getController();
<span class="ln">45</span> $method=new ReflectionMethod($controller, $methodName);
<span class="ln">46</span> if($method->getNumberOfParameters()>0)
<span class="ln">47</span> return $this->runWithParamsInternal($controller, $method, $params);
<span class="ln">48</span>
<span class="error"><span class="ln error-ln">49</span> $controller->$methodName();
</span><span class="ln">50</span> return true;
<span class="ln">51</span> }
<span class="ln">52</span> }
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#30 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CController.php(308): <strong>CInlineAction</strong>-><strong>runWithParams</strong>(array("r" => "surveyAdministration/listsurveys")) </div>
<div class="code"><pre><span class="ln">303</span> {
<span class="ln">304</span> $priorAction=$this->_action;
<span class="ln">305</span> $this->_action=$action;
<span class="ln">306</span> if($this->beforeAction($action))
<span class="ln">307</span> {
<span class="error"><span class="ln error-ln">308</span> if($action->runWithParams($this->getActionParams())===false)
</span><span class="ln">309</span> $this->invalidActionParams($action);
<span class="ln">310</span> else
<span class="ln">311</span> $this->afterAction($action);
<span class="ln">312</span> }
<span class="ln">313</span> $this->_action=$priorAction;
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#31 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(134): <strong>CController</strong>-><strong>runAction</strong>(CInlineAction) </div>
<div class="code"><pre><span class="ln">129</span> $filter=$this->itemAt($this->filterIndex++);
<span class="ln">130</span> Yii::trace('Running filter '.($filter instanceof CInlineFilter ? get_class($this->controller).'.filter'.$filter->name.'()':get_class($filter).'.filter()'),'system.web.filters.CFilterChain');
<span class="ln">131</span> $filter->filter($this);
<span class="ln">132</span> }
<span class="ln">133</span> else
<span class="error"><span class="ln error-ln">134</span> $this->controller->runAction($this->action);
</span><span class="ln">135</span> }
<span class="ln">136</span> }</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#32 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CController.php(291): <strong>CFilterChain</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">286</span> $this->runAction($action);
<span class="ln">287</span> else
<span class="ln">288</span> {
<span class="ln">289</span> $priorAction=$this->_action;
<span class="ln">290</span> $this->_action=$action;
<span class="error"><span class="ln error-ln">291</span> CFilterChain::create($this,$action,$filters)->run();
</span><span class="ln">292</span> $this->_action=$priorAction;
<span class="ln">293</span> }
<span class="ln">294</span> }
<span class="ln">295</span>
<span class="ln">296</span> /**
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#33 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(CInlineAction, array("postOnly + copy")) </div>
<div class="code"><pre><span class="ln">260</span> {
<span class="ln">261</span> if(($parent=$this->getModule())===null)
<span class="ln">262</span> $parent=Yii::app();
<span class="ln">263</span> if($parent->beforeControllerAction($this,$action))
<span class="ln">264</span> {
<span class="error"><span class="ln error-ln">265</span> $this->runActionWithFilters($action,$this->filters());
</span><span class="ln">266</span> $parent->afterControllerAction($this,$action);
<span class="ln">267</span> }
<span class="ln">268</span> }
<span class="ln">269</span> else
<span class="ln">270</span> $this->missingAction($actionID);
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#34 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/application/controllers/LSBaseController.php(145): <strong>CController</strong>-><strong>run</strong>("listsurveys") </div>
<div class="code"><pre><span class="ln">140</span> $this->redirect(array('/admin/authentication/sa/login'));
<span class="ln">141</span> }
<span class="ln">142</span> }
<span class="ln">143</span> }
<span class="ln">144</span>
<span class="error"><span class="ln error-ln">145</span> parent::run($action);
</span><span class="ln">146</span> }
<span class="ln">147</span>
<span class="ln">148</span> /**
<span class="ln">149</span> * Load and set session vars
<span class="ln">150</span> *
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#35 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): <strong>LSBaseController</strong>-><strong>run</strong>("listsurveys") </div>
<div class="code"><pre><span class="ln">277</span> {
<span class="ln">278</span> list($controller,$actionID)=$ca;
<span class="ln">279</span> $oldController=$this->_controller;
<span class="ln">280</span> $this->_controller=$controller;
<span class="ln">281</span> $controller->init();
<span class="error"><span class="ln error-ln">282</span> $controller->run($actionID);
</span><span class="ln">283</span> $this->_controller=$oldController;
<span class="ln">284</span> }
<span class="ln">285</span> else
<span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
<span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route)));
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#36 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("surveyAdministration/listsurveys") </div>
<div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
<span class="ln">137</span> $_GET[$name]=$value;
<span class="ln">138</span> }
<span class="ln">139</span> else
<span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest());
<span class="error"><span class="ln error-ln">141</span> $this->runController($route);
</span><span class="ln">142</span> }
<span class="ln">143</span>
<span class="ln">144</span> /**
<span class="ln">145</span> * Registers the core application components.
<span class="ln">146</span> * This method overrides the parent implementation by registering additional core components.
</pre></div> </td>
</tr>
<tr class="trace core collapsed">
<td class="number">
#37 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div>
<div class="code"><pre><span class="ln">180</span> public function run()
<span class="ln">181</span> {
<span class="ln">182</span> if($this->hasEventHandler('onBeginRequest'))
<span class="ln">183</span> $this->onBeginRequest(new CEvent($this));
<span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false);
<span class="error"><span class="ln error-ln">185</span> $this->processRequest();
</span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest'))
<span class="ln">187</span> $this->onEndRequest(new CEvent($this));
<span class="ln">188</span> }
<span class="ln">189</span>
<span class="ln">190</span> /**
</pre></div> </td>
</tr>
<tr class="trace app collapsed">
<td class="number">
#38 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/media/shnoulle/data/webdev/master/index.php(161): <strong>CApplication</strong>-><strong>run</strong>() </div>
<div class="code"><pre><span class="ln">156</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">157</span>
<span class="ln">158</span> $config = require_once(APPPATH . 'config/internal' . EXT);
<span class="ln">159</span>
<span class="ln">160</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">161</span> Yii::createApplication('LSYii_Application', $config)->run();
</span><span class="ln">162</span>
<span class="ln">163</span> /* End of file index.php */
<span class="ln">164</span> /* Location: ./index.php */
</pre></div> </td>
</tr>
</tbody></table>
</div>
<div class="version">
2023-11-20 17:03:18 nginx/1.22.1 <a href="https://www.yiiframework.com/">Yii Framework</a>/1.1.28 </div>
</div>
<script type="text/javascript">
/*<![CDATA[*/
var traceReg = new RegExp("(^|\\s)trace-file(\\s|$)");
var collapsedReg = new RegExp("(^|\\s)collapsed(\\s|$)");
var e = document.getElementsByTagName("div");
for(var j=0,len=e.length;j<len;j++){
if(traceReg.test(e[j].className)){
e[j].onclick = function(){
var trace = this.parentNode.parentNode;
if(collapsedReg.test(trace.className))
trace.className = trace.className.replace("collapsed", "expanded");
else
trace.className = trace.className.replace("expanded", "collapsed");
}
}
}
/*]]>*/
</script>
<table class="yiiLog" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;" width="100%" cellpadding="2">
<tbody><tr>
<th style="background:black;color:white;" colspan="6">
Sommaire du rapport de profilage
(Durée: 0.06180s,
Memoire: 7,132KB)
</th>
</tr>
<tr style="background-color: #ccc;">
<th>Fonction</th>
<th>Nb</th>
<th>Total (s)</th>
<th>Moy. (s)</th>
<th>Min. (s)</th>
<th>Max. (s)</th>
</tr>
<tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(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 `lime_templates` `template` WHERE
(`template`.`name`=:ypl0). Bound with :ypl0='bootswatch')</td>
<td align="center">38</td>
<td align="center">0.00383</td>
<td align="center">0.00010</td>
<td align="center">0.00010</td>
<td align="center">0.00012</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`)</td>
<td align="center">1</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='bootswatch' LIMIT 1)</td>
<td align="center">4</td>
<td align="center">0.00023</td>
<td align="center">0.00006</td>
<td align="center">0.00005</td>
<td align="center">0.00006</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)</td>
<td align="center">1</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)</td>
<td align="center">1</td>
<td align="center">0.00028</td>
<td align="center">0.00028</td>
<td align="center">0.00028</td>
<td align="center">0.00028</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)</td>
<td align="center">1</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)</td>
<td align="center">1</td>
<td align="center">0.00025</td>
<td align="center">0.00025</td>
<td align="center">0.00025</td>
<td align="center">0.00025</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)</td>
<td align="center">1</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1)</td>
<td align="center">1</td>
<td align="center">0.00019</td>
<td align="center">0.00019</td>
<td align="center">0.00019</td>
<td align="center">0.00019</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation`
FROM `lime_source_message` `t1`, `lime_message` `t2`
WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='fr')</td>
<td align="center">1</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
</tr> <tr style="background:#F5F5F5">
<td>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')</td>
<td align="center">1</td>
<td align="center">0.00008</td>
<td align="center">0.00008</td>
<td align="center">0.00008</td>
<td align="center">0.00008</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')</td>
<td align="center">1</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)</td>
<td align="center">1</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`)</td>
<td align="center">1</td>
<td align="center">0.00023</td>
<td align="center">0.00023</td>
<td align="center">0.00023</td>
<td align="center">0.00023</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)</td>
<td align="center">1</td>
<td align="center">0.00007</td>
<td align="center">0.00007</td>
<td align="center">0.00007</td>
<td align="center">0.00007</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)</td>
<td align="center">1</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`)</td>
<td align="center">1</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
<td align="center">0.00024</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`,
`t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`,
`t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`,
`t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`,
`t`.`packages_ltr`, `t`.`packages_rtl` FROM
`lime_template_configuration` `t` INNER JOIN lime_templates AS template
ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND
(t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY
`t`.`template_name`)</td>
<td align="center">38</td>
<td align="center">0.01180</td>
<td align="center">0.00031</td>
<td align="center">0.00028</td>
<td align="center">0.00037</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`)</td>
<td align="center">1</td>
<td align="center">0.00020</td>
<td align="center">0.00020</td>
<td align="center">0.00020</td>
<td align="center">0.00020</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t`
WHERE path = :path LIMIT 1. Bound with
:path='/media/shnoulle/data/webdev/master/application/extensions/admin/survey/ListSurveysWidget/assets/reload.js')</td>
<td align="center">1</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`)</td>
<td align="center">1</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(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 `lime_templates` `template` WHERE
(`template`.`name`=:ypl0). Bound with :ypl0='fruity')</td>
<td align="center">38</td>
<td align="center">0.00269</td>
<td align="center">0.00007</td>
<td align="center">0.00006</td>
<td align="center">0.00008</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(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 `lime_templates` `template` WHERE
(`template`.`name`=:ypl0). Bound with :ypl0='fruity_twentythree')</td>
<td align="center">38</td>
<td align="center">0.00262</td>
<td align="center">0.00007</td>
<td align="center">0.00006</td>
<td align="center">0.00009</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(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 `lime_templates` `template` WHERE
(`template`.`name`=:ypl0). Bound with :ypl0='vanilla')</td>
<td align="center">38</td>
<td align="center">0.00247</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
<td align="center">0.00009</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity_twentythree' LIMIT 1)</td>
<td align="center">4</td>
<td align="center">0.00021</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1)</td>
<td align="center">4</td>
<td align="center">0.00020</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)</td>
<td align="center">4</td>
<td align="center">0.00020</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t`)</td>
<td align="center">2</td>
<td align="center">0.00007</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` ORDER BY title ASC)</td>
<td align="center">2</td>
<td align="center">0.00007</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)</td>
<td align="center">1</td>
<td align="center">0.00027</td>
<td align="center">0.00027</td>
<td align="center">0.00027</td>
<td align="center">0.00027</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`)</td>
<td align="center">1</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT COUNT(DISTINCT `t`.`sid`) FROM
`lime_surveys` `t` LEFT OUTER JOIN `lime_surveys_languagesettings`
`correct_relation_defaultlanguage` ON
(`correct_relation_defaultlanguage`.`surveyls_language`=`t`.`language`)
AND (`correct_relation_defaultlanguage`.`surveyls_survey_id`=`t`.`sid`)
LEFT OUTER JOIN `lime_users` `owner` ON (`t`.`owner_id`=`owner`.`uid`)
LEFT OUTER JOIN `lime_surveys_groups` `surveygroup` ON
(`t`.`gsid`=`surveygroup`.`gsid`))</td>
<td align="center">1</td>
<td align="center">0.00015</td>
<td align="center">0.00015</td>
<td align="center">0.00015</td>
<td align="center">0.00015</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1)</td>
<td align="center">22</td>
<td align="center">0.00097</td>
<td align="center">0.00004</td>
<td align="center">0.00003</td>
<td align="center">0.00006</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`,
`t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS
`t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`,
`t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp`
AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS
`t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS
`t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`,
`t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`refurl`
AS `t0_c17`, `t`.`showsurveypolicynotice` AS `t0_c18`,
`t`.`publicstatistics` AS `t0_c19`, `t`.`publicgraphs` AS `t0_c20`,
`t`.`listpublic` AS `t0_c21`, `t`.`htmlemail` AS `t0_c22`,
`t`.`sendconfirmation` AS `t0_c23`, `t`.`tokenanswerspersistence` AS
`t0_c24`, `t`.`assessments` AS `t0_c25`, `t`.`usecaptcha` AS `t0_c26`,
`t`.`bounce_email` AS `t0_c27`, `t`.`attributedescriptions` AS `t0_c28`,
`t`.`emailresponseto` AS `t0_c29`, `t`.`emailnotificationto` AS
`t0_c30`, `t`.`tokenlength` AS `t0_c31`, `t`.`showxquestions` AS
`t0_c32`, `t`.`showgroupinfo` AS `t0_c33`, `t`.`shownoanswer` AS
`t0_c34`, `t`.`showqnumcode` AS `t0_c35`, `t`.`showwelcome` AS `t0_c36`,
`t`.`showprogress` AS `t0_c37`, `t`.`questionindex` AS `t0_c38`,
`t`.`navigationdelay` AS `t0_c39`, `t`.`nokeyboard` AS `t0_c40`,
`t`.`alloweditaftercompletion` AS `t0_c41`, `t`.`ipanonymize` AS
`t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS
`t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template`
AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`,
`SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS
`t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`,
`SurveysGroups`.`created` AS `t1_c8`, `SurveysGroups`.`modified` AS
`t1_c9`, `SurveysGroups`.`created_by` AS `t1_c10`,
`SurveysGroups`.`alwaysavailable` AS `t1_c11` FROM
`lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups`
`SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE
(`t`.`gsid`=1))</td>
<td align="center">11</td>
<td align="center">0.00177</td>
<td align="center">0.00016</td>
<td align="center">0.00014</td>
<td align="center">0.00027</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1)</td>
<td align="center">11</td>
<td align="center">0.00076</td>
<td align="center">0.00007</td>
<td align="center">0.00006</td>
<td align="center">0.00007</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`,
`t`.`owner_id` AS `t0_c1`, `t`.`gsid` AS `t0_c2`, `t`.`admin` AS
`t0_c3`, `t`.`active` AS `t0_c4`, `t`.`expires` AS `t0_c5`,
`t`.`startdate` AS `t0_c6`, `t`.`adminemail` AS `t0_c7`,
`t`.`anonymized` 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`.`showsurveypolicynotice`
AS `t0_c25`, `t`.`publicstatistics` AS `t0_c26`, `t`.`publicgraphs` AS
`t0_c27`, `t`.`listpublic` AS `t0_c28`, `t`.`htmlemail` AS `t0_c29`,
`t`.`sendconfirmation` AS `t0_c30`, `t`.`tokenanswerspersistence` AS
`t0_c31`, `t`.`assessments` AS `t0_c32`, `t`.`usecaptcha` AS `t0_c33`,
`t`.`usetokens` AS `t0_c34`, `t`.`bounce_email` AS `t0_c35`,
`t`.`attributedescriptions` AS `t0_c36`, `t`.`emailresponseto` AS
`t0_c37`, `t`.`emailnotificationto` AS `t0_c38`, `t`.`tokenlength` AS
`t0_c39`, `t`.`showxquestions` AS `t0_c40`, `t`.`showgroupinfo` AS
`t0_c41`, `t`.`shownoanswer` AS `t0_c42`, `t`.`showqnumcode` AS
`t0_c43`, `t`.`bouncetime` AS `t0_c44`, `t`.`bounceprocessing` AS
`t0_c45`, `t`.`bounceaccounttype` AS `t0_c46`, `t`.`bounceaccounthost`
AS `t0_c47`, `t`.`bounceaccountpass` AS `t0_c48`,
`t`.`bounceaccountencryption` AS `t0_c49`, `t`.`bounceaccountuser` AS
`t0_c50`, `t`.`showwelcome` AS `t0_c51`, `t`.`showprogress` AS `t0_c52`,
`t`.`questionindex` AS `t0_c53`, `t`.`navigationdelay` AS `t0_c54`,
`t`.`nokeyboard` AS `t0_c55`, `t`.`alloweditaftercompletion` AS
`t0_c56`, `t`.`googleanalyticsstyle` AS `t0_c57`,
`t`.`googleanalyticsapikey` AS `t0_c58`, `t`.`tokenencryptionoptions` AS
`t0_c59`, `t`.`ipanonymize` AS `t0_c60`,
`correct_relation_defaultlanguage`.`surveyls_survey_id` AS `t1_c0`,
`correct_relation_defaultlanguage`.`surveyls_language` AS `t1_c1`,
`correct_relation_defaultlanguage`.`surveyls_title` AS `t1_c2`,
`correct_relation_defaultlanguage`.`surveyls_description` AS `t1_c3`,
`correct_relation_defaultlanguage`.`surveyls_welcometext` AS `t1_c4`,
`correct_relation_defaultlanguage`.`surveyls_endtext` AS `t1_c5`,
`correct_relation_defaultlanguage`.`surveyls_policy_notice` AS `t1_c6`,
`correct_relation_defaultlanguage`.`surveyls_policy_error` AS `t1_c7`,
`correct_relation_defaultlanguage`.`surveyls_policy_notice_label` AS
`t1_c8`, `correct_relation_defaultlanguage`.`surveyls_url` AS `t1_c9`,
`correct_relation_defaultlanguage`.`surveyls_urldescription` AS
`t1_c10`,
`correct_relation_defaultlanguage`.`surveyls_email_invite_subj` AS
`t1_c11`, `correct_relation_defaultlanguage`.`surveyls_email_invite` AS
`t1_c12`,
`correct_relation_defaultlanguage`.`surveyls_email_remind_subj` AS
`t1_c13`, `correct_relation_defaultlanguage`.`surveyls_email_remind` AS
`t1_c14`,
`correct_relation_defaultlanguage`.`surveyls_email_register_subj` AS
`t1_c15`, `correct_relation_defaultlanguage`.`surveyls_email_register`
AS `t1_c16`,
`correct_relation_defaultlanguage`.`surveyls_email_confirm_subj` AS
`t1_c17`, `correct_relation_defaultlanguage`.`surveyls_email_confirm` AS
`t1_c18`, `correct_relation_defaultlanguage`.`surveyls_dateformat` AS
`t1_c19`,
`correct_relation_defaultlanguage`.`surveyls_attributecaptions` AS
`t1_c20`,
`correct_relation_defaultlanguage`.`email_admin_notification_subj` AS
`t1_c21`, `correct_relation_defaultlanguage`.`email_admin_notification`
AS `t1_c22`,
`correct_relation_defaultlanguage`.`email_admin_responses_subj` AS
`t1_c23`, `correct_relation_defaultlanguage`.`email_admin_responses` AS
`t1_c24`, `correct_relation_defaultlanguage`.`surveyls_numberformat` AS
`t1_c25`, `correct_relation_defaultlanguage`.`attachments` AS `t1_c26`,
`correct_relation_defaultlanguage`.`surveyls_alias` AS `t1_c27`,
`owner`.`uid` AS `t2_c0`, `owner`.`users_name` AS `t2_c1`,
`owner`.`password` AS `t2_c2`, `owner`.`full_name` AS `t2_c3`,
`owner`.`parent_id` AS `t2_c4`, `owner`.`lang` AS `t2_c5`,
`owner`.`email` AS `t2_c6`, `owner`.`htmleditormode` AS `t2_c7`,
`owner`.`templateeditormode` AS `t2_c8`, `owner`.`questionselectormode`
AS `t2_c9`, `owner`.`one_time_pw` AS `t2_c10`, `owner`.`dateformat` AS
`t2_c11`, `owner`.`created` AS `t2_c12`, `owner`.`modified` AS `t2_c13`,
`owner`.`last_login` AS `t2_c14`, `owner`.`validation_key` AS `t2_c15`,
`owner`.`validation_key_expiration` AS `t2_c16`,
`owner`.`last_forgot_email_password` AS `t2_c17`, `owner`.`expires` AS
`t2_c18`, `surveygroup`.`gsid` AS `t3_c0`, `surveygroup`.`name` AS
`t3_c1`, `surveygroup`.`title` AS `t3_c2`, `surveygroup`.`template` AS
`t3_c3`, `surveygroup`.`description` AS `t3_c4`,
`surveygroup`.`sortorder` AS `t3_c5`, `surveygroup`.`owner_id` AS
`t3_c6`, `surveygroup`.`parent_id` AS `t3_c7`, `surveygroup`.`created`
AS `t3_c8`, `surveygroup`.`modified` AS `t3_c9`,
`surveygroup`.`created_by` AS `t3_c10`, `surveygroup`.`alwaysavailable`
AS `t3_c11` FROM `lime_surveys` `t` LEFT OUTER JOIN
`lime_surveys_languagesettings` `correct_relation_defaultlanguage` ON
(`correct_relation_defaultlanguage`.`surveyls_language`=`t`.`language`)
AND (`correct_relation_defaultlanguage`.`surveyls_survey_id`=`t`.`sid`)
LEFT OUTER JOIN `lime_users` `owner` ON (`t`.`owner_id`=`owner`.`uid`)
LEFT OUTER JOIN `lime_surveys_groups` `surveygroup` ON
(`t`.`gsid`=`surveygroup`.`gsid`) ORDER BY t.datecreated desc LIMIT 10)</td>
<td align="center">1</td>
<td align="center">0.00046</td>
<td align="center">0.00046</td>
<td align="center">0.00046</td>
<td align="center">0.00046</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`)</td>
<td align="center">1</td>
<td align="center">0.00032</td>
<td align="center">0.00032</td>
<td align="center">0.00032</td>
<td align="center">0.00032</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE
(expires > :now OR expires IS NULL) AND (`t`.`uid`=1) LIMIT 1. Bound
with :now='2023-11-20 17:03:18')</td>
<td align="center">1</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
<td align="center">0.00012</td>
</tr> <tr style="background:#F5F5F5">
<td>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_policy_notice` AS `t1_c6`,
`defaultlanguage`.`surveyls_policy_error` AS `t1_c7`,
`defaultlanguage`.`surveyls_policy_notice_label` AS `t1_c8`,
`defaultlanguage`.`surveyls_url` AS `t1_c9`,
`defaultlanguage`.`surveyls_urldescription` AS `t1_c10`,
`defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c11`,
`defaultlanguage`.`surveyls_email_invite` AS `t1_c12`,
`defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c13`,
`defaultlanguage`.`surveyls_email_remind` AS `t1_c14`,
`defaultlanguage`.`surveyls_email_register_subj` AS `t1_c15`,
`defaultlanguage`.`surveyls_email_register` AS `t1_c16`,
`defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c17`,
`defaultlanguage`.`surveyls_email_confirm` AS `t1_c18`,
`defaultlanguage`.`surveyls_dateformat` AS `t1_c19`,
`defaultlanguage`.`surveyls_attributecaptions` AS `t1_c20`,
`defaultlanguage`.`email_admin_notification_subj` AS `t1_c21`,
`defaultlanguage`.`email_admin_notification` AS `t1_c22`,
`defaultlanguage`.`email_admin_responses_subj` AS `t1_c23`,
`defaultlanguage`.`email_admin_responses` AS `t1_c24`,
`defaultlanguage`.`surveyls_numberformat` AS `t1_c25`,
`defaultlanguage`.`attachments` AS `t1_c26`,
`defaultlanguage`.`surveyls_alias` AS `t1_c27` FROM
`lime_surveys_languagesettings` `defaultlanguage` WHERE
(`defaultlanguage`.`surveyls_language`=:ypl0) AND
(`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='fr',
:ypl1=33944)</td>
<td align="center">1</td>
<td align="center">0.00010</td>
<td align="center">0.00010</td>
<td align="center">0.00010</td>
<td align="center">0.00010</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT count(*)
FROM `lime_survey_33944`
WHERE submitdate IS NULL)</td>
<td align="center">1</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
<td align="center">0.00006</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`)</td>
<td align="center">1</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
<td align="center">0.00005</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t`
WHERE path = :path LIMIT 1. Bound with
:path='/media/shnoulle/data/webdev/master/vendor/yiisoft/yii/framework/zii/widgets/assets')</td>
<td align="center">1</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT count(*)
FROM `lime_survey_33944`
WHERE submitdate IS NOT NULL)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT count(*)
FROM `lime_survey_33944`)</td>
<td align="center">1</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
<td align="center">0.00003</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW TABLES)</td>
<td align="center">1</td>
<td align="center">0.00030</td>
<td align="center">0.00030</td>
<td align="center">0.00030</td>
<td align="center">0.00030</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=33944 LIMIT 1)</td>
<td align="center">1</td>
<td align="center">0.00009</td>
<td align="center">0.00009</td>
<td align="center">0.00009</td>
<td align="center">0.00009</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)</td>
<td align="center">1</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
<td align="center">0.00004</td>
</tr></tbody></table>
<!-- end of profiling summary -->
<div id="grammalecte_menu_main_button_shadow_host" style="width: 0px; height: 0px;"></div></body><script src="PHP%20error_fichiers/api.js"></script></html>
<!-- start profiling summary --> | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 6.3.6 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | mariadb | ||||
| Server OS (if known) | debian | ||||
| Webserver software & version (if known) | nginx | ||||
| PHP Version | 8.1.25 | ||||
 |
Cannot reproduce with attached lss using latest master (8226b41ece5e704aa5a980a25431daf5ad0313d5) with php 8.1 |
 |
Admin survey listing |
|
|
cannot reproduce on admin survey listing either |
|
|
It's really strange ;: if you check logic Then : if it's empty : you set null, and after Date(null) You activate debug mode to 2 ? |
|
|
yes, debug=2 |
|
|
oh, I got it you have to activate the survey for the error to show up |
|
|
I already fix it … |
|
|
|
|
|
Tested and merged. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-11-20 17:08 | DenisChenu | New Issue | |
| 2023-11-20 17:08 | DenisChenu | File Added: limesurvey_survey_391583.lss | |
| 2023-11-20 17:08 | DenisChenu | File Added: PHP error.html | |
| 2023-11-21 09:38 | mfavetti | Note Added: 78556 | |
| 2023-11-21 09:38 | mfavetti | File Added: LimeSurvey - Google Chrome 2023-11-21 00-35-28-converted.mp4 | |
| 2023-11-21 09:38 | mfavetti | Bug heat | 0 => 2 |
| 2023-11-21 09:39 | DenisChenu | Note Added: 78557 | |
| 2023-11-21 09:39 | DenisChenu | Bug heat | 2 => 4 |
| 2023-11-21 09:40 | DenisChenu | Description Updated | |
| 2023-11-21 09:40 | DenisChenu | Steps to Reproduce Updated | |
| 2023-11-21 09:57 | mfavetti | Note Added: 78560 | |
| 2023-11-21 09:57 | mfavetti | File Added: LimeSurvey - Google Chrome 2023-11-21 00-55-46-converted.mp4 | |
| 2023-11-21 10:52 | DenisChenu | Note Added: 78564 | |
| 2023-11-21 10:53 | DenisChenu | Summary | PHP8.1 + debug : survey with only stardate broke survey listing => PHP8.1 + debug=2 : survey with only stardate broke survey listing |
| 2023-11-21 10:53 | DenisChenu | Description Updated | |
| 2023-11-21 10:53 | DenisChenu | Steps to Reproduce Updated | |
| 2023-11-21 11:18 | mfavetti | Note Added: 78567 | |
| 2023-11-21 11:18 | mfavetti | Note Added: 78568 | |
| 2023-11-21 11:30 | mfavetti | Assigned To | => mfavetti |
| 2023-11-21 11:30 | mfavetti | Status | new => assigned |
| 2023-11-21 11:30 | DenisChenu | Note Added: 78572 | |
| 2023-11-21 11:30 | DenisChenu | Assigned To | mfavetti => DenisChenu |
| 2023-11-21 11:39 | DenisChenu | Assigned To | DenisChenu => mfavetti |
| 2023-11-21 11:39 | DenisChenu | Status | assigned => ready for code review |
| 2023-11-21 11:39 | DenisChenu | Note Added: 78574 | |
| 2023-11-21 11:39 | DenisChenu | Steps to Reproduce Updated | |
| 2023-11-24 16:38 | gabrieljenik | Assigned To | mfavetti => tibor.pacalat |
| 2023-11-24 16:38 | gabrieljenik | Status | ready for code review => ready for testing |
| 2023-11-27 17:30 | tibor.pacalat | Status | ready for testing => resolved |
| 2023-11-27 17:30 | tibor.pacalat | Resolution | open => fixed |
| 2023-11-27 17:30 | tibor.pacalat | Note Added: 78748 | |
| 2023-11-27 17:30 | tibor.pacalat | Bug heat | 4 => 6 |
| 2023-11-27 17:30 | tibor.pacalat | Note Edited: 78748 |
