How to see the mysql query passed by report on Firefox console?
38 views
Skip to first unread message
Aditya Duggal
Apr 9, 2014, 4:46:15 AM4/9/14
to erpnext-dev...@googlegroups.com
Hi,
I have been writing a lot of script reports on erpnext for my own purposes. I am facing a problem while debugging my code, the problem is that I am not able to find the mysql query which is being passed on after application of filters etc.
Is there a way that we could look at the query on the console so that I could debug it properly.
MP
Apr 10, 2014, 10:34:09 AM4/10/14
to erpnext-dev...@googlegroups.com
Hi Aditya,
In version 2 (Apache + CGI), you can enable logging of SQL queries by setting logging = 2 in conf.py file under erpnext directory. I am not sure if it has been implemented in version 3 and version 4. This is very helpful when debugging reports etc. It should be part of version 3 and Version 4.
Kind regards,
Mayur Patel
In version 2 (Apache + CGI), you can enable logging of SQL queries by setting logging = 2 in conf.py file under erpnext directory. I am not sure if it has been implemented in version 3 and version 4. This is very helpful when debugging reports etc. It should be part of version 3 and Version 4.
Kind regards,
Mayur Patel
Reply all
Reply to author
Forward
0 new messages