query log and requestaction

2007-09-15 Thread Claudia

Hi there

One of my controllers has an action that is only called via
requestaction from within an element. The idea behind is to cache this
element as described in
http://bakery.cakephp.org/articles/view/optimizing-your-cakephp-elements-and-views-with-caching

Generally this approach works fine, the only problem that I have is
that the queries made in the requested action are not displayed in the
query log even if no caching is used. This makes it hard to
troubleshoot any problems with the queries.

Does anyone have an idea why the queries are not in the log and how I
could get them there?

I am using cake 1.2.

Thanks for any hints

Claudia


--~--~-~--~~~---~--~~
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: query log and requestaction

2007-09-15 Thread francky06l

Very strange because I use the same approach. Are you sure your query
is not in the log because the element is already cached ?
If the element is cached, then your query is not executed
and ...therefore no log.

Hope this helps
Franck

On Sep 15, 6:53 pm, Claudia [EMAIL PROTECTED] wrote:
 Hi there

 One of my controllers has an action that is only called via
 requestaction from within an element. The idea behind is to cache this
 element as described 
 inhttp://bakery.cakephp.org/articles/view/optimizing-your-cakephp-eleme...

 Generally this approach works fine, the only problem that I have is
 that the queries made in the requested action are not displayed in the
 query log even if no caching is used. This makes it hard to
 troubleshoot any problems with the queries.

 Does anyone have an idea why the queries are not in the log and how I
 could get them there?

 I am using cake 1.2.

 Thanks for any hints

 Claudia


--~--~-~--~~~---~--~~
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: query log and requestaction

2007-09-15 Thread Claudia

Thanks for your quick reply.
Yes, I am sure that no caching takes place.
I don't use any cache parameter at the moment and
I have also checked the cache directory - no files in there.

But I just remembered that I fiddled around with the sqllog so it
does not mess the html of up my pages - maybe I messed
something up here. As the same setup is working for you
the problem is most likely caused by my fiddling
(although the other queries appear just fine).
I'll check it out and post again if the same happens with
default sql logging.


Claudia


--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---