View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
14109 | Bug reports | Survey editing | public | 2018-09-28 10:42 | 2019-05-13 15:28 |
Reporter | izzysteve | Assigned To | |||
Priority | none | Severity | minor | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 3.13.x | ||||
Summary | 14109: SQLSTATE[42S22] | ||||
Description | Hi, I am actually on Version 3.14.9+180917 but was not in list above. Hosting myself. I copied a survey I created, activated it, ran the survey and submitted and it crashes. I set debug to 2, repeated and attach the output from the crash. Based on a community suggestion, I also tried export/import of the original survey, activated that, ran it, submitted and all was fine. Given the source survey did not change in each case, I assume there may be a bug in the copy function? Thanks | ||||
Steps To Reproduce | See description | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | Version 3.14.9+180917 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Chrome and Firefox | ||||
Database type & version | mysql 5.7.23 | ||||
Server OS (if known) | linux | ||||
Webserver software & version (if known) | apache 2.4.34 | ||||
PHP Version | 5.6.37 | ||||
Attached phpinfo in case it helps |
|
Attach survey in lss format please … |
|
Can you export and upload here the LSA file too, because you write export/import lss fix the issue |
|
Also adding lsa file here |
|
I don't have such issue with the lsa … did you just try deactivate/reactivate ? Surely/maybe a subquestion badly deleted … Can you look if you have a question that don't exist anymore in group 42 in the database ? lime_question PS : reupload the HTML of the exception, more easy to see it here ¿ CDbException.html (28,070 bytes)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <!-- saved from url=(0039)https://illuceo.com/ls/index.php/191564 --> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>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 type="text/css">.backpack.dropzone { font-family: 'SF UI Display', 'Segoe UI'; font-size: 15px; text-align: center; display: flex; flex-direction: column; justify-content: center; align-items: center; width: 250px; height: 150px; font-weight: lighter; color: white; will-change: right; z-index: 2147483647; bottom: 20%; background: #333; position: fixed; user-select: none; transition: left .5s, right .5s; right: 0px; } .backpack.dropzone .animation { height: 80px; width: 250px; background: url("chrome-extension://lifbcibllhkdhoafpjfnlhfpfgnpldfl/assets/backpack/dropzone/hoverstate.png") left center; } .backpack.dropzone .title::before { content: 'Save to'; } .backpack.dropzone.closed { right: -250px; } .backpack.dropzone.hover .animation { animation: sxt-play-anim-hover 0.91s steps(21); animation-fill-mode: forwards; background: url("chrome-extension://lifbcibllhkdhoafpjfnlhfpfgnpldfl/assets/backpack/dropzone/hoverstate.png") left center; } @keyframes sxt-play-anim-hover { from { background-position: 0px; } to { background-position: -5250px; } } .backpack.dropzone.saving .title::before { content: 'Saving to'; } .backpack.dropzone.saving .animation { background: url("chrome-extension://lifbcibllhkdhoafpjfnlhfpfgnpldfl/assets/backpack/dropzone/saving_loop.png") left center; animation: sxt-play-anim-saving steps(59) 2.46s infinite; } @keyframes sxt-play-anim-saving { 100% { background-position: -14750px; } } .backpack.dropzone.saved .title::before { content: 'Saved to'; } .backpack.dropzone.saved .animation { background: url("chrome-extension://lifbcibllhkdhoafpjfnlhfpfgnpldfl/assets/backpack/dropzone/saved.png") left center; animation: sxt-play-anim-saved steps(20) 0.83s forwards; } @keyframes sxt-play-anim-saved { 100% { background-position: -5000px; } } </style></head> <body> <div class="container"> <h1>CDbException</h1> <p class="message"> CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '191564X42X1331' in 'field list'. The SQL statement executed was: UPDATE survey_191564 SET `lastpage`=1, `datestamp`='2018-09-27 17:47:39', `191564X43X1357`=NULL, `191564X43X1359SQ001`=NULL, `191564X43X1359SQ002`=NULL, `191564X43X1359SQ003`=NULL, `191564X43X1359SQ004`=NULL, `191564X43X1359SQ005`=NULL, `191564X43X1359SQ006`=NULL, `191564X43X1359other`=NULL, `191564X43X1360`=NULL, `191564X43X1361`=NULL, `191564X43X1362`=NULL, `191564X43X1363`=NULL, `191564X43X1364`=NULL, `191564X43X1365`=NULL, `191564X43X1366`=NULL, `191564X43X1367`=NULL, `191564X42X1331`='Hidden' WHERE ID=2 </p> <div class="source"> <p class="file">/home/illuceo/public_html/ls/framework/db/CDbCommand.php(543)</p> <div class="code"><pre><span class="ln">531</span> { <span class="ln">532</span> if($this->_connection->enableProfiling) <span class="ln">533</span> Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); <span class="ln">534</span> <span class="ln">535</span> $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; <span class="ln">536</span> $message=$e->getMessage(); <span class="ln">537</span> Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', <span class="ln">538</span> array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); <span class="ln">539</span> <span class="ln">540</span> if(YII_DEBUG) <span class="ln">541</span> $message.='. The SQL statement executed was: '.$this->getText().$par; <span class="ln">542</span> <span class="error"><span class="ln error-ln">543</span> throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', </span><span class="ln">544</span> array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); <span class="ln">545</span> } <span class="ln">546</span> } <span class="ln">547</span> <span class="ln">548</span> /** <span class="ln">549</span> * Builds a SQL SELECT statement from the given query specification. <span class="ln">550</span> * @param array $query the query specification in name-value pairs. The following <span class="ln">551</span> * query options are supported: {@link select}, {@link distinct}, {@link from}, <span class="ln">552</span> * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, <span class="ln">553</span> * {@link limit}, {@link offset} and {@link union}. <span class="ln">554</span> * @throws CDbException if "from" key is not present in given query parameter <span class="ln">555</span> * @return string the SQL statement </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> /home/illuceo/public_html/ls/framework/db/CDbCommand.php(377): <strong>CDbCommand</strong>-><strong>queryInternal</strong>("", 0, array()) </div> <div class="code"><pre><span class="ln">372</span> * @return CDbDataReader the reader object for fetching the query result <span class="ln">373</span> * @throws CException execution failed <span class="ln">374</span> */ <span class="ln">375</span> public function query($params=array()) <span class="ln">376</span> { <span class="error"><span class="ln error-ln">377</span> return $this->queryInternal('',0,$params); </span><span class="ln">378</span> } <span class="ln">379</span> <span class="ln">380</span> /** <span class="ln">381</span> * Executes the SQL statement and returns all rows. <span class="ln">382</span> * @param boolean $fetchAssociative whether each row should be returned as an associated array with </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #1 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/helpers/expressions/em_manager_helper.php(5591): <strong>CDbCommand</strong>-><strong>query</strong>() </div> <div class="code"><pre><span class="ln">5586</span> <span class="ln">5587</span> //If the responses already have been submitted once they are marked as completed already, so they shouldn't be changed. <span class="ln">5588</span> $oSurveyResponse = SurveyDynamic::model($this->sid)->findByAttributes(['id' => $_SESSION[$this->sessid]['srid']]); <span class="ln">5589</span> $result = true; <span class="ln">5590</span> if ($oSurveyResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y') { <span class="error"><span class="ln error-ln">5591</span> $result = !Yii::app()->db->createCommand($query)->query(); </span><span class="ln">5592</span> //$result = !dbExecuteAssoc($query); <span class="ln">5593</span> } <span class="ln">5594</span> <span class="ln">5595</span> if ($result) <span class="ln">5596</span> { </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #2 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/helpers/expressions/em_manager_helper.php(5316): <strong>LimeExpressionManager</strong>-><strong>_UpdateValuesInDatabase</strong>() </div> <div class="code"><pre><span class="ln">5311</span> continue; <span class="ln">5312</span> } <span class="ln">5313</span> else <span class="ln">5314</span> { <span class="ln">5315</span> // display new group <span class="error"><span class="ln error-ln">5316</span> $message .= $LEM->_UpdateValuesInDatabase(); </span><span class="ln">5317</span> $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now)); <span class="ln">5318</span> $LEM->lastMoveResult = array( <span class="ln">5319</span> 'finished'=>false, <span class="ln">5320</span> 'message'=>$message, <span class="ln">5321</span> 'gseq'=>$LEM->currentGroupSeq, </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> /home/illuceo/public_html/ls/application/helpers/SurveyRuntimeHelper.php(838): <strong>LimeExpressionManager</strong>::<strong>NavigateForwards</strong>() </div> <div class="code"><pre><span class="ln">833</span> $this->aMoveResult = false; // so display welcome page again <span class="ln">834</span> } <span class="ln">835</span> } <span class="ln">836</span> <span class="ln">837</span> if ($this->sMove == "movenext") { <span class="error"><span class="ln error-ln">838</span> $this->aMoveResult = LimeExpressionManager::NavigateForwards(); </span><span class="ln">839</span> } <span class="ln">840</span> <span class="ln">841</span> if (($this->sMove == 'movesubmit')) { <span class="ln">842</span> if ($this->sSurveyMode == 'survey') { <span class="ln">843</span> $this->aMoveResult = LimeExpressionManager::NavigateForwards(); </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/helpers/SurveyRuntimeHelper.php(537): <strong>SurveyRuntimeHelper</strong>-><strong>setMoveResult</strong>() </div> <div class="code"><pre><span class="ln">532</span> $this->initFirstStep(); // If it's the first time user load this survey, will init session and LEM <span class="ln">533</span> $this->initTotalAndMaxSteps(); <span class="ln">534</span> $this->checkIfUseBrowserNav(); // Check if user used browser navigation, or relaoded page <span class="ln">535</span> if ($this->sMove != 'clearcancel' && $this->sMove != 'confirmquota') { <span class="ln">536</span> $this->checkPrevStep(); // Check if prev step is set, else set it <span class="error"><span class="ln error-ln">537</span> $this->setMoveResult(); </span><span class="ln">538</span> $this->checkClearCancel(); <span class="ln">539</span> $this->setPrevStep(); <span class="ln">540</span> $this->checkIfFinished(); <span class="ln">541</span> $this->setStep(); <span class="ln">542</span> </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #5 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/helpers/SurveyRuntimeHelper.php(104): <strong>SurveyRuntimeHelper</strong>-><strong>initMove</strong>() </div> <div class="code"><pre><span class="ln">099</span> if (!isset($_SESSION[$this->LEMsessid]['step'])) { <span class="ln">100</span> $this->showTokenOrCaptchaFormsIfNeeded(); <span class="ln">101</span> } <span class="ln">102</span> <span class="ln">103</span> $this->checkForDataSecurityAccepted(); <span class="error"><span class="ln error-ln">104</span> $this->initMove(); // main methods to init session, LEM, moves, errors, etc </span><span class="ln">105</span> if (!$this->previewgrp && !$this->previewquestion) { <span class="ln">106</span> $this->checkQuotas(); // check quotas (then the process will stop here) <span class="ln">107</span> $this->displayFirstPageIfNeeded(); <span class="ln">108</span> $this->saveAllIfNeeded(); <span class="ln">109</span> $this->saveSubmitIfNeeded(); </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #6 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/controllers/survey/index.php(593): <strong>SurveyRuntimeHelper</strong>-><strong>run</strong>("191564", array("surveyid" => "191564", "thissurvey" => array("htmlemail" => "Y", "format" => "G", "template" => "illuceo", "language" => "en", ...), "thisstep" => "1", "tokensexist" => 0, ...)) </div> <div class="code"><pre><span class="ln">588</span> unset($redata); <span class="ln">589</span> $redata = compact(array_keys(get_defined_vars())); <span class="ln">590</span> Yii::import('application.helpers.SurveyRuntimeHelper'); <span class="ln">591</span> $tmp = new SurveyRuntimeHelper(); <span class="ln">592</span> // try { <span class="error"><span class="ln error-ln">593</span> $tmp->run($surveyid, $redata); </span><span class="ln">594</span> // } catch (WrongTemplateVersionException $ex) { <span class="ln">595</span> // echo $ex->getMessage(); <span class="ln">596</span> // } <span class="ln">597</span> } <span class="ln">598</span> </pre></div> </td> </tr> <tr class="trace app collapsed"> <td class="number"> #7 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/application/controllers/survey/index.php(24): <strong>index</strong>-><strong>action</strong>() </div> <div class="code"><pre><span class="ln">19</span> public $oTemplate; <span class="ln">20</span> <span class="ln">21</span> public function run() <span class="ln">22</span> { <span class="ln">23</span> useFirebug(); <span class="error"><span class="ln error-ln">24</span> $this->action(); </span><span class="ln">25</span> } <span class="ln">26</span> <span class="ln">27</span> public function action() <span class="ln">28</span> { <span class="ln">29</span> global $surveyid; </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> /home/illuceo/public_html/ls/framework/web/actions/CAction.php(76): <strong>index</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">71</span> { <span class="ln">72</span> $method=new ReflectionMethod($this, 'run'); <span class="ln">73</span> if($method->getNumberOfParameters()>0) <span class="ln">74</span> return $this->runWithParamsInternal($this, $method, $params); <span class="ln">75</span> <span class="error"><span class="ln error-ln">76</span> $this->run(); </span><span class="ln">77</span> return true; <span class="ln">78</span> } <span class="ln">79</span> <span class="ln">80</span> /** <span class="ln">81</span> * Executes a method of an object with the supplied named parameters. </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> /home/illuceo/public_html/ls/framework/web/CController.php(308): <strong>CAction</strong>-><strong>runWithParams</strong>(array("sid" => "191564")) </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"> #10 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/framework/web/CController.php(286): <strong>CController</strong>-><strong>runAction</strong>(index) </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"> #11 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/framework/web/CController.php(265): <strong>CController</strong>-><strong>runActionWithFilters</strong>(index, 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 core collapsed"> <td class="number"> #12 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/framework/web/CWebApplication.php(282): <strong>CController</strong>-><strong>run</strong>("index") </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"> #13 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("survey/index/sid/191564") </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"> #14 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/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"> #15 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div> /home/illuceo/public_html/ls/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"> 2018-09-27 17:47:39 Apache <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.19 </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> </body></html> |
|
Hi, Apologies for delay, weekend intervened. Yes, I have no issue when I too imported from an export file, so it makes sense that you would not have a problem from the .lsa file. It was when I copied the same survey that I had the issue. I have checked DB and confirm there is no Group 42 in it, not are there any questions that include gid 42. I have attached error as requested. Thanks, |
|
I'm unable to reproduce this issue using the latest version. |
|
Apologies, I do not seem to get notifications when a comment is added and didn't realise you had asked a question. In the last week, I have created other surveys with similar issue - if I use the copy, my answers do not get saved when I submit; if I export/import the very same survey, I have no issues at all. So sometimes it crashes as per original comment; other times answers not saved. I don't know any specific condition as it is when I click Submit at the end that the issue materialises. |
|
I think the best thing is that I will keep checking this over coming weeks, and if I see any useful pattern, I will report back. Thanks for your help. |
|
PS : Can you look if you have a question that don't exist anymore in group 42 in the database ? lime_question And see with a broken survey what happen when you click on «Check data integrity» It can be a subquestion (or not) leave in DB for some old reason : but «Check data integrity» must fix it. |
|
I ran the data integrity process and it shows no issues. I looked at the database and I have no group 42 any more and I also have no questions linked to Group 42. I have deleted the survey that was causing issues, so I think that is all as expected. As my previous note, I will keep checking for this issue (I have progressed significantly in the 2 weeks I started using LS) and will report back if issue re-occurs. If you want, this can be closed. Many thanks. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2018-09-28 10:42 | izzysteve | New Issue | |
2018-09-28 10:42 | izzysteve | File Added: error 20180927.zip | |
2018-09-28 10:55 | izzysteve | Note Added: 49163 | |
2018-09-28 10:59 | izzysteve | File Added: PHP 5.6.38.pdf | |
2018-09-28 12:00 | DenisChenu | Note Added: 49165 | |
2018-09-28 12:06 | izzysteve | File Added: limesurvey_survey_191564.lss | |
2018-09-28 12:10 | DenisChenu | Note Added: 49166 | |
2018-09-28 13:00 | izzysteve | File Added: survey_archive_191564.lsa | |
2018-09-28 13:00 | izzysteve | Note Added: 49168 | |
2018-09-28 15:27 | izzysteve | Issue Monitored: izzysteve | |
2018-09-28 17:20 | DenisChenu | File Added: CDbException.html | |
2018-09-28 17:20 | DenisChenu | Note Added: 49188 | |
2018-09-28 17:20 | DenisChenu | Note Edited: 49188 | |
2018-10-01 14:08 | izzysteve | File Added: error 20180927-2.zip | |
2018-10-01 14:08 | izzysteve | Note Added: 49201 | |
2018-10-04 17:25 |
|
Assigned To | => dominikvitt |
2018-10-04 17:25 |
|
Status | new => feedback |
2018-10-04 17:25 |
|
Note Added: 49243 | |
2018-10-10 16:56 | izzysteve | Note Added: 49295 | |
2018-10-10 16:56 | izzysteve | Status | feedback => assigned |
2018-10-10 18:13 | izzysteve | Note Added: 49298 | |
2018-10-10 18:56 | DenisChenu | Note Added: 49300 | |
2018-10-11 09:15 | izzysteve | Note Added: 49304 | |
2019-05-13 15:28 |
|
Status | assigned => resolved |
2019-05-13 15:28 |
|
Resolution | open => unable to reproduce |
2019-05-13 15:28 |
|
Status | resolved => closed |
2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |
2021-08-03 04:29 | guest | Bug heat | 6 => 8 |