StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODoctrine won't add persist entity relationship
primarykey
Id
17698296
data
AcceptedAnswerId
17705459
AnswerCount
4
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-07-17T11:13:26.040
FavoriteCount
0
LastActivityDate
2016-11-10T11:03:32.707
LastEditDate
2013-07-17T16:35:26.537
LastEditorUserId
2111099
OwnerUserId
2111099
ParentId
0
PostTypeId
1
Score
2
ViewCount
563
LastEditorDisplayName
text
Body
I have two entities, <code>View</code> and <code>Location</code> Each <code>View</code> can have a <code>Location</code>. In my view I thus have: <pre><code>class View { //..... Other Stuff..... /** * @ManyToOne(targetEntity="Location", inversedBy="views") **/ private $location; //...setters and getters.... public function setLocation($location){ $this->location = $location; } } </code></pre> and then for my Location <pre><code>class Location { //.....other stuff..... /** * @OneToMany(targetEntity="View", mappedBy="location") **/ private $views; public function __construct() { $this->created = $this->updated = new \DateTime("now"); $this->views = new \Doctrine\Common\Collections\ArrayCollection(); } // .... Getters and Setters .... } </code></pre> But when I try and do this: <pre><code><?php $this->pageview = $this->em->getRepository('Entities\View')->find(1); $this->location = $this->em->getRepository('Entities\Location')->find(1); $this->pageview->setLocation($this->location); $this->em->persist($this->pageview); $this->em->flush(); ?> </code></pre> Or even when I create new entities: <pre><code><?php $pv = new Entities\Pageview; $lc = new Entities\Location; $this->em->persist($lc); $this->em->flush(); $pv->setLocation($lc); $this->em->persist($pv); $this->em->flush(); ?> </code></pre> Doctrine never sets the location_id in the database (it is always NULL). I've checked the SQL queries and they're not even being attempted at being set, all I'm getting is: <pre><code>INSERT INTO View (field1, field2, created, updated) VALUES ('val1', 'val2', '2013-07-17T12:10:56+01:00', '2013-07-17T12:10:56+01:00') </code></pre> No reference to locations whatsoever...The weird thing is I can update field1 and field2 fine...and all other relations are working throughout my application...I just can't get views and locations to work... EDIT I have the exact some code working now on another computer. I don't know why it wasn't working, but I just moved the files back and restarted my computer and now it is...cacheing problem I guess?
Tags
<php><doctrine2><doctrine><associations><model-associations>
Title
Doctrine won't add persist entity relationship
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHarry Mustoe-Playfair
UserOwnerUserId
1. USHarry Mustoe-Playfair
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PODoctrine won't add persist entity relationship
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.