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

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

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-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-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

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: 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.

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

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

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

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

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

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.

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: 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

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, "

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**

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

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-

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: 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

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: 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
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.

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: 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

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 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-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-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, Here you go: **data-config.xml** **schema.xml**

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, 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
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

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: 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

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
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

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-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

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: 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

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: 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:

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-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-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
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
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-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-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-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.

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: 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

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-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-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

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

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

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

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.

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: 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

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.

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

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

full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-16 Thread PeterKerk
My full-data import stopped working all of a sudden. Afaik I have not made any changes that would cause this. The response is: 0 0 wedding-data-config.xml full-import busy A command is still running... 0:6:4.112 1 0 0 0 2011-12-16 13:12:29 This response format is experimental. It is li

full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-19 Thread PeterKerk
My full-data import stopped working all of a sudden. Afaik I have not made any changes that would cause this. Everything is deleted from the index, but no files are added anymore. I dont receive any errors either...:S STARTING via Cygwin: cd /cygdrive/c/My\ Dropbox/inetpub/apache-solr-4.0-2010-

Re: full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-19 Thread PeterKerk
Hi Chantal, I reduced my data-config.xml to a bare minimum: I ran reload-config succesfully, but still the same behavior occurs. Oh and the query select * from locations WHERE isapproved='true' returns a lot of results when ran directly

Re: full-data import suddenly stopped working. Total Rows Fetched remains 0

2011-12-20 Thread PeterKerk
Chantal...you are the queen! :p That was it, I downgraded to 6.27 and now it works again...thank god! -- View this message in context: http://lucene.472066.n3.nabble.com/full-data-import-suddenly-stopped-working-Total-Rows-Fetched-remains-0-tp3599004p3601013.html Sent from the Solr - User mailin

Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
I'm running MSSQL Server 2008 I did this: set CLASSPATH= C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar (I dont know where I can check if this has been executed correctly) Then when approaching this URL: http://localhost:8983/solr/db/dataimport?command=full-i

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
Hi Gora, I just ran the classpath command in a DOS command prompt, that normally works for regular PATH variable as well. Your suggestion for the open source JTDS driver sounds good. So if you look at my data-config.xml: What would I have to place there under driver property? Also Im still

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
@Michael: your suggestion to place the jar file in that folder has brought me 1 step further. Now I get a new error. It seems as if the user cannot log in. Strange because it IS the correct pwd. In my MSSQL mgmt studio I provide: server name: (local) login: sa password:123456 Now if you look at m

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
I just cant seem to get past this error! So perhaps if any of you are running on Windows with SQL Server 2008, maybe you could post your data-config? I could have a look at it so I at least know my data-config is configured correctly :) Thanks a bunch! -- View this message in context: http://lu

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
And found another thing, even when I have this in my data-config.xml (a totally deformed XML file), I still get the same login failed error...where I would expect something like a non-well formed XML document error... Im using cygwin...dont know if that caches anything, but its still weird I thoug

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-02 Thread PeterKerk
Hi Michael, Thanks, I now use that. But the same error. (PS. is there a way where I can test the current connectionstring?) Therefore I have attached 1 image with 2 screenshots of my situation. http://lucene.472066.n3.nabble.com/file/n1017327/Untitled.png Untitled.png Here's my current data-c

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Hooray, im a bit further now... Turned out that both SQL2005 and 2008 were running, where 2005 was listening on port 1433. I disabled that services, enabled the 2008 service and now I can connect and the command http://localhost:8983/solr/db/dataimport?command=full-import is successfull. But no

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Thanks for the quick reply :) Here it is:

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Ok, downloaded luke, but how do I run it? Tried googling it, but no luck...do I need to put in in some folder? And is there anything with regard to the casing of the columns? For example, I now have "select FEATUREID " and in my data-config However, my DB columns are all in lower casing...i

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Ok, that works... But it only confirms that the extra data to be indexed I have defined in my data-config does not seem to be indexed. What can I do to debug this? Because nothing special is logged in my cygwin window! I have even simplified the data-config further to this:

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
I had a look at this URL: http://localhost:8983/solr/db/admin/dataimport.jsp?handler=/dataimport There I see the data-config.xml on the left side and the full data import result on the right. The response is: − 0 234 − − wedding-data-config.xml full-import debug − − − 1 − Gemeentehuis

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Hi, You are correct that locationid is an integer. I have changed it to: But then I get the error: Incorrect syntax near '=' Even though that statement does work in mgmt studio SEVERE: Full Import failed org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to execute query:

RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Awesome! You did it! Turned out, I had to change the casing of this line: to: Now the resultset is like this: − 0 16 − on 0 *:* 2.2 10 − − − Gemeentehuis − Tuin Cafe 1 2010-08-03T17:31:21.562Z Gemeentehuis Nijmegen − − Gemeentehuis − Tuin Cafe Danszaal 2 2010-08-03T17:31:21.5

Re: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver'

2010-08-03 Thread PeterKerk
Ok thanks again :) I'm right here now: http://velocity.apache.org/tools/devel/index.html#Download What should I download? -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-data-on-MSSQL-failed-Caused-by-org-apache-solr-common-SolrException-Error-loading-class-com-tp1

Indexing boolean value

2010-08-04 Thread PeterKerk
Im trying to index a boolean location, but for some reason it does not show up in my indexed data. data-config.xml OFFICIALLOCATION is a MSSQL database field of type 'bit' schema.xml (im not sure why I would use http://lucene.47

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
I changed values to text_ws Now I only seem to have problems with fieldvalues that hold spacessee below: It has now become: "facet_counts":{ "facet_queries":{}, "facet_fields":{ "theme":[ "Gemeentehuis",2, "&",1, < still & is c

RE: Indexing boolean value

2010-08-04 Thread PeterKerk
Hi, I tried that already, so that would make this: (still not sure what copyField does though) But even that wont work. I also dont see the officallocation columns indexed in the documents: http://localhost:8983/solr/db/select/?q=*%3A*&version=2.2&start=0&rows=10&indent=on -- View this me

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
Sorry, but Im a newbie to Solr...how would I change my schema.xml to match your requirements? And what do you mean by "it will mess with your results"? What will happen then? -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-fieldvalues-with-dashes-and-spaces-tp102369

RE: Indexing fieldvalues with dashes and spaces

2010-08-04 Thread PeterKerk
Well the example you provided is 100% relevant to me :) I've read the wiki now (SchemaXml,SolrFacetingOverview,Query Syntax, SimpleFacetParameters), but still do not have an exact idea of what you mean. My situation: a city field is something that I want users to search on via text input, so let

RE: Indexing fieldvalues with dashes and spaces

2010-08-05 Thread PeterKerk
@Michael, @Erick, You both mention interesting things that triggered me. @Erick: Your referenced page is very useful. It seems the whitespace tokenizer under the text_ws is causing issues. You do mention another interesting thing: "And do be aware that fields you get back from a request (i.e. a

Re: Indexing fieldvalues with dashes and spaces

2010-08-06 Thread PeterKerk
ified it so. > So when you asked for the field to be returned in a search result, you > would > get "The World is an unknown Entity" if you asked for the field to be > returned as part of a search result that matched on, say, "world". > > HTH > Erick

Re: Indexing fieldvalues with dashes and spaces

2010-08-09 Thread PeterKerk
Hi Erick, Ok. its more clear now. I indeed have the whitespace tokenizer: What happens is that I have a field called 'Beach & Sea", which is a theme for a location. What happens because of the whitespace tokenizer, i

Re: Indexing fieldvalues with dashes and spaces

2010-08-19 Thread PeterKerk
Sorry for late reply, just back from holiday :) I did what you mentioned: and then in url facet.field=services_raw It works...awesome, thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-fieldvalues-with-dashes-and-spaces-tp1023699p1222961.html Sent from th

Showing results based on facet selection

2010-08-19 Thread PeterKerk
I have indexed all data (as can be seen below). But now I want to be able to simulate when a user clicks on a facet value, for example clicks on the value "Gemeentehuis" of facet "themes_raw" AND has a selection on features facet on value "Strand" I've been playing with facet.query function: fac

RE: Showing results based on facet selection

2010-08-19 Thread PeterKerk
Hi Markus, Thanks for the quick reply. it works now! :) -- View this message in context: http://lucene.472066.n3.nabble.com/Showing-results-based-on-facet-selection-tp1223362p1225626.html Sent from the Solr - User mailing list archive at Nabble.com.

Autosuggest on PART of cityname

2010-08-19 Thread PeterKerk
I want to have a Google-like autosuggest function on citynames. So when user types some characters I want to show cities that match those characters but ALSO the amount of locations that are in that city. Now with Solr I now have the parameter: "&fq=title:Bost" But the result doesnt show the cit

RE: Autosuggest on PART of cityname

2010-08-19 Thread PeterKerk
Ok, I now tried this: http://localhost:8983/solr/db/select/?wt=json&indent=on&q=*:*&fl=city&facet.field=city&facet.prefix=Bost Then I get: { "responseHeader":{ "status":0, "QTime":0, "params":{ "fl":"city", "indent":"on", "q":"*:*", "facet.prefix":"Bost",

RE: Autosuggest on PART of cityname

2010-08-20 Thread PeterKerk
Ok, I now do this (searching for "utr" in cityname): http://localhost:8983/solr/db/select/?wt=json&indent=on&q=*:*&rows=0&facet=true&facet.field=city&facet.prefix=utr In the DB there's 1 location with cityname 'Utrecht' and the other 1 is with 'Utrecht Overvecht' So in my dropdown I would like:

Re: Autosuggest on PART of cityname

2010-08-20 Thread PeterKerk
@Markus: thanks, will try to work with that. @Gijs: I've looked at the site and the search function on your homepage is EXACTLY what I need! Do you have some Solr code samples for me to study perhaps? (I just need the relevant fields in the schema.xml and the query url) It would help me a lot! :)

  1   2   3   >