I very much doubt that the problem relates to php and/or apache. Please post your controller classes.... Also, what url did u use to "hit the post controller"?
As far as debugging goes... Set debug to 3 (in .../config/core.php) and you should be able to see very quickly if your models are linked. http://book.cakephp.org/view/155/Debugging I would recommend you try using the bake console. Bake your models, controllers, and views, and then look for differences between your code and the code generated by bake. Bake is a great way for beginners and experts to get apps going quickly(imho). On Nov 22, 2: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 -~----------~----~----~----~------~----~------~--~---
