SQL debug output

Next topic

Author	Message
Victor Dujardin	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
justin kazadi	Tuesday 17 February 2009 8:39:12 am Hi victor, could you please be very clear? what do you want to do exactly? do you want to activate the sql debug? if so go to the administrator interface to the right menu check the sql debut output , apply the change and clear the cache. i think is what you want. The theory is when we know everything and nothing works. The practice is when everything works and nobody knows why. If the practice and theory are met, nothing works and we do not know why. Albert Einstein
Victor Dujardin	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.
André R.	Tuesday 17 February 2009 12:31:03 pm Database settings: http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/databasesettings Debug settings: http://ez.no/doc/ez_publish/technical_manual/4_0/reference/configuration_files/site_ini/debugsettings And how to work with ini files: http://ez.no/doc/ez_publish/technical_manual/4_0/concepts_and_basics/configuration eZ Online Editor 5: http://projects.ez.no/ezoe \|\| eZJSCore (Ajax): http://projects.ez.no/ezjscore \|\| eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription @: http://twitter.com/andrerom
Victor Dujardin	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