SQL debug output

Tuesday 17 February 2009 7:45:24 am

Hello everyone,

I'm newbie on eZ Publish (v 4.0.1).

My aim is to see which queries are executed when I run one of my eZ website page. For example, the query executed when there is a "fetch" in my template.

I checked the documentation and the forum (even google) and did several manipulations, with no results. I managed to get a debug on the administrator interface but the queries are not what I am looking for.
I'm sure I'veg just missed something obvious but, after several hours, I still don't what.

I'd be pleased if anyone could explain me the right manipulation.

Thank you.

Victor

Tuesday 17 February 2009 9:34:28 am

First, thanks for the answer.

Second, my aim is to get the query executed by the template when I load a page.

I did activate SQL debug output: I checked the SQL Debug Output and Debug Output boxes after selecting my website Siteaccess in the dropdownlist.
So I'm sure to have done something wrong in those two steps. Because, I don't get anything anywhere.

But, when I select the "Global (override)" Siteaccess, I get an eZ Debug but not the one I want.

Thank you.

Wednesday 18 February 2009 5:49:52 am

What I was looking for was in the /var/log/notice.ini file. I was expecting it to be displayed on my website page, like for the admin interface. My mistake.

Thank you for your time and reply.

Victor