When trying the recreate the user list page (profile page) i've created a new views page requesting user fields such as:
User: Created date
User: Last access
User: Name
User: Picture
User: Role
User: Uid

and when saving or trying to view the www.domain.com/profile page the following errors occurs

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS users_, users.login AS users_login, users.uid AS users_uid FROM users ' at line 5 query: SELECT COUNT(*) FROM (SELECT users.uid AS uid, users.created AS users_created, users.access AS users_access, users.name AS users_name, users. AS users_, users.login AS users_login, users.uid AS users_uid FROM users users ) count_alias in domain/sites/all/modules/views/includes/view.inc on line 545.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS users_, users.login AS users_login, users.uid AS users_uid FROM users ' at line 5 query: SELECT users.uid AS uid, users.created AS users_created, users.access AS users_access, users.name AS users_name, users. AS users_, users.login AS users_login, users.uid AS users_uid FROM users users ORDER BY users_created ASC, users_login ASC, users_name ASC, users_uid ASC LIMIT 0, 25 in domain/sites/all/modules/views/includes/view.inc on line 545.

Comments

merlinofchaos’s picture

Status: Active » Fixed

It appears the picture field was not working. (The other fields seem fine to me). I just checked in an update to fix this.

Anonymous’s picture

Status: Fixed » Closed (fixed)

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

focal55’s picture

Title: Views Error when try to add user fields » Views Error when try to add to block
Status: Closed (fixed) » Active

This is my first time posting an issue. Please forgive if this is wrong spot. I am trying to add a created View in my Adminsitration>Site BUilding> Blocks section. I can only get one created View to show up in Adminsitration>Site Building> Blocks section. Is this a bug? I have been searching for a few days to solve this and I can not find anything so I figured I'd try to post.

Thanks for the help

merlinofchaos’s picture

Title: Views Error when try to add to block » Views Error when try to add user fields
Status: Active » Closed (fixed)

Asking for forgiveness does not change the fact that opening closed issues for different issues is bad.

That said, the bug you're inquiring about is fixed in -dev, and there is already an issue about it.