What does the output look like when you have this:
if (!empty($this->data))
{
die(debug($this->data));
On Mon, Jan 19, 2009 at 7:05 PM, Rob Wilkerson <[email protected]> wrote:
>
> Hey all -
>
> I see a lot of questions about this, but nothing I've found references
> the error I'm seeing so I thought I'd post here and see whether anyone
> else recognizes what I'm doing wrong.
>
> I have an Event model that habtm Attraction:
>
> class Event extends AppModel {
> public $name = 'Event';
> public $belongsTo = 'Location';
> public $hasAndBelongsToMany = 'Attraction';
>
> ...
> }
>
> class Attraction extends AppModel {
> public $name = 'Attraction';
> public $hasAndBelongsToMany = array ( 'Event' );
>
> ...
> }
>
> In my EventsController, I have:
>
> $attractions = $this->Event->Attraction->find ( 'list' ); // the value
> is being set() later in the controller code
>
> And in my view:
>
> echo $form->input (
> 'Attraction', // I've also tried Attraction.Attraction per the docs
> array (
> 'type' => 'select',
> 'empty' => true
> )
> );
>
> When I try to save my Event ($this->Event->save ( $this->data ) ), I
> get this error:
>
> SQL Error: 1110: Column 'event_id' specified twice [CORE/cake/libs/
> model/datasources/dbo_source.php, line 514]
>
> Query: INSERT INTO `attractions_events`
> (`event_id`,`attraction_id`,`event_id`) VALUES ('4975132e-b0fc-42ee-
> a13f-9e633b196446','495f9db0-
> b548-4ee2-94ff-4aebc0a80232','4975132e-7a60-498b-819f-9e633b196446')
>
> Anyone have any thoughts? I read and re-read the docs, plus a few
> habtm blog posts, but I'm not seeing whatever it is I'm doing wrong.
> I'd appreciate it if someone could point me in the right direction.
>
> Thanks.
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
