I trying to make many-to-many relation between 2 models: Users_Role and Users_Right<\/p>\n
class Model_Users_Role extends ORM{\n protected $_has_many = array(\n 'rights' => array(\n 'model' => 'users_right',\n 'through' => 'users_roles_rights',\n ),\n ); \n}\n\nclass Model_Users_Right extends ORM{ \n protected $_has_many = array(\n 'roles' => array(\n 'model' => 'users_role',\n 'through' => 'users_roles_rights',\n ),\n );\n}\n<\/code><\/pre>\nI’m trying to do this:<\/p>\n
$role = ORM::factory('users_role', 1);\n$right = ORM::factory('users_right', 1);\n$right->add('roles', $role);\n<\/code><\/pre>\nError:<\/p>\n
Database_Exception [ 1054 ]: Unknown column 'role_id' in 'field list' [ INSERT INTO `users_roles_rights` (`users_right_id`, `role_id`) VALUES ('1', '1') ]\n<\/code><\/pre>\nI tryed to make it on the other side:<\/p>\n
$role = ORM::factory('users_role', 1);\n$right = ORM::factory('users_right', 1); \n$role->add('rights', $right);\n<\/code><\/pre>\nNew error:<\/p>\n
Database_Exception [ 1054 ]: Unknown column 'right_id' in 'field list' [ INSERT INTO `users_roles_rights` (`users_role_id`, `right_id`) VALUES ('1', '1') ]\n<\/code><\/pre>\nI expected ORM to use users_role_id<\/code> and users_right_id<\/code> field names in pivot table, but it uses wrong name of far key? Where I have made a mistake?<\/p>\n\n- \n
Check out where the default values are set. Try this:<\/p>\n
class Model_Users_Role extends ORM{\n protected $_has_many = array(\n 'rights' => array(\n 'model' => 'users_right',\n 'far_key' => 'users_right_id',\n 'through' => 'users_roles_rights',\n ),\n ); \n}\n\nclass Model_Users_Right extends ORM{ \n protected $_has_many = array(\n 'roles' => array(\n 'model' => 'users_role',\n 'far_key' => 'users_role_id',\n 'through' => 'users_roles_rights',\n ),\n );\n}\n<\/code><\/pre>\nKohana does not check that the relationship does not already exist.<\/p>\n
Either enforce this in the database table with a composite unique key on the two foreign key columns, or make your code check that the relationship does not already exist before adding.<\/p>\n<\/li>\n<\/ol>\n
Originally posted 2013-11-27 11:53:26. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
I trying to make many-to-many relation between 2 models: Users_Role and Users_Right class Model_Users_Role extends ORM{ protected $_has_many = array( ‘rights’ => array( ‘model’ => ‘users_right’, ‘through’ => ‘users_roles_rights’, ), ); } class Model_Users_Right extends ORM{ protected $_has_many = array( ‘roles’ => array( ‘model’ => ‘users_role’, ‘through’ => ‘users_roles_rights’, ), ); } I’m trying to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1580","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1580"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1580\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}