Hi Jake
Does your events_posts table have a primary key, that is a column named id
used for the primary key?
If not, then please add such and try again :)
Enjoy, John
On Sunday, 11 January 2015 16:45:30 UTC+2, Jake Newsom wrote:
>
> So I have 2 models, Posts and Events.
>
> Model Post.php looks like this:
> <?php
> App::uses('AppModel','Model');
>
> class Post extends AppModel{
>
> ...took out variables for brevity sake
>
> public $hasAndBelongsToMany = array(
> "Events"=>array(
> "className"=>"Event",
> "joinTable"=>"events_posts",
> "foreignKey"=>"post_id",
> "associationForeignKey"=>"event_id",
> "unique"=>true
> )
> );
> }
> ?>
>
> Model Event.php has this:
> public $hasAndBelongsToMany = array(
> "Posts"=>array(
> "className"=>"Post",
> "joinTable"=>"events_posts",
> "foreignKey"=>"event_id",
> "associationForeignKey"=>"post_id",
> "unique"=>true
> )
> );
>
>
> In the database there's a table called events_posts with 2 fields:
> event_id & post_id
>
> And finally, in a different controller, where I need to manually save
> stuff.... I have this code:
> $post_data = array(
> "Post"=>array(
> "image_id"=>$entry['id'],
>
> "image_url"=>$entry['images']['standard_resolution']['url'],
>
> "image_thumb"=>$entry['images']['low_resolution']['url'],
> "image_text"=>$entry['caption']['text'],
> "status"=>'1',
> "created_on"=>$entry['created_time'],
> "instagram_user_id"=>$user_id
> ),
> "Event"=>array(
> "id"=>$event['Event']['id']
> )
> );
>
> $this->Post->saveAll($post_data);
>
> And I've tried saveAll, save, and saveAssociated. The Post information
> saves, but nothing shows up in the events_posts table. What am I doing
> wrong? I'm sure it's gotta be some kind of alias mistake...
>
> Thanks in advance for taking the time to read and help me!
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
