Main view (User entity):


  • (Representative node) Content: Nid
  • (Representative node) Content: Type
  • (Representative node) Content: Post date
  • (Representative node) Content: Title
  • other fields

Filter criteria:

  • user roles, user active


  • User: Representative node

Represantative view (Content based)


  • Content: Nid

Filter criteria:

  • Content: Type (in Innovation, ...)
  • Content: Language (= Current user's language)
  • Content: Promoted to front page (Yes)


  • Content: Post date (desc)

Generated query: http://pastebin.com/cvKD3zzB


Error message SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Could someone give me any advice?

2 Answers 2


The error has to do with a bug related to User: Representative node. Checkout https://www.drupal.org/node/1417090. Comment #35 has a patch for the latest dev version of views that will possibly fix the issue.


Drupal 8 still has problem here is the related issue with patches available

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.