One more case when in one env code works and in other not - different
MySQL versions and their different bugs. If it is, you can try install
same version as on prod into your test env and check (but it is a hard
way, I know).

On Nov 17, 8:18 pm, Thiago Elias <thiagopt...@gmail.com> wrote:
> Thanks for the answer Dr. Loboto.
>
> I'm really using Views for some tables, bacause we have another schema that
> my application depends on, and I didn't fetch associated results in cake for
> different schemas so far. (cake doesn't make the joins with tables in
> different schemas (eg: using the prefix of the another schema), so I've
> decided to use views instead. If is there some way to do this, my life will
> be easier.. =)
>
> By the way, my views are working fine in the test environment, and the
> database is the same (when we've finished the project, we've cleaned the
> database and executed the sql script to create). About the permissions, I've
> tried with root, but I've got the same problem, (I'll try again to be sure).
>
> Thanks for the help.
>
> Atenciosamente,
> Thiago Elias Rezende Silva
> Programador Portal CidadãoPGwww.cidadaopg.sp.gov.br
>
> Stephen 
> Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html>
> - "I detest life-insurance agents: they always argue that I shall some
> day
> die, which is not so."
>
> 2009/11/17 Dr. Loboto <drlob...@gmail.com>
>
>
>
> > It is definitely not Apache problem. Are databases same in both
> > environments? Wrong model key may sometimes appear when you use MySQL
> > views instead of tables. Also there may be not enough DB access rights
> > to get tables structure.
>
> > On Nov 16, 8:20 pm, Thiago Elias <thiagopt...@gmail.com> wrote:
> > > Hey guys.
>
> > > I'm experiencing an strange problem these days:
>
> > > I have 3 environments for cakePHP:
>
> > > - Development (my machine and the other programmers machines) (Windows
> > > XP/SP3 Apache 2 via xammp)
> > > - Test Environment (Debian Linux 5 Lenny Apache 2)
> > > - Production Environment (Debian Linux 4 Etch Apache 1.3)
>
> > > Unfortunatelly, I'm not able to change Apache 1.3 to 2.x on Production
> > > Environment right now (We have another server that may be configured in
> > next
> > > days with 2.x)
>
> > > The matter is:
>
> > > On Development and Test Environments, When I made some
> > $this->model->find(),
> > > the resultant array is normal like this:
>
> > > [0] => array(
> > >     [Person] => array(
> > >         [person_name] => Person name
> > >         [created] => 2009-09-10
> > >     )
> > >     [Access] => array(
> > >         [login] => some_login_username
> > >         [pass] => some_password
> > >     )
> > > )
>
> > > [1] => array(
> > >     [Person] => array(
> > >         [person_name] => Person name
> > >         [created] => 2009-09-10
> > >     )
> > >     [Access] => array(
> > >         [login] => some_login_username
> > >         [pass] => some_password
> > >     )
> > > )
>
> > > This is normal. I get the array index as the Model name, but when I
> > upload
> > > to my Production Environment, these arrays comes absolutely different, as
> > > below:
>
> > > [0] => array(
> > >     [0] => array(
> > >         [person_name] => Person name
> > >         [created] => 2009-09-10
> > >         [login] => some_login_username
> > >         [pass] => some_password
> > >     )
> > > )
>
> > > [1] => array(
> > >     [0] => array(
> > >         [person_name] => Person name
> > >         [created] => 2009-09-10
> > >         [login] => some_login_username
> > >         [pass] => some_password
> > >     )
> > > )
>
> > > The resultant array is strange. Cake is joining Person and Access, and
> > > instead the model name, he's just naming as 0.
>
> > > Anyone here knows something to correct this, or even has experienced this
> > > problem before ?!
>
> > > I'm using *cakePHP 1.2.5* in all environments.
>
> > > Thanks for the help and patience. (and sorry for my bad english).
>
> > > Atenciosamente,
> > > Thiago Elias Rezende Silva
> > > Programador Portal 
> > > CidadãoPGwww.cidadaopg.sp.gov.br<http://xn--cidadopgwww-d8a.cidadaopg.sp.gov.br>
>
> > > Samuel Goldwyn<
> >http://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html>
> > > - "I'm willing to admit that I may not always be right, but I am never
> > > wrong."
>
> > --
>
> > You received this message because you are subscribed to the Google Groups
> > "CakePHP" group.
> > To post to this group, send email to cake-...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > cake-php+unsubscr...@googlegroups.com<cake-php%2bunsubscr...@googlegroups.c 
> > om>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/cake-php?hl=.

--

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-...@googlegroups.com.
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?hl=.


Reply via email to