View Issue Details

This issue affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
18418Bug reportsSurvey editingpublic2022-10-18 15:23
Reporternoxinmortus Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionno change required 
Product Version3.28.x 
Summary18418: 500: internal server error CDbCommand failed to execute the SQL statement + partially broken HTML in activate screen
Description

Hello,

The error is occuring since version 3.16.1+190314 and we are currently running 3.28.32+221011

Trying to enable a inactive survey occurs in a 500: Internal server error.

We managed to bypass this error by setting the following configuration on mariadb :

sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

Steps To Reproduce

Steps to reproduce:

  • as an administrator, go to LimeSurvey, list of surveys
  • choose any currently inactive survey
  • click on Activate this survey
  • on the next screen, click on Save & activate survey

Expected result:

the survey is activated

Actual result:

500: internal server error CDbCommand failed to execute the SQL statement (see picture for full error)

TagsNo tags attached.
Attached Files
limesurveybug.png (63,981 bytes)   
limesurveybug.png (63,981 bytes)   
Bug heat6
Complete LimeSurvey version number (& build)3.28.32+221011
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMariaDB 10.5.17
Server OS (if known)Debian 11
Webserver software & version (if known)Apache2
PHP VersionPHP 7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-10-17 10:54

developer   ~72272

Please : debug mode : https://manual.limesurvey.org/Debug_mode

And save it as HTML
Then we have where this instruction is called.

noxinmortus

noxinmortus

2022-10-17 11:10

reporter   ~72273

Hello DenisChenu, here is the full exception:

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'anonymized' cannot be null. The SQL statement executed was: UPDATE `ls_surveys` SET `htmlemail`=:yp0, `format`=:yp1, `template`=:yp2, `language`=:yp3, `owner_id`=:yp4, `admin`=:yp5, `adminemail`=:yp6, `sid`=:yp7, `gsid`=:yp8, `active`=:yp9, `expires`=:yp10, `startdate`=:yp11, `anonymized`=:yp12, `faxto`=:yp13, `savetimings`=:yp14, `additional_languages`=:yp15, `datestamp`=:yp16, `usecookie`=:yp17, `allowregister`=:yp18, `allowsave`=:yp19, `autonumber_start`=:yp20, `autoredirect`=:yp21, `allowprev`=:yp22, `printanswers`=:yp23, `ipaddr`=:yp24, `refurl`=:yp25, `datecreated`=:yp26, `publicstatistics`=:yp27, `publicgraphs`=:yp28, `listpublic`=:yp29, `sendconfirmation`=:yp30, `tokenanswerspersistence`=:yp31, `assessments`=:yp32, `usecaptcha`=:yp33, `usetokens`=:yp34, `bounce_email`=:yp35, `attributedescriptions`=:yp36, `emailresponseto`=:yp37, `emailnotificationto`=:yp38, `tokenlength`=:yp39, `showxquestions`=:yp40, `showgroupinfo`=:yp41, `shownoanswer`=:yp42, `showqnumcode`=:yp43, `bouncetime`=:yp44, `bounceprocessing`=:yp45, `bounceaccounttype`=:yp46, `bounceaccounthost`=:yp47, `bounceaccountpass`=:yp48, `bounceaccountencryption`=:yp49, `bounceaccountuser`=:yp50, `showwelcome`=:yp51, `showprogress`=:yp52, `questionindex`=:yp53, `navigationdelay`=:yp54, `nokeyboard`=:yp55, `alloweditaftercompletion`=:yp56, `googleanalyticsstyle`=:yp57, `googleanalyticsapikey`=:yp58, `showsurveypolicynotice`=:yp59 WHERE `ls_surveys`.`sid`=72986 
DenisChenu

DenisChenu

2022-10-17 11:14

developer   ~72275

Thank you, more clear now.

Can you check if you have this dropdown on the activate screen ?

noxinmortus

noxinmortus

2022-10-17 11:21

reporter   ~72276

There is a line "Responses to this survey are anonymized." but not a dropbox

noxinmortus

noxinmortus

2022-10-17 11:25

reporter   ~72277

bad page, but the dropbox appear to be missing!

DenisChenu

DenisChenu

2022-10-17 11:28

developer   ~72278

Seems you have some update on your instance …

Admin theme update only (the it can be a LimeSUrvey issue) ?
Can you set Admin theme /index.php?r=admin/themeoptions#adminthemes to a core included theme ?
If it's already Sea Green or Noto All languages : we can not fix hacked version of LimeSUrvey.

DenisChenu

DenisChenu

2022-10-17 11:29

developer   ~72279

Hacked admin theme OR hacked LimeSurvey version

or plugin ? : can you show the list of plugins ?

DenisChenu

DenisChenu

2022-10-17 11:31

developer   ~72280

PS : you lost ALL of this dropdown

noxinmortus

noxinmortus

2022-10-17 11:39

reporter   ~72281

It is Sea Green indeed

What do you mean "you have some update on your instance" ?

For more context I got this LS instance recently, and it has been configured a long time before me. How can I check if the theme was hacked ?
Plugins in screenshot

image.png (51,964 bytes)   
image.png (51,964 bytes)   
image-2.png (109,116 bytes)
DenisChenu

DenisChenu

2022-10-17 12:04

developer   ~72282

For more context I got this LS instance recently, and it has been configured a long time before me. How can I check if the theme was hacked ?

Try another one ?

LimeSurvey code hacked

Maybe :

  • rename current limesurvey directory
  • download clean zip version on https://community.limesurvey.org/downloads/ THE LTS Release 3.28.32 NOT Release 5.4.5
  • extract on previous directory
  • copy from old dir : application/config/config.php
  • copy from old dir : /upload/* EXCEPT /upload/admintheme
noxinmortus

noxinmortus

2022-10-17 12:27

reporter   ~72283

I tried

  • rename current limesurvey directory
  • download clean zip version on https://community.limesurvey.org/downloads/ THE LTS Release 3.28.32 NOT Release 5.4.5
  • extract on previous directory
  • copy from old dir : application/config/config.php
  • copy from old dir : /upload/* EXCEPT /upload/admintheme

but did not change anything. I checked the current upload/admintheme and it is empty except for a index.php which remains the same file than the official release.

I tried to select the them Purple Tentacle mais same issue occurs

DenisChenu

DenisChenu

2022-10-17 12:30

developer   ~72284

I can not confirm the issue about partial hidden part in this view … really strange …

noxinmortus

noxinmortus

2022-10-17 12:36

reporter   ~72285

Here are the console errors from Firefox of the "Activate survey" page, maybe it can help in some way ?

12:32:25.116 InstallTrigger is deprecated and will be removed in the future. constants.js:50:14
12:32:26.263 This page uses the non standard property “zoom”. Consider using calc() in the relevant property values, or using “transform” along with “transform-origin: 0 0”. 72986
12:32:26.332 JQMIGRATE: Migrate is installed with logging active, version 3.3.2 jquery-migrate-3.3.2.js:69:17
12:32:26.414 AdminCore appendToLoad 
Object { type: "function", fn: onLoadRegister()
 }
adminbasics.js:28105:23
12:32:26.415 JQMIGRATE: 'ready' event is deprecated jquery-migrate-3.3.2.js:100:12
12:32:26.415 console.trace() jquery-migrate-3.3.2.js:102:13
    jQuery 9
    appendToLoad https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:38899
    onLoadRegister https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:38851
    AdminCore https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:38975
    <anonymous> https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:38979
    <anonymous> https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:3
    <anonymous> https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:4
12:32:26.416 AdminCore appendToLoad 
Object { type: "function", fn: onLoadRegister()
 }
adminbasics.js:28105:23
12:32:26.417 AdminCore appendToLoad 
Object { type: "function", fn: SaveController()
 }
adminbasics.js:28105:23
12:32:26.418 AdminCore appendToLoad 
Object { type: "function", fn: loadMethods()
 }
adminbasics.js:28105:23
12:32:26.419 AdminCore appendToLoad 
Object { type: "function", fn: bindAdvancedAttribute()
 }
adminbasics.js:28105:23
12:32:26.420 AdminCore appendToLoad 
Object { type: "function", fn: confirmDeletemodal()
 }
adminbasics.js:28105:23
12:32:26.420 AdminCore appendToLoad 
Object { type: "function", fn: panelClickable()
 }
adminbasics.js:28105:23
12:32:26.421 AdminCore appendToLoad 
Object { type: "function", fn: panelsAnimation()
 }
adminbasics.js:28105:23
12:32:26.422 AdminCore appendToLoad 
Object { type: "function", fn: initNotification()
 }
adminbasics.js:28105:23
12:32:26.423 AdminCore appendToLoad 
Object { type: "function", fn: activateSubSubMenues()
 }
adminbasics.js:28105:23
12:32:26.424 AdminCore appendToLoad 
Object { type: "function", fn: fixAccordionPosition()
 }
adminbasics.js:28105:23
12:32:26.425 AdminCore AdminCore 
Object { document: (11) […] }
adminbasics.js:28105:23
12:32:26.489 JQMIGRATE: jQuery.fn.submit() event shorthand is deprecated jquery-migrate-3.3.2.js:100:12
12:32:26.489 console.trace() jquery-migrate-3.3.2.js:102:13
    jQuery 2
    <anonymous> surveysettings.js:1
    js adminsidepanel.js:818
    __webpack_require__ adminsidepanel.js:726
    fn adminsidepanel.js:101
    0 adminsidepanel.js:3718
    __webpack_require__ adminsidepanel.js:726
    <anonymous> adminsidepanel.js:793
    <anonymous> adminsidepanel.js:796
12:32:26.799 JQMIGRATE: jQuery.isFunction() is deprecated jquery-migrate-3.3.2.js:100:12
12:32:26.800 console.trace() jquery-migrate-3.3.2.js:102:13
    jQuery 2
    init https://limesurvey.dev.ow2.org/assets/packages/bootstrap/bootstrap.js:1472
    Tooltip https://limesurvey.dev.ow2.org/assets/packages/bootstrap/bootstrap.js:1441
    Plugin https://limesurvey.dev.ow2.org/assets/packages/bootstrap/bootstrap.js:1943
    jQuery 2
    Plugin https://limesurvey.dev.ow2.org/assets/packages/bootstrap/bootstrap.js:1937
    <anonymous> https://limesurvey.dev.ow2.org/index.php/admin/survey/sa/activate/surveyid/72986:495
12:32:26.878 Download the Vue Devtools extension for a better development experience:
https://github.com/vuejs/vue-devtools adminbasics.js:38743:49
12:32:26.878 You are running Vue in development mode.
Make sure to turn on production mode when deploying for production.
See more tips at https://vuejs.org/guide/deployment.html adminbasics.js:38753:47
12:32:26.879 You are running Vue in development mode.
Make sure to turn on production mode when deploying for production.
See more tips at https://vuejs.org/guide/deployment.html vue.esm.js:9088
12:32:26.880 AdminCore TRIGGERWARNING Document ready triggered adminbasics.js:28105:23
12:32:26.882 AdminCore saveBindings 
Object { check: "[data-submit-form]", run: run(ev)
, on: "click" }

Object { length: 0, prevObject: {…} }
adminbasics.js:28105:23
12:32:26.884 AdminCore saveBindings 
Object { check: "#save-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.885 AdminCore saveBindings 
Object { check: "#save-form-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.887 AdminCore saveBindings 
Object { check: "#save-and-new-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.888 AdminCore saveBindings 
Object { check: "#save-and-close-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.889 AdminCore saveBindings 
Object { check: "#save-and-close-form-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.890 AdminCore saveBindings 
Object { check: "#save-and-new-question-button", run: run(ev)
, on: "click" }

Object {  }
adminbasics.js:28105:23
12:32:26.891 AdminCore saveBindings 
Object { check: ".open-preview", run: run(ev)
, on: "click" }

Object { length: 0, prevObject: {…} }
adminbasics.js:28105:23
12:32:26.893 AdminCore saveBindings 
Object { check: "#in_survey_common", run: run(ev)
, on: "lsStopLoading" }

Object { 0: div#in_survey_common.container-fluid.ls-flex-column.fill.col-12.overflow-enabled
, length: 1 }
adminbasics.js:28105:23
12:32:26.894 AdminCore 
Object { 0: div#in_survey_common.container-fluid.ls-flex-column.fill.col-12.overflow-enabled
, length: 1 }
 on lsStopLoading run 
function run(ev)
adminbasics.js:28105:23
12:32:26.896 AdminCore ConfirmationModal calling adminbasics.js:28105:23
12:32:26.897 JQMIGRATE: jQuery.fn.click() event shorthand is deprecated jquery-migrate-3.3.2.js:100:12
12:32:26.897 console.trace() jquery-migrate-3.3.2.js:102:13
    jQuery 2
    bindAdvancedAttribute https://limesurvey.dev.ow2.org/assets/packages/adminbasics/build/adminbasics.js:27943
    jQuery 18
12:32:27.011 PJAX options 
Object { elements: (2) […], selectors: (4) […], debug: false, forceRedirectOnFail: true, reRenderCSS: true, scriptloadtimeout: 1500, mainScriptElement: "head", removeScriptsAfterParsing: true, logObject: Console, latestChance: null, … }
pjax.js:365:13
12:32:27.503 Source map error: Error: request failed with status 401
Resource URL: https://limesurvey.dev.ow2.org/assets/packages/pjax/pjax.js
Source Map URL: pjax.js.map

12:32:27.686 AdminCore Triggering panel animation adminbasics.js:28105:23
noxinmortus

noxinmortus

2022-10-17 12:40

reporter   ~72286

I think I found it...

<div class="form-group">
                    <label for="anonymized" class="control-label col-sm-7">
                        Anonymized responses?                        <!--
                        <script type="text/javascript">
                        -->
                            <!--
                            function alertPrivacy()
                            {
                                if (document.getElementById('anonymized').value == 'Y')
                                {
                                    alert('Warning: If you turn on the -Anonymized responses- option and create a tokens table, LimeSurvey will mark your completed tokens only with a \'Y\' instead of date/time to ensure the anonymity of your participants.');
                                }
                            }
                            //-->
                        <!--
                        </script>
                        -->
                    </label>

                    <div class="col-sm-5">
                      <!--
                        <select id='anonymized' class='form-control' name='anonymized' onchange='alertPrivacy();'>
                            <option value='Y'
                                                            >Yes</option>
                                <option value='N'
                                                                    selected='selected'
                                                                        >No</option>
                        </select>
                      -->
                    </div>
                </div>

I don't think this block should be commented

DenisChenu

DenisChenu

2022-10-17 16:05

developer   ~72294

@gabrieljenik any idea here ?

I can not reproduce on my part …
The HTML issue, the other one is easy to fix (2 way to fix it).

gabrieljenik

gabrieljenik

2022-10-17 16:26

manager   ~72298

I believe the HTML issue is creating the error on the DB Query.

Can you activate debug mode before loading the "Activate survey" screen you showed us here: https://bugs.limesurvey.org/view.php?id=18418#c72277
I want to be able to catch some problem in that screen.

Also, can you try with a chrome browser as well?

Thanks

Thanks

DenisChenu

DenisChenu

2022-10-17 16:27

developer   ~72299

I believe the HTML issue is creating the error on the DB Query.

Yes, evident … but we can fix it even if browser broken …

noxinmortus

noxinmortus

2022-10-18 09:36

reporter   ~72313

Hello back DenisChenu, gabrieljenik, here is the html export of the Activate survey screen with debug and sql debug enabled

CDbException_with_sql_debug.html (62,394 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" class=" rtzckgdk idc0_343" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>CDbException</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>
<style>.spantree-toggler {
  position: fixed;
  padding: 4px 8px;
  top: 40%;
  transform: rotate(-90deg);
  transform-origin: top left;
  border-radius: 0px 0px 4px 4px;
  cursor: pointer;
  z-index: 10;
  box-shadow: 0px 0px 5px #000000d9;
  color: white;
  background: rgb(77, 61, 146);
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29tcG9uZW50cy9Ub2dnbGVyL3N0eWxlcy5jc3MiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6IkFBQUE7RUFDRSxlQUFlO0VBQ2YsZ0JBQWdCO0VBQ2hCLFFBQVE7RUFDUix5QkFBeUI7RUFDekIsMEJBQTBCO0VBQzFCLDhCQUE4QjtFQUM5QixlQUFlO0VBQ2YsV0FBVztFQUNYLGlDQUFpQztFQUNqQyxZQUFZO0VBQ1osNEJBQTRCO0FBQzlCIiwic291cmNlc0NvbnRlbnQiOlsiLnNwYW50cmVlLXRvZ2dsZXIge1xuICBwb3NpdGlvbjogZml4ZWQ7XG4gIHBhZGRpbmc6IDRweCA4cHg7XG4gIHRvcDogNDAlO1xuICB0cmFuc2Zvcm06IHJvdGF0ZSgtOTBkZWcpO1xuICB0cmFuc2Zvcm0tb3JpZ2luOiB0b3AgbGVmdDtcbiAgYm9yZGVyLXJhZGl1czogMHB4IDBweCA0cHggNHB4O1xuICBjdXJzb3I6IHBvaW50ZXI7XG4gIHotaW5kZXg6IDEwO1xuICBib3gtc2hhZG93OiAwcHggMHB4IDVweCAjMDAwMDAwZDk7XG4gIGNvbG9yOiB3aGl0ZTtcbiAgYmFja2dyb3VuZDogcmdiKDc3LCA2MSwgMTQ2KTtcbn1cbiJdLCJzb3VyY2VSb290IjoiIn0= */</style><style>.spantree-loader {
  border-color: #f3f3f3;
  border-radius: 50%;
  border-style: solid;
  border-top-color: rgb(237, 153, 44);
  -webkit-animation: spantree-loader-spin 2s linear infinite; /* Safari */
  animation: spantree-loader-spin 2s linear infinite;
}

/* Safari */
@-webkit-keyframes spantree-loader-spin {
  0% {
    -webkit-transform: rotate(0deg);
  }
  100% {
    -webkit-transform: rotate(360deg);
  }
}

@keyframes spantree-loader-spin {
  0% {
    transform: rotate(0deg);
  }
  100% {
    transform: rotate(360deg);
  }
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29tcG9uZW50cy9Mb2FkZXIvc3R5bGVzLmNzcyJdLCJuYW1lcyI6W10sIm1hcHBpbmdzIjoiQUFBQTtFQUNFLHFCQUFxQjtFQUNyQixrQkFBa0I7RUFDbEIsbUJBQW1CO0VBQ25CLG1DQUFtQztFQUNuQywwREFBMEQsRUFBRSxXQUFXO0VBQ3ZFLGtEQUFrRDtBQUNwRDs7QUFFQSxXQUFXO0FBQ1g7RUFDRTtJQUNFLCtCQUErQjtFQUNqQztFQUNBO0lBQ0UsaUNBQWlDO0VBQ25DO0FBQ0Y7O0FBRUE7RUFDRTtJQUNFLHVCQUF1QjtFQUN6QjtFQUNBO0lBQ0UseUJBQXlCO0VBQzNCO0FBQ0YiLCJzb3VyY2VzQ29udGVudCI6WyIuc3BhbnRyZWUtbG9hZGVyIHtcbiAgYm9yZGVyLWNvbG9yOiAjZjNmM2YzO1xuICBib3JkZXItcmFkaXVzOiA1MCU7XG4gIGJvcmRlci1zdHlsZTogc29saWQ7XG4gIGJvcmRlci10b3AtY29sb3I6IHJnYigyMzcsIDE1MywgNDQpO1xuICAtd2Via2l0LWFuaW1hdGlvbjogc3BhbnRyZWUtbG9hZGVyLXNwaW4gMnMgbGluZWFyIGluZmluaXRlOyAvKiBTYWZhcmkgKi9cbiAgYW5pbWF0aW9uOiBzcGFudHJlZS1sb2FkZXItc3BpbiAycyBsaW5lYXIgaW5maW5pdGU7XG59XG5cbi8qIFNhZmFyaSAqL1xuQC13ZWJraXQta2V5ZnJhbWVzIHNwYW50cmVlLWxvYWRlci1zcGluIHtcbiAgMCUge1xuICAgIC13ZWJraXQtdHJhbnNmb3JtOiByb3RhdGUoMGRlZyk7XG4gIH1cbiAgMTAwJSB7XG4gICAgLXdlYmtpdC10cmFuc2Zvcm06IHJvdGF0ZSgzNjBkZWcpO1xuICB9XG59XG5cbkBrZXlmcmFtZXMgc3BhbnRyZWUtbG9hZGVyLXNwaW4ge1xuICAwJSB7XG4gICAgdHJhbnNmb3JtOiByb3RhdGUoMGRlZyk7XG4gIH1cbiAgMTAwJSB7XG4gICAgdHJhbnNmb3JtOiByb3RhdGUoMzYwZGVnKTtcbiAgfVxufVxuIl0sInNvdXJjZVJvb3QiOiIifQ== */</style><style>.spantree-tree-element {
  padding: 2px 15px 2px 0px;
  display: flex;
  height: 24px;
  align-items: center;
  width: max-content;
}

.spantree-child-list {
  list-style-type: none;
  padding: 0px 0px 0px 20px;
}

.spantree-tree-icon {
  width: 16px;
  text-align: center;
  margin-right: 2px;
  padding-bottom: 2px;
}

.spantree-file-icon {
  width: 22px;
  text-align: left;
}

.spantree-file-icon i {
  font-style: normal;
}

.spantree-item-name {
  width: max-content;
}

.spantree-arrow {
  font-style: normal;
}

.spantree-full-width-row {
  position: absolute;
  height: 24px;
  width: 100%;
  left: 0px;
  z-index: 5;
  opacity: 25%;
  background: transparent;
  transition: 0.2s background;
  box-sizing: border-box;
}

.spantree-full-width-row:hover {
  background: #6464ff;
  cursor: pointer;
}

.spantree-full-width-row:active {
  background: blue;
}

.spantree-active-row {
  border: 3px solid black;
  background: darkslategrey;
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29tcG9uZW50cy9UcmVlSXRlbS9zdHlsZXMuY3NzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBO0VBQ0UseUJBQXlCO0VBQ3pCLGFBQWE7RUFDYixZQUFZO0VBQ1osbUJBQW1CO0VBQ25CLGtCQUFrQjtBQUNwQjs7QUFFQTtFQUNFLHFCQUFxQjtFQUNyQix5QkFBeUI7QUFDM0I7O0FBRUE7RUFDRSxXQUFXO0VBQ1gsa0JBQWtCO0VBQ2xCLGlCQUFpQjtFQUNqQixtQkFBbUI7QUFDckI7O0FBRUE7RUFDRSxXQUFXO0VBQ1gsZ0JBQWdCO0FBQ2xCOztBQUVBO0VBQ0Usa0JBQWtCO0FBQ3BCOztBQUVBO0VBQ0Usa0JBQWtCO0FBQ3BCOztBQUVBO0VBQ0Usa0JBQWtCO0FBQ3BCOztBQUVBO0VBQ0Usa0JBQWtCO0VBQ2xCLFlBQVk7RUFDWixXQUFXO0VBQ1gsU0FBUztFQUNULFVBQVU7RUFDVixZQUFZO0VBQ1osdUJBQXVCO0VBQ3ZCLDJCQUEyQjtFQUMzQixzQkFBc0I7QUFDeEI7O0FBRUE7RUFDRSxtQkFBbUI7RUFDbkIsZUFBZTtBQUNqQjs7QUFFQTtFQUNFLGdCQUFnQjtBQUNsQjs7QUFFQTtFQUNFLHVCQUF1QjtFQUN2Qix5QkFBeUI7QUFDM0IiLCJzb3VyY2VzQ29udGVudCI6WyIuc3BhbnRyZWUtdHJlZS1lbGVtZW50IHtcbiAgcGFkZGluZzogMnB4IDE1cHggMnB4IDBweDtcbiAgZGlzcGxheTogZmxleDtcbiAgaGVpZ2h0OiAyNHB4O1xuICBhbGlnbi1pdGVtczogY2VudGVyO1xuICB3aWR0aDogbWF4LWNvbnRlbnQ7XG59XG5cbi5zcGFudHJlZS1jaGlsZC1saXN0IHtcbiAgbGlzdC1zdHlsZS10eXBlOiBub25lO1xuICBwYWRkaW5nOiAwcHggMHB4IDBweCAyMHB4O1xufVxuXG4uc3BhbnRyZWUtdHJlZS1pY29uIHtcbiAgd2lkdGg6IDE2cHg7XG4gIHRleHQtYWxpZ246IGNlbnRlcjtcbiAgbWFyZ2luLXJpZ2h0OiAycHg7XG4gIHBhZGRpbmctYm90dG9tOiAycHg7XG59XG5cbi5zcGFudHJlZS1maWxlLWljb24ge1xuICB3aWR0aDogMjJweDtcbiAgdGV4dC1hbGlnbjogbGVmdDtcbn1cblxuLnNwYW50cmVlLWZpbGUtaWNvbiBpIHtcbiAgZm9udC1zdHlsZTogbm9ybWFsO1xufVxuXG4uc3BhbnRyZWUtaXRlbS1uYW1lIHtcbiAgd2lkdGg6IG1heC1jb250ZW50O1xufVxuXG4uc3BhbnRyZWUtYXJyb3cge1xuICBmb250LXN0eWxlOiBub3JtYWw7XG59XG5cbi5zcGFudHJlZS1mdWxsLXdpZHRoLXJvdyB7XG4gIHBvc2l0aW9uOiBhYnNvbHV0ZTtcbiAgaGVpZ2h0OiAyNHB4O1xuICB3aWR0aDogMTAwJTtcbiAgbGVmdDogMHB4O1xuICB6LWluZGV4OiA1O1xuICBvcGFjaXR5OiAyNSU7XG4gIGJhY2tncm91bmQ6IHRyYW5zcGFyZW50O1xuICB0cmFuc2l0aW9uOiAwLjJzIGJhY2tncm91bmQ7XG4gIGJveC1zaXppbmc6IGJvcmRlci1ib3g7XG59XG5cbi5zcGFudHJlZS1mdWxsLXdpZHRoLXJvdzpob3ZlciB7XG4gIGJhY2tncm91bmQ6ICM2NDY0ZmY7XG4gIGN1cnNvcjogcG9pbnRlcjtcbn1cblxuLnNwYW50cmVlLWZ1bGwtd2lkdGgtcm93OmFjdGl2ZSB7XG4gIGJhY2tncm91bmQ6IGJsdWU7XG59XG5cbi5zcGFudHJlZS1hY3RpdmUtcm93IHtcbiAgYm9yZGVyOiAzcHggc29saWQgYmxhY2s7XG4gIGJhY2tncm91bmQ6IGRhcmtzbGF0ZWdyZXk7XG59XG4iXSwic291cmNlUm9vdCI6IiJ9 */</style><style>.spantree-loader-wrapper {
  height: 100%;
  display: flex;
  justify-content: center;
  align-content: center;
  align-items: center;
}

.spantree-tree-list {
  scroll-behavior: smooth;
  overflow-y: auto;
  height: calc(100vh - 40px);
}

.spantree-tree-list::-webkit-scrollbar-track {
  background-color: #c9c9c9;
}

.spantree-tree-list::-webkit-scrollbar-corner {
  background-color: #c9c9c9;
}

.spantree-tree-list::-webkit-scrollbar {
  width: 8px;
  height: 8px;
}

.spantree-tree-list::-webkit-scrollbar-thumb {
  border-radius: 10px;
  -webkit-box-shadow: inset 0 0 6px rgba(0, 0, 0, 0.3);
  background-color: rgba(0, 0, 0, 0.5);
}

.spantree-parent-list {
  font-size: 0.875rem;
  padding: 0px 0px 0px 5px;
  list-style-type: none;
  width: max-content;
  min-width: 100%;
  position: relative;
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29udGFpbmVycy9UcmVlTGlzdC9zdHlsZXMuY3NzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBO0VBQ0UsWUFBWTtFQUNaLGFBQWE7RUFDYix1QkFBdUI7RUFDdkIscUJBQXFCO0VBQ3JCLG1CQUFtQjtBQUNyQjs7QUFFQTtFQUNFLHVCQUF1QjtFQUN2QixnQkFBZ0I7RUFDaEIsMEJBQTBCO0FBQzVCOztBQUVBO0VBQ0UseUJBQXlCO0FBQzNCOztBQUVBO0VBQ0UseUJBQXlCO0FBQzNCOztBQUVBO0VBQ0UsVUFBVTtFQUNWLFdBQVc7QUFDYjs7QUFFQTtFQUNFLG1CQUFtQjtFQUNuQixvREFBb0Q7RUFDcEQsb0NBQW9DO0FBQ3RDOztBQUVBO0VBQ0UsbUJBQW1CO0VBQ25CLHdCQUF3QjtFQUN4QixxQkFBcUI7RUFDckIsa0JBQWtCO0VBQ2xCLGVBQWU7RUFDZixrQkFBa0I7QUFDcEIiLCJzb3VyY2VzQ29udGVudCI6WyIuc3BhbnRyZWUtbG9hZGVyLXdyYXBwZXIge1xuICBoZWlnaHQ6IDEwMCU7XG4gIGRpc3BsYXk6IGZsZXg7XG4gIGp1c3RpZnktY29udGVudDogY2VudGVyO1xuICBhbGlnbi1jb250ZW50OiBjZW50ZXI7XG4gIGFsaWduLWl0ZW1zOiBjZW50ZXI7XG59XG5cbi5zcGFudHJlZS10cmVlLWxpc3Qge1xuICBzY3JvbGwtYmVoYXZpb3I6IHNtb290aDtcbiAgb3ZlcmZsb3cteTogYXV0bztcbiAgaGVpZ2h0OiBjYWxjKDEwMHZoIC0gNDBweCk7XG59XG5cbi5zcGFudHJlZS10cmVlLWxpc3Q6Oi13ZWJraXQtc2Nyb2xsYmFyLXRyYWNrIHtcbiAgYmFja2dyb3VuZC1jb2xvcjogI2M5YzljOTtcbn1cblxuLnNwYW50cmVlLXRyZWUtbGlzdDo6LXdlYmtpdC1zY3JvbGxiYXItY29ybmVyIHtcbiAgYmFja2dyb3VuZC1jb2xvcjogI2M5YzljOTtcbn1cblxuLnNwYW50cmVlLXRyZWUtbGlzdDo6LXdlYmtpdC1zY3JvbGxiYXIge1xuICB3aWR0aDogOHB4O1xuICBoZWlnaHQ6IDhweDtcbn1cblxuLnNwYW50cmVlLXRyZWUtbGlzdDo6LXdlYmtpdC1zY3JvbGxiYXItdGh1bWIge1xuICBib3JkZXItcmFkaXVzOiAxMHB4O1xuICAtd2Via2l0LWJveC1zaGFkb3c6IGluc2V0IDAgMCA2cHggcmdiYSgwLCAwLCAwLCAwLjMpO1xuICBiYWNrZ3JvdW5kLWNvbG9yOiByZ2JhKDAsIDAsIDAsIDAuNSk7XG59XG5cbi5zcGFudHJlZS1wYXJlbnQtbGlzdCB7XG4gIGZvbnQtc2l6ZTogMC44NzVyZW07XG4gIHBhZGRpbmc6IDBweCAwcHggMHB4IDVweDtcbiAgbGlzdC1zdHlsZS10eXBlOiBub25lO1xuICB3aWR0aDogbWF4LWNvbnRlbnQ7XG4gIG1pbi13aWR0aDogMTAwJTtcbiAgcG9zaXRpb246IHJlbGF0aXZlO1xufVxuIl0sInNvdXJjZVJvb3QiOiIifQ== */</style><style>.spantree-resizer {
  /*background: red;*/
  width: 8px;
  position: relative;
  opacity: 100%;
}

.spantree-resizer:hover {
  cursor: col-resize;
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29udGFpbmVycy9SZXNpemVyL3N0eWxlcy5jc3MiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6IkFBQUE7RUFDRSxtQkFBbUI7RUFDbkIsVUFBVTtFQUNWLGtCQUFrQjtFQUNsQixhQUFhO0FBQ2Y7O0FBRUE7RUFDRSxrQkFBa0I7QUFDcEIiLCJzb3VyY2VzQ29udGVudCI6WyIuc3BhbnRyZWUtcmVzaXplciB7XG4gIC8qYmFja2dyb3VuZDogcmVkOyovXG4gIHdpZHRoOiA4cHg7XG4gIHBvc2l0aW9uOiByZWxhdGl2ZTtcbiAgb3BhY2l0eTogMTAwJTtcbn1cblxuLnNwYW50cmVlLXJlc2l6ZXI6aG92ZXIge1xuICBjdXJzb3I6IGNvbC1yZXNpemU7XG59XG4iXSwic291cmNlUm9vdCI6IiJ9 */</style><style>.spantree-tree-pane {
  position: fixed;
  display: flex;
  box-sizing: border-box;
  height: 100%;
  right: 0px !important;
  top: 0px !important;
  bottom: 0px !important;
  left: 0px !important;
  font-size: 0.8em;
  z-index: 1000;
  transform: translate3d(0px, 0px, 0px);
  transition: transform 0.2s ease 0s;
  box-shadow: 2px 0px 8px #00000070;
}

.spantree-pane-main {
  height: 100%;
  width: 100%;
  position: absolute;
}

.spantree-pane-header {
  height: 40px;
  background-color: rgb(77, 61, 146);
  border-bottom: 1px #404040 solid;
  color: white;
  padding: 5px;
  display: flex;
  flex-direction: column;
  justify-content: space-around;
}

.spantree-close-button {
  cursor: pointer;
  margin: 0 4px;
}

.spantree-spread {
  display: flex;
  justify-content: space-between;
}

.spantree-tree-body {
  height: 100%;
  width: 100%;
}

.spantree-pane-details {
  display: inline-block;
  overflow: hidden;
  white-space: nowrap;
  text-overflow: ellipsis;
  font-weight: bold;
}

.spantree-pane-icons {
  min-width: 35px;
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29tcG9uZW50cy9QYW5lL3N0eWxlcy5jc3MiXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6IkFBQUE7RUFDRSxlQUFlO0VBQ2YsYUFBYTtFQUNiLHNCQUFzQjtFQUN0QixZQUFZO0VBQ1oscUJBQXFCO0VBQ3JCLG1CQUFtQjtFQUNuQixzQkFBc0I7RUFDdEIsb0JBQW9CO0VBQ3BCLGdCQUFnQjtFQUNoQixhQUFhO0VBQ2IscUNBQXFDO0VBQ3JDLGtDQUFrQztFQUNsQyxpQ0FBaUM7QUFDbkM7O0FBRUE7RUFDRSxZQUFZO0VBQ1osV0FBVztFQUNYLGtCQUFrQjtBQUNwQjs7QUFFQTtFQUNFLFlBQVk7RUFDWixrQ0FBa0M7RUFDbEMsZ0NBQWdDO0VBQ2hDLFlBQVk7RUFDWixZQUFZO0VBQ1osYUFBYTtFQUNiLHNCQUFzQjtFQUN0Qiw2QkFBNkI7QUFDL0I7O0FBRUE7RUFDRSxlQUFlO0VBQ2YsYUFBYTtBQUNmOztBQUVBO0VBQ0UsYUFBYTtFQUNiLDhCQUE4QjtBQUNoQzs7QUFFQTtFQUNFLFlBQVk7RUFDWixXQUFXO0FBQ2I7O0FBRUE7RUFDRSxxQkFBcUI7RUFDckIsZ0JBQWdCO0VBQ2hCLG1CQUFtQjtFQUNuQix1QkFBdUI7RUFDdkIsaUJBQWlCO0FBQ25COztBQUVBO0VBQ0UsZUFBZTtBQUNqQiIsInNvdXJjZXNDb250ZW50IjpbIi5zcGFudHJlZS10cmVlLXBhbmUge1xuICBwb3NpdGlvbjogZml4ZWQ7XG4gIGRpc3BsYXk6IGZsZXg7XG4gIGJveC1zaXppbmc6IGJvcmRlci1ib3g7XG4gIGhlaWdodDogMTAwJTtcbiAgcmlnaHQ6IDBweCAhaW1wb3J0YW50O1xuICB0b3A6IDBweCAhaW1wb3J0YW50O1xuICBib3R0b206IDBweCAhaW1wb3J0YW50O1xuICBsZWZ0OiAwcHggIWltcG9ydGFudDtcbiAgZm9udC1zaXplOiAwLjhlbTtcbiAgei1pbmRleDogMTAwMDtcbiAgdHJhbnNmb3JtOiB0cmFuc2xhdGUzZCgwcHgsIDBweCwgMHB4KTtcbiAgdHJhbnNpdGlvbjogdHJhbnNmb3JtIDAuMnMgZWFzZSAwcztcbiAgYm94LXNoYWRvdzogMnB4IDBweCA4cHggIzAwMDAwMDcwO1xufVxuXG4uc3BhbnRyZWUtcGFuZS1tYWluIHtcbiAgaGVpZ2h0OiAxMDAlO1xuICB3aWR0aDogMTAwJTtcbiAgcG9zaXRpb246IGFic29sdXRlO1xufVxuXG4uc3BhbnRyZWUtcGFuZS1oZWFkZXIge1xuICBoZWlnaHQ6IDQwcHg7XG4gIGJhY2tncm91bmQtY29sb3I6IHJnYig3NywgNjEsIDE0Nik7XG4gIGJvcmRlci1ib3R0b206IDFweCAjNDA0MDQwIHNvbGlkO1xuICBjb2xvcjogd2hpdGU7XG4gIHBhZGRpbmc6IDVweDtcbiAgZGlzcGxheTogZmxleDtcbiAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjtcbiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1hcm91bmQ7XG59XG5cbi5zcGFudHJlZS1jbG9zZS1idXR0b24ge1xuICBjdXJzb3I6IHBvaW50ZXI7XG4gIG1hcmdpbjogMCA0cHg7XG59XG5cbi5zcGFudHJlZS1zcHJlYWQge1xuICBkaXNwbGF5OiBmbGV4O1xuICBqdXN0aWZ5LWNvbnRlbnQ6IHNwYWNlLWJldHdlZW47XG59XG5cbi5zcGFudHJlZS10cmVlLWJvZHkge1xuICBoZWlnaHQ6IDEwMCU7XG4gIHdpZHRoOiAxMDAlO1xufVxuXG4uc3BhbnRyZWUtcGFuZS1kZXRhaWxzIHtcbiAgZGlzcGxheTogaW5saW5lLWJsb2NrO1xuICBvdmVyZmxvdzogaGlkZGVuO1xuICB3aGl0ZS1zcGFjZTogbm93cmFwO1xuICB0ZXh0LW92ZXJmbG93OiBlbGxpcHNpcztcbiAgZm9udC13ZWlnaHQ6IGJvbGQ7XG59XG5cbi5zcGFudHJlZS1wYW5lLWljb25zIHtcbiAgbWluLXdpZHRoOiAzNXB4O1xufVxuIl0sInNvdXJjZVJvb3QiOiIifQ== */</style><style>.spantree-backdrop {
  width: 100%;
  height: 100%;
  position: fixed;
  z-index: 5000;
  left: 0;
  top: 0;
  background-color: rgba(0, 0, 0, 0.3);
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29tcG9uZW50cy9CYWNrZHJvcC9zdHlsZXMuY3NzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBO0VBQ0UsV0FBVztFQUNYLFlBQVk7RUFDWixlQUFlO0VBQ2YsYUFBYTtFQUNiLE9BQU87RUFDUCxNQUFNO0VBQ04sb0NBQW9DO0FBQ3RDIiwic291cmNlc0NvbnRlbnQiOlsiLnNwYW50cmVlLWJhY2tkcm9wIHtcbiAgd2lkdGg6IDEwMCU7XG4gIGhlaWdodDogMTAwJTtcbiAgcG9zaXRpb246IGZpeGVkO1xuICB6LWluZGV4OiA1MDAwO1xuICBsZWZ0OiAwO1xuICB0b3A6IDA7XG4gIGJhY2tncm91bmQtY29sb3I6IHJnYmEoMCwgMCwgMCwgMC4zKTtcbn1cbiJdLCJzb3VyY2VSb290IjoiIn0= */</style><style>.spantree-search {
  position: fixed;
  z-index: 6000;
  background-color: white;
  min-width: 40%;
  border: 1px solid #ccc;
  box-shadow: 0px 0px 10px #00000040;
  left: 30%;
  top: 12%;
  box-sizing: border-box;
  border-radius: 3px;
  transition: all 0.3s ease-out;
}

.spantree-searchbar {
  padding: 10px;
}

.spantree-searchbar input {
  width: 100%;
  padding: 8px;
  border: 1px solid #bbbbbb;
  box-sizing: border-box;
}

.spantree-searchbar input:focus {
  border: 1px solid rgb(77, 61, 146);
  outline: none;
  box-shadow: 0px 0px 10px rgba(77, 61, 146, 0.25);
}

.spantree-search-results {
  overflow-y: scroll;
  overflow-x: hidden;
  max-height: 35vh;
}

.spantree-results-loading {
  color: grey;
}

.spantree-search-result {
  overflow-x: scroll;
  padding: 5px 15px;
}

.spantree-search-result:hover {
  cursor: pointer;
}

.spantree-result-active {
  background: rgba(211, 211, 211, 0.5);
}

.spantree-search-result::-webkit-scrollbar {
  height: 0px;
}

.spantree-search-file {
  display: flex;
  font-size: 15px;
}

.spantree-search-filename {
  font-weight: 600;
  padding-left: 2px;
}

.spantree-search-filelocation {
  color: #919191;
  padding-left: 23px;
}

.spantree-in-fzy {
  color: rgb(77, 61, 146);
  font-weight: bold;
}

.spantree-search-term {
  margin-right: 10px;
}

.spantree-search-help {
  padding: 3px 8px 6px 8px;
  border-top: 1px solid #dddddd;
  font-size: 14px;
}

.spantree-search-help code {
  padding: 4px 6px;
}

.spantree-search-help-item {
  padding-right: 16px;
}

.spantree-search-help-item-icon {
  position: relative;
  font-size: 18px;
  top: 2px;
}

/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbIndlYnBhY2s6Ly8uL2NvbnRlbnQvc3JjL3NjcmlwdHMvY29udGFpbmVycy9TZWFyY2hCYXIvc3R5bGVzLmNzcyJdLCJuYW1lcyI6W10sIm1hcHBpbmdzIjoiQUFBQTtFQUNFLGVBQWU7RUFDZixhQUFhO0VBQ2IsdUJBQXVCO0VBQ3ZCLGNBQWM7RUFDZCxzQkFBc0I7RUFDdEIsa0NBQWtDO0VBQ2xDLFNBQVM7RUFDVCxRQUFRO0VBQ1Isc0JBQXNCO0VBQ3RCLGtCQUFrQjtFQUNsQiw2QkFBNkI7QUFDL0I7O0FBRUE7RUFDRSxhQUFhO0FBQ2Y7O0FBRUE7RUFDRSxXQUFXO0VBQ1gsWUFBWTtFQUNaLHlCQUF5QjtFQUN6QixzQkFBc0I7QUFDeEI7O0FBRUE7RUFDRSxrQ0FBa0M7RUFDbEMsYUFBYTtFQUNiLGdEQUFnRDtBQUNsRDs7QUFFQTtFQUNFLGtCQUFrQjtFQUNsQixrQkFBa0I7RUFDbEIsZ0JBQWdCO0FBQ2xCOztBQUVBO0VBQ0UsV0FBVztBQUNiOztBQUVBO0VBQ0Usa0JBQWtCO0VBQ2xCLGlCQUFpQjtBQUNuQjs7QUFFQTtFQUNFLGVBQWU7QUFDakI7O0FBRUE7RUFDRSxvQ0FBb0M7QUFDdEM7O0FBRUE7RUFDRSxXQUFXO0FBQ2I7O0FBRUE7RUFDRSxhQUFhO0VBQ2IsZUFBZTtBQUNqQjs7QUFFQTtFQUNFLGdCQUFnQjtFQUNoQixpQkFBaUI7QUFDbkI7O0FBRUE7RUFDRSxjQUFjO0VBQ2Qsa0JBQWtCO0FBQ3BCOztBQUVBO0VBQ0UsdUJBQXVCO0VBQ3ZCLGlCQUFpQjtBQUNuQjs7QUFFQTtFQUNFLGtCQUFrQjtBQUNwQjs7QUFFQTtFQUNFLHdCQUF3QjtFQUN4Qiw2QkFBNkI7RUFDN0IsZUFBZTtBQUNqQjs7QUFFQTtFQUNFLGdCQUFnQjtBQUNsQjs7QUFFQTtFQUNFLG1CQUFtQjtBQUNyQjs7QUFFQTtFQUNFLGtCQUFrQjtFQUNsQixlQUFlO0VBQ2YsUUFBUTtBQUNWIiwic291cmNlc0NvbnRlbnQiOlsiLnNwYW50cmVlLXNlYXJjaCB7XG4gIHBvc2l0aW9uOiBmaXhlZDtcbiAgei1pbmRleDogNjAwMDtcbiAgYmFja2dyb3VuZC1jb2xvcjogd2hpdGU7XG4gIG1pbi13aWR0aDogNDAlO1xuICBib3JkZXI6IDFweCBzb2xpZCAjY2NjO1xuICBib3gtc2hhZG93OiAwcHggMHB4IDEwcHggIzAwMDAwMDQwO1xuICBsZWZ0OiAzMCU7XG4gIHRvcDogMTIlO1xuICBib3gtc2l6aW5nOiBib3JkZXItYm94O1xuICBib3JkZXItcmFkaXVzOiAzcHg7XG4gIHRyYW5zaXRpb246IGFsbCAwLjNzIGVhc2Utb3V0O1xufVxuXG4uc3BhbnRyZWUtc2VhcmNoYmFyIHtcbiAgcGFkZGluZzogMTBweDtcbn1cblxuLnNwYW50cmVlLXNlYXJjaGJhciBpbnB1dCB7XG4gIHdpZHRoOiAxMDAlO1xuICBwYWRkaW5nOiA4cHg7XG4gIGJvcmRlcjogMXB4IHNvbGlkICNiYmJiYmI7XG4gIGJveC1zaXppbmc6IGJvcmRlci1ib3g7XG59XG5cbi5zcGFudHJlZS1zZWFyY2hiYXIgaW5wdXQ6Zm9jdXMge1xuICBib3JkZXI6IDFweCBzb2xpZCByZ2IoNzcsIDYxLCAxNDYpO1xuICBvdXRsaW5lOiBub25lO1xuICBib3gtc2hhZG93OiAwcHggMHB4IDEwcHggcmdiYSg3NywgNjEsIDE0NiwgMC4yNSk7XG59XG5cbi5zcGFudHJlZS1zZWFyY2gtcmVzdWx0cyB7XG4gIG92ZXJmbG93LXk6IHNjcm9sbDtcbiAgb3ZlcmZsb3cteDogaGlkZGVuO1xuICBtYXgtaGVpZ2h0OiAzNXZoO1xufVxuXG4uc3BhbnRyZWUtcmVzdWx0cy1sb2FkaW5nIHtcbiAgY29sb3I6IGdyZXk7XG59XG5cbi5zcGFudHJlZS1zZWFyY2gtcmVzdWx0IHtcbiAgb3ZlcmZsb3cteDogc2Nyb2xsO1xuICBwYWRkaW5nOiA1cHggMTVweDtcbn1cblxuLnNwYW50cmVlLXNlYXJjaC1yZXN1bHQ6aG92ZXIge1xuICBjdXJzb3I6IHBvaW50ZXI7XG59XG5cbi5zcGFudHJlZS1yZXN1bHQtYWN0aXZlIHtcbiAgYmFja2dyb3VuZDogcmdiYSgyMTEsIDIxMSwgMjExLCAwLjUpO1xufVxuXG4uc3BhbnRyZWUtc2VhcmNoLXJlc3VsdDo6LXdlYmtpdC1zY3JvbGxiYXIge1xuICBoZWlnaHQ6IDBweDtcbn1cblxuLnNwYW50cmVlLXNlYXJjaC1maWxlIHtcbiAgZGlzcGxheTogZmxleDtcbiAgZm9udC1zaXplOiAxNXB4O1xufVxuXG4uc3BhbnRyZWUtc2VhcmNoLWZpbGVuYW1lIHtcbiAgZm9udC13ZWlnaHQ6IDYwMDtcbiAgcGFkZGluZy1sZWZ0OiAycHg7XG59XG5cbi5zcGFudHJlZS1zZWFyY2gtZmlsZWxvY2F0aW9uIHtcbiAgY29sb3I6ICM5MTkxOTE7XG4gIHBhZGRpbmctbGVmdDogMjNweDtcbn1cblxuLnNwYW50cmVlLWluLWZ6eSB7XG4gIGNvbG9yOiByZ2IoNzcsIDYxLCAxNDYpO1xuICBmb250LXdlaWdodDogYm9sZDtcbn1cblxuLnNwYW50cmVlLXNlYXJjaC10ZXJtIHtcbiAgbWFyZ2luLXJpZ2h0OiAxMHB4O1xufVxuXG4uc3BhbnRyZWUtc2VhcmNoLWhlbHAge1xuICBwYWRkaW5nOiAzcHggOHB4IDZweCA4cHg7XG4gIGJvcmRlci10b3A6IDFweCBzb2xpZCAjZGRkZGRkO1xuICBmb250LXNpemU6IDE0cHg7XG59XG5cbi5zcGFudHJlZS1zZWFyY2gtaGVscCBjb2RlIHtcbiAgcGFkZGluZzogNHB4IDZweDtcbn1cblxuLnNwYW50cmVlLXNlYXJjaC1oZWxwLWl0ZW0ge1xuICBwYWRkaW5nLXJpZ2h0OiAxNnB4O1xufVxuXG4uc3BhbnRyZWUtc2VhcmNoLWhlbHAtaXRlbS1pY29uIHtcbiAgcG9zaXRpb246IHJlbGF0aXZlO1xuICBmb250LXNpemU6IDE4cHg7XG4gIHRvcDogMnB4O1xufVxuIl0sInNvdXJjZVJvb3QiOiIifQ== */</style><style>
/*# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJzb3VyY2VzIjpbXSwibmFtZXMiOltdLCJtYXBwaW5ncyI6IiIsInNvdXJjZVJvb3QiOiIifQ== */</style></head>

<body>
<div class="container">
	<h1>CDbException</h1>

	<p class="message">
		CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: 
Integrity constraint violation: 1048 Column 'anonymized' cannot be null.
 The SQL statement executed was: UPDATE `ls_surveys` SET 
`htmlemail`=:yp0, `format`=:yp1, `template`=:yp2, `language`=:yp3, 
`owner_id`=:yp4, `admin`=:yp5, `adminemail`=:yp6, `sid`=:yp7, 
`gsid`=:yp8, `active`=:yp9, `expires`=:yp10, `startdate`=:yp11, 
`anonymized`=:yp12, `faxto`=:yp13, `savetimings`=:yp14, 
`additional_languages`=:yp15, `datestamp`=:yp16, `usecookie`=:yp17, 
`allowregister`=:yp18, `allowsave`=:yp19, `autonumber_start`=:yp20, 
`autoredirect`=:yp21, `allowprev`=:yp22, `printanswers`=:yp23, 
`ipaddr`=:yp24, `refurl`=:yp25, `datecreated`=:yp26, 
`publicstatistics`=:yp27, `publicgraphs`=:yp28, `listpublic`=:yp29, 
`sendconfirmation`=:yp30, `tokenanswerspersistence`=:yp31, 
`assessments`=:yp32, `usecaptcha`=:yp33, `usetokens`=:yp34, 
`bounce_email`=:yp35, `attributedescriptions`=:yp36, 
`emailresponseto`=:yp37, `emailnotificationto`=:yp38, 
`tokenlength`=:yp39, `showxquestions`=:yp40, `showgroupinfo`=:yp41, 
`shownoanswer`=:yp42, `showqnumcode`=:yp43, `bouncetime`=:yp44, 
`bounceprocessing`=:yp45, `bounceaccounttype`=:yp46, 
`bounceaccounthost`=:yp47, `bounceaccountpass`=:yp48, 
`bounceaccountencryption`=:yp49, `bounceaccountuser`=:yp50, 
`showwelcome`=:yp51, `showprogress`=:yp52, `questionindex`=:yp53, 
`navigationdelay`=:yp54, `nokeyboard`=:yp55, 
`alloweditaftercompletion`=:yp56, `googleanalyticsstyle`=:yp57, 
`googleanalyticsapikey`=:yp58, `showsurveypolicynotice`=:yp59 WHERE 
`ls_surveys`.`sid`=72986. Bound with :yp0='Y', :yp1='G', :yp2='vanilla',
 :yp3='en', :yp4=97, :yp5='imlambda', :yp6='art.chrome@free.fr', 
:yp7=72986, :yp8=1, :yp9='N', :yp10='2022-09-29 00:00:00', 
:yp11='2022-09-07 00:00:00', :yp12=NULL, :yp13='', :yp14=NULL, :yp15='',
 :yp16='N', :yp17='Y', :yp18='Y', :yp19='Y', :yp20=23, :yp21='Y', 
:yp22='Y', :yp23='Y', :yp24=NULL, :yp25=NULL, :yp26='2022-09-12 
16:31:14', :yp27='N', :yp28='N', :yp29='N', :yp30='Y', :yp31='N', 
:yp32='N', :yp33='N', :yp34='N', :yp35='art.chrome@free.fr', :yp36=NULL,
 :yp37='art.chrome@free.fr', :yp38='', :yp39=15, :yp40='Y', :yp41='N', 
:yp42='N', :yp43='N', :yp44=NULL, :yp45='N', :yp46=NULL, :yp47=NULL, 
:yp48=NULL, :yp49=NULL, :yp50=NULL, :yp51='Y', :yp52='Y', :yp53=1, 
:yp54=0, :yp55='N', :yp56='Y', :yp57='', :yp58='', :yp59=0	</p>

	<div class="source">
		<p class="file">/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/CDbCommand.php(358)</p>
		<div class="code"><pre><span class="ln">346</span>         {
<span class="ln">347</span>             if($this-&gt;_connection-&gt;enableProfiling)
<span class="ln">348</span>                 Yii::endProfile('system.db.CDbCommand.execute('.$this-&gt;getText().$par.')','system.db.CDbCommand.execute');
<span class="ln">349</span> 
<span class="ln">350</span>             $errorInfo=$e instanceof PDOException ? $e-&gt;errorInfo : null;
<span class="ln">351</span>             $message=$e-&gt;getMessage();
<span class="ln">352</span>             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
<span class="ln">353</span>                 array('{error}'=&gt;$message, '{sql}'=&gt;$this-&gt;getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
<span class="ln">354</span> 
<span class="ln">355</span>             if(YII_DEBUG)
<span class="ln">356</span>                 $message.='. The SQL statement executed was: '.$this-&gt;getText().$par;
<span class="ln">357</span> 
<span class="error"><span class="ln error-ln">358</span>             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
</span><span class="ln">359</span>                 array('{error}'=&gt;$message)),(int)$e-&gt;getCode(),$errorInfo);
<span class="ln">360</span>         }
<span class="ln">361</span>     }
<span class="ln">362</span> 
<span class="ln">363</span>     /**
<span class="ln">364</span>      * Executes the SQL statement and returns query result.
<span class="ln">365</span>      * This method is for executing an SQL query that returns result set.
<span class="ln">366</span>      * @param array $params input parameters (name=&gt;value) for the SQL execution. This is an alternative
<span class="ln">367</span>      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
<span class="ln">368</span>      * them in this way can improve the performance. Note that if you pass parameters in this way,
<span class="ln">369</span>      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
<span class="ln">370</span>      * Please also note that all values are treated as strings in this case, if you need them to be handled as
</pre></div>	</div>

	<div class="traces">
		<h2>Stack Trace</h2>
				<table style="width:100%;">
						<tbody><tr class="trace core collapsed">
			<td class="number">
				#0			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(1756):
 <strong>CDbCommand</strong>-&gt;<strong>execute</strong>()				</div>

				<div class="code"><pre><span class="ln">1751</span>         Yii::trace(get_class($this).'.updateByPk()','system.db.ar.CActiveRecord');
<span class="ln">1752</span>         $builder=$this-&gt;getCommandBuilder();
<span class="ln">1753</span>         $table=$this-&gt;getTableSchema();
<span class="ln">1754</span>         $criteria=$builder-&gt;createPkCriteria($table,$pk,$condition,$params);
<span class="ln">1755</span>         $command=$builder-&gt;createUpdateCommand($table,$attributes,$criteria);
<span class="error"><span class="ln error-ln">1756</span>         return $command-&gt;execute();
</span><span class="ln">1757</span>     }
<span class="ln">1758</span> 
<span class="ln">1759</span>     /**
<span class="ln">1760</span>      * Updates records with the specified condition.
<span class="ln">1761</span>      * See {@link find()} for detailed explanation about $condition and $params.
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(1130):
 <strong>CActiveRecord</strong>-&gt;<strong>updateByPk</strong>("72986", array("htmlemail" =&gt; "Y", "format" =&gt; "G", "template" =&gt; "vanilla", "language" =&gt; "en", ...))				</div>

				<div class="code"><pre><span class="ln">1125</span>         if($this-&gt;beforeSave())
<span class="ln">1126</span>         {
<span class="ln">1127</span>             Yii::trace(get_class($this).'.update()','system.db.ar.CActiveRecord');
<span class="ln">1128</span>             if($this-&gt;_pk===null)
<span class="ln">1129</span>                 $this-&gt;_pk=$this-&gt;getPrimaryKey();
<span class="error"><span class="ln error-ln">1130</span>             $this-&gt;updateByPk($this-&gt;getOldPrimaryKey(),$this-&gt;getAttributes($attributes));
</span><span class="ln">1131</span>             $this-&gt;_pk=$this-&gt;getPrimaryKey();
<span class="ln">1132</span>             $this-&gt;afterSave();
<span class="ln">1133</span>             return true;
<span class="ln">1134</span>         }
<span class="ln">1135</span>         else
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(811):
 <strong>CActiveRecord</strong>-&gt;<strong>update</strong>(null)				</div>

				<div class="code"><pre><span class="ln">806</span>      * @return boolean whether the saving succeeds
<span class="ln">807</span>      */
<span class="ln">808</span>     public function save($runValidation=true,$attributes=null)
<span class="ln">809</span>     {
<span class="ln">810</span>         if(!$runValidation || $this-&gt;validate($attributes))
<span class="error"><span class="ln error-ln">811</span>             return $this-&gt;getIsNewRecord() ? $this-&gt;insert($attributes) : $this-&gt;update($attributes);
</span><span class="ln">812</span>         else
<span class="ln">813</span>             return false;
<span class="ln">814</span>     }
<span class="ln">815</span> 
<span class="ln">816</span>     /**
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#3			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/admin/surveyadmin.php(922):
 <strong>CActiveRecord</strong>-&gt;<strong>save</strong>()				</div>

				<div class="code"><pre><span class="ln">917</span>                 $survey-&gt;anonymized = Yii::app()-&gt;request-&gt;getPost('anonymized');
<span class="ln">918</span>                 $survey-&gt;datestamp = Yii::app()-&gt;request-&gt;getPost('datestamp');
<span class="ln">919</span>                 $survey-&gt;ipaddr = Yii::app()-&gt;request-&gt;getPost('ipaddr');
<span class="ln">920</span>                 $survey-&gt;refurl = Yii::app()-&gt;request-&gt;getPost('refurl');
<span class="ln">921</span>                 $survey-&gt;savetimings = Yii::app()-&gt;request-&gt;getPost('savetimings');
<span class="error"><span class="ln error-ln">922</span>                 $survey-&gt;save();
</span><span class="ln">923</span>                 Survey::model()-&gt;resetCache(); // Make sure the saved values will be picked up
<span class="ln">924</span>             }
<span class="ln">925</span> 
<span class="ln">926</span>             $aResult = activateSurvey($iSurveyID);
<span class="ln">927</span>             $aViewUrls = array();
</pre></div>			</td>
		</tr>
						<tr class="trace core collapsed">
			<td class="number">
				#4			</td>
			<td class="content">
				<div class="trace-file">
										&nbsp;unknown(0): <strong>SurveyAdmin</strong>-&gt;<strong>activate</strong>(72986)				</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/actions/CAction.php(115):
 <strong>ReflectionMethod</strong>-&gt;<strong>invokeArgs</strong>(SurveyAdmin, array("72986"))				</div>

				<div class="code"><pre><span class="ln">110</span>             elseif($param-&gt;isDefaultValueAvailable())
<span class="ln">111</span>                 $ps[]=$param-&gt;getDefaultValue();
<span class="ln">112</span>             else
<span class="ln">113</span>                 return false;
<span class="ln">114</span>         }
<span class="error"><span class="ln error-ln">115</span>         $method-&gt;invokeArgs($object,$ps);
</span><span class="ln">116</span>         return true;
<span class="ln">117</span>     }
<span class="ln">118</span> }
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#6			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/core/Survey_Common_Action.php(83):
 <strong>CAction</strong>-&gt;<strong>runWithParamsInternal</strong>(SurveyAdmin,
 ReflectionMethod, array("surveyid" =&gt; "72986", "sa" =&gt; 
"activate", "iSurveyId" =&gt; "72986", "iSurveyID" =&gt; "72986", ...))	
			</div>

				<div class="code"><pre><span class="ln">78</span>             $oMethod = new ReflectionMethod($this, $sDefault);
<span class="ln">79</span>         }
<span class="ln">80</span> 
<span class="ln">81</span>         // We're all good to go, let's execute it
<span class="ln">82</span>         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
<span class="error"><span class="ln error-ln">83</span>         return parent::runWithParamsInternal($this, $oMethod, $params);
</span><span class="ln">84</span>     }
<span class="ln">85</span> 
<span class="ln">86</span>     /**
<span class="ln">87</span>      * Some functions have different parameters, which are just an alias of the
<span class="ln">88</span>      * usual parameters we're getting in the url. This function just populates
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(308):
 <strong>Survey_Common_Action</strong>-&gt;<strong>runWithParams</strong>(array("surveyid" =&gt; "72986", "sa" =&gt; "activate", "iSurveyId" =&gt; "72986", "iSurveyID" =&gt; "72986", ...))				</div>

				<div class="code"><pre><span class="ln">303</span>     {
<span class="ln">304</span>         $priorAction=$this-&gt;_action;
<span class="ln">305</span>         $this-&gt;_action=$action;
<span class="ln">306</span>         if($this-&gt;beforeAction($action))
<span class="ln">307</span>         {
<span class="error"><span class="ln error-ln">308</span>             if($action-&gt;runWithParams($this-&gt;getActionParams())===false)
</span><span class="ln">309</span>                 $this-&gt;invalidActionParams($action);
<span class="ln">310</span>             else
<span class="ln">311</span>                 $this-&gt;afterAction($action);
<span class="ln">312</span>         }
<span class="ln">313</span>         $this-&gt;_action=$priorAction;
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(286):
 <strong>CController</strong>-&gt;<strong>runAction</strong>(SurveyAdmin)				</div>

				<div class="code"><pre><span class="ln">281</span>      * @see runAction
<span class="ln">282</span>      */
<span class="ln">283</span>     public function runActionWithFilters($action,$filters)
<span class="ln">284</span>     {
<span class="ln">285</span>         if(empty($filters))
<span class="error"><span class="ln error-ln">286</span>             $this-&gt;runAction($action);
</span><span class="ln">287</span>         else
<span class="ln">288</span>         {
<span class="ln">289</span>             $priorAction=$this-&gt;_action;
<span class="ln">290</span>             $this-&gt;_action=$action;
<span class="ln">291</span>             CFilterChain::create($this,$action,$filters)-&gt;run();
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(265):
 <strong>CController</strong>-&gt;<strong>runActionWithFilters</strong>(SurveyAdmin, array())				</div>

				<div class="code"><pre><span class="ln">260</span>         {
<span class="ln">261</span>             if(($parent=$this-&gt;getModule())===null)
<span class="ln">262</span>                 $parent=Yii::app();
<span class="ln">263</span>             if($parent-&gt;beforeControllerAction($this,$action))
<span class="ln">264</span>             {
<span class="error"><span class="ln error-ln">265</span>                 $this-&gt;runActionWithFilters($action,$this-&gt;filters());
</span><span class="ln">266</span>                 $parent-&gt;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-&gt;missingAction($actionID);
</pre></div>			</td>
		</tr>
						<tr class="trace app expanded">
			<td class="number">
				#10			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/AdminController.php(165):
 <strong>CController</strong>-&gt;<strong>run</strong>("survey")				</div>

				<div class="code"><pre><span class="ln">160</span>                     $this-&gt;redirect(array('/admin/authentication/sa/login'));
<span class="ln">161</span>                 }
<span class="ln">162</span>             }
<span class="ln">163</span>         }
<span class="ln">164</span> 
<span class="error"><span class="ln error-ln">165</span>         return parent::run($action);
</span><span class="ln">166</span>     }
<span class="ln">167</span> 
<span class="ln">168</span>     /**
<span class="ln">169</span>      * Routes all the actions to their respective places
<span class="ln">170</span>      *
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CWebApplication.php(282):
 <strong>AdminController</strong>-&gt;<strong>run</strong>("survey")				</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-&gt;_controller;
<span class="ln">280</span>             $this-&gt;_controller=$controller;
<span class="ln">281</span>             $controller-&gt;init();
<span class="error"><span class="ln error-ln">282</span>             $controller-&gt;run($actionID);
</span><span class="ln">283</span>             $this-&gt;_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}'=&gt;$route===''?$this-&gt;defaultController:$route)));
</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>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CWebApplication.php(141):
 <strong>CWebApplication</strong>-&gt;<strong>runController</strong>("admin/survey/sa/activate")				</div>

				<div class="code"><pre><span class="ln">136</span>             foreach(array_splice($this-&gt;catchAllRequest,1) as $name=&gt;$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-&gt;getUrlManager()-&gt;parseUrl($this-&gt;getRequest());
<span class="error"><span class="ln error-ln">141</span>         $this-&gt;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">
				#13			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										
&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/base/CApplication.php(185):
 <strong>CWebApplication</strong>-&gt;<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-&gt;hasEventHandler('onBeginRequest'))
<span class="ln">183</span>             $this-&gt;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-&gt;processRequest();
</span><span class="ln">186</span>         if($this-&gt;hasEventHandler('onEndRequest'))
<span class="ln">187</span>             $this-&gt;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">
				#14			</td>
			<td class="content">
				<div class="trace-file">
											<div class="plus">+</div>
						<div class="minus">–</div>
										&nbsp;/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/index.php(194): <strong>CApplication</strong>-&gt;<strong>run</strong>()				</div>

				<div class="code"><pre><span class="ln">189</span> require_once APPPATH . 'core/LSYii_Application' . EXT;
<span class="ln">190</span> 
<span class="ln">191</span> $config = require_once(APPPATH . 'config/internal' . EXT);
<span class="ln">192</span> 
<span class="ln">193</span> Yii::$enableIncludePath = false;
<span class="error"><span class="ln error-ln">194</span> Yii::createApplication('LSYii_Application', $config)-&gt;run();
</span><span class="ln">195</span> 
<span class="ln">196</span> /* End of file index.php */
<span class="ln">197</span> /* Location: ./index.php */
</pre></div>			</td>
		</tr>
				</tbody></table>
	</div>

	<div class="version">
		2022-10-18 09:35:04 Apache <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.24-dev	</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">
			Profiling Summary Report
			(Time: 0.12138s,
			Memory: 4,415KB)
		</th>
	</tr>
	<tr style="background-color: #ccc;">
	    <th>Procedure</th>
		<th>Count</th>
		<th>Total (s)</th>
		<th>Avg. (s)</th>
		<th>Min. (s)</th>
		<th>Max. (s)</th>
	</tr>
	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys`)</td>
		<td align="center">1</td>
		<td align="center">0.00201</td>
		<td align="center">0.00201</td>
		<td align="center">0.00201</td>
		<td align="center">0.00201</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW TABLES)</td>
		<td align="center">1</td>
		<td align="center">0.00168</td>
		<td align="center">0.00168</td>
		<td align="center">0.00168</td>
		<td align="center">0.00168</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_users`)</td>
		<td align="center">1</td>
		<td align="center">0.00140</td>
		<td align="center">0.00140</td>
		<td align="center">0.00140</td>
		<td align="center">0.00140</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_templates`)</td>
		<td align="center">1</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
		<td align="center">0.00119</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_permissions`)</td>
		<td align="center">1</td>
		<td align="center">0.00096</td>
		<td align="center">0.00096</td>
		<td align="center">0.00096</td>
		<td align="center">0.00096</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys_languagesettings`)</td>
		<td align="center">1</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
		<td align="center">0.00095</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugins`)</td>
		<td align="center">1</td>
		<td align="center">0.00090</td>
		<td align="center">0.00090</td>
		<td align="center">0.00090</td>
		<td align="center">0.00090</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_settings_global`)</td>
		<td align="center">1</td>
		<td align="center">0.00082</td>
		<td align="center">0.00082</td>
		<td align="center">0.00082</td>
		<td align="center">0.00082</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.execute(UPDATE `ls_surveys` SET 
`htmlemail`=:yp0, `format`=:yp1, `template`=:yp2, `language`=:yp3, 
`owner_id`=:yp4, `admin`=:yp5, `adminemail`=:yp6, `sid`=:yp7, 
`gsid`=:yp8, `active`=:yp9, `expires`=:yp10, `startdate`=:yp11, 
`anonymized`=:yp12, `faxto`=:yp13, `savetimings`=:yp14, 
`additional_languages`=:yp15, `datestamp`=:yp16, `usecookie`=:yp17, 
`allowregister`=:yp18, `allowsave`=:yp19, `autonumber_start`=:yp20, 
`autoredirect`=:yp21, `allowprev`=:yp22, `printanswers`=:yp23, 
`ipaddr`=:yp24, `refurl`=:yp25, `datecreated`=:yp26, 
`publicstatistics`=:yp27, `publicgraphs`=:yp28, `listpublic`=:yp29, 
`sendconfirmation`=:yp30, `tokenanswerspersistence`=:yp31, 
`assessments`=:yp32, `usecaptcha`=:yp33, `usetokens`=:yp34, 
`bounce_email`=:yp35, `attributedescriptions`=:yp36, 
`emailresponseto`=:yp37, `emailnotificationto`=:yp38, 
`tokenlength`=:yp39, `showxquestions`=:yp40, `showgroupinfo`=:yp41, 
`shownoanswer`=:yp42, `showqnumcode`=:yp43, `bouncetime`=:yp44, 
`bounceprocessing`=:yp45, `bounceaccounttype`=:yp46, 
`bounceaccounthost`=:yp47, `bounceaccountpass`=:yp48, 
`bounceaccountencryption`=:yp49, `bounceaccountuser`=:yp50, 
`showwelcome`=:yp51, `showprogress`=:yp52, `questionindex`=:yp53, 
`navigationdelay`=:yp54, `nokeyboard`=:yp55, 
`alloweditaftercompletion`=:yp56, `googleanalyticsstyle`=:yp57, 
`googleanalyticsapikey`=:yp58, `showsurveypolicynotice`=:yp59 WHERE 
`ls_surveys`.`sid`=72986. Bound with :yp0='Y', :yp1='G', :yp2='vanilla',
 :yp3='en', :yp4=97, :yp5='imlambda', :yp6='art.chrome@free.fr', 
:yp7=72986, :yp8=1, :yp9='N', :yp10='2022-09-29 00:00:00', 
:yp11='2022-09-07 00:00:00', :yp12=NULL, :yp13='', :yp14=NULL, :yp15='',
 :yp16='N', :yp17='Y', :yp18='Y', :yp19='Y', :yp20=23, :yp21='Y', 
:yp22='Y', :yp23='Y', :yp24=NULL, :yp25=NULL, :yp26='2022-09-12 
16:31:14', :yp27='N', :yp28='N', :yp29='N', :yp30='Y', :yp31='N', 
:yp32='N', :yp33='N', :yp34='N', :yp35='art.chrome@free.fr', :yp36=NULL,
 :yp37='art.chrome@free.fr', :yp38='', :yp39=15, :yp40='Y', :yp41='N', 
:yp42='N', :yp43='N', :yp44=NULL, :yp45='N', :yp46=NULL, :yp47=NULL, 
:yp48=NULL, :yp49=NULL, :yp50=NULL, :yp51='Y', :yp52='Y', :yp53=1, 
:yp54=0, :yp55='N', :yp56='Y', :yp57='', :yp58='', :yp59=0)</td>
		<td align="center">1</td>
		<td align="center">0.00061</td>
		<td align="center">0.00061</td>
		<td align="center">0.00061</td>
		<td align="center">0.00061</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_users` `t` WHERE `t`.`uid`=1 LIMIT 1)</td>
		<td align="center">5</td>
		<td align="center">0.00055</td>
		<td align="center">0.00011</td>
		<td align="center">0.00008</td>
		<td align="center">0.00018</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t`)</td>
		<td align="center">2</td>
		<td align="center">0.00051</td>
		<td align="center">0.00026</td>
		<td align="center">0.00023</td>
		<td align="center">0.00028</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=:yp0 LIMIT 1. Bound with :yp0=72986)</td>
		<td align="center">1</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</td>
		<td align="center">0.00043</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=:ycp0 LIMIT 2. Bound with :ycp0='72986')</td>
		<td align="center">1</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
		<td align="center">0.00033</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=72986 LIMIT 1)</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 `ls_surveys_languagesettings`)</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `ls_users`)</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(SHOW CREATE TABLE `ls_templates`)</td>
		<td align="center">1</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys`)</td>
		<td align="center">1</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS 
`t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS 
`t0_c2`, `t`.`surveyls_description` AS `t0_c3`, 
`t`.`surveyls_welcometext` AS `t0_c4`, `t`.`surveyls_endtext` AS 
`t0_c5`, `t`.`surveyls_policy_notice` AS `t0_c6`, 
`t`.`surveyls_policy_error` AS `t0_c7`, 
`t`.`surveyls_policy_notice_label` AS `t0_c8`, `t`.`surveyls_url` AS 
`t0_c9`, `t`.`surveyls_urldescription` AS `t0_c10`, 
`t`.`surveyls_email_invite_subj` AS `t0_c11`, 
`t`.`surveyls_email_invite` AS `t0_c12`, 
`t`.`surveyls_email_remind_subj` AS `t0_c13`, 
`t`.`surveyls_email_remind` AS `t0_c14`, 
`t`.`surveyls_email_register_subj` AS `t0_c15`, 
`t`.`surveyls_email_register` AS `t0_c16`, 
`t`.`surveyls_email_confirm_subj` AS `t0_c17`, 
`t`.`surveyls_email_confirm` AS `t0_c18`, `t`.`surveyls_dateformat` AS 
`t0_c19`, `t`.`surveyls_attributecaptions` AS `t0_c20`, 
`t`.`email_admin_notification_subj` AS `t0_c21`, 
`t`.`email_admin_notification` AS `t0_c22`, 
`t`.`email_admin_responses_subj` AS `t0_c23`, 
`t`.`email_admin_responses` AS `t0_c24`, `t`.`surveyls_numberformat` AS 
`t0_c25`, `t`.`attachments` AS `t0_c26`, `survey`.`sid` AS `t1_c0`, 
`survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, 
`survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, 
`survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, 
`survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` AS `t1_c8`, 
`survey`.`faxto` AS `t1_c9`, `survey`.`format` AS `t1_c10`, 
`survey`.`savetimings` AS `t1_c11`, `survey`.`template` AS `t1_c12`, 
`survey`.`language` AS `t1_c13`, `survey`.`additional_languages` AS 
`t1_c14`, `survey`.`datestamp` AS `t1_c15`, `survey`.`usecookie` AS 
`t1_c16`, `survey`.`allowregister` AS `t1_c17`, `survey`.`allowsave` AS 
`t1_c18`, `survey`.`autonumber_start` AS `t1_c19`, 
`survey`.`autoredirect` AS `t1_c20`, `survey`.`allowprev` AS `t1_c21`, 
`survey`.`printanswers` AS `t1_c22`, `survey`.`ipaddr` AS `t1_c23`, 
`survey`.`refurl` AS `t1_c24`, `survey`.`datecreated` AS `t1_c25`, 
`survey`.`showsurveypolicynotice` AS `t1_c26`, 
`survey`.`publicstatistics` AS `t1_c27`, `survey`.`publicgraphs` AS 
`t1_c28`, `survey`.`listpublic` AS `t1_c29`, `survey`.`htmlemail` AS 
`t1_c30`, `survey`.`sendconfirmation` AS `t1_c31`, 
`survey`.`tokenanswerspersistence` AS `t1_c32`, `survey`.`assessments` 
AS `t1_c33`, `survey`.`usecaptcha` AS `t1_c34`, `survey`.`usetokens` AS 
`t1_c35`, `survey`.`bounce_email` AS `t1_c36`, 
`survey`.`attributedescriptions` AS `t1_c37`, `survey`.`emailresponseto`
 AS `t1_c38`, `survey`.`emailnotificationto` AS `t1_c39`, 
`survey`.`tokenlength` AS `t1_c40`, `survey`.`showxquestions` AS 
`t1_c41`, `survey`.`showgroupinfo` AS `t1_c42`, `survey`.`shownoanswer` 
AS `t1_c43`, `survey`.`showqnumcode` AS `t1_c44`, `survey`.`bouncetime` 
AS `t1_c45`, `survey`.`bounceprocessing` AS `t1_c46`, 
`survey`.`bounceaccounttype` AS `t1_c47`, `survey`.`bounceaccounthost` 
AS `t1_c48`, `survey`.`bounceaccountpass` AS `t1_c49`, 
`survey`.`bounceaccountencryption` AS `t1_c50`, 
`survey`.`bounceaccountuser` AS `t1_c51`, `survey`.`showwelcome` AS 
`t1_c52`, `survey`.`showprogress` AS `t1_c53`, `survey`.`questionindex` 
AS `t1_c54`, `survey`.`navigationdelay` AS `t1_c55`, 
`survey`.`nokeyboard` AS `t1_c56`, `survey`.`alloweditaftercompletion` 
AS `t1_c57`, `survey`.`googleanalyticsstyle` AS `t1_c58`, 
`survey`.`googleanalyticsapikey` AS `t1_c59` FROM 
`ls_surveys_languagesettings` `t`  LEFT OUTER JOIN `ls_surveys` `survey`
 ON (t.surveyls_survey_id = survey.sid) WHERE 
(`t`.`surveyls_survey_id`=72986 AND `t`.`surveyls_language`='en'))</td>
		<td align="center">1</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
		<td align="center">0.00018</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1)</td>
		<td align="center">2</td>
		<td align="center">0.00016</td>
		<td align="center">0.00008</td>
		<td align="center">0.00007</td>
		<td align="center">0.00009</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `ls_permissions`)</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(SHOW CREATE TABLE `ls_settings_global`)</td>
		<td align="center">1</td>
		<td align="center">0.00014</td>
		<td align="center">0.00014</td>
		<td align="center">0.00014</td>
		<td align="center">0.00014</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugins`)</td>
		<td align="center">1</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')</td>
		<td align="center">1</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
		<td align="center">0.00013</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT 
`languagesettings`.`surveyls_survey_id` AS `t1_c0`, 
`languagesettings`.`surveyls_language` AS `t1_c1`, 
`languagesettings`.`surveyls_title` AS `t1_c2`, 
`languagesettings`.`surveyls_description` AS `t1_c3`, 
`languagesettings`.`surveyls_welcometext` AS `t1_c4`, 
`languagesettings`.`surveyls_endtext` AS `t1_c5`, 
`languagesettings`.`surveyls_policy_notice` AS `t1_c6`, 
`languagesettings`.`surveyls_policy_error` AS `t1_c7`, 
`languagesettings`.`surveyls_policy_notice_label` AS `t1_c8`, 
`languagesettings`.`surveyls_url` AS `t1_c9`, 
`languagesettings`.`surveyls_urldescription` AS `t1_c10`, 
`languagesettings`.`surveyls_email_invite_subj` AS `t1_c11`, 
`languagesettings`.`surveyls_email_invite` AS `t1_c12`, 
`languagesettings`.`surveyls_email_remind_subj` AS `t1_c13`, 
`languagesettings`.`surveyls_email_remind` AS `t1_c14`, 
`languagesettings`.`surveyls_email_register_subj` AS `t1_c15`, 
`languagesettings`.`surveyls_email_register` AS `t1_c16`, 
`languagesettings`.`surveyls_email_confirm_subj` AS `t1_c17`, 
`languagesettings`.`surveyls_email_confirm` AS `t1_c18`, 
`languagesettings`.`surveyls_dateformat` AS `t1_c19`, 
`languagesettings`.`surveyls_attributecaptions` AS `t1_c20`, 
`languagesettings`.`email_admin_notification_subj` AS `t1_c21`, 
`languagesettings`.`email_admin_notification` AS `t1_c22`, 
`languagesettings`.`email_admin_responses_subj` AS `t1_c23`, 
`languagesettings`.`email_admin_responses` AS `t1_c24`, 
`languagesettings`.`surveyls_numberformat` AS `t1_c25`, 
`languagesettings`.`attachments` AS `t1_c26` FROM 
`ls_surveys_languagesettings` `languagesettings`  WHERE 
(`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with 
:ypl0='72986')</td>
		<td align="center">1</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
	</tr>	<tr style="background:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1)</td>
		<td align="center">1</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
		<td align="center">0.00011</td>
	</tr>	<tr style="background:#FFFFFF">
		<td>system.db.CDbCommand.query(SELECT `owner`.`uid` AS `t1_c0`, 
`owner`.`users_name` AS `t1_c1`, `owner`.`password` AS `t1_c2`, 
`owner`.`full_name` AS `t1_c3`, `owner`.`parent_id` AS `t1_c4`, 
`owner`.`lang` AS `t1_c5`, `owner`.`email` AS `t1_c6`, 
`owner`.`htmleditormode` AS `t1_c7`, `owner`.`templateeditormode` AS 
`t1_c8`, `owner`.`questionselectormode` AS `t1_c9`, 
`owner`.`one_time_pw` AS `t1_c10`, `owner`.`dateformat` AS `t1_c11`, 
`owner`.`created` AS `t1_c12`, `owner`.`modified` AS `t1_c13` FROM 
`ls_users` `owner`  WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0='97')</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:#F5F5F5">
		<td>system.db.CDbCommand.query(SELECT * FROM `ls_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.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 * FROM `ls_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)</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></tbody></table>
<!-- end of profiling summary --></body></html>
<!-- start profiling summary -->
noxinmortus

noxinmortus

2022-10-18 09:39

reporter   ~72314

I don't see anything different with chormium

noxinmortus

noxinmortus

2022-10-18 09:41

reporter   ~72315

And I think here is the page with the sql debug you wished

DenisChenu

DenisChenu

2022-10-18 12:06

developer   ~72318

Your file didn't came from LimeSurvey

See the limesurey file : https://github.com/LimeSurvey/LimeSurvey/blob/3.x-LTS/application/views/admin/survey/activateSurvey_view.php

Download it, and replace in your system.

DenisChenu

DenisChenu

2022-10-18 12:06

developer   ~72319

gabrieljenik

gabrieljenik

2022-10-18 14:43

manager   ~72326

Agree. there is something wrong in the produced html.

noxinmortus

noxinmortus

2022-10-18 15:07

reporter   ~72329

@DenisChenu @gabrieljenik, thanks a lot for your time, it seems indeed that these edits are the root cause of my issue.

I consider this matter closed.

Issue History

Date Modified Username Field Change
2022-10-17 10:09 noxinmortus New Issue
2022-10-17 10:09 noxinmortus File Added: limesurveybug.png
2022-10-17 10:11 noxinmortus Bug heat 0 => 2
2022-10-17 10:54 DenisChenu Note Added: 72272
2022-10-17 10:54 DenisChenu Bug heat 2 => 4
2022-10-17 11:10 noxinmortus Note Added: 72273
2022-10-17 11:12 DenisChenu Assigned To => DenisChenu
2022-10-17 11:12 DenisChenu Status new => assigned
2022-10-17 11:14 DenisChenu Note Added: 72275
2022-10-17 11:14 DenisChenu File Added: Capture d’écran du 2022-10-17 11-13-37.png
2022-10-17 11:21 noxinmortus Note Added: 72276
2022-10-17 11:21 noxinmortus File Added: Screenshot 2022-10-17 at 11-21-06 ReachOut Surveys.png
2022-10-17 11:25 noxinmortus Note Added: 72277
2022-10-17 11:25 noxinmortus File Added: Screenshot 2022-10-17 at 11-25-29 ReachOut Surveys.png
2022-10-17 11:28 DenisChenu Note Added: 72278
2022-10-17 11:29 DenisChenu Status assigned => acknowledged
2022-10-17 11:29 DenisChenu Note Added: 72279
2022-10-17 11:31 DenisChenu Note Added: 72280
2022-10-17 11:31 DenisChenu File Added: Capture d’écran du 2022-10-17 11-30-37.png
2022-10-17 11:39 noxinmortus Note Added: 72281
2022-10-17 11:39 noxinmortus File Added: image.png
2022-10-17 11:39 noxinmortus File Added: image-2.png
2022-10-17 12:04 DenisChenu Note Added: 72282
2022-10-17 12:27 noxinmortus Note Added: 72283
2022-10-17 12:30 DenisChenu Note Added: 72284
2022-10-17 12:31 DenisChenu Summary 500: internal server error CDbCommand failed to execute the SQL statement => 500: internal server error CDbCommand failed to execute the SQL statement + partially broken HTML in activate screen
2022-10-17 12:36 noxinmortus Note Added: 72285
2022-10-17 12:40 noxinmortus Note Added: 72286
2022-10-17 16:05 DenisChenu Assigned To DenisChenu => gabrieljenik
2022-10-17 16:05 DenisChenu Status acknowledged => feedback
2022-10-17 16:05 DenisChenu Note Added: 72294
2022-10-17 16:26 gabrieljenik Note Added: 72298
2022-10-17 16:26 gabrieljenik Bug heat 4 => 6
2022-10-17 16:27 DenisChenu Note Added: 72299
2022-10-18 09:36 noxinmortus Note Added: 72313
2022-10-18 09:36 noxinmortus File Added: CDbException_with_sql_debug.html
2022-10-18 09:36 noxinmortus Status feedback => assigned
2022-10-18 09:39 noxinmortus Note Added: 72314
2022-10-18 09:41 noxinmortus Note Added: 72315
2022-10-18 09:41 noxinmortus File Added: before_CDbException_with_sql_debug.html
2022-10-18 12:06 DenisChenu Note Added: 72318
2022-10-18 12:06 DenisChenu Note Added: 72319
2022-10-18 12:06 DenisChenu File Added: Capture d’écran du 2022-10-18 12-02-26.png
2022-10-18 14:43 gabrieljenik Status assigned => feedback
2022-10-18 14:43 gabrieljenik Note Added: 72326
2022-10-18 15:07 noxinmortus Note Added: 72329
2022-10-18 15:07 noxinmortus Status feedback => assigned
2022-10-18 15:23 DenisChenu Assigned To gabrieljenik => DenisChenu
2022-10-18 15:23 DenisChenu Status assigned => closed
2022-10-18 15:23 DenisChenu Resolution open => no change required