This quick debugging tip is very helpful, but not enough when it comes to debugging SQL queries in Magento!
I just read that in v1.1.1 an SQL debugging option was added to the code, but could not find anything about how to trigger this option?
When I log the $select array I see this variable
as part of the Varien_Db_Select object, but there is nothing being written to var/debug/sql.txt. I created the directory and and empty sql.txt file with full write permissions to no avail.
[_debugFile:protected] => var/debug/sql.txt
I’ve seen various threads about debugging questions - most unanswered. It would be very nice to have a Wiki entry about debugging Magento. I read that the Magento team uses Zend Studio for debugging, but as not everybody is using this IDE it would be very nice to have some easy debugging options.