KohanaPHP » Kohana v3.x

Say, we have two tables: users and subscriptions:

CREATE TABLE prefix_users (
    id INTEGER NOT NULL PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE prefix_subscriptions (
    id INTEGER NOT NULL PRIMARY KEY,
    user_id INTEGER UNSIGNED NOT NULL,
    some_data TEXT NOT NULL
);

A user has_many subscriptions, a subscription belongs_to one user.

We have two models describing the tables above:

class Model_User extends ORM {
    protected $_has_many = array(
        'subscriptions' => array(
            'foreign_key' => 'user_id',
            'model'       => 'Subscription',
        ),
    );
}

class Model_Subscription extends ORM {
    protected $_belongs_to = array(
        'user' => array(
            'foreign_key' => 'user_id',
            'model'       => 'User',
        ),
    );
}

Database connection configuration is as follows:

return array(
    'default' => array(
        'type'       => 'mysql',
        'connection' => array( /* Omitted for the sake of brevity */),
        'table_prefix' => 'prefix_',  // <<< This is the crucial part
    ),
);

Now, if we call something like ORM::factory('Subscription')->with('user')->find_all(); we will get an exception (I have reformatted the message for the sake of readability):

Database_Exception [ 1054 ]: Unknown column 'prefix_user.id' in 'field list' [ 
SELECT `prefix_user`.`id` AS `user:id`, `prefix_user`.`name` AS `user:name`, `prefix_subscriptions`.*
FROM `prefix_subscriptions`
LEFT JOIN `prefix_users` AS `user` ON (`prefix_user`.`id` = `prefix_subscriptions`.`user_id`)
ORDER BY `prefix_subscriptions`.`id` ASC
] ~ MODPATH/database/classes/kohana/database/mysql.php [ 183 ]

The problem is that the Database module is unaware of table aliases (thus replacing all user. with prefix_user.) and ORM module is unaware of table prefixes.

The patch that fixes the issue is attached.