[programerboy]

Hi,

In executeQuery function there is a constant variable with DEBUG_SQL name. If I set it to 1 I can see my queries errors.
But where can I set this constant to 1?
Because I think this variable only exists in this function and it isn't in config file !!!

Thanks

[andreaadamczyk]

Hello programerboy,

You cannot modify the ProcessMaker core, setting the value to 1 to show the query errors; however, what you can do is enable the propel logs to be able to identify errors in your queries by adding the mysql_debug = 1 parameter in the env.ini file so then you could see the logs in /shared/logs/propel.log.

For more details you could see the documentation on the following page:

http://wiki.processmaker.com/3.2/Config ... QL_Logging

I hope it helps you.

Best regards.

[programerboy]

Thanks for your answer,

I set debug_sql=1 in env file and it didn't any thing in propel.log file and I saw 500 error alarm in page.
Therefore I set DEBUG_SQL=1 in this function and I saw query error.

Thanks