Akelos PHP Framework Forum - find, has_one association, errors Mon, 06 Sep 2010 10:14:01 +0200 http://forum.akelos.org/ Lussumo Vanilla 1.1.4 & Feed Publisher find, has_one association, errors http://forum.akelos.org/discussion/686/?Focus=2872#Comment_2872 http://forum.akelos.org/discussion/686/?Focus=2872#Comment_2872 Sat, 15 Nov 2008 21:22:29 +0100 bloogrox 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 http://forum.akelos.org/discussion/686/?Focus=2885#Comment_2885 Tue, 18 Nov 2008 10:30:22 +0100 suthern 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 http://forum.akelos.org/discussion/686/?Focus=2887#Comment_2887 Tue, 18 Nov 2008 16:29:32 +0100 bloogrox 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 http://forum.akelos.org/discussion/686/?Focus=3457#Comment_3457 Tue, 22 Jun 2010 17:39:26 +0200 suthern 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.

]]>