I have a view with a block display and when I add the field field: User: Roles I get an error:
Notice: Array to string conversion in DatabaseStatementBase->execute() (line 2137 of /var/www/mototribe/dev/includes/database/database.inc).

Comments

dawehner’s picture

Status: Active » Fixed

You have to add the content: author relationship first.
This bug is fixed in the current dev version.

ppc.coder’s picture

I tried adding the Content: Authored relationship before adding User: Roles field but I still get that error (and many more times).

Ate_f’s picture

Having the same problem... Is there any other way of showing all the people assigned a certain role on one page? (I wish to group people per role, duplicates in different roles are no objection)

Aldus’s picture

I am having the same problem with an user view. Adding an User: Roles field creates this error:

Notice: Array to string conversion in DatabaseStatementBase->execute() (line 2137 of [....]

Using content: authored doens't work (it would work maybe for a node view)

Aldus’s picture

Status: Fixed » Active
daniela basualdo’s picture

+ subscribing

BeaPower’s picture

I get this error when using the latest dev: PDOException: SQLSTATE[08004] [1040] Too many connections in drupal_get_installed_schema_version() (line 150 of /var/www/vhosts/ewe.com/httpdocs/includes/install.inc).

dawehner’s picture

Status: Active » Postponed (maintainer needs more info)

@BeaPower
My suggestion for this error is google. This has simply nothing to do with drupal.

@Aldus
Could you please this with the current version of views and provide a view export of the buggy view? This would be somehow required to get some help.

esmerel’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)