Open smcguire36 opened 6 years ago
That error occours on mysql.
Issue is in components/lib/dao/dbDataProvider.cfc on Line 147
To fix it on mysql replace
<cfset tmpMessage = replace(replace(tmpMessage,"[","[[]",'all'),"''","'")>
with
<cfset tmpMessage = replace(tmpMessage,"''","'")>
I think that masking of"[" should only be used on mssql, as it is done in components/entryFinder.cfc:124
<cfif dbtype eq "mssql">
<cfset tmpMessage = replace(replace(tmpMessage,"[","[[]",'all'),"''","'", "all")>
</cfif>
Maybe someone, who is more familiar with the project, can write a pull request based on this information.
I have an error log with multiples of the same error. If I select "Delete all reports with the same message on this application" it doesn't delete ANY reports at all. I can delete one report at a time no problem.
It doesn't give any errors, it just doesn't delete anything.