rassy Posted August 28, 2011 Share Posted August 28, 2011 Hi guys, is there a way to debug all SQL statements that are generated in real-time? I switched on the "define('_PS_DEBUG_SQL_', true)" BUT I see no output. I would be really thankful for a tip. Thanks Rassy Link to comment Share on other sites More sharing options...
rassy Posted September 11, 2011 Author Share Posted September 11, 2011 Hi guys, I am still searching for a way to "debug" the sql-queries within prestashop. What is the best way to do this? I would love to see which SQL Statements are run and how long they take. I would really be thankful for a tip Rassy Link to comment Share on other sites More sharing options...
razaro Posted September 12, 2011 Share Posted September 12, 2011 I think that "define('_PS_DEBUG_SQL_', true)" displays just error in SQL statement, if any. If you use some 1.4 version in override/classes folder rename files _FrontController.php, _MySQL.php, _Module.php by removing _ . Then in front office you will see some info and SQL times for queries. Link to comment Share on other sites More sharing options...
tomerg3 Posted September 12, 2011 Share Posted September 12, 2011 What statements are you trying to debug exactly? Link to comment Share on other sites More sharing options...
rassy Posted September 13, 2011 Author Share Posted September 13, 2011 Razaros tip works great!!! Thanks for your help guys!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now