CDbException
Description
CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1142 CREATE VIEW command denied to user ‘dbuser’@‘localhost’ for table ‘view_categories’
Source File
/home/user/public_html/mvc/framework/db/CDbCommand.php(227)
00215: $n=$this->_statement->rowCount();
00216:
00217: if($this->_connection->enableProfiling)
00218: Yii::endProfile(‘system.db.CDbCommand.execute(’.$this->getText().’)’,‘system.db.CDbCommand.execute’);
00219:
00220: return $n;
00221: }
00222: catch(Exception $e)
00223: {
00224: if($this->_connection->enableProfiling)
00225: Yii::endProfile(‘system.db.CDbCommand.execute(’.$this->getText().’)’,‘system.db.CDbCommand.execute’);
00226: Yii::log('Error in executing SQL: '.$this->getText().$par,CLogger::LEVEL_ERROR,‘system.db.CDbCommand’);
00227: throw new CDbException(Yii::t(‘yii’,‘CDbCommand failed to execute the SQL statement: {error}’,
00228: array(’{error}’=>$e->getMessage())));
00229: }
00230: }
00231:
00232: /**
00233: * Executes the SQL statement and returns query result.
00234: * This method is for executing an SQL query that returns result set.
00235: * @param array input parameters (name=>value) for the SQL execution. This is an alternative
00236: * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
00237: * them in this way can improve the performance. Note that you pass parameters in this way,
00238: * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
00239: * binding methods and the input parameters this way can improve the performance.
Stack Trace
#0 /home/user/public_html/mvc/protected/modules/Install/controllers/DefaultController.php(146): CDbCommand->execute()
#1 /home/user/public_html/mvc/framework/web/actions/CInlineAction.php(32): DefaultController->actionStep3()
#2 /home/user/public_html/mvc/framework/web/CController.php(300): CInlineAction->run()
#3 /home/user/public_html/mvc/framework/web/CController.php(278): CController->runAction(Object(CInlineAction))
#4 /home/user/public_html/mvc/framework/web/CController.php(257): CController->runActionWithFilters(Object(CInlineAction), Array)
#5 /home/user/public_html/mvc/framework/web/CWebApplication.php(320): CController->run(‘Step3’)
#6 /home/user/public_html/mvc/framework/web/CWebApplication.php(120): CWebApplication->runController(‘Install/default…’)
#7 /home/user/public_html/mvc/framework/base/CApplication.php(135): CWebApplication->processRequest()
#8 /home/user/public_html/mvc/install.php(9): CApplication->run()