Loggin all Db Queries

[Thalant]

Hello everyone,

 

I am having some problems in my web. I think that an update query which I don't want to be executed is being executed and I can't find where.

 

With the porpuse of finding which is exactly the query, and when it is being executed, plus having more security on my web, I'd like to have a log with all the queries that are executed.

 

So I'd like to know how can I store every single query on a txt log . I guess there must be a place where all the sql queries go trough, but I can't find it anywhere.

 

Thank you

[El Patron]

what is your ps version?

 

generally if you can navigate to a page that you 'think' the statement is executing you can enable debug mode

 

config/defines.inc.php

 

define('_PS_DEBUG_PROFILING_', true);

 

then navigate to page to replicate and scroll down, there is a lot of information, make sure to turn off (false) when done.
 

[vekia]

if you turn on debug profiling everyone will see these logs, so i think that you're looking for some kind of logs only for you, am i right/

[El Patron]

vekia makes excellent point about debug, it's very visible.

 

here is an article on how to run debug privately.

 

http://blog.dh42.com/discrete-prestashop-debugging/

[Thalant]

Hello,

thanks to both of you for your help, but as vekia said, I am interested on having a private log and I don't have a clue on which page is being executed that statement.

 

So what I am really, really interested in is if there is any point on the Db class where every query goes trough before being executed.