View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 18418 | Bug reports | Survey editing | public | 2022-10-17 10:09 | 2022-10-18 15:23 |
| Reporter | noxinmortus | Assigned To | DenisChenu | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.28.x | ||||
| Summary | 18418: 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:
Expected result:the survey is activated Actual result:500: internal server error CDbCommand failed to execute the SQL statement (see picture for full error) | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | 3.28.32+221011 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox | ||||
| Database type & version | MariaDB 10.5.17 | ||||
| Server OS (if known) | Debian 11 | ||||
| Webserver software & version (if known) | Apache2 | ||||
| PHP Version | PHP 7.4 | ||||
|
Please : debug mode : https://manual.limesurvey.org/Debug_mode And save it as HTML |
|
|
Hello DenisChenu, here is the full exception: |
|
|
Thank you, more clear now. Can you check if you have this dropdown on the activate screen ? |
|
|
There is a line "Responses to this survey are anonymized." but not a dropbox |
|
|
bad page, but the dropbox appear to be missing! |
|
|
Seems you have some update on your instance … Admin theme update only (the it can be a LimeSUrvey issue) ? |
|
|
Hacked admin theme OR hacked LimeSurvey version or plugin ? : can you show the list of plugins ? |
|
|
PS : you lost ALL of this dropdown |
|
|
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 ? |
|
Try another one ?
Maybe :
|
|
|
I tried
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 |
|
|
I can not confirm the issue about partial hidden part in this view … really strange … |
|
|
Here are the console errors from Firefox of the "Activate survey" page, maybe it can help in some way ? |
|
|
I think I found it...
I don't think this block should be commented |
|
|
@gabrieljenik any idea here ? I can not reproduce on my part … |
|
|
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 Also, can you try with a chrome browser as well? Thanks Thanks |
|
Yes, evident … but we can fix it even if browser broken … |
|
|
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->_connection->enableProfiling)
<span class="ln">348</span> Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
<span class="ln">349</span>
<span class="ln">350</span> $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
<span class="ln">351</span> $message=$e->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}'=>$message, '{sql}'=>$this->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->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}'=>$message)),(int)$e->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=>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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(1756):
<strong>CDbCommand</strong>-><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->getCommandBuilder();
<span class="ln">1753</span> $table=$this->getTableSchema();
<span class="ln">1754</span> $criteria=$builder->createPkCriteria($table,$pk,$condition,$params);
<span class="ln">1755</span> $command=$builder->createUpdateCommand($table,$attributes,$criteria);
<span class="error"><span class="ln error-ln">1756</span> return $command->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(1130):
<strong>CActiveRecord</strong>-><strong>updateByPk</strong>("72986", array("htmlemail" => "Y", "format" => "G", "template" => "vanilla", "language" => "en", ...)) </div>
<div class="code"><pre><span class="ln">1125</span> if($this->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->_pk===null)
<span class="ln">1129</span> $this->_pk=$this->getPrimaryKey();
<span class="error"><span class="ln error-ln">1130</span> $this->updateByPk($this->getOldPrimaryKey(),$this->getAttributes($attributes));
</span><span class="ln">1131</span> $this->_pk=$this->getPrimaryKey();
<span class="ln">1132</span> $this->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/ar/CActiveRecord.php(811):
<strong>CActiveRecord</strong>-><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->validate($attributes))
<span class="error"><span class="ln error-ln">811</span> return $this->getIsNewRecord() ? $this->insert($attributes) : $this->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/admin/surveyadmin.php(922):
<strong>CActiveRecord</strong>-><strong>save</strong>() </div>
<div class="code"><pre><span class="ln">917</span> $survey->anonymized = Yii::app()->request->getPost('anonymized');
<span class="ln">918</span> $survey->datestamp = Yii::app()->request->getPost('datestamp');
<span class="ln">919</span> $survey->ipaddr = Yii::app()->request->getPost('ipaddr');
<span class="ln">920</span> $survey->refurl = Yii::app()->request->getPost('refurl');
<span class="ln">921</span> $survey->savetimings = Yii::app()->request->getPost('savetimings');
<span class="error"><span class="ln error-ln">922</span> $survey->save();
</span><span class="ln">923</span> Survey::model()->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">
unknown(0): <strong>SurveyAdmin</strong>-><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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/actions/CAction.php(115):
<strong>ReflectionMethod</strong>-><strong>invokeArgs</strong>(SurveyAdmin, array("72986")) </div>
<div class="code"><pre><span class="ln">110</span> elseif($param->isDefaultValueAvailable())
<span class="ln">111</span> $ps[]=$param->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->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/core/Survey_Common_Action.php(83):
<strong>CAction</strong>-><strong>runWithParamsInternal</strong>(SurveyAdmin,
ReflectionMethod, array("surveyid" => "72986", "sa" =>
"activate", "iSurveyId" => "72986", "iSurveyID" => "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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(308):
<strong>Survey_Common_Action</strong>-><strong>runWithParams</strong>(array("surveyid" => "72986", "sa" => "activate", "iSurveyId" => "72986", "iSurveyID" => "72986", ...)) </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">
#8 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(286):
<strong>CController</strong>-><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->runAction($action);
</span><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="ln">291</span> CFilterChain::create($this,$action,$filters)->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CController.php(265):
<strong>CController</strong>-><strong>runActionWithFilters</strong>(SurveyAdmin, array()) </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 expanded">
<td class="number">
#10 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/AdminController.php(165):
<strong>CController</strong>-><strong>run</strong>("survey") </div>
<div class="code"><pre><span class="ln">160</span> $this->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>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CWebApplication.php(282):
<strong>AdminController</strong>-><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->_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">
#12 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/web/CWebApplication.php(141):
<strong>CWebApplication</strong>-><strong>runController</strong>("admin/survey/sa/activate") </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">
#13 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/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">
#14 </td>
<td class="content">
<div class="trace-file">
<div class="plus">+</div>
<div class="minus">–</div>
/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/index.php(194): <strong>CApplication</strong>-><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)->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 --> |
|
|
I don't see anything different with chormium |
|
|
And I think here is the page with the sql debug you wished |
|
|
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. |
|
|
|
|
|
Agree. there is something wrong in the produced html. |
|
|
@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. |
|
| 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 |