View Issue Details

IDProjectCategoryView StatusLast Update
15990Bug reportsInstallationpublic2020-03-18 11:10
Reporterkoopmanw Assigned Toollehar  
PrioritynoneSeverityblock 
Status assignedResolutionopen 
Summary15990: Error on attempt to upgrade
Description

Hello

I tried upgrading (from 3.x to the current version) but when trying to go to the login page I get the following request to upgrade the database (Database upgrade
Please verify the following information before continuing with the database upgrade:) (see image: drive.google.com/open?id=1DCj919rjxGeWPXgZXKhm0keH6A88wDJM )(also attached)

Then when I click on "Start database upgrade" I get :
"An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question' in 'field list'

File update_helper.php, line 31.
Please fix this error in your database and try again

Please could you assist?
I can't recall the exact version but it was 3.x

Steps To Reproduce

Install the latest version.
Point the config file to the existing (not new) database.
Get the message above and try to start the database upgrade.

TagsNo tags attached.
Complete LimeSurvey version number (& build)Unsure
I will donate to the project if issue is resolvedNo
BrowserChrome
Database & DB-Version10.3.22-MariaDB-cll-lve
Server OS (if known)Linux
Webserver software & version (if known)Apapche 2.4.41
PHP Version7.1

Activities

koopmanw

koopmanw

2020-03-17 10:57

reporter  

Capture1.JPG (54,720 bytes)   
Capture1.JPG (54,720 bytes)   
ollehar

ollehar

2020-03-17 11:30

administrator   ~56594

What's the "current version"? Top of github master?

ollehar

ollehar

2020-03-17 11:31

administrator   ~56595

Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.

koopmanw

koopmanw

2020-03-17 11:46

reporter   ~56596

Hello Ollehar
In the code
"'debug'=>0,
'debugsql'=>0, // Set this to 1 to enanble sql logging, only active when debug = 2"

How do I set the debug to be to please?

koopmanw

koopmanw

2020-03-17 11:47

reporter   ~56597

"What's the "current version"? Top of github master?"
Busy checking ...

ollehar

ollehar

2020-03-17 11:50

administrator   ~56598

How do I set the debug to be to please?

Just change 0 to 2 and save.

koopmanw

koopmanw

2020-03-17 11:58

reporter   ~56599

CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'question' in 'field list'. The SQL statement executed was: INSERT INTO lime_question_l10ns (qid, question, help, language) select qid, question, help, language from lime_questions

/home/creat145/public_html/surveys/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
#0
– /home/creat145/public_html/surveys/application/helpers/update/updatedb_helper.php(2451): CDbCommand->execute()
2446 'question' => "text NOT NULL",
2447 'help' => "text",
2448 'language' => "string(20) NOT NULL"
2449 ), $options);
2450 $oDB->createCommand()->createIndex('{{idx1_question_l10ns}}', '{{question_l10ns}}', ['qid', 'language'], true);
2451 $oDB->createCommand("INSERT INTO {{question_l10ns}} (qid, question, help, language) select qid, question, help, language from {{questions}}")->execute();
2452 / questions by rename/insert /
2453 if(Yii::app()->db->schema->getTable('{{questions_update400}}')){
2454 $oDB->createCommand()->dropTable('{{questions_update400}}');
2455 }
2456 $oDB->createCommand()->renameTable('{{questions}}', '{{questions_update400}}');
#1
– /home/creat145/public_html/surveys/application/helpers/update/update_helper.php(31): db_upgrade_all(359)
26 Yii::app()->loadHelper('update/updatedb');
27 if (isset($subaction) && $subaction == "yes") {
28 $header = Yii::app()->getController()->_getAdminHeader(false, true);
29 $header = preg_replace('/<###begin###>/', '', $header);
30 echo $header;
31 $result = db_upgrade_all(intval($currentDBVersion));
32 if ($result) {
33 $data =
34 '<div class="jumbotron message-box">'.
35 '<h2 class="">'.gT('Success').'</h2>'.
36 '<p class="lead">'.
#2
– /home/creat145/public_html/surveys/application/controllers/admin/databaseupdate.php(40): CheckForDBUpgrades("yes")
35 public function db($continue = null)
36 {
37 Yii::app()->loadHelper("update/update");
38 $aData = $aViewUrls = [];
39 if (isset($continue) && $continue == "yes") {
40 $aViewUrls['output'] = CheckForDBUpgrades($continue);
41 $aData['display']['header'] = false;
42 } else {
43 $aData['display']['header'] = true;
44 $aViewUrls['output'] = CheckForDBUpgrades();
45 }
#3
unknown(0): databaseupdate->db("yes")
#4
– /home/creat145/public_html/surveys/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(databaseupdate, array("yes"))
104 elseif($param->isDefaultValueAvailable())
105 $ps[]=$param->getDefaultValue();
106 else
107 return false;
108 }
109 $method->invokeArgs($object,$ps);
110 return true;
111 }
112 }
#5
– /home/creat145/public_html/surveys/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal(databaseupdate, ReflectionMethod, array("continue" => "yes", "sa" => "db"))
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
– /home/creat145/public_html/surveys/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("continue" => "yes", "sa" => "db"))
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/creat145/public_html/surveys/framework/web/CController.php(286): CController->runAction(databaseupdate)
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/creat145/public_html/surveys/framework/web/CController.php(265): CController->runActionWithFilters(databaseupdate, 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/creat145/public_html/surveys/application/controllers/AdminController.php(165): CController->run("databaseupdate")
160 }
161
162 $this->runModuleController($action);
163
164
165 return parent::run($action);
166 }
167
168 /

169 Starting with LS4, 3rd party developper can extends any of the LimeSurve controllers.
170
/
#10
– /home/creat145/public_html/surveys/framework/web/CWebApplication.php(282): AdminController->run("databaseupdate")
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)));
#11
– /home/creat145/public_html/surveys/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/databaseupdate/sa/db")
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.
#12
– /home/creat145/public_html/surveys/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 /

#13
– /home/creat145/public_html/surveys/index.php(195): CApplication->run()
190 require_once APPPATH . 'core/LSYii_Application' . EXT;
191
192 $config = require_once(APPPATH . 'config/internal' . EXT);
193
194 Yii::$enableIncludePath = false;
195 Yii::createApplication('LSYii_Application', $config)->run();
196
197 / End of file index.php /
198 / Location: ./index.php /
2020-03-17 10:52:13 Apache Yii Framework/1.1.22-dev

koopmanw

koopmanw

2020-03-17 12:01

reporter   ~56601

Screenshot attached.

errorlog.jpg (1,609,378 bytes)
koopmanw

koopmanw

2020-03-17 12:14

reporter   ~56603

Is this what you're looking for Ollehar?

$config['versionnumber'] = '4.1.10';
$config['dbversionnumber'] = 425;
$config['buildnumber'] = 200311;
$config['updatable'] = true;
$config['templateapiversion'] = 3;
$config['assetsversionnumber'] = '30125';
return $config;

koopmanw

koopmanw

2020-03-17 13:22

reporter   ~56604

Hi Ollehar,
I do appreciate that you are still attempting to debug the issue, thank you.
Here's a question, though. If this should take some time, could I roll back to an earlier installation that will work with the current database in the interim?
We cannot afford to lose access to the data collected with the active surveys (postgraduate students are collecting data as part of their masters and doctoral studies).
If you are able to suggest why the above error is occurring and there is a fix, I shall then re-install the latest version?
Is so, which release will work with the current dB?
Thank you, kindly.

ollehar

ollehar

2020-03-17 13:28

administrator   ~56605

Did you do a backup before upgrading?

ollehar

ollehar

2020-03-17 13:29

administrator   ~56606

If you're not a paying customer you should go to the forum for more feedback.

koopmanw

koopmanw

2020-03-17 13:31

reporter   ~56607

Noted, thanks, Ollehar - I was in the forum and was advised to report this issue as a bug hence my posting it here.
I did a SQL dump of the database before attempting to upgrading - I also saved my uploads folder to a separate location.

ollehar

ollehar

2020-03-17 13:35

administrator   ~56608

OK, then just import your old data into a new database and install LS3 on top of it.

koopmanw

koopmanw

2020-03-17 13:35

reporter   ~56609

Note that I explored whether I can pay for support for the CE version but see that it is limited to comfort update support - comfort update doesn't work at the moment due to the above issue so I could not see the reason to subscribe

ollehar

ollehar

2020-03-17 14:36

administrator   ~56611

One reason to subscribe would be to get paid technical support ;)

koopmanw

koopmanw

2020-03-17 21:54

reporter   ~56622

Indeed, Ollehar.
You know how these things start - A friend needed an online survey for her data collection and then another needed one too and so on.
I shall explore with our university.

koopmanw

koopmanw

2020-03-17 22:13

reporter   ~56623

I have subscribed to a premium package now. Please advise how I request technical support?

koopmanw

koopmanw

2020-03-17 22:35

reporter   ~56624

"OK, then just import your old data into a new database and install LS3 on top of it."
I did that and this is what happened :(

PHP notice
Undefined index: pap-AW

/home/creat145/public_html/surveys/application/helpers/surveytranslator_helper.php(1081)

1069 if (isset($aConversions[$sLocale])) {
1070 $sLocale = $aConversions[$sLocale];
1071 }
1072 return strtolower($sLocale);
1073 }
1074
1075 function getLanguageDataRestricted($bOrderByNative = false, $sDetail = 'full')
1076 {
1077 $aLanguageData = getLanguageData($bOrderByNative);
1078
1079 if (trim(Yii::app()->getConfig('restrictToLanguages')) != '') {
1080 foreach (explode(' ', trim(Yii::app()->getConfig('restrictToLanguages'))) as $key) {
1081 $aResult[$key] = $aLanguageData[$key];
1082 }
1083 } else {
1084 $aResult = $aLanguageData;
1085 }
1086 if ($sDetail == 'short') {
1087 foreach ($aResult as $sKey => $aLanguageData) {
1088 $aNewArray[$sKey] = $aLanguageData['description'];
1089 }
1090 $aResult = $aNewArray;
1091 }
1092 return $aResult;
1093 }
Stack Trace
#0
– /home/creat145/public_html/surveys/application/views/admin/authentication/login.php(86): getLanguageDataRestricted(true)
81 $blockData = $pluginContent[$selectedAuth];
82 / @var $blockData PluginEventContent /
83 echo $blockData->getContent();
84 }
85
86 $aLangList = getLanguageDataRestricted(true);
87 $languageData = array();
88
89 $reqLang = App()->request->getParam('lang');
90 if ($reqLang === null){
91 $languageData['default'] = gT('Default');
#1
– /home/creat145/public_html/surveys/framework/web/CBaseController.php(126): require("/home/creat145/public_html/surveys/application/views/admin/authe...")
121 $data=$data;
122 if($return)
123 {
124 ob_start();
125 ob_implicit_flush(false);
126 require($viewFile);
127 return ob_get_clean();
128 }
129 else
130 require($viewFile);
131 }
#2
– /home/creat145/public_html/surveys/framework/web/CBaseController.php(95): CBaseController->renderInternal("/home/creat145/public_html/surveys/application/views/admin/authe...", array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...), true)
090 {
091 $widgetCount=count($this->_widgetStack);
092 if(($renderer=Yii::app()->getViewRenderer())!==null && $renderer->fileExtension==='.'.CFileHelper::getExtension($viewFile))
093 $content=$renderer->renderFile($this,$viewFile,$data,$return);
094 else
095 $content=$this->renderInternal($viewFile,$data,$return);
096 if(count($this->_widgetStack)===$widgetCount)
097 return $content;
098 else
099 {
100 $widget=end($this->_widgetStack);
#3
– /home/creat145/public_html/surveys/framework/web/CController.php(872): CBaseController->renderFile("/home/creat145/public_html/surveys/application/views/admin/authe...", array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...), true)
867 */
868 public function renderPartial($view,$data=null,$return=false,$processOutput=false)
869 {
870 if(($viewFile=$this->getViewFile($view))!==false)
871 {
872 $output=$this->renderFile($viewFile,$data,true);
873 if($processOutput)
874 $output=$this->processOutput($output);
875 if($return)
876 return $output;
877 else
#4

  • /home/creat145/public_html/surveys/application/core/Survey_Common_Action.php(269): CController->renderPartial("/admin/authentication/login", array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...), true)
    #5
    – /home/creat145/public_html/surveys/application/core/Survey_Common_Action.php(346): Survey_Common_Action->renderCentralContents("authentication", array("login"), array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...))
    341 }
    342 } else {
    343 $renderFile = $basePath.'/'.$sRenderFile;
    344 }
    345
    346 $content = $this->renderCentralContents($sAction, $aViewUrls, $aData);
    347 $out = $this->renderInternal($renderFile, ['content' => $content, 'aData' => $aData], true);
    348
    349 App()->getClientScript()->render($out);
    350 echo $out;
    351 }
    #6
    – /home/creat145/public_html/surveys/application/controllers/admin/authentication.php(361): Survey_Common_Action->_renderWrappedTemplate("authentication", "login", array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...), false)
    356 */
    357 protected function _renderWrappedTemplate($sAction = 'authentication', $aViewUrls = array(), $aData = array(), $sRenderFile = false)
    358 {
    359 $aData['display']['menu_bars'] = false;
    360 $aData['language'] = Yii::app()->getLanguage() != Yii::app()->getConfig("defaultlang") ? Yii::app()->getLanguage() : 'default';
    361 parent::_renderWrappedTemplate($sAction, $aViewUrls, $aData, $sRenderFile);
    362 }
    363
    364 }
    #7
    – /home/creat145/public_html/surveys/application/controllers/admin/authentication.php(82): Authentication->_renderWrappedTemplate("authentication", "login", array("defaultAuth" => "Authdb", "summary" => "Please log in first.", "pluginContent" => array("Authdb" => LimeSurvey\PluginManager\PluginEventContent), "display" => array("menu_bars" => false), ...))
    77
    78 // Neither success nor failure, meaning no form submission - result = template data from plugin
    79 $aData = $result;
    80
    81 // If for any reason, the plugin bugs, we can't let the user with a blank screen.
    82 $this->_renderWrappedTemplate('authentication', 'login', $aData);
    83 }
    84
    85 /
    86 Prepare login and return result
    87
    It checks if the authdb plugin is registered and active
    #8
    unknown(0): Authentication->index()
    #9
    – /home/creat145/public_html/surveys/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Authentication, array())
    104 elseif($param->isDefaultValueAvailable())
    105 $ps[]=$param->getDefaultValue();
    106 else
    107 return false;
    108 }
    109 $method->invokeArgs($object,$ps);
    110 return true;
    111 }
    112 }
    #10
    – /home/creat145/public_html/surveys/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(Authentication, ReflectionMethod, array("sa" => "login"))
    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
    #11
    – /home/creat145/public_html/surveys/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("sa" => "login"))
    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;
    #12
    – /home/creat145/public_html/surveys/framework/web/CController.php(286): CController->runAction(Authentication)
    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();
    #13
    – /home/creat145/public_html/surveys/framework/web/CController.php(265): CController->runActionWithFilters(Authentication, 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);
    #14
    – /home/creat145/public_html/surveys/application/controllers/AdminController.php(158): CController->run("authentication")
    153 $this->redirect(array('/admin/authentication/sa/login'));
    154 }
    155 }
    156 }
    157
    158 return parent::run($action);
    159 }
    160
    161 /
    162 Routes all the actions to their respective places
    163

    #15
    – /home/creat145/public_html/surveys/framework/web/CWebApplication.php(282): AdminController->run("authentication")
    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)));
    #16
    – /home/creat145/public_html/surveys/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/authentication/sa/login")
    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.
    #17
    – /home/creat145/public_html/surveys/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 /*
    #18
    – /home/creat145/public_html/surveys/index.php(194): CApplication->run()
    189 require_once APPPATH . 'core/LSYii_Application' . EXT;
    190
    191 $config = require_once(APPPATH . 'config/internal' . EXT);
    192
    193 Yii::$enableIncludePath = false;
    194 Yii::createApplication('LSYii_Application', $config)->run();
    195
    196 /
    End of file index.php /
    197 /
    Location: ./index.php */
    2020-03-17 21:33:13 Apache Yii Framework/1.1.22-dev
koopmanw

koopmanw

2020-03-17 22:40

reporter   ~56625

I suspect there was a login error with the try above so checked the credentials and attempted to log in again then received this...

CDbException
Table "lime_questions" does not have a column named "language".

/home/creat145/public_html/surveys/framework/db/schema/CDbCommandBuilder.php(697)

685 }
686 else
687 {
688 $conditions[]=$prefix.$column->rawName.'='.self::PARAM_PREFIX.$i;
689 $values[self::PARAM_PREFIX.$i]=$value;
690 $i++;
691 }
692 }
693 else
694 $conditions[]=$prefix.$column->rawName.' IS NULL';
695 }
696 else
697 throw new CDbException(Yii::t('yii','Table "{table}" does not have a column named "{column}".',
698 array('{table}'=>$table->name,'{column}'=>$name)));
699 }
700 $criteria->params=array_merge($values,$criteria->params);
701 if(isset($conditions[0]))
702 {
703 if($criteria->condition!='')
704 $criteria->condition=implode(' AND ',$conditions).' AND ('.$criteria->condition.')';
705 else
706 $criteria->condition=implode(' AND ',$conditions);
707 }
708 return $criteria;
709 }
Stack Trace
#0
– /home/creat145/public_html/surveys/framework/db/ar/CActiveRecord.php(1526): CDbCommandBuilder->createColumnCriteria(CMysqlTableSchema, array("qid" => "9400", "gid" => "582", "sid" => "578569", "language" => "en"), "", array(), ...)
1521 */
1522 public function findByAttributes($attributes,$condition='',$params=array())
1523 {
1524 Yii::trace(get_class($this).'.findByAttributes()','system.db.ar.CActiveRecord');
1525 $prefix=$this->getTableAlias(true).'.';
1526 $criteria=$this->getCommandBuilder()->createColumnCriteria($this->getTableSchema(),$attributes,$condition,$params,$prefix);
1527 return $this->query($criteria);
1528 }
1529
1530 /*
1531
Finds all active records that have the specified attribute values.
#1
– /home/creat145/public_html/surveys/application/controllers/admin/index.php(64): CActiveRecord->findByAttributes(array("qid" => "9400", "gid" => "582", "sid" => "578569", "language" => "en"))
59 $baselang = $survey->language;
60 $aData['showLastQuestion'] = true;
61 $qid = $lastquestion;
62 $gid = $lastquestiongroup;
63 $sid = $lastquestionsid;
64 $qrrow = Question::model()->findByAttributes(array('qid' => $qid, 'gid' => $gid, 'sid' => $sid, 'language' => $baselang));
65 if ($qrrow) {
66 $aData['last_question_name'] = $qrrow['title'];
67 if ($qrrow['question']) {
68 $aData['last_question_name'] .= ' : '.$qrrow['question'];
69 }
#2
unknown(0): Index->run()
#3
– /home/creat145/public_html/surveys/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Index, array())
104 elseif($param->isDefaultValueAvailable())
105 $ps[]=$param->getDefaultValue();
106 else
107 return false;
108 }
109 $method->invokeArgs($object,$ps);
110 return true;
111 }
112 }
#4
– /home/creat145/public_html/surveys/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(Index, ReflectionMethod, array())
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
#5
– /home/creat145/public_html/surveys/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array())
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;
#6
– /home/creat145/public_html/surveys/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();
#7
– /home/creat145/public_html/surveys/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);
#8
– /home/creat145/public_html/surveys/application/controllers/AdminController.php(158): CController->run("")
153 $this->redirect(array('/admin/authentication/sa/login'));
154 }
155 }
156 }
157
158 return parent::run($action);
159 }
160
161 /

162 Routes all the actions to their respective places
163

#9
– /home/creat145/public_html/surveys/framework/web/CWebApplication.php(282): AdminController->run("")
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/creat145/public_html/surveys/framework/web/CWebApplication.php(141): CWebApplication->runController("admin")
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/creat145/public_html/surveys/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/creat145/public_html/surveys/index.php(194): CApplication->run()
189 require_once APPPATH . 'core/LSYii_Application' . EXT;
190
191 $config = require_once(APPPATH . 'config/internal' . EXT);
192
193 Yii::$enableIncludePath = false;
194 Yii::createApplication('LSYii_Application', $config)->run();
195
196 / End of file index.php /
197 / Location: ./index.php /
2020-03-17 21:37:44 Apache Yii Framework/1.1.22-dev

ollehar

ollehar

2020-03-18 10:10

administrator   ~56630

I have subscribed to a premium package now. Please advise how I request technical support?

That's great! What you do is login to limesurvey.org and then go to support to file a support ticket. Please link this issue in your text. You can mark it as "Emergency". ;)

https://www.limesurvey.org/support

ollehar

ollehar

2020-03-18 10:14

administrator   ~56631

First thing I want you to do is to clear the Yii runtime cache. Run rm -r tmp/runtime/* from your web root folder.

ollehar

ollehar

2020-03-18 10:17

administrator   ~56632

Oh, and if you get "PHP Notice" message, please try to set debug = 0 and try again.

koopmanw

koopmanw

2020-03-18 11:10

reporter   ~56634

Ok - will try that but I have also logged a ticket. Ticket reference number:LS-RIPO-SJZZ-ZLAJ
I don't want to cause you and Carsten to be working at cross-purposes :)

Issue History

Date Modified Username Field Change
2020-03-17 10:57 koopmanw New Issue
2020-03-17 10:57 koopmanw File Added: Capture1.JPG
2020-03-17 11:30 ollehar Note Added: 56594
2020-03-17 11:31 ollehar Note Added: 56595
2020-03-17 11:31 ollehar Status new => feedback
2020-03-17 11:46 koopmanw Note Added: 56596
2020-03-17 11:46 koopmanw Status feedback => new
2020-03-17 11:47 koopmanw Note Added: 56597
2020-03-17 11:50 ollehar Note Added: 56598
2020-03-17 11:58 koopmanw Note Added: 56599
2020-03-17 12:01 koopmanw File Added: errorlog.jpg
2020-03-17 12:01 koopmanw Note Added: 56601
2020-03-17 12:14 koopmanw Note Added: 56603
2020-03-17 13:22 koopmanw Note Added: 56604
2020-03-17 13:28 ollehar Note Added: 56605
2020-03-17 13:29 ollehar Note Added: 56606
2020-03-17 13:31 koopmanw Note Added: 56607
2020-03-17 13:35 ollehar Note Added: 56608
2020-03-17 13:35 koopmanw Note Added: 56609
2020-03-17 14:36 ollehar Note Added: 56611
2020-03-17 21:54 koopmanw Note Added: 56622
2020-03-17 22:13 koopmanw Note Added: 56623
2020-03-17 22:35 koopmanw Note Added: 56624
2020-03-17 22:40 koopmanw Note Added: 56625
2020-03-18 10:10 ollehar Note Added: 56630
2020-03-18 10:10 ollehar Assigned To => ollehar
2020-03-18 10:10 ollehar Status new => assigned
2020-03-18 10:10 ollehar Severity partial_block => block
2020-03-18 10:10 ollehar Description Updated View Revisions
2020-03-18 10:10 ollehar Steps to Reproduce Updated View Revisions
2020-03-18 10:14 ollehar Note Added: 56631
2020-03-18 10:17 ollehar Note Added: 56632
2020-03-18 11:10 koopmanw Note Added: 56634