Advanced Search "is blank" on date fields

Discuss MySQL Ajax Table Editor

Advanced Search "is blank" on date fields

Postby astutzman » Mon Nov 19, 2012 3:59 pm

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
astutzman
 
Posts: 1
Joined: Mon Nov 19, 2012 3:52 pm

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 8 guests

cron