Search Inconsistency

[shlomik]

Hi,

 

I have a problem with my secondary language search. It fails regardless of what i am trying to search for.

 

The interesting thing is that if I echo the search query and use it directly in my data base, it works just fine.

 

I echoed it in advance_search_result.php just before:

 

require(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);

 

and the result i got was correct (the search still failed).

 

I tracked it into split_page_results.php, the echoed query just after:

 

$count_query = tep_db_query("select count(" . $count_string . ") as total " . substr($this->sql_query, $pos_from, ($pos_to - $pos_from)));

 

is fine, but when i echo the count result, i get 0 even though the result in the data base is different.

 

This of course breaks the rest of the flow, and i get no resuls for the search.

 

Any ideas? My secondary lang is Hebrew.

 

Shlomi