Mysql Database

I am following the document.

In the document "", under Connecting to Database, it says,

return array(










I am using XAMPP. I can make db in phpmyAdmin, but what I need to write for 'sqlite:protected/data/source.db'?

Thanks in advance.






Ok, I tried the above code.

'db'=>array( 'connectionString'=>'mysql:host=localhost;dbname=myDBName', 'username'=> 'root', 'password'=> 'mypass' )

Then using cmd,

cd WebRoot/testdrive

protected/yiic shell

Yii Interactive Tool v1.0

Please type 'help' for help. Type 'exit' to quit.

>> model User

  generate User.php

But I keep getting the following error.

exception 'CDbException' with message 'CDbconnection.connectionSting cannot be empty.' in c:\xampp\htdocs\yii\framework\db\CDbConnection.php:238

Stck trace:

What do I need to do?

I'm not sure if this is the problem, or if you just didn't paste it in with the code, but the last parentheses needs a comma after it. For example, here's mine:



    		'username' => 'root',

    		'password' => 'password'


It has , in mine.

I just did not type it in the previous post.

It seems you configuration is not being used. Check your entry script index.php about the configuration file you are using, and make sure you are modifying the right configuration file.

I checked it and it is correct.

Is there anyone using XAMPP for Yii?

If there is, tell me how you did it please?

I use xampp with no problems

Is the db configuration inside the components array?

first of all you need to modify th php.ini file an uncomment the mysql statements

Silly me. I did not take out comment /*  */.

I have a next question.

The command in the document should be like this??

>> crud User;

  generate UserController.php;

  generate create.php;

  mkdir D:/wwwroot/testdrive/protected/views/user;

  generate update.php;

  generate list.php;

  generate show.php;

I am using windows cmd. I think semi-colons are needed for this, right?

can you send me the php.ini file

The only command you need is

>>crud User

everything else will be created automatically

write crud model

in cmd

@kk; this forum does not allow to send more than 2000 characters.

@Spyros; I get the following error now.

exception 'CDbException' with message 'The table "generate" for active record class "User" cannot b e found in the databasee.' in c:\xampp\htdocs\yii\framework\db\ar\CActiveRecord.php:2154

Stack trace:

#0 c:`\xampp\htdocs…

did you see the blog demo??

in cmd you should be in the path of php folder

D:\xampp\php>d:\yii\framework\yiic shell d:\xampp\htdocs\wwwroot\cart11\index.php

after that it will come

Yii Interactive Tool v1.0 (based on Yii v1.0.6)

Please type 'help' for help. Type 'exit' to quit.


now write

>>model User

some thing will display

then write

>>crud User

  generate UserController.php

      mkdir D:/xampp/htdocs/wwwroot/cart11/protected/views/User

  generate create.php

  generate update.php

  generate list.php

  generate show.php

  generate admin.php

  generate _form.php

Crud 'user' has been successfully created. You may access it via:


try it

I get upto here is alright.


protected\yiic shell

Yii Interactive Tool v1.0

Please type 'help' for help. Type 'exit' to quit.

>> model User


This generate user.php, so it is working. then problem is the next.

>> crud User

I get this error message this time.

Error: Table "generate" does not have a primary key.

Oh my.

you have not set primary key field for the user table

set it

I has been set.  :(

But it does not recognize it.

i think primary means a seperate key with auto increment facility

try it create a new id in the user table and make it primary + autoincrement

remove the primary key property of the already set key

What is the result of executing SQL: SHOW CREATE TABLE User