Databases
StackOverflow2013
Postsdbo
POFind on models with HasAndBelongsToMany relationship returns unexpected format in Cakephp
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFind on models with HasAndBelongsToMany relationship returns unexpected format in Cakephp
    primarykey
    data
    text
    <p>I'm working on tagging system in cakephp. Tags can be children of other tags that are roots. (No children of children).</p> <p>The models are User and Tag. Their relationships look like this:</p> <pre><code>//User.php: public $hasAndBelongsToMany = array( 'Tag' =&gt; array( 'className' =&gt; 'Tag', 'joinTable' =&gt; 'users_tags', 'foreignKey' =&gt; 'user_id', 'associationForeignKey' =&gt; 'tag_id', 'unique' =&gt; true, ), ); //Tag.php: var $belongsTo = array( 'Parent' =&gt; array( 'className' =&gt; 'Tag', 'foreignKey' =&gt; 'parent_id', 'dependent' =&gt; true, ), ); </code></pre> <p>When I try to do a simple paginate, like so,</p> <pre><code>$this-&gt;User-&gt;recursive = 2; $this-&gt;set('users', $this-&gt;paginate()); </code></pre> <p>I get some weird results that look like this:</p> <pre><code>array( (int) 0 =&gt; array( 'User' =&gt; array( ... ), 'Tag' =&gt; array( (int) 0 =&gt; array( 'id' =&gt; '1', 'parent_id' =&gt; null, ... 'Parent' =&gt; array() ), (int) 1 =&gt; array( 'id' =&gt; '2', 'parent_id' =&gt; '1', ... 'Parent' =&gt; array( 'id' =&gt; '1', 'parent_id' =&gt; null, ... ) ) ) ), (int) 1 =&gt; array( 'User' =&gt; array( ... ), 'Tag' =&gt; array( (int) 0 =&gt; array( 'id' =&gt; '1', 'parent_id' =&gt; null, ... 'Parent' =&gt; array( 'Parent' =&gt; array() //What's up with this parent inside the parent? ) ), (int) 1 =&gt; array( 'id' =&gt; '2', 'parent_id' =&gt; '1', ... 'Parent' =&gt; array( 'id' =&gt; '1', 'parent_id' =&gt; null, ... ) ) ) ) </code></pre> <p>)</p> <p>You'll notice that the tag that returned weird results is actually the same tag (id #1) as the first tag in the array. I'm confused as to why it would be right before, and wrong the second time..? </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USKai
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThat is due to recursive is set to `2`. Hide that code line and check what it outputs.
      singulars
      1. POFind on models with HasAndBelongsToMany relationship returns unexpected format in Cakephp
      1. USArun Jain
    2. COI would advise to stop using recursive, set it to -1 in the AppModel and use the containable behavior on all Models.
      singulars
      1. POFind on models with HasAndBelongsToMany relationship returns unexpected format in Cakephp
      1. USAlex Stallen
    3. COI did try removing recursive, but then I don't get the parents, which I do need for what I'm doing with the data. And again, the first and the third tag are actually the same tag, (owned by two different users) so I still don't feel like it explains why one of them is weird and one of them isn't. I'll try using containable though.
      singulars
      1. POFind on models with HasAndBelongsToMany relationship returns unexpected format in Cakephp
      1. USKai
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload