Undefined binding(s) detected when compiling SELECT query about strapi-examples HOT 7 CLOSED

I am also having the same problem. The example from Strapi doc is not working
https://strapi.io/documentation/3.x.x/guides/graphql.html#query-api
Only workaround is to use a where clause but that returns an array of posts instead of a single post.

Not working:

query {
    post(id: "3") {
      title
      byline
      lead
      content
    }
}

Returns error:
"Undefined binding(s) detected when compiling SELECT query: select posts.* from posts where posts.id = ? limit ?"

Workaround:

query {
    posts(where: {id:"3"}) {
      title
      byline
      lead
      content
    }
}

Node: v10.15.0
Npm: 6.4.1
Strapi: 3.0.0.alpha 21
OS: Windows 10
Database: MySQL

from strapi-examples.

Alpha 23.1, same issue too.
But I found the error point maybe.

Changing plugins/graphql/service/Query.js
from

              ...this.convertToParams(_.omit(_options, 'where')),
              ..._options.where,

to

              ...this.convertToParams(_.omit(_options, 'where')),
              ..._options,
              ..._options.where,

makes working right temporary.

from strapi-examples.

Having the same issue here on Strapi version 3.0.0-alpha.22. The referenced issue #2396 (which was fixed in alpha 22) appears to be a different issue entirely since this is still broken in alpha 22.

from strapi-examples.

I am also facing the same issue. Please provide solution at the earliest as it is stopping me alot. Thanks in advance. I was using 3.0.0.alpha 21, now upgraded to 3.0.0.alpha 22 still i am facing same issues :(

from strapi-examples.

Alpha 22, same issue

from strapi-examples.

Workaround is to use mongodb - in stage 1 - setup they use MongoDB (recommended).

Got here because I had the same issue, but using Postgres. I did not get this problem when using MongoDB.

from strapi-examples.

I close this issue, can you check on the mono repo if this issue exist.
It's not related to the example but look like related to the GraphQL plugin.

from strapi-examples.