SQL Output debug switch not working

Software Support
#1

Hello again,

; Enable database debug output (very verbose!)
debug = On

In previous versions I could use this statement in config.inc.php to see the output of all the SQL queries for any given page, however since upgrading from 2.4 to 3.2 that switch no longer turns on SQL output for any page. Is this expected behavior? Does it matter that I’ve also upgraded my database to MySQL 8?

Thanks a bunch

#2

Hi @Jafucius,

In OJS/OMP/OPS 3.2 the SQL queries were split between two frameworks – ADODB and Illuminate/Database. The debug option only applied to ADODB. Starting with OJS/OMP/OPS 3.3, all queries are executed using Illuminate/Database and the debug option now works on that toolset.

Regards,
Alec Smecher
Public Knowledge Project Team