Yii User Management Module Version 0.8

I need any user management extension… but it seems that any doesn’t work for me.

I installed Yii user management module. I have read the installation tutorials but

after click’n the installation module where i set up my tablenames it says that:


CDbCommand failed to execute the SQL statement: CDbCommand failed to prepare the SQL statement: SQLSTATE[HY000]: General error: 1 near "set": syntax error. The SQL statement executed was: set FOREIGN_KEY_CHECKS = 0;

Stack Trace


/Applications/XAMPP/xamppfiles/htdocs/sample/protected/modules/user/controllers/YumInstallController.php(41): CDbCommand->execute()

36 if (Yii::app()->request->isPostRequest) {

37 // A associative array containing the tables to be created.

38 $createdTables = array();

39 if ($db = Yii::app()->db) {

40 $sql = ‘set FOREIGN_KEY_CHECKS = 0;’;

41 $db->createCommand($sql)->execute();


43 $transaction = $db->beginTransaction();


45 $tables = array(

46 ‘userTable’,

Somebody? Any Answers/Suggestion/Comments would be appreciated.

Thanks in advance.

I know that this topic is very old. Anyway, I just spent 20 minutes figuring out what’s the problem and thought I could share what was wrong. And I’m pretty sure I will be looking for the same answer in the nearest future. :)

Solution: I somehow forgot to uncomment MySQL DB configuration in config/main.php and Yii used Sqlite by default.