It looks like there is a bug in the code.
Update this section in the queryobj.php file:
$paramValue = strtotime($paramValue);
if ($hasTime) {
$paramValue = date('Y-m-d H:i:s',$paramValue);
} else {
$paramValue = date('Y-m-d',$paramValue);
}
and wrap it in an IF statement like:
if ($paramValue) {
$paramValue = strtotime($paramValue);
if ($hasTime) {
$paramValue = date('Y-m-d H:i:s',$paramValue);
} else {
$paramValue = date('Y-m-d',$paramValue);
}
}
The code that we have to update the syntax of date columns to a format that MySQL recognizes is still running even when no value is entered and causing this problem.