Hi,

when conducting a survey a click on "Resume later" leads the participant to a site where the participant can fill in some information to resume to the survey later on. However, after having typed in the necessary information a click on "Save now" leads to a situation where the page is loading for a couple of minutes and then brings up the message mentioned below. During the time where the webpage is loading the backend or any other survey are not accessible.

I use PHP 7.0 which might be the cause for the error?

Any other suggestions?

Thank you.

Kind regards

PHP warning
Error while sending QUERY packet. PID=20896
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/CDbCommand.php(508)
496 Yii::trace('Query result found in cache','system.db.CDbCommand');
497 return $result[0];
498 }
499 }
500
501 try
502 {
503 if($this->_connection->enableProfiling)
504 Yii::beginProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
505
506 $this->prepare();
507 if($params===array())
508 $this->_statement->execute();
509 else
510 $this->_statement->execute($params);
511
512 if($method==='')
513 $result=new CDbDataReader($this);
514 else
515 {
516 $mode=(array)$mode;
517 call_user_func_array(array($this->_statement, 'setFetchMode'), $mode);
518 $result=$this->_statement->$method();
519 $this->_statement->closeCursor();
520 }
Stack Trace
#0 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/CDbCommand.php(508): PDOStatement->execute()
#1 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/CDbCommand.php(396): CDbCommand->queryInternal("fetchAll", array(2), array())
#2 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/schema/mysql/CMysqlSchema.php(168): CDbCommand->queryAll()
#3 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/schema/mysql/CMysqlSchema.php(128): CMysqlSchema->findColumns(CMysqlTableSchema)
#4 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/schema/CDbSchema.php(96): CMysqlSchema->loadTable("survey_884596")
#5 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/ar/CActiveRecord.php(2386): CDbSchema->getTable("{{survey_884596}}")
#6 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->construct(SurveyDynamic)
#7 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/ar/CActiveRecord.php(680): CActiveRecord->getMetaData()
#8 –
/is/htdocs/XXX_YYY/www/limesurvey/application/models/LSActiveRecord.php(29): CActiveRecord->hasAttribute("created")
24 @return array
25 /
26 public function behaviors()
27 {
28 $aBehaviors=array();
29 $sCreateFieldName=($this->hasAttribute('created')?'created':null);
30 $sUpdateFieldName=($this->hasAttribute('modified')?'modified':null);
31 $sDriverName = Yii::app()->db->getDriverName();
32 if ($sDriverName=='sqlsrv' || $sDriverName=='dblib')
33 {
34 $sTimestampExpression=new CDbExpression('GETDATE()');
#9 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/db/ar/CActiveRecord.php(396): LSActiveRecord->behaviors()
#10 –
/is/htdocs/XXX_YYY/www/limesurvey/application/models/SurveyDynamic.php(42): CActiveRecord::model("SurveyDynamic")
37 {
38 self::sid($sid);
39 $refresh = true;
40 }
41
42 $model = parent::model(CLASS__);
43
44 //We need to refresh if we changed sid
45 if ($refresh === true) $model->refreshMetaData();
46
47 return $model;
#11 –
/is/htdocs/XXX_YYY/www/limesurvey/application/helpers/replacements_helper.php(347): SurveyDynamic::model("884596")
342 $_linkreplace='';
343 }
344
345 if(isset($thissurvey['sid']) && isset($SESSION['survey'.$thissurvey['sid']]['srid']) && $thissurvey['active']=='Y')
346 {
347 $iscompleted=SurveyDynamic::model($surveyid)->isCompleted($SESSION['survey'.$thissurvey['sid']]['srid']);
348 }
349 else
350 {
351 $iscompleted=false;
352 }
#12 +
/is/htdocs/XXX_YYY/www/limesurvey/application/libraries/Save.php(66): templatereplace("<!-- startpage.pstl --> <meta http-equiv="content-type" content=...", array(), array("errormsg" => "Error: Email failed, this may indicate a PHP Mail Setup problem ...", "thissurvey" => array("template" => "default", "language" => "en", "sid" => "884596", "owner_id" => "12", ...), "surveyid" => "884596", "clienttoken" => "", ...))
#13 +
/is/htdocs/XXX_YYY/www/limesurvey/application/helpers/SurveyRuntimeHelper.php(684): Save->showsaveform()
#14 +
/is/htdocs/XXX_YYY/www/limesurvey/application/controllers/survey/index.php(611): SurveyRuntimeHelper->run("884596", array("surveyid" => "884596", "thissurvey" => array("template" => "default", "language" => "en", "sid" => "884596", "owner_id" => "12", ...), "thisstep" => "1", "tokensexist" => 0, ...))
#15 +
/is/htdocs/XXX_YYY/www/limesurvey/application/controllers/survey/index.php(70): index->action()
#16 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/actions/CAction.php(76): index->run()
#17 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/CController.php(308): CAction->runWithParams(array("sid" => "884596"))
#18 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/CController.php(286): CController->runAction(index)
#19 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/CController.php(265): CController->runActionWithFilters(index, array())
#20 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/CWebApplication.php(282): CController->run("index")
#21 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController("survey/index/sid/884596")
#22 +
/is/htdocs/XXX_YYY/www/limesurvey/framework/base/CApplication.php(185): CWebApplication->processRequest()
#23 +
/is/htdocs/XXX_YYY/www/limesurvey/index.php(214): CApplication->run()