# ES-5.0.0 with php client query error

**URL:** <https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961>\
**Category:** Elasticsearch\
**Created:** [November 14, 2016, 10:49am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961 "2016-11-14T10:49:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [November 14, 2016, 10:49am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/1 "2016-11-14T10:49:30Z")

</div>

Hi I indexed mysql data on ES-5.0.0 and I did query PHP:

```
unset($AlimSekli);
    if(isset($_GET['AlimSekli'])){
        $AlimSekli['match_phrase']['AlimSekli']=$_GET['AlimSekli'];
    }

if(is_array($AlimSekli)){
    $searchParams['body']['query']['bool']['should']['and'][]=$AlimSekli;
}

```

but I have error:

```
Fatal error: Uncaught exception 
'Elasticsearch\Common\Exceptions\BadRequest400Exception' with message 
'{"error":{"root_cause":[{"type":"parsing_exception","reason":"[and] 
query malformed, no start_object after query 
name","line":1,"col":35}],"type":"parsing_exception","reason":"[and] 
query malformed, no start_object after query 
name","line":1,"col":35},"status":400}' in 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php:681
Stack
 trace:
#0 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php(659):
 Elasticsearch\Connections\Connection->tryDeserializeError(Array, 
'Elasticsearch\\C...')
#1 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php(579):
 Elasticsearch\Connections\Connection->tryDeserialize400Error(Array)
#2 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticse
 in /home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php on line 682
```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 14, 2016, 11:02am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/2 "2016-11-14T11:02:05Z")

</div>

No idea until you print the JSON document which is sent to elasticsearch.  
Can you do that?

---

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [November 14, 2016, 11:14am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/3 "2016-11-14T11:14:45Z")

</div>

Ok .

```
curl -XGET 'localhost:9200/titub2/ihale/_search' -d '{
    "query" : {
        "match" : {
            "AlimSekli" : "DOGRUDAN"
        }
    }
}'

```

result:

`{"error":{"root_cause":[{"type":"security_exception","reason":"missing authentication token for REST request [/titub2/ihale/_search]","header":{"WWW-Authenticate":"Basic realm=\"security\" charset=\"UTF-8\""}}],"type":"security_exception","reason":"missing authentication token for REST request [/titub2/ihale/_search]","header":{"WWW-Authenticate":"Basic realm=\"security\" charset=\"UTF-8\""}},"status":401}`

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 14, 2016, 11:26am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/4 "2016-11-14T11:26:07Z")

</div>

Don't you notice something in the response here?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 14, 2016, 11:32am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/5 "2016-11-14T11:32:36Z")

</div>

And I don't believe that `'body']['query']['bool']['should']['and']` generates

```auto
"query" : {
        "match" : {
            "AlimSekli" : "DOGRUDAN"
        }
    }

```

---

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [November 14, 2016, 11:37am UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/6 "2016-11-14T11:37:59Z")

</div>

```
unset($AlimSekli);
    if(isset($_GET['AlimSekli'])){
        $AlimSekli['match_phrase']['AlimSekli']=$_GET['AlimSekli'];
    }

if(is_array($AlimSekli)){
    $searchParams['body']['query']['match'][]=$AlimSekli;
} 

```

I tried `http://192.168.1.35/filtreleme.php?AlimSekli=DOGRUDAN` and result:

```
Fatal error: Uncaught exception 
'Elasticsearch\Common\Exceptions\BadRequest400Exception' with message 
'{"error":{"root_cause":[{"type":"parsing_exception","reason":"[match] 
query malformed, no start_object after query 
name","line":1,"col":19}],"type":"parsing_exception","reason":"[match] 
query malformed, no start_object after query 
name","line":1,"col":19},"status":400}' in 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php:681
Stack
 trace:
#0 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php(659):
 Elasticsearch\Connections\Connection->tryDeserializeError(Array, 
'Elasticsearch\\C...')
#1 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php(579):
 Elasticsearch\Connections\Connection->tryDeserialize400Error(Array)
#2 
/home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elast
 in /home/admin/web/localhost.example.com/public_html/vendor/elasticsearch/elasticsearch/src/Elasticsearch/Connections/Connection.php on line 682
```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [November 14, 2016, 12:29pm UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/7 "2016-11-14T12:29:47Z")

</div>

I can't tell if you don't answer [my question](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/2?u=dadoonet). Sorry.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [December 12, 2016, 12:29pm UTC](https://discuss.elastic.co/t/es-5-0-0-with-php-client-query-error/65961/8 "2016-12-12T12:29:57Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.