Log SQL Query

[MorningStar]

Is it posible to activate log for all sql queries?

[Kurt]

I have the same question. I have seen suggestions elsewhere that say "set logger level in data/config.php to 'DEBUG'" but that does not work for me. It actually doesn't increase the logging at all which may be another issue.

I tried adding print statements in a variety of places but haven't been able to find a place where it actually puts the query together (I'm not a PHP developer). In my situation I'm trying to override getDuplicateWhereClause() for a few entities but it's not following the logic as I would expect (it's counting the same entity as a duplicate even though Record.php seems to have code that should prevent that). So looking at the SQL it's putting together would be helpful in debugging...

[tanya]

https://github.com/espocrm/espocrm/blob/master/application/Espo/ORM/DB/Query/Base.php#L431

add here $GLOBALS['log']->debug($sql); and save

[khopper]

https://github.com/espocrm/espocrm/b.../Base.php#L431
add here $GLOBALS['log']->debug($sql); and save

Where would this be added to?

[yuri]

It's already possible to log SQL queries to the log file. https://docs.espocrm.com/administrat...g/#sql-queries