Exception

Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '958678X2740X533814' in 'field list'. The SQL statement executed was: UPDATE lime_survey_958678 SET `lastpage`=1, `958678X2740X533811`='A4', `958678X2740X533812`='A3', `958678X2740X533813`='A2', `958678X2740X533814`='A1' WHERE ID=3

/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(5425): dbExecuteAssoc("UPDATE {{survey_958678}} SET `lastpage`=1, `958678X2740X533811`=...")
5420 
5421                 if (isset($_SESSION[$this->sessid]['srid']) && $this->surveyOptions['active'])
5422                 {
5423                     $query .= $_SESSION[$this->sessid]['srid'];
5424 
5425                     if (!dbExecuteAssoc($query))
5426                     {
5427                         // TODO: This kills the session if adminemail is defined, so the queries below won't work.
5428                         $message = submitfailed('', $query);  // TODO - report SQL error?
5429 
5430                         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(5603): LimeExpressionManager->_UpdateValuesInDatabase(array("958678X2740X533811" => array("type" => "R", "value" => "A4"), "958678X2740X533812" => array("type" => "R", "value" => "A3"), "958678X2740X533813" => array("type" => "R", "value" => "A2"), "958678X2740X533814" => array("type" => "R", "value" => "A1")), true)
5598                     while (true)
5599                     {
5600                         $LEM->currentQset = array();    // reset active list of questions
5601                         if (++$LEM->currentGroupSeq >= $LEM->numGroups)
5602                         {
5603                             $message .= $LEM->_UpdateValuesInDatabase($updatedValues,true);
5604                             $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
5605                             $LEM->lastMoveResult = array(
5606                                 'finished'=>true,
5607                                 'message'=>$message,
5608                                 'gseq'=>$LEM->currentGroupSeq,
#2
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/helpers/SurveyRuntimeHelper.php(535): LimeExpressionManager::JumpTo(2, false)
530                     {
531                         // may be submitting from the navigation bar, in which case need to process all intervening questions
532                         // in order to update equations and ensure there are no intervening relevant mandatory or relevant invalid questions
533                         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)
534                             LimeExpressionManager::StartSurvey($surveyid, $surveyMode, $surveyOptions);
535                         $moveResult = LimeExpressionManager::JumpTo($_SESSION[$LEMsessid]['totalsteps'] + 1, false);
536                     }
537                 }
538                 if (isset($move) && $move=='changelang')
539                 {
540                     // jump to current step using new language, processing POST values
2016-06-02 16:16:04 Apache/2.2.22 (Debian) Yii Framework/1.1.17
Profiling Summary Report (Time: 0.36139s, Memory: 10,380KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) 1 0.00771 0.00771 0.00771 0.00771
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 1 0.00653 0.00653 0.00653 0.00653
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugin_settings`) 1 0.00595 0.00595 0.00595 0.00595
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) 1 0.00526 0.00526 0.00526 0.00526
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) 1 0.00507 0.00507 0.00507 0.00507
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) 1 0.00477 0.00477 0.00477 0.00477
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) 1 0.00474 0.00474 0.00474 0.00474
system.db.CDbCommand.query(SHOW TABLES) 1 0.00220 0.00220 0.00220 0.00220
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_url` AS `t0_c6`, `t`.`surveyls_urldescription` AS `t0_c7`, `t`.`surveyls_email_invite_subj` AS `t0_c8`, `t`.`surveyls_email_invite` AS `t0_c9`, `t`.`surveyls_email_remind_subj` AS `t0_c10`, `t`.`surveyls_email_remind` AS `t0_c11`, `t`.`surveyls_email_register_subj` AS `t0_c12`, `t`.`surveyls_email_register` AS `t0_c13`, `t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm` AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`, `t`.`surveyls_attributecaptions` AS `t0_c17`, `t`.`email_admin_notification_subj` AS `t0_c18`, `t`.`email_admin_notification` AS `t0_c19`, `t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses` AS `t0_c21`, `t`.`surveyls_numberformat` AS `t0_c22`, `t`.`attachments` AS `t0_c23`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`, `survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`, `survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`, `survey`.`faxto` AS `t1_c8`, `survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS `t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS `t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS `t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`, `survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`, `survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`, `survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto` AS `t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`, `survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS `t1_c39`, `survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer` AS `t1_c41`, `survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime` AS `t1_c43`, `survey`.`bounceprocessing` AS `t1_c44`, `survey`.`bounceaccounttype` AS `t1_c45`, `survey`.`bounceaccounthost` AS `t1_c46`, `survey`.`bounceaccountpass` AS `t1_c47`, `survey`.`bounceaccountencryption` AS `t1_c48`, `survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS `t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`navigationdelay` AS `t1_c52`, `survey`.`nokeyboard` AS `t1_c53`, `survey`.`alloweditaftercompletion` AS `t1_c54`, `survey`.`googleanalyticsstyle` AS `t1_c55`, `survey`.`googleanalyticsapikey` AS `t1_c56`, `survey`.`questionindex` AS `t1_c57` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=958678 AND `t`.`surveyls_language`='en')) 1 0.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) 1 0.00115 0.00115 0.00115 0.00115
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='82', :yp1='useSessionLifeTime') 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='82', :yp1='interval') 1 0.00105 0.00105 0.00105 0.00105
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=958678 LIMIT 1) 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(UPDATE lime_survey_958678 SET `lastpage`=1, `958678X2740X533811`='A4', `958678X2740X533812`='A3', `958678X2740X533813`='A2', `958678X2740X533814`='A1' WHERE ID=3) 1 0.00050 0.00050 0.00050 0.00050
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1) 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugin_settings`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) 1 0.00020 0.00020 0.00020 0.00020