404 error on Solr 7.2.1 dataimport handler (on Windows via Cygwin)

2018-04-30 Thread PeterKerk
I'm running Solr 7.2.1 on Windows via Cygwin. I've installed Solr7.2.1 but I'm getting a 404 when trying to run the dataimport handler: http://localhost:8983/solr/tt-giftsamplecatalog/dataimport?command=full-import After calling this URL, I don't see any logging in the console. The error in my br

Execution of query in subentity dependent on a field from the main entity

2018-03-15 Thread PeterKerk
How can I make the execution of a query in a subentity dependent on a field value from the main entity? So as you can see in the (simplified) data config below, there's an entity `categories_lvl_0` which holds an expensive query. I ONLY want to execute this query if: searchobject.objecttype=115 H

RE: Solr search engine configuration

2018-03-13 Thread PeterKerk
Thanks, will look into all that :-) -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

RE: Solr search engine configuration

2018-03-13 Thread PeterKerk
Cool, will do some more digging around in the analysis GUI first. One last thing then on this comment of yours: "Does the decompounder support emitting the compound word as well? If so, enable it. It should help scoring compounds higher via IDF as they are less common." So I checked the Javadoc:

RE: Solr search engine configuration

2018-03-13 Thread PeterKerk
You must stay in the Javadoc section, there the examples are good, or the reference guide: https://lucene.apache.org/core/6_5_0/analyzers-common/org/apache/lucene/analysis/compound/HyphenationCompoundWordTokenFilterFactory.html https://lucene.apache.org/solr/guide/6_6/filter-descriptions.html#filt

RE: Solr search engine configuration

2018-03-13 Thread PeterKerk
Markus, Thanks again. Ok, 1 by 1: StemmerOverride wants \t separated fields, that is probably the cause of the AIooBE you get. Regarding schema definitions, each factory JavaDoc [1] has a proper example listed. I recommend putting a decompounder before a stemmer, and have an accent (or ICU) fold

RE: Solr search engine configuration

2018-03-12 Thread PeterKerk
@Erick: thank you for clarifying! @Markus: I feel like I'm not (or at least should not be :-)) the first person to run into these challenges. "You can solve this by adding manual rules to StemmerOverrideFilter, but due to the compound nature of words, you would need to add it for all the mills"

Re: Solr search engine configuration

2018-03-11 Thread PeterKerk
Sorry for this lengthy post, but I wanted to be complete. The only occurence of edismax in solrconfig.xml is this one: edismax explicit 10

Re: Solr search engine configuration

2018-03-11 Thread PeterKerk
Thanks! That provides me with some more insight, I altered the search query to "dieren zaak" to see how queries consisting of more than 1 word are handled. I see that words are tokenized into groups of 3, I think because of my NGramFilterFactory with minGramSize of 3. (title_sear

Solr search engine configuration

2018-03-10 Thread PeterKerk
Since Google onsite search will be end of life April 1 2018, I'm trying to setup my own onsite search engine that indexes my site's content and makes it searchable. My data config successfully loads data from my database (products, companies, blogs) into the fields. I then try to search in both t

Link entities in Solr Data config with multiple datasource

2017-10-27 Thread PeterKerk
I started here: https://wiki.apache.org/solr/DataImportHandler#multipleds I have a WordPress database with articles. I keep statistics (like views) on those articles (and a range of other objects not in WordPress) in a separate MS SQL Server database. Statistics in the MS SQL database for article

Re: geolocation search ignores distance parameter

2015-11-22 Thread PeterKerk
@Erik: thanks, overlooked that...added fq= before geofilt and now it works :) -- View this message in context: http://lucene.472066.n3.nabble.com/geolocation-search-ignores-distance-parameter-tp4241564p4241571.html Sent from the Solr - User mailing list archive at Nabble.com.

geolocation search ignores distance parameter

2015-11-22 Thread PeterKerk
Why is the result below returned even though I'm filtering in a radius of 20 from geocoordinates defined in pt parameter in the querystring? As you can see the result in _dist_ in this result is is far larger than 20. http://localhost:8983/solr/locs/select/?indent=on&facet=true{!geofilt}&pt=51.98,

Re: Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-31 Thread PeterKerk
Hey Alessandro, Can you help me? :) Thank you! -- View this message in context: http://lucene.472066.n3.nabble.com/Use-faceted-search-to-drill-down-in-hierarchical-structure-and-omit-node-data-outside-current-selectn-tp4219384p4220080.html Sent from the Solr - User mailing list archive at Nab

Re: Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-29 Thread PeterKerk
Hi Alessandro! I'm having a hard time on how to use the PathHierarchyTokenizerFactory. I was reading here: https://lucene.apache.org/core/4_4_0/analyzers-common/org/apache/lucene/analysis/path/PathHierarchyTokenizerFactory.html And ended up with this:

Re: Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-29 Thread PeterKerk
Hi Charlie, Your solution seems to remove faceting capabilities...so that's not what I'm looking for :) Thanks though! -- View this message in context: http://lucene.472066.n3.nabble.com/Use-faceted-search-to-drill-down-in-hierarchical-structure-and-omit-node-data-outside-current-selectn-tp421

Re: Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-29 Thread PeterKerk
Ok, I managed to get this as output via SQL for a single product: ProductId categorystring 2481445 cake > caketoppers > funny 2481445 caketoppers > funny Before I start diving into the tokenization in Solr, this is what you meant as the correct input of the data right? I should be able to suppor

Re: Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-28 Thread PeterKerk
? e.g. a product may be in: Man Man > top Man > top > shirt Man > top > shirt> sleeveless shirt AND also fall under: Clothing Clothing > shirt Clothing > shirt> sleeveless shirt Thanks again! From: Alessandro Benedetti [via Lucene] Sent: Tuesday, July 2

Use faceted search to drill down in hierarchical structure and omit node data outside current selection

2015-07-27 Thread PeterKerk
I have the following structure for my products, where a product may fall into multiple categories. In my case, a "caketopper", which would be under "cake/caketoppers" as well as "caketoppers" (don't focus on the logic behind the category structure in this example). Category structure: cak

delta import on changes in entity within a document

2015-03-26 Thread PeterKerk
I have the following data-config: Now, when the object in the [locations] table is updated, my delta import (/dataimport?comm

Filter Solr multivalued fields to be able to add pagination

2015-01-20 Thread PeterKerk
I have the Solr XML response below using this query: http://localhost:8983/solr/tt/select/?indent=off&facet=false&wt=xml&fl=title,overallscore,service,reviewdate&q=*:*&fq=id:315&start=0&rows=4&sort=reviewdate%20desc I want to add paging on the multivalued fields, but the above query throws the err

Re: Flexible search field analyser/tokenizer configuration

2014-10-04 Thread PeterKerk
Thanks, removing the fq parameters helped :) -- View this message in context: http://lucene.472066.n3.nabble.com/Flexible-search-field-analyser-tokenizer-configuration-tp4161624p4162667.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Flexible search field analyser/tokenizer configuration

2014-10-04 Thread PeterKerk
In Engish, I think this part: (title_search_global:(Ballonnenboog) OR title_search_global:"Ballonnenboog"^100) is looking for a match on "Ballonenboog" in the title and give a boost if it occurs exactly as this. The second part does the same but then for the description_search field, and with an O

Re: Flexible search field analyser/tokenizer configuration

2014-10-03 Thread PeterKerk
Ok, that field now totally works, thanks again! I've removed the wildcard to benefit from ranking and boosting and am now trying to combine this field with another, but I have some difficulties figuring out the right query. I want to search on the occurence of the keyword in the title field (titl

Re: Flexible search field analyser/tokenizer configuration

2014-10-01 Thread PeterKerk
Sorry, one final thing. In my current application I search like this: "&q=title:*&defType=lucene I was checking here: http://wiki.apache.org/solr/SolrQuerySyntax But with my new query, could I just remove the defType=lucene parameter and the wildcard right? Or am I overlooking something then?

Re: Flexible search field analyser/tokenizer configuration

2014-10-01 Thread PeterKerk
You were right, I had an old configuration :) But using your new suggestions had made that it works! Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Flexible-search-field-analyser-tokenizer-configuration-tp4161624p4162249.html Sent from the Solr - User mailing list a

Re: Flexible search field analyser/tokenizer configuration

2014-10-01 Thread PeterKerk
Hi Erick, Thanks for clarifying some of this :) That triggers a few more questions: 1. I have no df" setting in my solrconfig.xml file at all, nor do I see a

Re: Flexible search field analyser/tokenizer configuration

2014-10-01 Thread PeterKerk
Ok, I missed the Query tab where I can do the actual site search :) I've also used your links, but even with those I fail to grasp why the following is happening: This is my query: http://localhost:8983/solr/bm/select?q=*%3A*&fq=The+Royal+Garden&rows=50&fl=id%2Ctitle&wt=xml&indent=true And belo

Re: Flexible search field analyser/tokenizer configuration

2014-09-29 Thread PeterKerk
Ah, thanks! Sounds indeed like EdgeNGramFilterFactory is what I need. I actually upgraded to Solr 4.10.1 (from 4.3.1) while I was at it. I now have this:

Re: Flexible search field analyser/tokenizer configuration

2014-09-29 Thread PeterKerk
Hi Ahmet, Am I correct that his this is only avalable in Solr4.8? http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters#solr.TruncateTokenFilterFactory Also, I need to add your lines to both "index" and "query" analyzers? making my definition like so:

Flexible search field analyser/tokenizer configuration

2014-09-28 Thread PeterKerk
I have a site which lists companies. I'm looking to improve my search, but I want to know which available analysers and tokenizers I should use for which scenario, and if it's at all possible. I want users to be able to search on the company title on for example a company called "The Royal Garden

Re: JSP support not configured in cygwin with Apache Solr

2014-09-28 Thread PeterKerk
Was an old bookmark..I did not notice the extra pages under core selectionfound it now , thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/JSP-support-not-configured-in-cygwin-with-Apache-Solr-tp4161613p4161619.html Sent from the Solr - User mailing list archive at

JSP support not configured in cygwin with Apache Solr

2014-09-28 Thread PeterKerk
I'm starting Cygwin with Apache solr-4.3.1 like so: @echo off C: chdir C:\cygwin\bin rem bash --login -i bash -c "cd /cygdrive/c/solr-4.3.1/example/;java -Dsolr.solr.home="./example-DIH/solr/" -jar -Xms200m -Xmx1200m start.jar -OPTIONS=jsp" But when I go to htt

Re: Searchquery on field that contains space

2014-01-10 Thread PeterKerk
@iorixxx: thanks, you 2nd solution worked. The first one didn't (does not matter now), I got this: With the first solution all queries work as expected, however with this: q=title_search:"new%20yk"* still new york is returned. -- View this message in context: http://lucene.472066.n3.nabb

Return only distinct combinations of 2 field values

2014-01-09 Thread PeterKerk
I'm searching on cities and returning city and province, some cities exist in different provinces, which is ok. However, I have some duplicates, meaning 2 cities occur in the same province. In that case I only want to return 1 result. I therefore need to have a distinct and unique city+province com

Re: Searchquery on field that contains space

2014-01-09 Thread PeterKerk
Hi Ahmet, Thanks. Also for that link, although it's too advanced for my usecase. I see that by using KeywordTokenizerFactory it almost works now, but when I search on: "new y", no results are found, but when I search on "new", I do get "New York". So the space in the searchquery is still caus

Re: Searchquery on field that contains space

2014-01-09 Thread PeterKerk
Basically a user starts typing the first letters of a city and I want to return citynames that start with those letters, case-insensitive and not splitting the cityname on separate words (whether the separator is a whitespace or a "-"). But although the search of a user is case-insensitive, I want

Re: Searchquery on field that contains space

2014-01-09 Thread PeterKerk
@Ahmet: Thanks, but I also need to be able to search via wildcard and just found that a "-" might be resulting in unwanted results. E.g. when using this query: http://localhost:8983/solr/tt-cities/select/?indent=off&facet=false&fl=id,title,provincetitle_nl&q=title_search:nij*&defType=lucene&start

Searchquery on field that contains space

2014-01-08 Thread PeterKerk
My query on finding a cityname does not show the closest matching value, but instead gives priority to the first word in the searchquery. I believe it has something to do with the whitespace tokenenization, but I don't know which fields to change to what type. Here's what happens when I search o

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
No need, you solved it! It was the id name, it had to be uppercase. btw the ; is still there in the query, but everything still works. Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109425.html Sent from the Solr - User m

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
Hi Andrea, I think you helped me to get closer, but not quite there yet. When I replace wtr.object_id='${article.id}'; with wtr.object_id=18 the cat_name field holds a value, which I checked via the schema browser of Solr dashboard! I then checked my main query SELECT p.*, ( SELECT guid FROM wp

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
But when I execute the query directly on MySQL I do get a cat_name column in there: select wt.name as cat_name,wt.slug,wtr.term_taxonomy_id,wtt.term_id,wtt.taxonomy from wp_term_relationships wtr INNER JOIN wp_term_taxonomy wtt ON wtt.term_taxonomy_id=wtr.term_taxonomy_id AND wtt.taxonomy='catego

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
Hi Andrea, Here you go: **data-config.xml** **schema.xml**

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
Hi Andrea, You were right, I do see errors when setting the required=true attribute...what can it be? Logging console homepage: 13:31:54 WARN SolrWriter Error creating document : SolrInputDocument[comment_status=open,​ post_content=algemeen kpn artikeltje ook over vodafone,​ guid=http://www.tel

Re: Empty facets on Solr with MySQL

2014-01-03 Thread PeterKerk
Hi Andrea, I would say the JDBC driver must be working because when I leave out the required="true" from the cat_name field, 4 documents are imported. Since my entire DB currently holds only 4 records, there's no need for a LIMIT clause I guess? Andrea Gazzarini-4 wrote > In the solr console se

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
Hi Andrea, I changed it to: When I run full-import 0 documents are indexed, but no errors in the console. When I run my query via MySQL Workbench the statement executes correctly. How else can I debug the index process? -- View this message in context: http://lucene.472066.n3.nabble.co

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
I get "Sorry, no Term Info available :(" -- View this message in context: http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109186.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
Hi Ahmet, I tried this URL: http://localhost:8983/solr/wordpress/select/?indent=on&facet=true&sort=post_modified%20desc&q=*:*&start=0&rows=10&fl=id,post_title,cat_name*&facet.field=cat_name_raw&facet.mincount=1 and this URL: http://localhost:8983/solr/wordpress/select/?indent=on&facet=true&sort

Empty facets on Solr with MySQL

2014-01-02 Thread PeterKerk
I've set up Solr with MySQL. My data import is succesful: http://localhost:8983/solr/wordpress/dataimport?command=full-import However, when trying to get the cat_name facets all facets are empty: http://localhost:8983/solr/wordpress/select/?indent=on&facet=true&sort=post_modified%20desc&q=*:*&sta

Re: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query

2013-12-30 Thread PeterKerk
This is all I see in the XML response: This XML file does not appear to have any style information associated with it. The document tree is shown below. 0 39 wordpress-data-config.xml full-import debug idle 0:0:0.57 1 0 0 0 2013-12-30 12:21:49 Indexing failed. Rolled back all changes.

Re: how to debug dataimporthandler

2013-12-30 Thread PeterKerk
Tried your steps, but failed. Could you perhaps have a look at my post here: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-td4108227.html -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-debug-d

Re: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query

2013-12-30 Thread PeterKerk
I ran the query in debug mode: http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import&debug=true Here's the output, what can you tell from this? 22432 [qtp33142123-13] INFO org.apache.solr.handler.dataimport.JdbcDataSource û Creating a connection for entity article with URL: jdbc

RE: Disable caching on sorting to improve performance

2013-12-27 Thread PeterKerk
Thanks and good call, that has been there for quite some time! I've changed it to: -Xms200m -Xmx1500m I'll look into the effect of this first. -- View this message in context: http://lucene.472066.n3.nabble.com/Disable-caching-on-sorting-to-improve-performance-tp4108356p4108362.html Sent from

Disable caching on sorting to improve performance

2013-12-27 Thread PeterKerk
I'm getting a lot of java heap memory full errors. I've now been reading into solr performance (in the meantime also configuring the sematext tools to try to drill down to the cause) I already increased the memory available to Solr: bash -c "cd /cygdrive/c/Databases/solr-4.3.1/example/;java -Dsolr

Re: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query

2013-12-26 Thread PeterKerk
Shalin Shekhar Mangar wrote > Can you try using the debug mode and paste its response? Ok, thanks. How do I enabled and use the debug mode? -- View this message in context: http://lucene.472066.n3.nabble.com/org-apache-solr-handler-dataimport-DataImportHandlerException-Unable-to-execute-query-

Re: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query

2013-12-26 Thread PeterKerk
Solr 4.3.1 When I run the statement in MySQL Workbench or console the statement executes successfully and returns 2 results. FYI: I placed the mysql-connector-java-5.1.27-bin.jar in the \lib folder. Also: it should not throw this error even when 0 results are returned right? -- View this mess

org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query

2013-12-26 Thread PeterKerk
I'm trying to setup Solr with a Wordpress database running on MySQL. But on trying a full import: `http://localhost:8983/solr/tv-wordpress/dataimport?command=full-import` The error is: org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query **data-config.xml**

Displaying actual field values and searching lowercase ignoring spaces

2013-12-09 Thread PeterKerk
Values of the field [street] in my DB may be "Castle Road" However, I want to be able to find these values using lowercase including dashes, so "castle-road" would be a match. When I use fieldtype "text_lower_space", which holds a solr.WhitespaceTokenizerFactory, the value is split in 2 values, "

Re: get min-max prices as facets

2013-11-06 Thread PeterKerk
Hi Raymond, Thanks. This caching of the main query you mention, is that done automatically or do I have to do something for that? -- View this message in context: http://lucene.472066.n3.nabble.com/get-min-max-prices-as-facets-tp4099501p4099613.html Sent from the Solr - User mailing list archi

Limit single field length in solr response via the request url

2013-11-06 Thread PeterKerk
I'm requesting fields like so: http://localhost:8983/solr/test/select/?indent=on&facet=true&wt=json&start=0&rows=20&fl= id,title,description,pricerange However, the field description might be more than 4000 characters long, so I want to limit it to a maximum of 100 characters and then cut it off.

Re: solr sort facets by name

2013-11-06 Thread PeterKerk
That works, thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/solr-sort-facets-by-name-tp4099499p4099572.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: get min-max prices as facets

2013-11-06 Thread PeterKerk
Thanks! I know how to fire a range query. However, what I want is to provide the visitor with a range filter. In this range filter the minimum and maximum value are already set to the lowest and highest price of the current resultset. e.g. I sell cars. My cheapest car is 1,000 and the most expensi

get min-max prices as facets

2013-11-05 Thread PeterKerk
I want to provide my visitors with a price range slider when they can easily filter on a min and max value. For this I need to know the lowest and highest price of all the products found by my solr query.Since this is dynamic, based on the query by the user, I can not simply get the min and max val

solr sort facets by name

2013-11-05 Thread PeterKerk
By default solr sorts facets by the amount of hits for each result. However, I want to sort by facetnames alphabetically. Earlier I sorted the facets on the client or via my .NET code, however, this time I need solr to return the results with alphabetically sorted facets directly. How? -- View t

Re: Adding OR operator in querystring and grouping fields?

2013-10-07 Thread PeterKerk
@Jason: your example worked perfectly! -- View this message in context: http://lucene.472066.n3.nabble.com/Adding-OR-operator-in-querystring-and-grouping-fields-tp4093942p4093999.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Adding OR operator in querystring and grouping fields?

2013-10-07 Thread PeterKerk
Ok thanks. "you must combine them into one filter query parameter. ", how would I do that? Can I simply change the URL structure or must I change my schema.xml and/or data-config.xml? -- View this message in context: http://lucene.472066.n3.nabble.com/Adding-OR-operator-in-querystring-and-group

Adding OR operator in querystring and grouping fields?

2013-10-07 Thread PeterKerk
This query returns the correct results: http://localhost:8983/solr/tt/select/?indent=on&fq={!geofilt}&pt=41.7882,-71.9498&sfield=geolocation&d=2000&q=*:*&start=0&rows=12&fl=id,title&facet.mincount=1&fl=_dist_:geodist() However, I want to add OR select on a field city as well: &fq=city:(brooklyn)

Re: Unable to load com.microsoft.sqlserver.jdbc.SQLServerDriver

2013-08-09 Thread PeterKerk
Had to add one more "../" and now it works indeed...thanks for noticing! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Unable-to-load-com-microsoft-sqlserver-jdbc-SQLServerDriver-tp4083529p4083665.html Sent from the Solr - User mailing list archive at Nabble.com.

Unable to load com.microsoft.sqlserver.jdbc.SQLServerDriver

2013-08-09 Thread PeterKerk
I'm getting this error when trying to user Data Import Handler via URL: http://localhost:8983/solr/1001/dataimport?command=full-import Caused by: java.lang.ClassNotFoundException: Unable to load com.microsoft.sqlser ver.jdbc.SQLServerDriver or org.apache.solr.handler.dataimport.com.microsoft.sql

Error loading class 'solr.DisMaxRequestHandler' after upgrade from solr350 to 431

2013-08-09 Thread PeterKerk
I'm in the process of upgrading from solr 350 to 431. I see this in my log: Caused by: org.apache.solr.common.SolrException: Error loading class 'solr.DisMa xRequestHandler' 1742 [coreLoadExecutor-3-thread-1] ERROR org.apache.solr.core.CoreContainer û n ull:org.apache.solr.common.SolrException: U

Configuring Tomcat 6 with Solr431 with multiple cores

2013-07-18 Thread PeterKerk
Thanks to Sandeep in this post: http://lucene.472066.n3.nabble.com/HTTP-Status-503-Server-is-shutting-down-td4065958.html#a4078567 I was able to setup Tomcat 6 with Solr 431. However, I need a multicore implementation and am now stuck on how to do so. Here is what I did based on Sandeeps recommen

Re: HTTP Status 503 - Server is shutting down

2013-07-17 Thread PeterKerk
I can now approach http://localhost:8080/solr-4.3.1/#/, thanks!! I also noticed you mentioning something about a data import handler. Now, what I will be requiring after I've completed the basic setup of Tomcat6 and Solr431 I want to migrate my Solr350 (now running on Cygwin) cores to that envir

Re: HTTP Status 503 - Server is shutting down

2013-07-15 Thread PeterKerk
Hi Sandeep, Thank you for your extensive answer :) Before I'm going through all your steps, I noticed you mentioning something about a data import handler. Now, what I will be requiring after I've completed the basic setup of Tomcat6 and Solr431 I want to migrate my Solr350 (now running on Cygwin

Re: HTTP Status 503 - Server is shutting down

2013-07-14 Thread PeterKerk
Ok, still getting the same error "HTTP Status 503 - Server is shutting down", so here's what I did now: - reinstalled tomcat - deployed solr-4.3.1.war in C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps - copied log4j-1.2.16.jar,slf4j-api-1.6.6.jar,slf4j-log4j12-1.6.6.jar to C:\Progr

Re: HTTP Status 503 - Server is shutting down

2013-07-14 Thread PeterKerk
Hi Shawn, I'm also getting the HTTP Status 503 - Server is shutting down error when navigating to http://localhost:8080/solr-4.3.1/ I already copied the logging.properties file from C:\Dropbox\Databases\solr-4.3.1\example\etc to C:\Dropbox\Databases\solr-4.3.1\example\lib Here's my Tomcat consol

Steps to take when upgrading from 3.5.0 to 4.2

2013-06-23 Thread PeterKerk
I was reading this post: http://myjeeva.com/upgrade-migrate-solr-3x-to-solr-4.html However, under step 6 and 7 I'm unsure what to do: > Step 6: So remove old configuration section and add new one Do I need to remove the entire nodes and ? What should I do with their content? Which nodes will t

solr spatial search with distance to search results

2013-06-19 Thread PeterKerk
I was reading this: http://wiki.apache.org/solr/SpatialSearch I have this Solr query: http://localhost:8983/solr/tt/select/?indent=on&facet=true&fq={!geofilt}&pt=51.4416420,5.4697225&sfield=geolocation&d=20&sort=geodist()%20asc&q=*:*&start=0&rows=10&fl=_dist_:geodist(),id,title,lat,lng,location&f

Re: geodist() spatial sorting: sort param could not be parsed as a query, and is not a field that exists in the index: geodist()

2013-02-28 Thread PeterKerk
You were right, sloppy on my side. I replaced the %20 with & (in more than 1 place) and now it does work. Thanks. -- View this message in context: http://lucene.472066.n3.nabble.com/geodist-spatial-sorting-sort-param-could-not-be-parsed-as-a-query-and-is-not-a-field-that-exists-in--tp4043603p40

geodist() spatial sorting: sort param could not be parsed as a query, and is not a field that exists in the index: geodist()

2013-02-28 Thread PeterKerk
I want to sort the results of my query on distance. But I get this error: sort param could not be parsed as a query, and is not a field that exists in the index: geodist() On this query: http://localhost:8983/solr/tt/select/?indent=on&facet=true&fq=countryid:1&fq={!geofilt}&pt=51.8425,5.85278%20

RE: Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
Ok, something went wrong with posting the code,since I did not escape the quotes and ampersands. I tried your code, but nu luck. Here's the original query I'm trying to execute. What characters do I need to escape? I thought only the < and > characters? Thanks! -- View this message in contex

RE: Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
Ok, but I restarted solr several times and the issue still occurs. So my guess is that the entity I added contains errors: 50' END as PriceCategory From products) Select PriceCategory, Count(*) as Cnt From Categorized Group By PriceCategory "> Or are you saying tha

Implement price range filter: DataImportHandler started. Not Initialized. No commands can be run

2013-02-14 Thread PeterKerk
On all products I have I want to implement a price range filter. Since this pricerange is applied on the entire population and not on a single product, my assumption was that it would not make sense to define this within the "shopitem" entity, but rather under the document "shopitems". So that's wh

RE: how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
Awesome! This one line did the trick: http://lucene.472066.n3.nabble.com/how-to-perform-a-delta-import-when-related-table-is-updated-tp4032587p4032671.html Sent from the Solr - User mailing list archive at Nabble.com.

RE: how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
Hi James, Ok, so I did this: I now get this error in the logfile: SEVERE: Delta Import Failed java.lang.IllegalArgumentException: deltaQuery has no column to resolve to declared primary key pk='ID'

how to perform a delta-import when related table is updated

2013-01-11 Thread PeterKerk
My delta-import (http://localhost:8983/solr/freemedia/dataimport?command=delta-import) does not correctly update my solr fields. Please see my data-config here: Now when a new item is inserted into [freemedialikes] an

Filter on multiple word field of type "string" not showing any results

2012-12-31 Thread PeterKerk
I'm trying to filter on the field functiontitle_nl when the user selects "Management en Organisatie", but I'm getting 0 results. The actual value in the DB is "Management en Organisatie". This is the URL I build up to query the Solr index: http://localhost:8983/solr/zz_vacs/select/?indent=on&face

CQL instead of SQL in Solr data-config

2012-09-24 Thread PeterKerk
Please see this post here: http://stackoverflow.com/questions/12324837/apache-cassandra-integration-with-apache-solr/12326329#comment16936430_12326329 Does anyone have experience with or know if it's possible with the Solr data-config combined with Cassandra JDBC drivers (http://code.google.com/a/

Re: How to use Apache Cassandra with Apache Solr

2012-09-10 Thread PeterKerk
Thanks. I sent you a DM, if there's non sensitive material in your bakeoff feel free to post it here as well for reference for other (I'm kind of surprised there seems little info on this specific topic). Looking forward very much to your reply!! :) Thanks ahead. -- View this message in context

How to use Apache Cassandra with Apache Solr

2012-09-09 Thread PeterKerk
For a totally new project I'm building I want to use Cassandra as my datasource (normally I use MSSQL) and provide search/facet navigation with Apache Solr. Is there a tutorial somewhere on how to set this up? I've heard of commercial solutions like Datastax or a small open source initiative Solla

Re: Need tokenization that finds part of stringvalue

2012-03-06 Thread PeterKerk
edismax did the trick! Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Need-tokenization-that-finds-part-of-stringvalue-tp3785366p3805045.html Sent from the Solr - User mailing list archive at Nabble.com.

Re: Need tokenization that finds part of stringvalue

2012-03-06 Thread PeterKerk
@iorixxx: Sorry it took so long, had some difficulties upgrading to 3.5.0 It still doesnt work. Here's what I have now: I copied text_general_rev from http://svn.apache.org/repos/asf/lucene/dev/trunk/solr/example/solr/conf/schema.xml to my schema.xml:

org.apache.solr.common.SolrException: Error loading class 'org.apache.solr.handler.dataimport.DataImportHandler'

2012-03-04 Thread PeterKerk
I wanted to to upgrade from version apache-solr-4.0-2010-10-12_08-05-48 to apache-solr-3.5.0. I installed apache-solr-3.5.0 and then copied all stuff from \example-DIH\solr of old installation to \example-DIH\solr but then I get the following error after I restart my server and try to do a full-imp

Re: Need tokenization that finds part of stringvalue

2012-03-04 Thread PeterKerk
@iorixxx I tried making my title_search of type text_rev and tried adding the ReversedWildcardFilterFactory to my existing "text" type, but in both cases no luck. @Erick Erickson "On frequent method of doing leading and trailing wildcards is to use ngrams (as distinct from edgengrams). That in com

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
@iorixxx: Where can I find that example schema.xml? I downloaded the latest version here: ftp://apache.mirror.easycolocate.nl//lucene/solr/3.5.0 And checked \example\example-DIH\solr\db\conf\schema.xml But no text_rev type is defined in there. And when I find it, can I just make the title field w

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
@iorixxx: yes, that is what I need. But also when its IN the text, not necessarily at the beginning. So using the * character like: q=smart* the product is found, but when I do this: q=*mart* it isnt...why is that? -- View this message in context: http://lucene.472066.n3.nabble.com/Need-toke

Re: Need tokenization that finds part of stringvalue

2012-03-01 Thread PeterKerk
I think I didnt explain myself clearly: I need to be able to find substrings. So, its not that I'd expect Solr to find synonyms, but rather if a piece of text contains the searched text, for example: if title holds "smartphone" I want it to be found when someone types "martph" or "smar" or "smart"

Need tokenization that finds part of stringvalue

2012-02-28 Thread PeterKerk
I have the following in my schema.xml I want to search on field "title". Now my field title holds the value "great smartphone". If I search on "smartphone" the item is fo

sort my results alphabetically on facetnames

2012-02-14 Thread PeterKerk
I want to sort my results on the facetnames (not by their number of results). So now I have this (ordered by number of results): Instelling voor auditief gehandicapten (16) Audiologisch centrum (13) Huisartsenpraktijk (13) Instelling voor lichamelijk gehandicapten (13) Ambulancezorg (12) Beroepsor

Re: Format version is not supported in file 'segments_gw': 0 (needs to be between -9 and -10). This version of Lucene only supports indexes created with release 3.0 and later.

2012-02-13 Thread PeterKerk
I have no idea how to check that. Also I have no idea how I would attach a trunk Solr to a 1.4 index, so it's not very likely I actually did that :) My Solr folder looks like this: C:\My Dropbox\Dropbox\inetpub\apache-solr-4.0-2010-10-12_08-05-48\example\example-DIH\solr How would I check what ve

Format version is not supported in file 'segments_gw': 0 (needs to be between -9 and -10). This version of Lucene only supports indexes created with release 3.0 and later.

2012-02-12 Thread PeterKerk
Im getting the error below all of a sudden. AFAIK i haven't touched anything with Lucene. I did add a fields to my schema and data-config.xml: data-config.xml: schema.xml: But removed those again later. I restarted my machine several times, and also restarted cygwin and reloaded my data-config.

  1   2   3   >