/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 }
#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 |
#3 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(602): SurveyRuntimeHelper->run("958678",
array("surveyid" => "958678", "thissurvey" => array("template"
=> "default", "language" => "en", "sid" => "958678", "owner_id"
=> "1", ...), "thisstep" => "1", "tokensexist" => 0, ...)) 597 //Send local variables to the appropriate survey type 598 unset($redata); 599 $redata = compact(array_keys(get_defined_vars())); 600 Yii::import('application.helpers.SurveyRuntimeHelper'); 601 $tmp = new SurveyRuntimeHelper(); 602 $tmp->run($surveyid,$redata); 603 604 if (App()->request->getPost('saveall') || isset($flashmessage)) 605 { 606 App()->clientScript->registerScript("saveflashmessage","alert('".gT("Your responses were successfully saved.","js")."');",CClientScript::POS_READY); 607 } |
#4 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/application/controllers/survey/index.php(70): index->action() 65 App()->getClientScript()->reset(); 66 return $buffer; 67 }); 68 69 ob_implicit_flush(false); 70 $this->action(); 71 ob_flush(); 72 } 73 74 function action() 75 { |
#5 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/actions/CAction.php(76): index->run() 71 { 72 $method=new ReflectionMethod($this, 'run'); 73 if($method->getNumberOfParameters()>0) 74 return $this->runWithParamsInternal($this, $method, $params); 75 76 $this->run(); 77 return true; 78 } 79 80 /** 81 * Executes a method of an object with the supplied named parameters. |
#6 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(308): CAction->runWithParams(array("sid" => "958678")) 303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction; |
#7 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(286): CController->runAction(index) 281 * @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); |
#8 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CController.php(265): CController->runActionWithFilters(index, array()) 260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); |
#9 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(282): CController->run("index") 277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); |
#10 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/web/CWebApplication.php(141): CWebApplication->runController("survey/index/sid/958678") 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 137 $_GET[$name]=$value; 138 } 139 else 140 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 141 $this->runController($route); 142 } 143 144 /** 145 * Registers the core application components. 146 * This method overrides the parent implementation by registering additional core components. |
#11 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/framework/base/CApplication.php(185): CWebApplication->processRequest() 180 public function run() 181 { 182 if($this->hasEventHandler('onBeginRequest')) 183 $this->onBeginRequest(new CEvent($this)); 184 register_shutdown_function(array($this,'end'),0,false); 185 $this->processRequest(); 186 if($this->hasEventHandler('onEndRequest')) 187 $this->onEndRequest(new CEvent($this)); 188 } 189 190 /** |
#12 |
+
–
/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey/index.php(212): CApplication->run() 207 die (sprintf('%s should be writable by the webserver (766 or 776).', $runtimePath)); 208 } 209 } 210 211 Yii::$enableIncludePath = false; 212 Yii::createApplication('LSYii_Application', $config)->run(); 213 214 /* End of file index.php */ 215 /* Location: ./index.php */ |
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 |