nooblag
2021-08-18 18:27
reporter
~66057
Last edited: 2021-09-01 16:33
|
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42803]: Grouping error: 7 ERROR: column "lime_survey_873476.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 5: ORDER BY "lime_survey_873476"."id" ASC
^. The SQL statement executed was: SELECT count(*)
FROM "lime_survey_873476"
LEFT JOIN "lime_survey_873476_timings" "survey_timings" ON lime_survey_873476.id = survey_timings.id
WHERE lime_survey_873476.id >= :min AND lime_survey_873476.id <= :max
ORDER BY "lime_survey_873476"."id" ASC
/var/www/LimeSurvey/framework/db/CDbCommand.php(543)
531 {
532 if($this->_connection->enableProfiling)
533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534
535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536 $message=$e->getMessage();
537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539
540 if(YII_DEBUG)
541 $message.='. The SQL statement executed was: '.$this->getText().$par;
542
543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545 }
546 }
547
548 /**
549 * Builds a SQL SELECT statement from the given query specification.
550 * @param array $query the query specification in name-value pairs. The following
551 * query options are supported: {@link select}, {@link distinct}, {@link from},
552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553 * {@link limit}, {@link offset} and {@link union}.
554 * @throws CDbException if "from" key is not present in given query parameter
555 * @return string the SQL statement
Stack Trace
#0
+
/var/www/LimeSurvey/framework/db/CDbCommand.php(433): CDbCommand->queryInternal()
#1
–
/var/www/LimeSurvey/application/helpers/admin/exportresults_helper.php(109): CDbCommand->queryScalar()
104 $survey = $surveyDao->loadSurveyById($iSurveyId, $sLanguageCode, $oOptions);
105 $writer->init($survey, $sLanguageCode, $oOptions);
106
107 $countResponsesCommand = $surveyDao->loadSurveyResults($survey, $oOptions->responseMinRecord, $oOptions->responseMaxRecord, $sFilter, $oOptions->responseCompletionState, $oOptions->selectedColumns, $oOptions->aResponses);
108 $countResponsesCommand->select('count(*)');
109 $reponsesCount = $countResponsesCommand->queryScalar();
110 $maxRows = 100;
111 $maxPages = ceil($reponsesCount / $maxRows);
112 for ($i = 0; $i < $maxPages; $i++) {
113 $offset = $i * $maxRows;
114 $responsesQuery = $surveyDao->loadSurveyResults($survey, $oOptions->responseMinRecord, $oOptions->responseMaxRecord, $sFilter, $oOptions->responseCompletionState, $oOptions->selectedColumns, $oOptions->aResponses);
#2
–
/var/www/LimeSurvey/application/controllers/admin/export.php(340): ExportSurveyResultsService->exportResponses()
335 } else {
336 $sFilter = '';
337 }
338
339 viewHelper::disableHtmlLogging();
340 $resultsService->exportResponses($iSurveyID, $explang, $sExportType, $options, $sFilter);
341
342 Yii::app()->end();
343 }
344
345 /*
#3
unknown(0): export->exportresults()
#4
+
/var/www/LimeSurvey/framework/web/actions/CAction.php(115): ReflectionMethod->invokeArgs()
#5
–
/var/www/LimeSurvey/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal()
81 $oMethod = new ReflectionMethod($this, $sDefault);
82 }
83
84 // We're all good to go, let's execute it
85 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
86 return parent::runWithParamsInternal($this, $oMethod, $params);
87 }
88
89 /**
90 * Some functions have different parameters, which are just an alias of the
91 * usual parameters we're getting in the url. This function just populates
#6
+
/var/www/LimeSurvey/framework/web/CController.php(308): Survey_Common_Action->runWithParams()
#7
+
/var/www/LimeSurvey/framework/web/CController.php(286): CController->runAction()
#8
+
/var/www/LimeSurvey/framework/web/CController.php(265): CController->runActionWithFilters()
#9
+
/var/www/LimeSurvey/application/controllers/AdminController.php(202): CController->run()
#10
+
/var/www/LimeSurvey/framework/web/CWebApplication.php(282): AdminController->run()
#11
+
/var/www/LimeSurvey/framework/web/CWebApplication.php(141): CWebApplication->runController()
#12
+
/var/www/LimeSurvey/framework/base/CApplication.php(185): CWebApplication->processRequest()
#13
+
/var/www/LimeSurvey/index.php(192): CApplication->run()
2021-08-19 02:25:59 nginx/1.18.0 Yii Framework/1.1.24-dev
|
