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
Comment #1
merlinofchaos CreditAttribution: merlinofchaos commentedIt appears the picture field was not working. (The other fields seem fine to me). I just checked in an update to fix this.
Comment #2
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.
Comment #3
focal55 CreditAttribution: focal55 commentedThis 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
Comment #4
merlinofchaos CreditAttribution: merlinofchaos commentedAsking 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.