Re: Find results with or without whitespace

I had the same problem: http://lucene.472066.n3.nabble.com/Results-with-and-without-whitespace-soccer-club-and-soccerclub-td2934742.html#a2964942 -- View this message in context: http://lucene.472066.n3.nabble.com/Find-results-with-or-without-whitespace-tp3117144p3117386.html Sent from the Sol

SOLR and SQL functions

Hello, I have made my own sql function(isSoccerClub). In my sql query browser this works fine. My query looks like: select * from soccer where isSoccerClub(id,name) = 1; Now i try to use this with the DIH. It looks like this: Now i get some error with the full-import: Indexing failed. Rolled

Re: SOLR and SQL functions

Ok, i checked my error logs and find some problems. SET NAMES latin1 SET character_set_results = NULL SHOW VARIABLES SHOW COLLATION SET autocommit=1 SET sql_mode='STRICT_TRANS_TABLES' SET autocommit=0 select * from soccer where isSoccerClub(id,name) = 1; I see that the sql_mode is set to ST

Re: SOLR and SQL functions

I have found the problem. Some records has incorrect data. Thanks for your help so far!! -- View this message in context: http://lucene.472066.n3.nabble.com/SOLR-and-SQL-functions-tp3129175p3129409.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: How many fields can SOLR handle?

Nobody? I'm still confused about this -- View this message in context: http://lucene.472066.n3.nabble.com/How-many-fields-can-SOLR-handle-tp3033910p3137301.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: How many fields can SOLR handle?

Hi, I know i can add components to my requesthandler. In this situation facets are dependent of there category. So if a user choose for the category TV: Inch: 32 inch(5) 34 inch(3) 40 inch(1) Resolution: Full HD(5) HD ready(2) When a user search for category Computer: CPU: Intel(12) AMD(10) G

Re: How many fields can SOLR handle?

Thanks Bill, That's exactly what i mean. But first i do a request to get the right facetFields from a category. So a user search for TV, i do request to a db to get tv_size and resolution. The next step is to add this to my query like this: facet.field=tv_size&facet.field=resolution. I thought ma

Re: faceting on field with two values

Are you using the DIH?? You can use the transformer to concat the two fields -- View this message in context: http://lucene.472066.n3.nabble.com/faceting-on-field-with-two-values-tp3139870p3139934.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: How many fields can SOLR handle?

Hello Erik, I need the *_facets also for searching so stored must be true. "Then, and I used *_facet similar to you, kept a list of all *_facet actual field names and used those in all subsequent search requests. " Is this not bad for performance? I only need a few facets, not all.(only the face

Re: Problem with spellchecking, dont want multiple request to SOLR

What should the query look like?? I can't define 2 spellchecker in one query. I want something like this: Search: Soccerclub(what) Manchester(where) select/?q=socerclub macnchester&spellcheck=true&spellcheck.dictionary=spell_what&spellcheck.dictionary=spell_where&spell_what=socerclub&spell_where

Re: How many fields can SOLR handle?

Yes i use something like that. I make a db connection to get the facets for the chosen category. With this data i add facet.fields dynamically: example: foreach(results as result){ qStr = "facet.field=" . result; } I was searching for a solution that i don't need to get the facets from db. Now i

- character in search query

Hello, I have some problem with characters in the search term. I have some query's like this: Arsenal - london Ajax - amsterdam Arsenal - moskou Arsenal - China When i send arsenal - london to SOLR i get 2 results, China and moskou. I looked in the debugQuery and it looks like solr is searching

Re: - character in search query

thanks! I use the escape function of the solr pecl package to escape special characters http://docs.php.net/manual/kr/solrutils.escapequerychars.php -- View this message in context: http://lucene.472066.n3.nabble.com/character-in-search-query-tp3168604p3168638.html Sent from the Solr - User mai

Re: - character in search query

It looks like it's still not working. I send this to SOLR: q=arsenal \- london I get no results. When i look at the debugQuery i see this: (name: arsenal | city:arsenal)~1.0 (name: \ | city:\)~1.0 (name: london | city: london)~1.0 my requesthandler: dismax

Re: - character in search query

Yes, i had some tokenizer like this: Now i removed the - from this tokenizer and the debugQuery looks like this: (name:arsenal | city:arsenal)~1.0 (name:\- | city:\-)~1.0 (name:london | city:london)~1.0 Still i get no results.. -- View this message in context: http://lucene.472066.n3.nabble

Re: - character in search query

Anybody? -- View this message in context: http://lucene.472066.n3.nabble.com/character-in-search-query-tp3168604p3182228.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: - character in search query

Here is my complete fieldtype: In the Field Analysis i see that the - is removed by the patternreplaceFilter. When i escaped the term($q = SolrUtils::escapeQueryChars($q);) i see in my debugQuery something like this(term = arsenal

Re: - character in search query

When i use the edismax handler the escaping works great(before i used the dismax handler).The debugQuery shows me this: +((DisjunctionMaxQuery((name:arsenal)~1.0) DisjunctionMaxQuery((name:london)~1.0))~2 The "\" is not in the parsedquery, so i get the results i wanted. I don't know why the disma

Updating opinion

Hello, I want some opinions for the updating process of my application. Users can edit there own data. This data will be validated and must be updated every 24 hours. I want to do this at night(0:00). Now lets say 50.000 documents are edited. The delta import will take ~20 minutes. So the index

Strip special chars like "-"

Hello, I have some terms in my index with specials characters. An example is "manchester-united". I want that a user can search for "manchester-united","manchester united" and "manchesterunited". What's the best way to fix this? i have used the patternReplaceFilter and some tokenizers but it coul

Re: Strip special chars like "-"

With the worddelimiter i can only fix the first 2 situations("manchester-united" and "manchester united") I can use something like generateWordParts. But i think this doesn't fix the problem with "manchesterunited". -- View this message in context: http://lucene.472066.n3.nabble.com/Strip-specia

Re: Strip special chars like "-"

The catenateWordParts option has the following effect: manchester-united => "manchester","united" The query "manchesterunited" will not match with: "manchester","united". Maybe i'm wrong but i have test something similar in the past. -- View this message in context: http://lucene.472066.n3.nabb

Re: Strip special chars like "-"

Yes, i understand the difference between generateWordParts and catenateWords. But i can't fix my problem with these options, It doesn't fix all the possibilities. -- View this message in context: http://lucene.472066.n3.nabble.com/Strip-special-chars-like-tp3238942p3239186.html Sent from the Solr

Re: Strip special chars like "-"

Ok, i there are three query possibilities: Manchester-united Manchester united Manchesterunited The original name of the club is "manchester-united". generateWordParts will fixes two of these possibilities: "Manchester-united" => "manchester","united" I can search for "Manchester-united" and

Re: Strip special chars like "-"

Erick, you're right. It's working, my schema looks like this: Thanks for helping me!! -- View this message in cont

Solr backup replication -> restore from snapshot

Hello, I have some question about restoring from a snapshot backup. I have a master and do the following command: http://solr.test.uk:/solr/replication?command=backup It created a directory in my data directory: snapshot.20120911224532 When i want to use this backup on master i replace the

<    1   2