Is there any debug code I can throw into the controller to expose
whether things are being passed? I'm kinda of completely in the dark
because I know it should be working.
On Nov 22, 4:36 pm, "James.Diss" <[EMAIL PROTECTED]> wrote:
> I actually tried this first in an effort to get it working.
>
> Currently the model for 'Post' looks like;
>
> // app/models/Post.php
> class Post extends AppModel {
> var $name = 'Post';
> var $validate = array();
> var $belongsTo = array('User'=>array
> ('className'=>'User','foreignKey'=>'user_id'));
>
> }
>
> The model for 'User' looks like;
>
> // app/models/User.php
> class User extends AppModel {
> var $name = 'User';
> var $validate = array();
> var $hasMany = array('Post');
>
> }
>
> The thing is that I suspect that I'm keeping to the conventions with
> the following DDLs;
>
> CREATE TABLE `users` (
> `id` int(11) unsigned NOT NULL auto_increment,
> `name` varchar(100) default NULL,
> `email` varchar(150) default NULL,
> `firstname` varchar(60) default NULL,
> `lastname` varchar(60) default NULL,
> PRIMARY KEY (`id`)
> ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
>
> CREATE TABLE `posts` (
> `id` int(11) unsigned NOT NULL auto_increment,
> `name` varchar(255) default NULL,
> `date` datetime default NULL,
> `content` text,
> `user_id` int(11) default NULL,
> PRIMARY KEY (`id`),
> KEY `user_id` (`user_id`)
> ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
>
> (before anyone points out the index 'user_id' after the primary key,
> it's not that, I checked. I would have been disappointed if an index
> threw things out of kilter, though)
>
> At this moment I'm leaning towards something being wrong with the
> install, and I'm humble enough to think it's PHP/Apache2. Is there
> any configuration in either of those can stop associations being made?
> (Although they're both as vanilla as possible for deploying code on
> live servers)
>
> TIA
>
> On Nov 22, 3:42 pm, Rob <[EMAIL PROTECTED]> wrote:
>
> > You probably want to add the foreigh_key to your hasMany and
> > belongsTo, especially if they don't follow the cake conventions.
>
> > In my models, I have ID columns like 'user_id', and the foreign_key is
> > typically the same name, so for instance in my Users to Groups
> > relationship I have something like:
>
> > // Users model ...
> > var $hasMany = array(
> > 'UserGroup' => array(
> > 'className' => 'UserGroup',
> > 'foreignKey' => 'user_id',
> > 'limit' => '5',
> > 'dependent' => true
> > )
> > );
>
> > // Link to groups
> > var $hasAndBelongsToMany = array(
> > 'Group' =>
> > array(
> > 'className' => 'Group',
> > 'joinTable' => 'user_groups',
> > 'foreignKey' => 'user_id',
> > 'associationForeignKey' => 'group_id',
> > 'conditions' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'unique' => true,
> > 'finderQuery' => '',
> > 'deleteQuery' => '',
> > 'insertQuery' => ''
> > )
> > );
>
> > // Groups model
> > var $hasMany = array(
> > 'UserGroup' => array(
> > 'className' => 'UserGroup',
> > 'foreignKey' => 'group_id',
> > 'limit' => '5',
> > 'dependent' => true
> > )
> > );
>
> > // Link to users
> > var $hasAndBelongsToMany = array(
> > 'User' =>
> > array(
> > 'className' => 'User',
> > 'joinTable' => 'user_groups',
> > 'foreignKey' => 'group_id',
> > 'associationForeignKey' => 'user_id',
> > 'conditions' => '',
> > 'order' => '',
> > 'limit' => '',
> > 'unique' => true,
> > 'finderQuery' => '',
> > 'deleteQuery' => '',
> > 'insertQuery' => ''
> > )
> > );
>
> > On Nov 22, 9:45 am, "James.Diss" <[EMAIL PROTECTED]> wrote:
>
> > > The failing isn't really in understanding the relationships, just
> > > something odd is happening that I want to get a perspective on as a
> > > beginner.
>
> > > I have two models with backing database tables. The models are;
>
> > > // app/models/User.php
> > > class User extends AppModel {
> > > var $name = 'User';
> > > var $validate = array();
> > > var $hasMany = array('Post');
>
> > > }
>
> > > // app/models/Post.php
> > > class Post extends AppModel {
> > > var $name = 'Post';
> > > var $validate = array();
> > > var $belongsTo = array('User');
>
> > > }
>
> > > I also have two controllers that basically use the scaffold. The
> > > users controller does what it's supposed to do, but hitting the post
> > > controller doesn't show the user select box, which indicates to me
> > > that the relationship isn't being built. The foreign key in the posts
> > > table is 'user_id'.
>
> > > As I'm just getting started, I'm at a loss to debug what appears to be
> > > a very basic piece of code.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
