Ch8 - error with Project::associateUserToRole method

Hi - I have been following the book and have an issue with chapter 8 on page 191 -> 194 (Implementing the new Project AR methods.)

I’ve created the RBAC tables/details successfully in both _test and _dev.

I’ve added the code to Project.php and ProjectTest.php

After I’ve added in the sql to associateUserToRole() I was expecting to run the phpunit unit/ProjectTest.php test and it to pass - instead I get the following:

D:\Zend\Apache2\htdocs\trackstar\protected\tests>phpunit unit/ProjectTest.php

Notice: Please no longer include "PHPUnit/Framework.php". in D:\Zend\ZendServer\

bin\pear\PHPUnit\Framework.php on line 50

PHPUnit 3.5.5 by Sebastian Bergmann.


Time: 4 seconds, Memory: 9.25Mb

There was 1 error:

  1. ProjectTest::testUserRoleAssignment

CException: Property "CDbCommand.execute" is not defined.





Tests: 6, Assertions: 13, Errors: 1.

Not quite sure where I’ve gone wrong - any help gratefully received.



I think the problem is that the code in models/Project.php is referencing the wrong part of the yii app.

The code : $command = Yii::app()->db->createCommand($sql);

This should resolve to …\yii114\framework\db : CDbCommand.php

but in the error above it resolves to : …\yii114\framework\base\CComponent.php

Not sure how I (or even if I need to) change Yii::app()->db to the correct directory ?

Any help ?


Had missed out the method brackets on the return from Project::associateUserToRole()…

Wrong : return $command->execute;

Right : return $command->execute();


yes, this is an identified issue with the printing of the book (#10 in the identified issues thread).