I was receiving an error when searching for "is blank" on all my date fields. The issue was that system was appending to single quotes to the "is null" where clause in the sql. The is null parameter looked like 'is null '')". This was breaking the system.
I didn't have time to search down the exact cause. I just used a src_replace function on the doQuery function. On line 215 I added:
//fix date search error on is null
$issue_text = "is null '')";
$fixed_text = "is null)";
if(strpos($query,$issue_text))
{
$query = str_replace($issue_text,$fixed_text,$query);
}
This fixed the issue as far as I can see. Has anyone else seen this issue?
Andy