7.11.15 Audit Module View Change Log Bug

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

Hi Folks,

Following the 7.11.15 upgrade (in my instance from 7.11.13) there is a SQL syntax error in modules/Audit/Audit.php

Specifically line 135 includes a call to the MySQL IFNULL function, in a SQL Server install this will fail with a syntax error ending [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]‘IFNULL’ is not a recognized built-in function name. (ODBC driver will be specific to your install).

To correct this and restore Change Log functionality it is necessary to change the IFNULL to the SQL Server function ISNULL.

Regards,
Ian

#2

Could you raise this on GitHub please if you are able to replicate the issue. If you already have the fix your welcome to raise a related PR which our team can assess.

#3

I posted on the relevant PR alerting to this bug

1 Like
#4

Please check the fix in this PR comment:

2 Likes
#5

PR created.

1 Like