Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
When using either the latest stable 7.x-1.5 or the latest dev
Nothing happens when clicking the "E" link of the slow query log, and I get the following error in watchdog :
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1: EXPLAIN ; Array ( ) in devel_querylog_explain() (line 46 of /var/www/html/sites/all/modules/contrib/devel/devel.pages.inc).
it seems to work correctly with php 5.3 but breaks on 5.6
Comments
Comment #1
willzyx CreditAttribution: willzyx commented@loze your problem may be related to #2465025: SQL query log doesn't work on pages generated by a view. Can you try patch from #1 and see if it solve the issue?
Comment #2
willzyx CreditAttribution: willzyx commented@loze can you confirm that the latest dev version solves this issue?
Comment #3
willzyx CreditAttribution: willzyx commentedClosing this, since in #2465025: SQL query log doesn't work on pages generated by a view we solve this issue. Feel free to reopen if you think that the problem is still present.