Nevermind...lol too late to be coding...
For some reason the user_id column in the departments_users table had
been set as a primary key. I'm not exactly sure why, but who knows
maybe I totally bailed and set a primary key flag somewhere along the
line.
Everything is working though.
On 4 Oct, 01:12, Keith <[EMAIL PROTECTED]> wrote:
> I have a situation where I have a user model & a department model.
>
> MODEL - User.php
>
> var $hasAndBelongsToMany = array(
> 'Department' => array('className' => 'Department',
> 'joinTable' =>
> 'departments_users',
> 'foreignKey' => 'user_id',
> 'associationForeignKey' =>
> 'department_id',
> 'unique' => true,
> 'conditions' => '',
> 'fields' => '',
> 'order' => '',
> 'limit' => '',
> 'offset' => '',
> 'finderQuery' => '',
> 'deleteQuery' => '',
> 'insertQuery' => ''
> )
> );
>
> MODEL - department.php
>
> var $hasAndBelongsToMany = array(
> 'User' => array('className' => 'User',
> 'joinTable' =>
> 'departments_users',
> 'foreignKey' =>
> 'department_id',
> 'associationForeignKey' =>
> 'user_id',
> 'unique' => true,
> 'conditions' => '',
> 'fields' => '',
> 'order' => '',
> 'limit' => '',
> 'offset' => '',
> 'finderQuery' => '',
> 'deleteQuery' => '',
> 'insertQuery' => ''
> )
> );
>
> So...my problem is this:
>
> I baked my application's controllers, views, and models via the
> console and they are still the defaults.
>
> I currently have 2 users & 2 departments in the database.
>
> Whenever I associate a user with a single department (doesn't matter
> which one) everything works fine.
>
> Whenever I associate a user with both departments I get the following
> error:
>
> Warning (512): SQL Error: 1062: Duplicate entry '2' for key 1 [CORE/
> cake/libs/model/datasources/dbo_source.php, line 521]
>
> Query: INSERT INTO `departments_users` (`user_id`,`department_id`)
> VALUES (2,'1'), (2,'2')
>
> Any help would be greatly appreciated. This project was created
> exclusively with the 1.2 RC3 so it wasn't an upgrade or anything like
> that from RC2 or before.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
