CDbException

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

/var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/framework/db/CDbCommand.php(358)

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

Stack Trace

#3
+
 /var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/admin/surveyadmin.php(922): CActiveRecord->save()
917                 $survey->anonymized = Yii::app()->request->getPost('anonymized');
918                 $survey->datestamp = Yii::app()->request->getPost('datestamp');
919                 $survey->ipaddr = Yii::app()->request->getPost('ipaddr');
920                 $survey->refurl = Yii::app()->request->getPost('refurl');
921                 $survey->savetimings = Yii::app()->request->getPost('savetimings');
922                 $survey->save();
923                 Survey::model()->resetCache(); // Make sure the saved values will be picked up
924             }
925 
926             $aResult = activateSurvey($iSurveyID);
927             $aViewUrls = array();
#6
+
 /var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(SurveyAdmin, ReflectionMethod, array("surveyid" => "72986", "sa" => "activate", "iSurveyId" => "72986", "iSurveyID" => "72986", ...))
78             $oMethod = new ReflectionMethod($this, $sDefault);
79         }
80 
81         // We're all good to go, let's execute it
82         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
83         return parent::runWithParamsInternal($this, $oMethod, $params);
84     }
85 
86     /**
87      * Some functions have different parameters, which are just an alias of the
88      * usual parameters we're getting in the url. This function just populates
#10
+
 /var/www/limesurvey.dev.ow2.org/releases/limesurvey3.28.32+221011-20221014101110Z/application/controllers/AdminController.php(165): CController->run("survey")
160                     $this->redirect(array('/admin/authentication/sa/login'));
161                 }
162             }
163         }
164 
165         return parent::run($action);
166     }
167 
168     /**
169      * Routes all the actions to their respective places
170      *
2022-10-18 09:35:04 Apache Yii Framework/1.1.24-dev
Profiling Summary Report (Time: 0.12138s, Memory: 4,415KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys`) 1 0.00201 0.00201 0.00201 0.00201
system.db.CDbCommand.query(SHOW TABLES) 1 0.00168 0.00168 0.00168 0.00168
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_users`) 1 0.00140 0.00140 0.00140 0.00140
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_templates`) 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_permissions`) 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_surveys_languagesettings`) 1 0.00095 0.00095 0.00095 0.00095
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_plugins`) 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `ls_settings_global`) 1 0.00082 0.00082 0.00082 0.00082
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) 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM `ls_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 5 0.00055 0.00011 0.00008 0.00018
system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t`) 2 0.00051 0.00026 0.00023 0.00028
system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=:yp0 LIMIT 1. Bound with :yp0=72986) 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=:ycp0 LIMIT 2. Bound with :ycp0='72986') 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SELECT * FROM `ls_surveys` `t` WHERE `t`.`sid`=72986 LIMIT 1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys_languagesettings`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_users`) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_templates`) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_surveys`) 1 0.00018 0.00018 0.00018 0.00018
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')) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1) 2 0.00016 0.00008 0.00007 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_permissions`) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_settings_global`) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW CREATE TABLE `ls_plugins`) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT * FROM `ls_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00013 0.00013 0.00013 0.00013
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') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT * FROM `ls_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1) 1 0.00011 0.00011 0.00011 0.00011
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') 1 0.00010 0.00010 0.00010 0.00010
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') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `ls_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1) 1 0.00008 0.00008 0.00008 0.00008