FuelPHP Forums

I'm getting a "Primary key cannot be changed" exception when I try to delete a record from a table that has a dual primary key. Hopefully I'm just doing something wrong - any help is much appreciated! Here's the full story : I've got three tables/models - users, tokens, and user_tokens. Users and tokens have many user_tokens, and user_tokens belong to users and tokens. (Can't just establish a many-to-many between users and tokens because I'm storing created_at as well in the user_tokens table.) The primary keys for user_tokens is user_id and token_id. And like I said, I cannot seem to delete records from user_tokens. I get the "primary key cannot be changed" error. Here's the ORM definitions : In Model_User :

protected static $_has_many = array(
  'tokens' => array( 
    'model_to' => 'Model_User_Token',
    'cascade_delete' => true  
  )
);

In Model_User_Token :

protected static $_primary_key = array( 'user_id', 'token_id');

protected static $_belongs_to = array(
  'user',
  'token'
);

In Model_Token :

protected static $_has_many = array(
  'users' => array(
    'model_to' => 'Model_User_Token'
  )
);

And here's how I'm testing deleting from user_tokens :

$tokens = $user->tokens;

foreach( $tokens as $t )
  $t->delete();

Any help is much appreciated!