Patch for testing advanced searches with custom date fields. Cause was where the custom field is tested to skip the field if the search param is empty. Problem is a date custom field is an array of day,month, and year, so it's never empty. This led to the eventum_issue_custom_field table being added to the query for each custom date field, but never being properly joined.

Sean

--- eventum-20061019/include/class.issue.php 2006-10-23 11:06:25.000000000 -0700 +++ /var/www/html/eventumbeta/include/class.issue.php 2006-10-23 10:50:18.000000000 -0700 @@ -2867,6 +2867,22 @@ if (empty($search_value)) { continue; } + // test is custom field is an array, such as for dates + if(is_array($search_value)) { + $useArray=0; + foreach($search_value as $searchKey=>$searchValue) { + if (empty($searchValue)) { + continue; + } + // set flag to use array custom field in search + $useArray=1; + } + } + // skip using an array custom field if it is empty + if ($useArray==0) { + continue; + } + $field = Custom_Field::getDetails($fld_id); if ($field['fld_type'] == 'multiple') { $search_value = Misc::escapeInteger($search_value);