Exception

Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '779847X2989X5717157174' in 'field list'. The SQL statement executed was: UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`='', `779847X2989X57171SQ002`='', `779847X2989X57171SQ003`='A1', `779847X2989X5717157174`='A1' WHERE ID=1

/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/database_helper.php(44)

32         {
33             $dataset=Yii::app()->db->createCommand($sql)->query();
34 
35         }
36     } catch(CDbException $e) {
37         $error = $e->getMessage();
38         $dataset=false;
39     }
40 
41     if (!$dataset && (Yii::app()->getConfig('debug') >0 || !$silent))
42     {
43         // Exception is better than safeDie, because you can see the backtrace.
44         throw new \Exception('Error executing query in dbExecuteAssoc:'.$error);
45     }
46     return $dataset;
47 }
48 
49 
50 function dbQueryOrFalse($sql)
51 {
52     try {
53         $dataset=Yii::app()->db->createCommand($sql)->query();
54     } catch(CDbException $e) {
55         $dataset=false;
56     }

Stack Trace

#0
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5500): dbExecuteAssoc("UPDATE {{survey_779847}} SET `lastpage`=0, `779847X2989X57171SQ0...")
5495 
5496                 if (isset($_SESSION[$this->sessid]['srid']) && $this->surveyOptions['active'])
5497                 {
5498                     $query .= $_SESSION[$this->sessid]['srid'];
5499 
5500                     if (!dbExecuteAssoc($query))
5501                     {
5502                         // TODO: This kills the session if adminemail is defined, so the queries below won't work.
5503                         $message = submitfailed('', $query);  // TODO - report SQL error?
5504 
5505                         if (($this->debugLevel & LEM_DEBUG_VALIDATION_SUMMARY) == LEM_DEBUG_VALIDATION_SUMMARY) {
#1
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656): LimeExpressionManager->_UpdateValuesInDatabase(array("779847X2989X57171SQ001" => array("type" => "F", "value" => ""), "779847X2989X57171SQ002" => array("type" => "F", "value" => ""), "779847X2989X57171SQ003" => array("type" => "F", "value" => "A1"), "779847X2989X5717157174" => array("type" => "F", "value" => "A1")), false)
5651                         $message .= $result['message'];
5652                         $updatedValues = array_merge($updatedValues,$result['updatedValues']);
5653                         if (!is_null($result) && ($result['mandViolation'] || !$result['valid']))
5654                         {
5655                             // redisplay the current group, showing error
5656                             $message .= $LEM->_UpdateValuesInDatabase($updatedValues,false);
5657                             $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
5658                             $LEM->lastMoveResult = array(
5659                                 'finished'=>false,
5660                                 'message'=>$message,
5661                                 'gseq'=>$LEM->currentGroupSeq,
#2
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/SurveyRuntimeHelper.php(583): LimeExpressionManager::JumpTo(2, false)
578                     {
579                         // may be submitting from the navigation bar, in which case need to process all intervening questions
580                         // in order to update equations and ensure there are no intervening relevant mandatory or relevant invalid questions
581                         if($thissurvey['questionindex']==2) // Must : save actual page , review whole before set finished to true (see #09906), index==1 seems to don't need it : (don't force move)
582                             LimeExpressionManager::StartSurvey($surveyid, $surveyMode, $surveyOptions);
583                         $moveResult = LimeExpressionManager::JumpTo($_SESSION[$LEMsessid]['totalsteps'] + 1, false);
584                     }
585                 }
586                 if (isset($move) && $move=='changelang')
587                 {
588                     // jump to current step using new language, processing POST values
2017-02-03 17:29:28 Apache/2.2.22 (Debian) Yii Framework/1.1.17
Application Log
Timestamp Level Category Message
17:29:27.986068 error system.db.CDbCommand
CDbCommand::() failed: SQLSTATE[42S22]: Column not found: 1054 Unknown
column '779847X2989X5717157174' in 'field list'. The SQL statement executed
was: UPDATE lime_survey_779847 SET `lastpage`=0,
`779847X2989X57171SQ001`='', `779847X2989X57171SQ002`='',
`779847X2989X57171SQ003`='A1', `779847X2989X5717157174`='A1' WHERE ID=1.
17:29:28.223948 error exception.Exception
exception 'Exception' with message 'Error executing query in
dbExecuteAssoc:CDbCommand failed to execute the SQL statement:
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'779847X2989X5717157174' in 'field list'. The SQL statement executed was:
UPDATE lime_survey_779847 SET `lastpage`=0, `779847X2989X57171SQ001`='',
`779847X2989X57171SQ002`='', `779847X2989X57171SQ003`='A1',
`779847X2989X5717157174`='A1' WHERE ID=1' in
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/database_helper.php:44
Stack trace:
#0
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5500):
dbExecuteAssoc('UPDATE {{survey...')
#1
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/expressions/em_manager_helper.php(5656):
LimeExpressionManager->_UpdateValuesInDatabase(Array, false)
#2
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/SurveyRuntimeHelper.php(583):
LimeExpressionManager::JumpTo(2, false)
#3
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(611):
SurveyRuntimeHelper->run('779847', Array)
#4
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(70):
index->action()
#5
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/actions/CAction.php(76):
index->run()
#6
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308):
CAction->runWithParams(Array)
#7
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(286):
CController->runAction(Object(index))
#8
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(265):
CController->runActionWithFilters(Object(index), Array)
#9
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282):
CController->run('index')
#10
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141):
CWebApplication->runController('survey/index/si...')
#11
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/base/CApplication.php(185):
CWebApplication->processRequest()
#12 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/index.php(214):
CApplication->run()
#13 {main}
REQUEST_URI=/index.php/779847
HTTP_REFERER=https://limesurvey.sondages.pro/
---