View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06867 | Bug reports | Other | public | 2012-11-14 09:54 | 2012-11-16 10:40 |
Reporter | rolandr | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.00+ | ||||
Fixed in Version | 2.00+ | ||||
Summary | 06867: modification of user and survey rights result in an error | ||||
Description | i installed limesurvey200plus without any problems, i did the update to the newest version. i started to do a test-survey and added one survey-admin. i've two problems now, both have to do with right management. first, i cannot set "global rights" for the user i added. when doing so, i get "Error executing query in dbSelectLimitAssoc:SELECT uid FROM lime_users WHERE parent_id=0". second, when changing survey rights i receive the following "Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute." everything else works normally as far as i tested it now. | ||||
Steps To Reproduce | user rights: when clicking on the "set global rights for this user" padlock icon the error results as mentioned above. survey rights: when clicking on the "set survey rights" padlock icon the error results as mentioned above. | ||||
Additional Information | i attached a phpinfo excerpt as pdf. | ||||
Tags | No tags attached. | ||||
Attached Files | debug2.txt (10,280 bytes)
CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.. The SQL statement executed was: SELECT * FROM lime_users ORDER BY uid /var/www/html/survey/framework/db/CDbCommand.php(528) 516 return $result; 517 } 518 catch(Exception $e) 519 { 520 if($this->_connection->enableProfiling) 521 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 522 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 523 $message = $e->getMessage(); 524 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 525 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 526 if(YII_DEBUG) 527 $message .= '. The SQL statement executed was: '.$this->getText().$par; 528 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 529 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 530 } 531 } 532 533 /** 534 * Builds a SQL SELECT statement from the given query specification. 535 * @param array $query the query specification in name-value pairs. The following 536 * query options are supported: {@link select}, {@link distinct}, {@link from}, 537 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 538 * {@link limit}, {@link offset} and {@link union}. 539 * @return string the SQL statement 540 * @since 1.1.6 Stack Trace #0 � /var/www/html/survey/framework/db/CDbCommand.php(372): CDbCommand->queryInternal("", 0, array()) 367 * @return CDbDataReader the reader object for fetching the query result 368 * @throws CException execution failed 369 */ 370 public function query($params=array()) 371 { 372 return $this->queryInternal('',0,$params); 373 } 374 375 /** 376 * Executes the SQL statement and returns all rows. 377 * @param boolean $fetchAssociative whether each row should be returned as an associated array with #1 � /var/www/html/survey/application/helpers/common_helper.php(1342): CDbCommand->query() 1337 else 1338 { 1339 $uquery = "SELECT * FROM {{users}} ORDER BY uid"; 1340 } 1341 1342 $uresult = Yii::app()->db->createCommand($uquery)->query()->readAll(); //Checked 1343 1344 if (count($uresult)==0) 1345 //user is not in a group and usercontrolSameGroupPolicy is activated - at least show his own userinfo 1346 { 1347 $uquery = "SELECT u.* FROM {{users}} AS u WHERE u.uid=".$myuid; #2 � /var/www/html/survey/application/helpers/common_helper.php(7561): getUserList() 7556 $surveyselecter = ""; 7557 7558 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == true) 7559 { 7560 7561 $authorizedUsersList = getUserList('onlyuidarray'); 7562 } 7563 7564 foreach($surveyidresult->readAll() as $sv) 7565 { 7566 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == false || #3 � /var/www/html/survey/application/controllers/admin/surveypermission.php(169): getSurveyUserList() 164 165 $surveysecurity .= "</tbody>\n" 166 . "</table>\n" 167 . "<form class='form44' action='".$this->getController()->createUrl('admin/surveypermission/adduser/surveyid/'.$surveyid)."' method='post'><ul>\n" 168 . "<li><label for='uidselect'>".$clang->gT("User").": </label><select id='uidselect' name='uid'>\n" 169 . getSurveyUserList(false,false,$surveyid) 170 . "</select>\n" 171 . "<input style='width: 15em;' type='submit' value='".$clang->gT("Add User")."' onclick=\"if (document.getElementById('uidselect').value == -1) { alert('".$clang->gT("Please select a user first","js")."'); return false;}\"/>" 172 . "<input type='hidden' name='action' value='addsurveysecurity' />" 173 . "</li></ul></form>\n" 174 . "<form class='form44' action='".$this->getController()->createUrl('admin/surveypermission/addusergroup/surveyid/'.$surveyid)."' method='post'><ul><li>\n" #4 unknown(0): surveypermission->index("onlyuidarray") #5 � /var/www/html/survey/framework/web/actions/CAction.php(107): ReflectionMethod->invokeArgs(false, false, "428269") 102 else if($param->isDefaultValueAvailable()) 103 $ps[]=$param->getDefaultValue(); 104 else 105 return false; 106 } 107 $method->invokeArgs($object,$ps); 108 return true; 109 } 110 } #6 � /var/www/html/survey/application/core/Survey_Common_Action.php(82): CAction->runWithParamsInternal("428269") 77 $oMethod = new ReflectionMethod($this, $sDefault); 78 } 79 80 // We're all good to go, let's execute it 81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 82 return parent::runWithParamsInternal($this, $oMethod, $params); 83 } 84 85 /** 86 * Some functions have different parameters, which are just an alias of the 87 * usual parameters we're getting in the url. This function just populates #7 � /var/www/html/survey/framework/web/CController.php(309): Survey_Common_Action->runWithParams(surveypermission, array("428269")) 304 { 305 $priorAction=$this->_action; 306 $this->_action=$action; 307 if($this->beforeAction($action)) 308 { 309 if($action->runWithParams($this->getActionParams())===false) 310 $this->invalidActionParams($action); 311 else 312 $this->afterAction($action); 313 } 314 $this->_action=$priorAction; #8 � /var/www/html/survey/framework/web/CController.php(287): CController->runAction(surveypermission, ReflectionMethod, array("surveyid" => "428269", "sa" => "view", "iSurveyId" => "428269", "iSurveyID" => "428269")) 282 * @see runAction 283 */ 284 public function runActionWithFilters($action,$filters) 285 { 286 if(empty($filters)) 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); #9 � /var/www/html/survey/framework/web/CController.php(266): CController->runActionWithFilters(array("surveyid" => "428269", "sa" => "view")) 261 { 262 if(($parent=$this->getModule())===null) 263 $parent=Yii::app(); 264 if($parent->beforeControllerAction($this,$action)) 265 { 266 $this->runActionWithFilters($action,$this->filters()); 267 $parent->afterControllerAction($this,$action); 268 } 269 } 270 else 271 $this->missingAction($actionID); #10 � /var/www/html/survey/application/controllers/AdminController.php(159): CController->run(surveypermission) 154 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri; 155 156 $this->redirect($this->createUrl('/admin/authentication/login')); 157 } 158 159 return parent::run($action); 160 } 161 162 /** 163 * Routes all the actions to their respective places 164 * #11 � /var/www/html/survey/framework/web/CWebApplication.php(276): AdminController->run(surveypermission, array()) 271 { 272 list($controller,$actionID)=$ca; 273 $oldController=$this->_controller; 274 $this->_controller=$controller; 275 $controller->init(); 276 $controller->run($actionID); 277 $this->_controller=$oldController; 278 } 279 else 280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 281 array('{route}'=>$route===''?$this->defaultController:$route))); #12 � /var/www/html/survey/framework/web/CWebApplication.php(135): CWebApplication->runController("surveypermission") 130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 131 $_GET[$name]=$value; 132 } 133 else 134 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 135 $this->runController($route); 136 } 137 138 /** 139 * Registers the core application components. 140 * This method overrides the parent implementation by registering additional core components. #13 � /var/www/html/survey/framework/base/CApplication.php(162): CWebApplication->processRequest("surveypermission") 157 */ 158 public function run() 159 { 160 if($this->hasEventHandler('onBeginRequest')) 161 $this->onBeginRequest(new CEvent($this)); 162 $this->processRequest(); 163 if($this->hasEventHandler('onEndRequest')) 164 $this->onEndRequest(new CEvent($this)); 165 } 166 167 /** #14 � /var/www/html/survey/index.php(178): CApplication->run("admin/surveypermission/sa/view") 173 * 174 */ 175 require_once BASEPATH . 'yii' . EXT; 176 require_once APPPATH . 'core/LSYii_Application' . EXT; 177 178 Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run(); 179 180 /* End of file index.php */ 181 /* Location: ./index.php */ 2012-11-14 11:32:44 Apache Yii Framework/1.1.10 debug2_after_changeset.txt (10,779 bytes)
CDbException CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.. The SQL statement executed was: SELECT a.ugid, a.name, a.owner_id, b.uid FROM lime_user_groups AS a LEFT JOIN lime_user_in_groups AS b ON a.ugid = b.ugid WHERE uid = 1 ORDER BY name /var/www/html/survey/framework/db/CDbCommand.php(528) 516 return $result; 517 } 518 catch(Exception $e) 519 { 520 if($this->_connection->enableProfiling) 521 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 522 $errorInfo = $e instanceof PDOException ? $e->errorInfo : null; 523 $message = $e->getMessage(); 524 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 525 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 526 if(YII_DEBUG) 527 $message .= '. The SQL statement executed was: '.$this->getText().$par; 528 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 529 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 530 } 531 } 532 533 /** 534 * Builds a SQL SELECT statement from the given query specification. 535 * @param array $query the query specification in name-value pairs. The following 536 * query options are supported: {@link select}, {@link distinct}, {@link from}, 537 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 538 * {@link limit}, {@link offset} and {@link union}. 539 * @return string the SQL statement 540 * @since 1.1.6 Stack Trace #0 � /var/www/html/survey/framework/db/CDbCommand.php(372): CDbCommand->queryInternal("", 0, array()) 367 * @return CDbDataReader the reader object for fetching the query result 368 * @throws CException execution failed 369 */ 370 public function query($params=array()) 371 { 372 return $this->queryInternal('',0,$params); 373 } 374 375 /** 376 * Executes the SQL statement and returns all rows. 377 * @param boolean $fetchAssociative whether each row should be returned as an associated array with #1 � /var/www/html/survey/application/helpers/common_helper.php(7130): CDbCommand->query() 7125 { 7126 $clang = Yii::app()->lang; 7127 //$squery = "SELECT ugid, name FROM ".db_table_name('user_groups') ." WHERE owner_id = {Yii::app()->session['loginID']} ORDER BY name"; 7128 $squery = "SELECT a.ugid, a.name, a.owner_id, b.uid FROM {{user_groups}} AS a LEFT JOIN {{user_in_groups}} AS b ON a.ugid = b.ugid WHERE uid = ".Yii::app()->session['loginID']." ORDER BY name"; 7129 7130 $sresult = Yii::app()->db->createCommand($squery)->query(); //Checked 7131 if (!$sresult) {return "Database Error";} 7132 $selecter = ""; 7133 foreach ($sresult->readAll() as $row) 7134 { 7135 $groupnames[] = $row; #2 � /var/www/html/survey/application/helpers/common_helper.php(7610): getUserGroupList() 7605 7606 $surveyselecter = ""; 7607 7608 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == true) 7609 { 7610 $authorizedGroupsList=getUserGroupList(NULL, 'simplegidarray'); 7611 } 7612 7613 foreach($surveyidresult->readAll() as $sv) 7614 { 7615 if (Yii::app()->getConfig('usercontrolSameGroupPolicy') == false || #3 � /var/www/html/survey/application/controllers/admin/surveypermission.php(176): getSurveyUserGroupList() 171 . "<input style='width: 15em;' type='submit' value='".$clang->gT("Add User")."' onclick=\"if (document.getElementById('uidselect').value == -1) { alert('".$clang->gT("Please select a user first","js")."'); return false;}\"/>" 172 . "<input type='hidden' name='action' value='addsurveysecurity' />" 173 . "</li></ul></form>\n" 174 . "<form class='form44' action='".$this->getController()->createUrl('admin/surveypermission/addusergroup/surveyid/'.$surveyid)."' method='post'><ul><li>\n" 175 . "<label for='ugidselect'>".$clang->gT("Groups").": </label><select id='ugidselect' name='ugid'>\n" 176 . getSurveyUserGroupList('htmloptions',$surveyid) 177 . "</select>\n" 178 . "<input style='width: 15em;' type='submit' value='".$clang->gT("Add user group")."' onclick=\"if (document.getElementById('ugidselect').value == -1) { alert('".$clang->gT("Please select a user group first","js")."'); return false;}\" />" 179 . "<input type='hidden' name='action' value='addusergroupsurveysecurity' />\n" 180 . "</li></ul></form>"; 181 #4 unknown(0): surveypermission->index(null, "simplegidarray") #5 � /var/www/html/survey/framework/web/actions/CAction.php(107): ReflectionMethod->invokeArgs("htmloptions", "428269") 102 else if($param->isDefaultValueAvailable()) 103 $ps[]=$param->getDefaultValue(); 104 else 105 return false; 106 } 107 $method->invokeArgs($object,$ps); 108 return true; 109 } 110 } #6 � /var/www/html/survey/application/core/Survey_Common_Action.php(82): CAction->runWithParamsInternal("428269") 77 $oMethod = new ReflectionMethod($this, $sDefault); 78 } 79 80 // We're all good to go, let's execute it 81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 82 return parent::runWithParamsInternal($this, $oMethod, $params); 83 } 84 85 /** 86 * Some functions have different parameters, which are just an alias of the 87 * usual parameters we're getting in the url. This function just populates #7 � /var/www/html/survey/framework/web/CController.php(309): Survey_Common_Action->runWithParams(surveypermission, array("428269")) 304 { 305 $priorAction=$this->_action; 306 $this->_action=$action; 307 if($this->beforeAction($action)) 308 { 309 if($action->runWithParams($this->getActionParams())===false) 310 $this->invalidActionParams($action); 311 else 312 $this->afterAction($action); 313 } 314 $this->_action=$priorAction; #8 � /var/www/html/survey/framework/web/CController.php(287): CController->runAction(surveypermission, ReflectionMethod, array("surveyid" => "428269", "sa" => "view", "iSurveyId" => "428269", "iSurveyID" => "428269")) 282 * @see runAction 283 */ 284 public function runActionWithFilters($action,$filters) 285 { 286 if(empty($filters)) 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); #9 � /var/www/html/survey/framework/web/CController.php(266): CController->runActionWithFilters(array("surveyid" => "428269", "sa" => "view")) 261 { 262 if(($parent=$this->getModule())===null) 263 $parent=Yii::app(); 264 if($parent->beforeControllerAction($this,$action)) 265 { 266 $this->runActionWithFilters($action,$this->filters()); 267 $parent->afterControllerAction($this,$action); 268 } 269 } 270 else 271 $this->missingAction($actionID); #10 � /var/www/html/survey/application/controllers/AdminController.php(159): CController->run(surveypermission) 154 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri; 155 156 $this->redirect($this->createUrl('/admin/authentication/login')); 157 } 158 159 return parent::run($action); 160 } 161 162 /** 163 * Routes all the actions to their respective places 164 * #11 � /var/www/html/survey/framework/web/CWebApplication.php(276): AdminController->run(surveypermission, array()) 271 { 272 list($controller,$actionID)=$ca; 273 $oldController=$this->_controller; 274 $this->_controller=$controller; 275 $controller->init(); 276 $controller->run($actionID); 277 $this->_controller=$oldController; 278 } 279 else 280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 281 array('{route}'=>$route===''?$this->defaultController:$route))); #12 � /var/www/html/survey/framework/web/CWebApplication.php(135): CWebApplication->runController("surveypermission") 130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 131 $_GET[$name]=$value; 132 } 133 else 134 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 135 $this->runController($route); 136 } 137 138 /** 139 * Registers the core application components. 140 * This method overrides the parent implementation by registering additional core components. #13 � /var/www/html/survey/framework/base/CApplication.php(162): CWebApplication->processRequest("surveypermission") 157 */ 158 public function run() 159 { 160 if($this->hasEventHandler('onBeginRequest')) 161 $this->onBeginRequest(new CEvent($this)); 162 $this->processRequest(); 163 if($this->hasEventHandler('onEndRequest')) 164 $this->onEndRequest(new CEvent($this)); 165 } 166 167 /** #14 � /var/www/html/survey/index.php(178): CApplication->run("admin/surveypermission/sa/view") 173 * 174 */ 175 require_once BASEPATH . 'yii' . EXT; 176 require_once APPPATH . 'core/LSYii_Application' . EXT; 177 178 Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run(); 179 180 /* End of file index.php */ 181 /* Location: ./index.php */ 2012-11-14 12:17:12 Apache Yii Framework/1.1.10 debug2_after_changeset2.txt (8,493 bytes)
CDbException The table "{{survey_permissions}}" for active record class "Survey_permissions" cannot be found in the database. /var/www/html/survey/framework/db/ar/CActiveRecord.php(2264) 2252 private $_model; 2253 2254 /** 2255 * Constructor. 2256 * @param CActiveRecord $model the model instance 2257 */ 2258 public function __construct($model) 2259 { 2260 $this->_model=$model; 2261 2262 $tableName=$model->tableName(); 2263 if(($table=$model->getDbConnection()->getSchema()->getTable($tableName))===null) 2264 throw new CDbException(Yii::t('yii','The table "{table}" for active record class "{class}" cannot be found in the database.', 2265 array('{class}'=>get_class($model),'{table}'=>$tableName))); 2266 if($table->primaryKey===null) 2267 { 2268 $table->primaryKey=$model->primaryKey(); 2269 if(is_string($table->primaryKey) && isset($table->columns[$table->primaryKey])) 2270 $table->columns[$table->primaryKey]->isPrimaryKey=true; 2271 else if(is_array($table->primaryKey)) 2272 { 2273 foreach($table->primaryKey as $name) 2274 { 2275 if(isset($table->columns[$name])) 2276 $table->columns[$name]->isPrimaryKey=true; Stack Trace #0 � /var/www/html/survey/framework/db/ar/CActiveRecord.php(379): CActiveRecordMetaData->__construct(Survey_permissions) 374 if(isset(self::$_models[$className])) 375 return self::$_models[$className]; 376 else 377 { 378 $model=self::$_models[$className]=new $className(null); 379 $model->_md=new CActiveRecordMetaData($model); 380 $model->attachBehaviors($model->behaviors()); 381 return $model; 382 } 383 } 384 #1 � /var/www/html/survey/application/models/Survey_permissions.php(50): CActiveRecord::model("Survey_permissions") 45 * @param string $class 46 * @return CActiveRecord 47 */ 48 public static function model($class = __CLASS__) 49 { 50 return parent::model($class); 51 } 52 53 /** 54 * Returns the base permissions 55 * #2 � /var/www/html/survey/application/controllers/admin/surveypermission.php(408): Survey_permissions::model() 403 . "<th class='extended'>".$clang->gT("Import")."</th>\n" 404 . "<th class='extended'>".$clang->gT("Export")."</th>\n" 405 . "</tr></thead>\n"; 406 407 //content 408 $aBasePermissions=Survey_permissions::model()->getBasePermissions(); 409 410 $oddcolumn=false; 411 foreach($aBasePermissions as $sPermissionKey=>$aCRUDPermissions) 412 { 413 $oddcolumn=!$oddcolumn; #3 unknown(0): surveypermission->set("428269") #4 � /var/www/html/survey/framework/web/actions/CAction.php(107): ReflectionMethod->invokeArgs(surveypermission, array("428269")) 102 else if($param->isDefaultValueAvailable()) 103 $ps[]=$param->getDefaultValue(); 104 else 105 return false; 106 } 107 $method->invokeArgs($object,$ps); 108 return true; 109 } 110 } #5 � /var/www/html/survey/application/core/Survey_Common_Action.php(82): CAction->runWithParamsInternal(surveypermission, ReflectionMethod, array("surveyid" => "428269", "sa" => "set", "iSurveyId" => "428269", "iSurveyID" => "428269")) 77 $oMethod = new ReflectionMethod($this, $sDefault); 78 } 79 80 // We're all good to go, let's execute it 81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params 82 return parent::runWithParamsInternal($this, $oMethod, $params); 83 } 84 85 /** 86 * Some functions have different parameters, which are just an alias of the 87 * usual parameters we're getting in the url. This function just populates #6 � /var/www/html/survey/framework/web/CController.php(309): Survey_Common_Action->runWithParams(array("surveyid" => "428269", "sa" => "set")) 304 { 305 $priorAction=$this->_action; 306 $this->_action=$action; 307 if($this->beforeAction($action)) 308 { 309 if($action->runWithParams($this->getActionParams())===false) 310 $this->invalidActionParams($action); 311 else 312 $this->afterAction($action); 313 } 314 $this->_action=$priorAction; #7 � /var/www/html/survey/framework/web/CController.php(287): CController->runAction(surveypermission) 282 * @see runAction 283 */ 284 public function runActionWithFilters($action,$filters) 285 { 286 if(empty($filters)) 287 $this->runAction($action); 288 else 289 { 290 $priorAction=$this->_action; 291 $this->_action=$action; 292 CFilterChain::create($this,$action,$filters)->run(); #8 � /var/www/html/survey/framework/web/CController.php(266): CController->runActionWithFilters(surveypermission, array()) 261 { 262 if(($parent=$this->getModule())===null) 263 $parent=Yii::app(); 264 if($parent->beforeControllerAction($this,$action)) 265 { 266 $this->runActionWithFilters($action,$this->filters()); 267 $parent->afterControllerAction($this,$action); 268 } 269 } 270 else 271 $this->missingAction($actionID); #9 � /var/www/html/survey/application/controllers/AdminController.php(159): CController->run("surveypermission") 154 Yii::app()->session['redirectopage'] = Yii::app()->request->requestUri; 155 156 $this->redirect($this->createUrl('/admin/authentication/login')); 157 } 158 159 return parent::run($action); 160 } 161 162 /** 163 * Routes all the actions to their respective places 164 * #10 � /var/www/html/survey/framework/web/CWebApplication.php(276): AdminController->run("surveypermission") 271 { 272 list($controller,$actionID)=$ca; 273 $oldController=$this->_controller; 274 $this->_controller=$controller; 275 $controller->init(); 276 $controller->run($actionID); 277 $this->_controller=$oldController; 278 } 279 else 280 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 281 array('{route}'=>$route===''?$this->defaultController:$route))); #11 � /var/www/html/survey/framework/web/CWebApplication.php(135): CWebApplication->runController("admin/surveypermission/sa/set") 130 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 131 $_GET[$name]=$value; 132 } 133 else 134 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 135 $this->runController($route); 136 } 137 138 /** 139 * Registers the core application components. 140 * This method overrides the parent implementation by registering additional core components. #12 � /var/www/html/survey/framework/base/CApplication.php(162): CWebApplication->processRequest() 157 */ 158 public function run() 159 { 160 if($this->hasEventHandler('onBeginRequest')) 161 $this->onBeginRequest(new CEvent($this)); 162 $this->processRequest(); 163 if($this->hasEventHandler('onEndRequest')) 164 $this->onEndRequest(new CEvent($this)); 165 } 166 167 /** #13 � /var/www/html/survey/index.php(178): CApplication->run() 173 * 174 */ 175 require_once BASEPATH . 'yii' . EXT; 176 require_once APPPATH . 'core/LSYii_Application' . EXT; 177 178 Yii::createApplication('LSYii_Application', APPPATH . 'config/config' . EXT)->run(); 179 180 /* End of file index.php */ 181 /* Location: ./index.php */ 2012-11-14 16:32:24 Apache Yii Framework/1.1.10 | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 121113 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | browser-independent | ||||
Database type & version | MySQL 4.1.21 | ||||
Server OS (if known) | Linux RedHat | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | PHP Version 5.2.0 | ||||
Set debug to 2 in /application/config/config.php and let me know the detailed error on the 2nd issue. |
|
please see debug2.txt for exception information |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10285 |
|
Thank you very much. That helped alot. This issue seem only to happen on a very minor number of system (I am not able to reproduce it here). However based on the error message I created a patch (see the changeset below) |
|
thank you. unfortunately the 2 patches don't resolve the error on both issues. i added a debug information. |
|
rolandr: well the issue is resolved, but it seems there are more. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10287 |
|
thank you for the patch. we are getting closer. now i can add a user or group. but when i try to edit the rights i result in an error again. debug info can be found under "debug2_after_changeset2.txt". i tried to generate a ebug trace for the global user rights problem, but it only tells me the known error - "Error executing query in dbSelectLimitAssoc:SELECT uid FROM lime_users WHERE parent_id=0" Setze Benutzerrechte:ulrike. is there any way i can generate a meaningful debug info for you? |
|
Your installation seems to be missing a table 'survey_permissions' for whatever reasons. You will need to create it manually with an according prefix: run this statement on your database (assuming that your table prefix is lime_): CREATE TABLE IF NOT EXISTS then try again. |
|
i checked and found out that the table is not missing. i installed the survey in a seperate database only for the survey but i didn't delete the prefix "lime_" during db-installation. i thought the installation routine examines if db is empty there is no use of the prefix. i hope this info helps. |
|
I am sorry but that is what the error message says: The table "{{survey_permissions}}" for active record class "Survey_permissions" cannot be found in the database. so however you have configured your prefix and database the related table is definitely missing. |
|
i created the table as you mentioned above. the resulting error is the same. as you i was wondering due to the fact that i checked the db via phpadmin relating to the error message given and realised that the "missing" table is there. sorry for bringing you a headache about this! |
|
As said, if the error message says the table is missing then it is still missing. |
|
i know it sounds weired. but it is fact. |
|
fact is also that when i'm adding a user to the survey rights the table "lime_survey_permissions" is accessed and data is written to it. when clicking on the pencil-icon to modify the rights of a user it tells us the table cannot be found. |
|
Please send access data for LimeSurvey, phpMyAdmin and FTP to (email address removed) |
|
rolandr? |
|
info is on it's way to you |
|
ftp data is sent to you |
|
Ok, thank you for the debug access - the issue is resolved now. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10296 |
|
carsten, well done. thank you very much indeed! donation is on it's way. |
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10309 |
|
Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10311 |
|
New version 2.00+ Build 121116 released |
|
LimeSurvey: master 0d327a50 2012-11-14 11:17 Details Diff |
Fixed issue 06867: Modification of user and survey rights results in an error |
Affected Issues 06867 |
|
mod - application/controllers/admin/usergroups.php | Diff File | ||
mod - application/helpers/common_helper.php | Diff File | ||
LimeSurvey: master 1e81f440 2012-11-14 12:36 Details Diff |
Fixed issue 06867: Modification of user and survey rights results in an error |
Affected Issues 06867 |
|
mod - application/helpers/common_helper.php | Diff File | ||
LimeSurvey: master 020ae9ec 2012-11-15 14:44 Details Diff |
Fixed issue 06867: Modification of user and survey rights results in an error |
Affected Issues 06867 |
|
mod - application/controllers/admin/surveypermission.php | Diff File | ||
mod - application/views/admin/user/setuserrights.php | Diff File | ||
LimeSurvey: 2.1 61f311d2 2012-11-15 20:40 Details Diff |
Fixed issue 06867: Modification of user and survey rights results in an error Fixed issue 06869: Status icon broken / not shown on list of active survey with start date set |
Affected Issues 06867, 06869 |
|
mod - application/controllers/admin/surveyadmin.php | Diff File | ||
mod - application/controllers/admin/usergroups.php | Diff File | ||
mod - application/helpers/common_helper.php | Diff File | ||
LimeSurvey: 2.1 07d8e30d 2012-11-15 20:46 Details Diff |
Fixed issue 06867: Modification of user and survey rights results in an error |
Affected Issues 06867 |
|
mod - application/controllers/admin/surveypermission.php | Diff File | ||
mod - application/views/admin/user/setuserrights.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2012-11-14 09:54 | rolandr | New Issue | |
2012-11-14 09:54 | rolandr | File Added: phpinfo.pdf | |
2012-11-14 11:13 | c_schmitz | Note Added: 22138 | |
2012-11-14 11:13 | c_schmitz | Assigned To | => c_schmitz |
2012-11-14 11:13 | c_schmitz | Status | new => feedback |
2012-11-14 11:36 | rolandr | File Added: debug2.txt | |
2012-11-14 11:37 | rolandr | Note Added: 22140 | |
2012-11-14 11:37 | rolandr | Status | feedback => assigned |
2012-11-14 11:51 | c_schmitz | Changeset attached | => LimeSurvey master 0d327a50 |
2012-11-14 11:51 | c_schmitz | Note Added: 22141 | |
2012-11-14 11:51 | c_schmitz | Resolution | open => fixed |
2012-11-14 11:52 | c_schmitz | Note Added: 22142 | |
2012-11-14 11:52 | c_schmitz | Status | assigned => feedback |
2012-11-14 12:19 | rolandr | File Added: debug2_after_changeset.txt | |
2012-11-14 12:20 | rolandr | Note Added: 22143 | |
2012-11-14 12:20 | rolandr | Status | feedback => assigned |
2012-11-14 12:25 | c_schmitz | Note Added: 22144 | |
2012-11-14 13:16 | c_schmitz | Status | assigned => feedback |
2012-11-14 14:34 | c_schmitz | Changeset attached | => LimeSurvey master 1e81f440 |
2012-11-14 14:34 | c_schmitz | Note Added: 22147 | |
2012-11-14 16:38 | rolandr | File Added: debug2_after_changeset2.txt | |
2012-11-14 16:44 | rolandr | Note Added: 22160 | |
2012-11-14 16:44 | rolandr | Status | feedback => assigned |
2012-11-14 19:58 | c_schmitz | Note Added: 22161 | |
2012-11-14 20:08 | rolandr | Note Added: 22162 | |
2012-11-14 20:09 | rolandr | File Added: dump_limesurvey.sql | |
2012-11-14 20:18 | c_schmitz | Note Added: 22163 | |
2012-11-14 21:48 | rolandr | Note Added: 22164 | |
2012-11-14 21:57 | c_schmitz | Note Added: 22165 | |
2012-11-14 22:09 | rolandr | Note Added: 22166 | |
2012-11-14 22:23 | rolandr | Note Added: 22167 | |
2012-11-14 22:38 | c_schmitz | Note Added: 22168 | |
2012-11-15 09:20 | c_schmitz | Note View State: 22168: public | |
2012-11-15 09:20 | c_schmitz | Note Added: 22176 | |
2012-11-15 09:57 | rolandr | Note Added: 22177 | |
2012-11-15 10:34 | rolandr | Note Added: 22178 | |
2012-11-15 14:45 | c_schmitz | Note Added: 22182 | |
2012-11-15 14:45 | c_schmitz | Status | assigned => resolved |
2012-11-15 14:45 | c_schmitz | Fixed in Version | => 2.00+ |
2012-11-15 14:46 | c_schmitz | Changeset attached | => LimeSurvey master 020ae9ec |
2012-11-15 14:46 | c_schmitz | Note Added: 22183 | |
2012-11-15 16:36 | rolandr | Note Added: 22190 | |
2012-11-15 20:41 | c_schmitz | Changeset attached | => LimeSurvey 2.1 61f311d2 |
2012-11-15 20:41 | c_schmitz | Note Added: 22205 | |
2012-11-15 20:48 | c_schmitz | Changeset attached | => LimeSurvey 2.1 07d8e30d |
2012-11-15 20:48 | c_schmitz | Note Added: 22208 | |
2012-11-16 10:40 | c_schmitz | Note Added: 22245 | |
2012-11-16 10:40 | c_schmitz | Status | resolved => closed |