Re: Cakephp generates Wrong query in PHP4?
Hello Samuel, I did it and now it works in php 4 and php 5. I posted this problem because previously, after replacing findByUserId with findByUser_Id it was giving an error like it was not finding user__id in table. However I am not capable of reproducing the problem. If it happens, I will post the error, (at most I will use find( $criteria = 'user_id' = $user_id ) ) Thanks - Michele On Jul 7, 11:50 pm, "Samuel DeVore" <[EMAIL PROTECTED]> wrote: > I am fairly sure that in php 4 you have to do FindByUser_Id I know this used > to be the case due to limitations in php 4 > seehttps://trac.cakephp.org/ticket/1567for a ticket on the manual for this. > I hope that one of the Cake Devs can confirm or deny this > > Sam D > > On 7/7/07, M <[EMAIL PROTECTED]> wrote: > > > > > > > CakePHP version: : 1.1.15.5144. > > > Hello, the Bankaccount model belongs to User model. > > > Now, in BankaccountsController::view method I have this statement: > > > $data = $this->Bankaccount->findByUserId( $user_id ); > > > In PHP 5 it works fine. > > > In PHP 4.4.7 it gives this error: > > > Query: SELECT `Bankaccount`.`id`, `Bankaccount`.`user_id`, > > `Bankaccount`.`credits`, `Bankaccount`.`created`, > > `Bankaccount`.`modified`, `User`.`id`, `User`.`username`, > > `User`.`password`, `User`.`name`, `User`.`email`, `User`.`telno`, > > `User`.`race`, `User`.`sex`, `User`.`level`, `User`.`hp`, > > `User`.`hpmax`, `User`.`str`, `User`.`strmax`, `User`.`dex`, > > `User`.`dexmax`, `User`.`int`, `User`.`intmax`, `User`.`cha`, > > `User`.`chamax`, `User`.`energy`, `User`.`credits`, > > `User`.`last_visit`, `User`.`group_id`, `User`.`active`, > > `User`.`token`, `User`.`created`, `User`.`modified` FROM > > `bankaccounts` AS `Bankaccount` LEFT JOIN `users` AS `User` ON > > (`Bankaccount`.`user_id` = `User`.`id`) WHERE `Bankaccount`.`userid` = > > 5 LIMIT 1 > > Warning: SQL Error: 1054: Unknown column 'Bankaccount.userid' in > > 'where clause' in ...cake/libs/model/datasources/dbo_source.php on > > line 463 > > > Fatal error: Call to undefined method: bankaccount->onerror() in .../ > > cake/libs/model/datasources/dbo_source.php on line 596 > > > have I done something wrong or there is an incompatibility? > > > Thanks > > > -- M > > -- > (the old fart) the advice is free, the lack of crankiness will cost you > > - its a fine line between a real question and an idiot > > http://blog.samdevore.com/archives/2007/03/05/when-open-source-bugs-me/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Cakephp generates Wrong query in PHP4?
Hello Samuel, I did it and now it works in php 4 and php 5. I posted this problem because previously, after replacing findByUserId with findByUser_Id it was giving an error like it was not finding user__id in table. However I am not capable of reproducing the problem. If it happens, I will post the error, (at most I will use find( $criteria = 'user_id' = $user_id ) ) Thanks - Michele On Jul 7, 11:50 pm, "Samuel DeVore" <[EMAIL PROTECTED]> wrote: > I am fairly sure that in php 4 you have to do FindByUser_Id I know this used > to be the case due to limitations in php 4 > seehttps://trac.cakephp.org/ticket/1567for a ticket on the manual for this. > I hope that one of the Cake Devs can confirm or deny this > > Sam D > > On 7/7/07, M <[EMAIL PROTECTED]> wrote: > > > > > > > CakePHP version: : 1.1.15.5144. > > > Hello, the Bankaccount model belongs to User model. > > > Now, in BankaccountsController::view method I have this statement: > > > $data = $this->Bankaccount->findByUserId( $user_id ); > > > In PHP 5 it works fine. > > > In PHP 4.4.7 it gives this error: > > > Query: SELECT `Bankaccount`.`id`, `Bankaccount`.`user_id`, > > `Bankaccount`.`credits`, `Bankaccount`.`created`, > > `Bankaccount`.`modified`, `User`.`id`, `User`.`username`, > > `User`.`password`, `User`.`name`, `User`.`email`, `User`.`telno`, > > `User`.`race`, `User`.`sex`, `User`.`level`, `User`.`hp`, > > `User`.`hpmax`, `User`.`str`, `User`.`strmax`, `User`.`dex`, > > `User`.`dexmax`, `User`.`int`, `User`.`intmax`, `User`.`cha`, > > `User`.`chamax`, `User`.`energy`, `User`.`credits`, > > `User`.`last_visit`, `User`.`group_id`, `User`.`active`, > > `User`.`token`, `User`.`created`, `User`.`modified` FROM > > `bankaccounts` AS `Bankaccount` LEFT JOIN `users` AS `User` ON > > (`Bankaccount`.`user_id` = `User`.`id`) WHERE `Bankaccount`.`userid` = > > 5 LIMIT 1 > > Warning: SQL Error: 1054: Unknown column 'Bankaccount.userid' in > > 'where clause' in ...cake/libs/model/datasources/dbo_source.php on > > line 463 > > > Fatal error: Call to undefined method: bankaccount->onerror() in .../ > > cake/libs/model/datasources/dbo_source.php on line 596 > > > have I done something wrong or there is an incompatibility? > > > Thanks > > > -- M > > -- > (the old fart) the advice is free, the lack of crankiness will cost you > > - its a fine line between a real question and an idiot > > http://blog.samdevore.com/archives/2007/03/05/when-open-source-bugs-me/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Cakephp generates Wrong query in PHP4?
I am fairly sure that in php 4 you have to do FindByUser_Id I know this used to be the case due to limitations in php 4 see https://trac.cakephp.org/ticket/1567 for a ticket on the manual for this. I hope that one of the Cake Devs can confirm or deny this Sam D On 7/7/07, M <[EMAIL PROTECTED]> wrote: > > > CakePHP version: : 1.1.15.5144. > > Hello, the Bankaccount model belongs to User model. > > Now, in BankaccountsController::view method I have this statement: > > $data = $this->Bankaccount->findByUserId( $user_id ); > > In PHP 5 it works fine. > > In PHP 4.4.7 it gives this error: > > Query: SELECT `Bankaccount`.`id`, `Bankaccount`.`user_id`, > `Bankaccount`.`credits`, `Bankaccount`.`created`, > `Bankaccount`.`modified`, `User`.`id`, `User`.`username`, > `User`.`password`, `User`.`name`, `User`.`email`, `User`.`telno`, > `User`.`race`, `User`.`sex`, `User`.`level`, `User`.`hp`, > `User`.`hpmax`, `User`.`str`, `User`.`strmax`, `User`.`dex`, > `User`.`dexmax`, `User`.`int`, `User`.`intmax`, `User`.`cha`, > `User`.`chamax`, `User`.`energy`, `User`.`credits`, > `User`.`last_visit`, `User`.`group_id`, `User`.`active`, > `User`.`token`, `User`.`created`, `User`.`modified` FROM > `bankaccounts` AS `Bankaccount` LEFT JOIN `users` AS `User` ON > (`Bankaccount`.`user_id` = `User`.`id`) WHERE `Bankaccount`.`userid` = > 5 LIMIT 1 > Warning: SQL Error: 1054: Unknown column 'Bankaccount.userid' in > 'where clause' in ...cake/libs/model/datasources/dbo_source.php on > line 463 > > Fatal error: Call to undefined method: bankaccount->onerror() in .../ > cake/libs/model/datasources/dbo_source.php on line 596 > > have I done something wrong or there is an incompatibility? > > Thanks > > -- M > > > > > -- (the old fart) the advice is free, the lack of crankiness will cost you - its a fine line between a real question and an idiot http://blog.samdevore.com/archives/2007/03/05/when-open-source-bugs-me/ --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Cakephp generates Wrong query in PHP4?
CakePHP version: : 1.1.15.5144. Hello, the Bankaccount model belongs to User model. Now, in BankaccountsController::view method I have this statement: $data = $this->Bankaccount->findByUserId( $user_id ); In PHP 5 it works fine. In PHP 4.4.7 it gives this error: Query: SELECT `Bankaccount`.`id`, `Bankaccount`.`user_id`, `Bankaccount`.`credits`, `Bankaccount`.`created`, `Bankaccount`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`email`, `User`.`telno`, `User`.`race`, `User`.`sex`, `User`.`level`, `User`.`hp`, `User`.`hpmax`, `User`.`str`, `User`.`strmax`, `User`.`dex`, `User`.`dexmax`, `User`.`int`, `User`.`intmax`, `User`.`cha`, `User`.`chamax`, `User`.`energy`, `User`.`credits`, `User`.`last_visit`, `User`.`group_id`, `User`.`active`, `User`.`token`, `User`.`created`, `User`.`modified` FROM `bankaccounts` AS `Bankaccount` LEFT JOIN `users` AS `User` ON (`Bankaccount`.`user_id` = `User`.`id`) WHERE `Bankaccount`.`userid` = 5 LIMIT 1 Warning: SQL Error: 1054: Unknown column 'Bankaccount.userid' in 'where clause' in ...cake/libs/model/datasources/dbo_source.php on line 463 Fatal error: Call to undefined method: bankaccount->onerror() in .../ cake/libs/model/datasources/dbo_source.php on line 596 have I done something wrong or there is an incompatibility? Thanks -- M --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---