Undefined index of

Other symfony projects

Undefined index of

Postby iteps » Fri Dec 21, 2012 7:07 pm

Guys I need your help!
I have 3 entities : User , UserRole , UserProfile.
My primary key for the userprofile entity is actually a foreign key from user entity which is the UserId.
Everytime I try to access userProfile using the foreign key userid. I always got an error of undefined index of userID.

this is the exact error message
Notice: Undefined index: userID in C:\wamp\www\SymfonyFolder\vendor\doctrine\orm\lib\Doctrine\ORM\UnitOfWork.php line 2583


Controller
Code: Select all
.....
....

public function profileAction($id)
    {
        $user = new User();
        $user_repository = $this->getDoctrine()->getRepository('AcmePodUserBundle:User');
        $user = $user_repository->find($id);

        $userprofile = new UserProfile();
        $userprofile_repository = $this->getDoctrine()->getRepository('AcmeUserBundle:UserProfile');       
        $userprofile = $userprofile_repository->find($user);

       return new Response($userprofile); // this is not the actual output i need. I just used this simply to test if userprofile has some value.
}


User.orm.yml
Code: Select all
  type:  entity
  table: reg_user
  oneToOne:
  id:
    userID:
      column: user_id
      type: integer
      generator: { strategy: AUTO }
      targetEntity: UserProfile
      mappedBy: userProfileID


UserProfile.orm.yml
Code: Select all
type:  entity
  table: users_profile
  id:
    userProfileID:
      associationKey: true
  fields:
    firstName:
      column: first_name
      type: string
      length: 255
      unique: true
      nullable: false
    lastName:
      column: last_name
      type: string
      length: 255
      nullable: false
 oneToOne:
    userProfileID:
      targetEntity: User
      inversedBy: userID
      joinColumn:
        name: fk_user_id
        referencedColumnName: user_id


I think the problem is on my controller codes. Can somebody tell me the proper way of coding it.
P.S I seperated the user to user profile because i dont want to mix up in a table the user account data(like username, role, etc.) with its user info.
iteps
Junior Member
 
Posts: 15
Joined: Thu Dec 06, 2012 5:42 pm

Return to Other

Who is online

Users browsing this forum: chamroeunliverpool and 1 guest