Hi,<br><br>I found out how to turn on the debug mode (damn, taht was hard :-) ) and here is the out when I search for 'galati' (there is a city called Galați in Romania):<br><pre id="line1">string(196) "select min(word_id) as word_id,word_token, word, class, type, location,country_code from word where word_token in (' galati','galati') group by word_token, word, class, type, location,country_code"<br>
array(1) {<br> [0]=><br> array(3) {<br> ["string"]=><br> string(6) "galati"<br> ["words"]=><br> array(1) {<br> [0]=><br> string(6) "galati"<br> }<br>
["wordsets"]=><br> array(1) {<br> [0]=><br> array(1) {<br> [0]=><br> string(6) "galati"<br> }<br> }<br> }<br>}<br>array(2) {<br> ["galati"]=><br>
array(1) {<br> [0]=><br> array(7) {<br> ["word_id"]=><br> string(3) "510"<br> ["word_token"]=><br> string(6) "galati"<br> ["word"]=><br>
NULL<br> ["class"]=><br> NULL<br> ["type"]=><br> NULL<br> ["location"]=><br> NULL<br> ["country_code"]=><br> NULL<br> }<br>
}<br> [" galati"]=><br> array(1) {<br> [0]=><br> array(7) {<br> ["word_id"]=><br> string(3) "509"<br> ["word_token"]=><br> string(7) " galati"<br>
["word"]=><br> string(7) "Galați"<br> ["class"]=><br> NULL<br> ["type"]=><br> NULL<br> ["location"]=><br> NULL<br> ["country_code"]=><br>
NULL<br> }<br> }<br>}<br>array(2) {<br> [1]=><br> array(1) {<br> [0]=><br> array(11) {<br> ["iSearchRank"]=><br> int(1)<br> ["iNamePhrase"]=><br> int(0)<br>
["sCountryCode"]=><br> bool(false)<br> ["aName"]=><br> array(1) {<br> [509]=><br> string(3) "509"<br> }<br> ["aAddress"]=><br>
array(1) {<br> [509]=><br> string(3) "509"<br> }<br> ["sClass"]=><br> string(0) ""<br> ["sType"]=><br> string(0) ""<br>
["sHouseNumber"]=><br> string(0) ""<br> ["fLat"]=><br> string(0) ""<br> ["fLon"]=><br> string(0) ""<br> ["fRadius"]=><br>
string(0) ""<br> }<br> }<br> [10]=><br> array(1) {<br> [0]=><br> array(11) {<br> ["iSearchRank"]=><br> int(10)<br> ["iNamePhrase"]=><br> int(0)<br>
["sCountryCode"]=><br> bool(false)<br> ["aName"]=><br> array(1) {<br> [510]=><br> string(3) "510"<br> }<br> ["aAddress"]=><br>
array(1) {<br> [510]=><br> string(3) "510"<br> }<br> ["sClass"]=><br> string(0) ""<br> ["sType"]=><br> string(0) ""<br>
["sHouseNumber"]=><br> string(0) ""<br> ["fLat"]=><br> string(0) ""<br> ["fLon"]=><br> string(0) ""<br> ["fRadius"]=><br>
string(0) ""<br> }<br> }<br>}<br><<span class="start-tag">table</span><span class="attribute-name"> border</span>=<span class="attribute-value">"1"</span>><<span class="start-tag">tr</span>><<span class="start-tag">td</span>>1</<span class="end-tag">td</span>><<span class="start-tag">td</span>># galati#</<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>></<span class="end-tag">tr</span>><<span class="start-tag">tr</span>><<span class="start-tag">td</span>>10</<span class="end-tag">td</span>><<span class="start-tag">td</span>>#galati#</<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>><<span class="start-tag">td</span>></<span class="end-tag">td</span>></<span class="end-tag">tr</span>></<span class="end-tag">table</span>>array(11) {<br>
["iSearchRank"]=><br> int(1)<br> ["iNamePhrase"]=><br> int(0)<br> ["sCountryCode"]=><br> bool(false)<br> ["aName"]=><br> array(1) {<br> [509]=><br> string(3) "509"<br>
}<br> ["aAddress"]=><br> array(1) {<br> [509]=><br> string(3) "509"<br> }<br> ["sClass"]=><br> string(0) ""<br> ["sType"]=><br> string(0) ""<br>
["sHouseNumber"]=><br> string(0) ""<br> ["fLat"]=><br> string(0) ""<br> ["fLon"]=><br> string(0) ""<br> ["fRadius"]=><br> string(0) ""<br>
}<br>string(697) "select place_id,ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-295.312499988,83.0509608196),ST_Point(295.312499988,-75.881174634)),4326), centroid) as in_small,ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-885.937499965,241.983096273),ST_Point(885.937499965,-234.813310088)),4326), centroid) as in_large from search_name where name_vector @> ARRAY[509] and nameaddress_vector @> ARRAY[509] order by ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-295.312499988,83.0509608196),ST_Point(295.312499988,-75.881174634)),4326), centroid) desc, ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-885.937499965,241.983096273),ST_Point(885.937499965,-234.813310088)),4326), centroid) desc, search_rank ASC limit 10"<br>
array(0) {<br>}<br>array(11) {<br> ["iSearchRank"]=><br> int(10)<br> ["iNamePhrase"]=><br> int(0)<br> ["sCountryCode"]=><br> bool(false)<br> ["aName"]=><br> array(1) {<br>
[510]=><br> string(3) "510"<br> }<br> ["aAddress"]=><br> array(1) {<br> [510]=><br> string(3) "510"<br> }<br> ["sClass"]=><br> string(0) ""<br>
["sType"]=><br> string(0) ""<br> ["sHouseNumber"]=><br> string(0) ""<br> ["fLat"]=><br> string(0) ""<br> ["fLon"]=><br> string(0) ""<br>
["fRadius"]=><br> string(0) ""<br>}<br>string(697) "select place_id,ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-295.312499988,83.0509608196),ST_Point(295.312499988,-75.881174634)),4326), centroid) as in_small,ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-885.937499965,241.983096273),ST_Point(885.937499965,-234.813310088)),4326), centroid) as in_large from search_name where name_vector @> ARRAY[510] and nameaddress_vector @> ARRAY[510] order by ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-295.312499988,83.0509608196),ST_Point(295.312499988,-75.881174634)),4326), centroid) desc, ST_Contains(ST_SetSRID(ST_MakeBox2D(ST_Point(-885.937499965,241.983096273),ST_Point(885.937499965,-234.813310088)),4326), centroid) desc, search_rank ASC limit 10"<br>
array(0) {<br>}<br></pre>I have tried to execute those statements manually, and I have found out that the search_name table is empty. In what conditions does this happen? Am I missing some steps while creating/updating the DB (from a short investigation of the code - I am far from being a pgSQL expert - seems like something is going wrong while reindexing the data)?<br>
<br>Thanks,<br>Ciprian<br>