Hi,
I am newbie in Yii. And during installation of Yii extension User Management but during this I am getting this error. Please help me I am not getting installation page. I have followed all steps given in tutorial.
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘testdrive.translation’ doesn’t exist. The SQL statement executed was: select message, translation from translation where language = :language and category = :category
/opt/lampp/htdocs/yii/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
- /opt/lampp/htdocs/yii/framework/db/CDbCommand.php(390): CDbCommand->queryInternal("fetchAll", array(2), array())
#1
– /opt/lampp/htdocs/mydemo/protected/modules/user/models/Yum.php(131): CDbCommand->queryAll()
126 $command=Yii::app()->db->createCommand($sql);
127 $command->bindValue(’:category’,$category);
128 $command->bindValue(’:language’,$language);
129
130 $messages=array();
131 foreach($command->queryAll() as $row)
132 $messages[$row[‘message’]]=$row[‘translation’];
133 }
134
135 if(Yii::app()->cache)
136 Yii::app()->cache->set($cache_id, $messages);
#2
– /opt/lampp/htdocs/mydemo/protected/modules/user/controllers/YumInstallController.php(459): Yum::t("User management module is not in Debug Mode")
454 ‘friendshipTable’ => Yum::resolveTableName($this->module->friendshipTable, Yii::app()->db),
455 ‘actionTable’ => Yum::resolveTableName($this->module->actionTable, Yii::app()->db),
456 ));
457 }
458 } else {
459 throw new CException(Yum::t(‘User management module is not in Debug Mode’));
460 }
461 }
462
463 public function actionIndex()
464 {
#3
- /opt/lampp/htdocs/yii/framework/web/actions/CInlineAction.php(50): YumInstallController->actionInstall()
#4
- /opt/lampp/htdocs/yii/framework/web/CController.php(309): CInlineAction->runWithParams(array())
#5
- /opt/lampp/htdocs/yii/framework/web/filters/CFilterChain.php(134): CController->runAction(CInlineAction)
#6
- /opt/lampp/htdocs/yii/framework/web/filters/CFilter.php(41): CFilterChain->run()
#7
- /opt/lampp/htdocs/yii/framework/web/CController.php(1146): CFilter->filter(CFilterChain)
#8
- /opt/lampp/htdocs/yii/framework/web/filters/CInlineFilter.php(59): CController->filterAccessControl(CFilterChain)
#9
- /opt/lampp/htdocs/yii/framework/web/filters/CFilterChain.php(131): CInlineFilter->filter(CFilterChain)
#10
- /opt/lampp/htdocs/yii/framework/web/CController.php(292): CFilterChain->run()
#11
- /opt/lampp/htdocs/yii/framework/web/CController.php(266): CController->runActionWithFilters(CInlineAction, array("accessControl"))
#12
- /opt/lampp/htdocs/yii/framework/web/CWebApplication.php(276): CController->run("")
#13
- /opt/lampp/htdocs/yii/framework/web/CWebApplication.php(135): CWebApplication->runController("user/install")
#14
- /opt/lampp/htdocs/yii/framework/base/CApplication.php(162): CWebApplication->processRequest()
#15
– /opt/lampp/htdocs/mydemo/index.php(13): CApplication->run()
08 defined(‘YII_DEBUG’) or define(‘YII_DEBUG’,true);
09 // specify how many levels of call stack should be shown in each log message
10 defined(‘YII_TRACE_LEVEL’) or define(‘YII_TRACE_LEVEL’,3);
11
12 require_once($yii);
13 Yii::createWebApplication($config)->run();
2012-06-01 22:36:29 Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1 Yii Framework/1.1.10