Yii-User Migration failing

Yii 1.1 General Discussion
1

error message - failed to apply m110810_162301_userTimestampFix migration failed. all later migrations are canceled.

what are the reasons?

Help me.

2

this is the error message

3

solved it

i just executed this

protected/modules/user/data/schema.mysql.sql;

now its working…

But the feature with migration is still a qn!!!

4

Hello,

You must to configure ‘tablePrefix’ in console.php, like :




...

'components'=>array(

'db'=>array(

...

'tablePrefix'=>'tbl_',

...

),

),

...
5

yes i did that already…but not working… any way

then i go through this link

Here is the solution

http://www.benjaminlhaas.com/blog/installing-yii-users-and-rights-5-steps

6

Change this:




	public $tableUsers = '{{users}}';

	public $tableProfiles = '{{profiles}}';

	public $tableProfileFields = '{{profiles_fields}}';

into this:




	public $tableUsers = 'users';

	public $tableProfiles = 'profiles';

	public $tableProfileFields = 'profiles_fields';

in UserModule.php line 95.

7

I had the same error. First time running migrations. :)

So, I notice that the bottom message is… well… useless to figure out what the problem is. But it tells you “Hey, you have a problem” and that’s nice.

The proper reason, could be found (it was on my case), at the very top of that console process printed on your terminal.


Exception: CDbCommand failed to execute the SQL statement: ...

And after that, you may found the reason for the issue. :)

I realise the OP already found his solution, I just wish to add this for future reference.