Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The quick answer is that your associations are wrong. The long one follows:</p> <p>First of all there is no association called <code>hasAndBelongsTo</code>. The association name is <code>hasAndBelongsToMany</code>. Furthermore the associations you've put together in the <code>Message Model</code> are a totally wrong or if I may put it this way - you may have not understood them correctly. So the quick fix would be to remove the <code>hasMany</code> to <code>MessageUser</code>, the <code>belongsTo</code> <code>User</code> and the wrong <code>hasAndBelongsTo</code> <code>Message</code> and add a <code>hasAndBelongsToMany</code> association to User.</p> <p>If you want to have <code>Message hasAndBelongsToMany User</code> just use that. How <a href="http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#hasandbelongstomany-habtm" rel="nofollow noreferrer">is described here</a>. Also HABTM has be discussed many times here so I'm not going to go into detail about it.</p> <p>However I would like to point you to another possible set up. Now I am proposing this because I saw you tried to also use <code>hasMany</code> so there is the possibility to use the so-called <code>hasManyThrough the Join Model</code>, but usually that is to be used when you want to store additional data in the join model (MessageUser in your case). Check <a href="https://stackoverflow.com/questions/12224596/self-habtm-or-hasmany-through-concept-confusion">this question out</a>. </p>
    singulars
    1. This table or related slice is empty.
    1. POImplement Message System into cakephp 2.x
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USBorislav Sabev
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POImplement Message System into cakephp 2.x
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COIve just read the link you provided to HABTM association and i feel enlighted now! i really appreciate this- thank you! My approach now is to set the association: Message HABTM User. I reedited the database messages_users to the way which is provided in the cakephp link. Now im thinkin about the association User to Message. In my mind im thinkin of User hasMany Messages - so i am going to implement this into the User Model next. Kind regards
      singulars
      1. PO
      1. USBen Matheja
 

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