SQL Output debug switch not working

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

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

Hi @asmecher so is not possible to see the executed queries in OJS 3.3.0.8?

Hi @juancure,

Yes, with 3.3.0-x and with the debug option enabled, all SQL queries are logged to the PHP error log.

Regards,
Alec Smecher
Public Knowledge Project Team

This topic was automatically closed after 5 days. New replies are no longer allowed.