# HG changeset patch # User Dan # Date 1227937115 18000 # Node ID 7ba7b85e119500ec05c321c3514afc77e9417f60 # Parent e8cf183834253962824b8c499c484accb868b4b3 Fixed PostgreSQL incompatibility in new search API diff -r e8cf18383425 -r 7ba7b85e1195 includes/search.php --- a/includes/search.php Sat Nov 29 00:20:57 2008 -0500 +++ b/includes/search.php Sat Nov 29 00:38:35 2008 -0500 @@ -954,9 +954,9 @@ $where_any =& $where['any']; $where_req =& $where['req']; $where_not =& $where['not']; - $title_col = ( $case_sensitive ) ? $options['titlecolumn'] : 'lcase(' . $options['titlecolumn'] . ')'; + $title_col = ( $case_sensitive ) ? $options['titlecolumn'] : ENANO_SQLFUNC_LOWERCASE . '(' . $options['titlecolumn'] . ')'; if ( isset($options['datacolumn']) ) - $desc_col = ( $case_sensitive ) ? $options['datacolumn'] : 'lcase(' . $options['datacolumn'] . ')'; + $desc_col = ( $case_sensitive ) ? $options['datacolumn'] : ENANO_SQLFUNC_LOWERCASE . '(' . $options['datacolumn'] . ')'; else $desc_col = "''"; foreach ( $terms['any'] as $term )