Referring to this issue: #1098110: General feedback. Search API Facets module is supposed handle range values, like:

   *       - [VALUE1 VALUE2]: Filter for a value between VALUE1 and VALUE2. Use
   *         parantheses for excluding the border values and square brackets for
   *         including them. An asterisk (*) can be used as a wildcard, e.g.
   *         (* 0) or [* 0) would be a filter for all negative values.

But this seems not implemented by search_api_solr or even search_api_db (if I'm right).

For example, a date filter like ?filter[changed][0]=[198 1133] crashes Solr:

SearchApiException: "400" Status: Bad Request: Bad Request<html><head><title>Apache Tomcat/7.0.8 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 400 - Invalid Date String:'0'</h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u>Invalid Date String:'0'</u></p><p><b>description</b> <u>The request sent by the client was syntactically incorrect (Invalid Date String:'0').</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.8</h3></body></html> in SearchApiSolrService->search() (line 502 of C:\Inetpub\wwwroot\123.dev\sites\all\modules\contrib\search_api_solr\service.inc).
Page execution time was 319.98 ms. Memory used at: devel_boot()=2.87 MB, devel_shutdown()=24.21 MB, PHP peak=24.5 MB.

Comments

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Active » Fixed

While testing this for posting it to your issue queue (since I had already forgotten how to exactly do this, myself), I discovered and fixed the exact same error. See this commit. If you update to the newest dev version, you'll probably discover that the bug is now fixed.

Otherwise, please reopen and I'll look into it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

manoj2371’s picture

manoj2371 commented
Status: Closed (fixed) » Active

I got the same error

the problem was to refer database i.e.

in java code i wrote

  String url = "jdbc:mysql://localhost:3306/";
       String db = "lrap";

then used url and db as
con=DriverManager.getConnection(url+db,"root","mysql");

but in C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps folder of apache i named folder as "lrapserver" insted of "lrap"

legolasbo’s picture

legolasbo
he/him
Primary language Dutch
Location Middelburg
commented
Status: Active » Closed (outdated)

This issue has not seen activity in over 2,5 years. I am therefore closing this issue to clean up the issue queue. Feel free to re-open and update this issue if you feel this issue is still relevant and of importance.