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

Comments

Memeshift’s picture

Memeshift commented

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.
Memeshift’s picture

Memeshift commented

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)

zetxek’s picture

zetxek commented

Suscribing... I'm having the same issue.

bwright’s picture

bwright commented

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

antiorario’s picture

antiorario commented
Assigned: antiorario » Unassigned
antiorario’s picture

antiorario commented
Issue summary: View changes
Status: Active » Closed (won't fix)