Mysql Database

shinokada · July 8, 2009, 3:47pm

mysql>USE yiisource

Database changed

mysql> SHOW CREATE TABLE User

Tabel | Create Table

User | CREATE TABLE 'user' (

'id' int(11) NOT NULL AUTO_INCREMENT,

'username' varchar(120) NOT NULL,

'password' varchar120) NOT NULL,

PRIMARY KEY ('id'))

ENGINE=MyISAM DEFAULT CHARSET =latin 1|

qiang · July 8, 2009, 5:29pm

This is very strange. One more to do, could you please show the result of executing "SHOW COLUMNS FROM user"?

shinokada · July 8, 2009, 6:20pm

id int(11) No PRI Null auto_increment

username verchar(128) No Null

password varchar(120) No Null

email varchar(120) No Null

Spyros · July 8, 2009, 6:28pm

Quote

>> crud User

I get this error message this time.

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

Oh my.

Why the error is table "generate"?

Shouldn't be table "users"?

Is there a "generate" table in your db?

qiang · July 8, 2009, 6:34pm

ah, yes, check your User class' tableName() method. I guess you didn't generate this class correctly.

shinokada · July 9, 2009, 8:26am

Where can I find it?

qiang · July 9, 2009, 2:43pm

In your User.php file.

shinokada · July 9, 2009, 3:06pm

I found User.php under testdrive\protected\models.

And tableName() method is the following.

/**

 * @return string the associated database table name


 */


public function tableName()


{


	return &#039;user&#039;;


}

qiang · July 9, 2009, 3:14pm

What is your error message now when using crud command? I'm confused…

shinokada · July 9, 2009, 6:26pm

sorry of all of this.

I just did exactly what I did before, following the docmentation.

Then it worked this time.

Thank for your patience.

I will carry through quick start in the docementation.

I appreciate your help and time.

shinokada · July 9, 2009, 6:37pm

However I am not able to add any new users.

After adding some then when I see User List or managing user, I see nothing.

I checked db and there are no data.

Now what is wrong?

qiang · July 9, 2009, 8:44pm

Are there any validation errors? Did you override beforeValidate or beforeSave?

shinokada · July 10, 2009, 9:01am

After logging in as admin. going to …?r=user/create to create a new user.

After clicking Creat, going to the same page, …r=user/create.

Then clicking User List or Manage User. There is no list. No record in db either.

I don't get any error message throughout.