Akelos PHP Framework Forum - find, has_one association, errors 2010-09-10T09:01:58+02:00 http://forum.akelos.org/ Lussumo Vanilla & Feed Publisher find, has_one association, errors http://forum.akelos.org/discussion/686/?Focus=2872#Comment_2872 2008-11-15T21:22:29+01:00 2010-09-10T09:01:58+02:00 bloogrox http://forum.akelos.org/account/408/ Hi! i have model User, User $has_one Wallet code: $Wallet = $_User->wallet->find(); // i want to retrieve wallet object associated to user raises: Notice: Tried 'SELECT wallets.* FROM ... i have model User, User $has_one Wallet
code:
$Wallet = $_User->wallet->find(); // i want to retrieve wallet object associated to user
raises:
Notice: Tried 'SELECT wallets.* FROM wallets LEFT OUTER JOIN users ON users.id = wallets.user_id WHERE wallets.user_id = '12' AND ( __owner.type = 'User' ) '. Got: [1054] Unknown column '__owner.type' in 'where clause' in C:\xampp\htdocs\showbirja\lib\AkActiveRecord\AkDbAdapter.php on line 226

i copy paste this sql to sqlmanager and execute,
without "AND ( __owner.type = 'User' )" it works fine

is it bug?
how could i get over it ?

thnx!]]> find, has_one association, errors http://forum.akelos.org/discussion/686/?Focus=2885#Comment_2885 2008-11-18T10:30:22+01:00 2008-11-18T10:30:29+01:00 suthern http://forum.akelos.org/account/128/ If each user has only one wallet, (Table user has 'wallet_id'), what about using `$Wallet = $_User->wallet->load();` If each user has only one wallet, (Table user has 'wallet_id'), what about using $Wallet = $_User->wallet->load();

]]> find, has_one association, errors http://forum.akelos.org/discussion/686/?Focus=2887#Comment_2887 2008-11-18T16:29:32+01:00 2010-09-10T09:01:58+02:00 bloogrox http://forum.akelos.org/account/408/ and what if Table wallet has 'user_id', but table user doesn't have 'wallet_id'. Table wallet has 'user_id', but
table user doesn't have 'wallet_id'.]]> find, has_one association, errors http://forum.akelos.org/discussion/686/?Focus=3457#Comment_3457 2010-06-22T17:39:26+02:00 2010-09-10T09:01:58+02:00 suthern http://forum.akelos.org/account/128/ BlooGrox, this thread is a couple of years old. Are you still around? Sorry I never saw your response. Putting the user_id inside the schema wallet is interesting. As long as you have defined ... BlooGrox, this thread is a couple of years old. Are you still around? Sorry I never saw your response.

Putting the user_id inside the schema wallet is interesting. As long as you have defined your models correctly (Has_one and belongs_to), then

$this->User->wallet->load();

should work just fine.

]]>