Province not showing in table view
antiorario - October 18, 2007 - 10:45
| Project: | Location Views |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | antiorario |
| Status: | active |
Jump to:
Description
User province data don't show when i create a table view. I checked the database table and the data is there. I even tried to create a basic table view, with only a province field. The right number of rows show up, but the province field is still empty.
Any ideas?
Thanks,
Tony
#1
Hey antiorario,
were you ever able to resolve this?
I keep getting this wierd error every time i try and filter by state:
user warning: Unknown column 'location.province_select' in 'where clause' query: SELECT count(node.nid) FROM node node LEFT JOIN location location ON node.vid = location.eid WHERE (node.status = '1') AND (location.type = 'node') AND (node.type IN ('member_organization')) AND (location.province_select = 'us-IN') in /Applications/MAMP/htdocs/drupal/includes/database.mysql.inc on line 172.#2
Hey again antiorario,
I made another post here regarding this issue:
http://drupal.org/node/118814#comment-739468
It now works for FILTERING a Search by State (Province)
#3
Suscribing... I'm having the same issue.
#4
I'm having a similar problem:
I created a 'user' view with a table layout and added username & avatar image fields along with the 'location: province' field so that I could have a page showing a table of all users with their avatars and what state they are from. Username and avatar image show up fine in the table but the province column is empty. Not all users have filled out their location info in their profiles but a lot have so I should see at least some states in that column.
Drupal 6.8
Location 6.x-3.x-dev