Installing yii-user extension

General Miscellaneous
1

[size=2]Hi All,[/size]

[size=2]I am facing error after installation of yii-user extension. I installed yii, after that i installed this extension as mentioned.[/size]

[size=2]1) extracted in protected module [/size]

[size=2]2) configured config/main.php as said [/size]

[size=2]3) Created tables as in from schema.mysql.sql (not sure what to do with schema.sqlite.sql after using schema.mysql.sql)[/size]

[size=2]4) added following layout in layout/main.php with <?php widget(‘zii.widgets.CMenu’, array(…));?>[/size]

[size=2]5) now when i try to login, it gives me following error [/size]

[size=2]"The table "{{users}}" for active record class "User" cannot be found in the database". [/size]

[size=2]what wrong am i doing here…?[/size]

[size=2]Pls suggest…![/size]

[size=2]-Big O[/size]

2

Maybe table Users doesn’t exists in db? B)

3

yes it doesn’t exist as the schema defines the table name to be "tbl_users…

also to experiment I created two tables "users" and "user " with same configuration but no effect…

4

U need to put table prefix to’tbl_’…in config/main.php page

5

Check the file modules/user/UserModule.php - Lines 88-90, I changed them from this:




public $tableUsers = '{{users}}';<br />

public $tableProfiles = '{{profiles}}';<br />

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

to this:


public $tableUsers = 'users';<br />

public $tableProfiles = 'profiles';<br />

public $tableProfileFields = 'profiles_fields';

and now it works. I don’t understand the purpose of surrounding the table names by {{}} though.