|
|
Here is the debug message.
========
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'language'.. The SQL statement executed was: SELECT * FROM [dbo].[questions] [t] WHERE parent_qid=:parent_qid and language=:language and scale_id=:scale_id
C:\Websites\Limesurvey2019_Org\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
- C:\Websites\Limesurvey2019_Org\framework\db\CDbCommand.php(396): CDbCommand->queryInternal("fetchAll", array(2), array())
#1
- C:\Websites\Limesurvey2019_Org\framework\db\ar\CActiveRecord.php(1359): CDbCommand->queryAll()
#2
– C:\Websites\Limesurvey2019_Org\application\models\LSActiveRecord.php(74): CActiveRecord->query(CDbCriteria, true)
69 @since 1.1.7
70 /
71 protected function query($criteria, $all = false, $asAR = true)
72 {
73 if ($asAR === true) {
74 return parent::query($criteria, $all);
75 } else {
76 $this->beforeFind();
77 $this->applyScopes($criteria);
78 if (!$all) {
79 $criteria->limit = 1;
#3
- C:\Websites\Limesurvey2019_Org\framework\db\ar\CActiveRecord.php(1478): LSActiveRecord->query(CDbCriteria, true)
#4
– C:\Websites\Limesurvey2019_Org\plugins\arrayTextAdapt\arrayTextAdapt.php(168): CActiveRecord->findAll(array("condition" => "parent_qid=:parent_qid and language=:language and scale_id=:scal...", "params" => array(":parent_qid" => "703", ":language" => "en", ":scale_id" => 1), "index" => "qid"))
163 if($sType==";")
164 {
165 $aoSubQuestionX=Question::model()->findAll(array(
166 'condition'=>"parent_qid=:parent_qid and language=:language and scale_id=:scale_id",
167 'params'=>array(":parent_qid"=>$oEvent->get('qid'),":language"=>App()->language,":scale_id"=>1),
168 'index'=>'qid',
169 ));
170 $oCriteria = new CDbCriteria;
171 $oCriteria->condition="attribute='arrayTextAdaptation'";
172 $oCriteria->addInCondition("qid",CHtml::listData($aoSubQuestionX,'qid','qid'));
173 $oExistingAttribute=QuestionAttribute::model()->findAll($oCriteria);
#5
unknown(0): arrayTextAdapt->beforeQuestionRender()
#6
– C:\Websites\Limesurvey2019_Org\application\libraries\PluginManager\PluginManager.php(261): call_user_func(array(arrayTextAdapt, "beforeQuestionRender"))
256 if (isset($this->subscriptions[$eventName])) {
257 foreach ($this->subscriptions[$eventName] as $subscription) {
258 if (!$event->isStopped()
259 && (empty($target) || in_array(get_class($subscription[0]), $target))) {
260 $subscription[0]->setEvent($event);
261 call_user_func($subscription);
262 }
263 }
264 }
265
266 return $event;
#7
- C:\Websites\Limesurvey2019_Org\application\helpers\SurveyRuntimeHelper.php(1811): LimeSurvey\PluginManager\PluginManager->dispatchEvent(PluginEvent)
#8
- C:\Websites\Limesurvey2019_Org\application\helpers\SurveyRuntimeHelper.php(493): SurveyRuntimeHelper->doBeforeQuestionRenderEvent(array("qid" => "703", "gid" => "1", "code" => "Q01", "type" => ";", ...))
#9
- C:\Websites\Limesurvey2019_Org\application\controllers\survey\index.php(604): SurveyRuntimeHelper->run("538377", array("surveyid" => "538377", "thissurvey" => array("htmlemail" => "Y", "format" => "G", "tokenencryptionoptions" => "{"enabled":"N","columns":{"firstname":"N","lastname":"N","email"...", "template" => "extends_bootswatch_PPRI_YTS", ...), "thisstep" => 0, "clienttoken" => "mMBYzB5YwrzeRNC", ...))
#10
- C:\Websites\Limesurvey2019_Org\application\controllers\survey\index.php(26): index->action()
#11
- C:\Websites\Limesurvey2019_Org\framework\web\actions\CAction.php(76): index->run()
#12
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(308): CAction->runWithParams(array("r" => "survey/index", "sid" => "538377", "token" => "mMBYzB5YwrzeRNC", "newtest" => "Y"))
#13
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(286): CController->runAction(index)
#14
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(265): CController->runActionWithFilters(index, array())
#15
- C:\Websites\Limesurvey2019_Org\framework\web\CWebApplication.php(282): CController->run("index")
#16
- C:\Websites\Limesurvey2019_Org\framework\web\CWebApplication.php(141): CWebApplication->runController("survey/index")
#17
- C:\Websites\Limesurvey2019_Org\framework\base\CApplication.php(185): CWebApplication->processRequest()
#18
- C:\Websites\Limesurvey2019_Org\index.php(192): CApplication->run()
2021-08-16 09:10:18 Microsoft-IIS/10.0 Yii Framework/1.1.24-dev
|
|
|
The debug error when I click the plugin page.
=====
PHP notice
Undefined index:
C:\Websites\Limesurvey2019_Org\application\models\Plugin.php(324)
312 }
313
314 /*
315 Get installation folder of this plugin.
316 Installation folder is different for core and
317 user plugins.
318 @return string
319 @throws Exception
320 /
321 protected function getDir()
322 {
323 $pluginManager = App()->getPluginManager();
324 $alias = $pluginManager->pluginDirs[$this->plugin_type];
325
326 if (empty($alias)) {
327 throw new \Exception('Unknown plugin type: ' . json_encode($this->plugin_type));
328 }
329
330 $folder = Yii::getPathOfAlias($alias);
331
332 if (empty($folder)) {
333 throw new \Exception('Alias has no folder: ' . json_encode($alias));
334 }
335
336 // NB: Name is same as plugin folder and plugin main class.
Stack Trace
#0
– C:\Websites\Limesurvey2019_Org\application\models\Plugin.php(100): Plugin->getDir()
095 @return ExtensionConfig
096 @throws Exception if file does not exist.
097 /
098 public function getExtensionConfig()
099 {
100 $file = $this->getDir() . DIRECTORY_SEPARATOR . 'config.xml';
101 if (file_exists($file)) {
102 if (\PHP_VERSION_ID < 80000) {
103 libxml_disable_entity_loader(false);
104 }
105 $config = simplexml_load_file(realpath($file));
#1
– C:\Websites\Limesurvey2019_Org\application\models\Plugin.php(169): Plugin->getExtensionConfig()
164 Description as shown in plugin list.
165 @return string
166 */
167 public function getDescription()
168 {
169 $config = $this->getExtensionConfig();
170 // Harden for XSS
171 $filter = LSYii_HtmlPurifier::getXssPurifier();
172 return $filter->purify($config->getDescription());
173 }
174
#2
C:\Websites\Limesurvey2019_Org\framework\base\CComponent.php(614) : eval()'d code(1): Plugin->getDescription()
#3
- C:\Websites\Limesurvey2019_Org\framework\base\CComponent.php(614): eval()
#4
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CDataColumn.php(148): CComponent->evaluateExpression("$data->getDescription()", array("data" => Plugin, "row" => 0))
#5
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridColumn.php(237): CDataColumn->getDataCellContent(0)
#6
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridColumn.php(160): CGridColumn->renderDataCellContent(0, Plugin)
#7
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridView.php(655): CGridColumn->renderDataCell(0)
#8
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridView.php(639): CGridView->renderDataCell(TbDataColumn, 0)
#9
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridView.php(595): CGridView->renderTableRow(0)
#10
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\grid\CGridView.php(505): CGridView->renderTableBody()
#11
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\CBaseListView.php(181): CGridView->renderItems()
#12
unknown(0): CBaseListView->renderSection(array("{items}", "items"))
#13
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\CBaseListView.php(164): preg_replace_callback("/{(\w+)}/", array(TbGridView, "renderSection"), "{items} <div class="row-fluid"><div class="span6">{pager}</div><...")
#14
- C:\Websites\Limesurvey2019_Org\framework\zii\widgets\CBaseListView.php(149): CBaseListView->renderContent()
#15
- C:\Websites\Limesurvey2019_Org\framework\web\CBaseController.php(182): CBaseListView->run()
#16
- C:\Websites\Limesurvey2019_Org\application\views\admin\pluginmanager\index.php(135): CBaseController->widget("bootstrap.widgets.TbGridView", array("dataProvider" => CArrayDataProvider, "id" => "plugins-grid", "summaryText" => "Displaying {start}-{end} of {count} result(s). <select class="ch...", "columns" => array(array("header" => "Status", "type" => "html", "name" => "status", "value" => "$data->getStatus()"), array("header" => "Plugin", "name" => "name", "type" => "html", "value" => "$data->getName()"), array("header" => "Description", "name" => "description", "type" => "html", "value" => "$data->getDescription()"), array("type" => "raw", "header" => "Action", "name" => "action", "value" => "$data->getActionButtons()")), ...))
#17
- C:\Websites\Limesurvey2019_Org\framework\web\CBaseController.php(126): require("C:\Websites\Limesurvey2019_Org\application\views\admin\pluginman...")
#18
- C:\Websites\Limesurvey2019_Org\framework\web\CBaseController.php(95): CBaseController->renderInternal("C:\Websites\Limesurvey2019_Org\application\views/admin/pluginman...", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...), true)
#19
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(872): CBaseController->renderFile("C:\Websites\Limesurvey2019_Org\application\views/admin/pluginman...", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...), true)
#20
- C:\Websites\Limesurvey2019_Org\application\controllers\AdminController.php(261): CController->renderPartial("/admin/pluginmanager/index", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...), true, false)
#21
- C:\Websites\Limesurvey2019_Org\application\core\Survey_Common_Action.php(276): AdminController->renderPartial("/admin/pluginmanager/index", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...), true)
#22
- C:\Websites\Limesurvey2019_Org\application\core\Survey_Common_Action.php(361): Survey_Common_Action->renderCentralContents("pluginmanager", array("index"), array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...))
#23
- C:\Websites\Limesurvey2019_Org\application\controllers\admin\PluginManagerController.php(743): Survey_Common_Action->_renderWrappedTemplate("pluginmanager", "index", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...), false)
#24
- C:\Websites\Limesurvey2019_Org\application\controllers\admin\PluginManagerController.php(87): PluginManagerController->_renderWrappedTemplate("pluginmanager", "index", array("data" => array(array("id" => "11", "name" => "addScriptToQuestion", "load_error" => null, "description" => "", ...), array("id" => "12", "name" => "arrayTextAdapt", "load_error" => null, "description" => "", ...), array("id" => "2", "name" => "AuditLog", "load_error" => null, "description" => "", ...), array("id" => "1", "name" => "Authdb", "load_error" => null, "description" => "", ...), ...), "plugins" => array(Plugin, Plugin, Plugin, Plugin, ...), "extraMenus" => array(), "pageTitle" => "Plugins", ...))
#25
unknown(0): PluginManagerController->index()
#26
- C:\Websites\Limesurvey2019_Org\framework\web\actions\CAction.php(115): ReflectionMethod->invokeArgs(PluginManagerController, array())
#27
- C:\Websites\Limesurvey2019_Org\application\core\Survey_Common_Action.php(86): CAction->runWithParamsInternal(PluginManagerController, ReflectionMethod, array("r" => "admin/pluginmanager/sa/index", "sa" => "index"))
#28
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(308): Survey_Common_Action->runWithParams(array("r" => "admin/pluginmanager/sa/index", "sa" => "index"))
#29
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(286): CController->runAction(PluginManagerController)
#30
- C:\Websites\Limesurvey2019_Org\framework\web\CController.php(265): CController->runActionWithFilters(PluginManagerController, array())
#31
- C:\Websites\Limesurvey2019_Org\application\controllers\AdminController.php(202): CController->run("pluginmanager")
#32
- C:\Websites\Limesurvey2019_Org\framework\web\CWebApplication.php(282): AdminController->run("pluginmanager")
#33
- C:\Websites\Limesurvey2019_Org\framework\web\CWebApplication.php(141): CWebApplication->runController("admin/pluginmanager/sa/index")
#34
- C:\Websites\Limesurvey2019_Org\framework\base\CApplication.php(185): CWebApplication->processRequest()
#35
- C:\Websites\Limesurvey2019_Org\index.php(192): CApplication->run()
2021-08-16 09:33:03 Microsoft-IIS/10.0 Yii Framework/1.1.24-dev
|
