Re: Cakephp,Auth with Oracle connectivity
Hi, because you changed you alias, the results from the database are stored in a "Mem" hash instead of a "User" hash. You need to modify your views to reflect the change as well. Also, click on the notice, you will get more information as to where the error might have occured. Cheers, ojonam -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp,Auth with Oracle connectivity
Hello Manoj, I can confirm that after putting alias, i am able to login with oracle database. However in my login page after putting alias i am getting some notice and warning. *Notice* (8): Trying to get property of non-object [*CORE\cake\libs\view\helper.php*, line *458*] *Warning* (2): array_keys() expects parameter 1 to be array, null given [*CORE\cake\libs\view\helper.php*, line *458*] *Warning* (2): in_array() expects parameter 2 to be array, null given [*CORE\cake\libs\view\helper.php*, line *458*] Can you please suggest how to resolve this issue? Regards Tapan Thapa On Mon, Apr 11, 2011 at 8:33 PM, Tapan Kumar Thapa < tapan.th...@hindustantimes.com> wrote: > Nice to know that after such a long time someone is there to help... > > I will try this and will get back in case it works.. > > Regards > Tapan Thapa > > > On Mon, Apr 11, 2011 at 8:11 PM, ojonam wrote: > >> Hi, >> >> this is because Oracle has a list of reserved keywords (like "User") which >> make your query impossible to deal with for Oracle. The full list is >> available here : >> http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm. >> This means that you cannot use the term 'User' directly in a query. Your >> option is to create an alias for the user model. In the model/user.php file, >> add the following: >> >> class User extends AppModel { >> var $name = 'User'; >> var $alias = 'Mem'; >> >> Hope this helps! >> >> PS: your error is actually an Oracle SQL error. Try using SQLDeveloper or >> some other client to test these queries independently of cake. >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp,Auth with Oracle connectivity
Nice to know that after such a long time someone is there to help... I will try this and will get back in case it works.. Regards Tapan Thapa On Mon, Apr 11, 2011 at 8:11 PM, ojonam wrote: > Hi, > > this is because Oracle has a list of reserved keywords (like "User") which > make your query impossible to deal with for Oracle. The full list is > available here : > http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm. > This means that you cannot use the term 'User' directly in a query. Your > option is to create an alias for the user model. In the model/user.php file, > add the following: > > class User extends AppModel { > var $name = 'User'; > var $alias = 'Mem'; > > Hope this helps! > > PS: your error is actually an Oracle SQL error. Try using SQLDeveloper or > some other client to test these queries independently of cake. > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > cake-php+unsubscr...@googlegroups.com For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp,Auth with Oracle connectivity
Hi, this is because Oracle has a list of reserved keywords (like "User") which make your query impossible to deal with for Oracle. The full list is available here : http://download.oracle.com/docs/cd/B10500_01/appdev.920/a42525/apb.htm. This means that you cannot use the term 'User' directly in a query. Your option is to create an alias for the user model. In the model/user.php file, add the following: class User extends AppModel { var $name = 'User'; var $alias = 'Mem'; Hope this helps! PS: your error is actually an Oracle SQL error. Try using SQLDeveloper or some other client to test these queries independently of cake. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Cakephp,Auth with Oracle connectivity
http://procsharp.blogspot.com/2011/04/connect-oracle-with-cakephp.html -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php