Re: CakePHP 1.2.5 and Mysql 5.0.51a

You can get out SQL queries by extending mysql dbo driver log methods.
Read http://book.cakephp.org/view/87/DataSources

Example for firebug output
http://bin.cakephp.org/view/27213675

On Mar 2, 9:40 am, John Andersen <j.andersen...@gmail.com> wrote:
> Use the CakePHP logging functions together with debug, that should do
> it from the controller.
> Seehttp://book.cakephp.org/view/157/Logging
> It will not give you the SQL statements, but at least the data and
> other information can be gathered into the log.
> Enjoy,
>    John
>
> On Mar 2, 9:58 am, Michiel Rensen <mjren...@gmail.com> wrote:
>
> > Is there a way in Cake to show debug information *not* in the view but
> > in the controller? I'm using cake as a server application with a Flex-
> > client over AmfPHP, so I never use cake views, therefor never get to
> > see the cake-debug information...
>
> > On Mar 1, 5:06 pm, John Andersen <j.andersen...@gmail.com> wrote:
>
> > > Have you positive proof that it is a CakePHP issue and not a data
> > > issue? Have you taken the "offending" SQL statement(s) and executed
> > > them in both environments outside of CakePHP?
> > > Can you show the SQL code which is the issue?
> > > Enjoy,
> > >    John
>
> > > On Mar 1, 12:11 pm, Michiel Rensen <mjren...@gmail.com> wrote:
>
> > > > Far into the development-process of a project I noticed a discrepancy
> > > > in MySQL-database servers between my test-server and the clients test-
> > > > server (local test-server -> client's test-server -> clients live-
> > > > server). [I know it's a major mistake, but I didn't notice any
> > > > problems until now]. They run MySQL 5.0.51a and I run 5.0.67. When I
> > > > run a query using the same cake-code on the same data-set results in
> > > > different results (there: nothing, here: expected result).
> > > > Does anyone know why queries in this configuration (CakePHP 1.2.5 and
> > > > MySQL 5.0.51a) result in unexpected results and more importantly does
> > > > anyone know a quick fix (i.e. changing server configuration is sadly
> > > > but logically not an option)?
>
> > > > Thanks in advance!
>
>

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en