FuelPHP Forums

I am having a very unreal many to many problem here. I have two ORM models setup and many to many relation between two of thems: Category and Location model. The setup like this:

// Location model
protected static $_many_many = array(
     'categories' => array(
         'key_from' => 'id',
         'key_through_from' => 'location_id',
         'table_through' => 'categories_locations',
         'key_through_to' => 'category_id',
         'model_to' => 'Model_Category',
         'key_to' => 'id',
         'cascade_save' => true,
         'cascade_delete' => true,
     )     
 ); 


// Category model  
protected static $_many_many = array(
     'locations' => array(
         'key_from' => 'id',
         'key_through_from' => 'category_id', 
         'table_through' => 'categories_locations', 
         'key_through_to' => 'location_id', 
         'model_to' => 'Model_Location',
         'key_to' => 'id',
         'cascade_save' => true,
         'cascade_delete' => true,
     ),
 ); 

I am now facing really strange behavior. For a particular location record count says only 1, even though I have many relations saved in many-many pivot table. Example:

// actual values in categories_locations
category_id  location_id
27           44
55           44
56           44
58           44
25           5
27           5
26           5

$location = Model_Location::find(44);
echo count($location->categories); // will echo 1?!? WTF?

$location2 = Model_Location::find(5);
echo count($location2->categories); // will echo 3!!! 

The really strange thing is I am seeing this only with some locations. I am really busting my head over this but makes no sense whatsoever and why it would work normally with some location and have problems with another?