Province not showing in table view [#184565]

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

Comment #1

Memeshift CreditAttribution: Memeshift commented 21 February 2008 at 00:45

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.

Comment #2

Memeshift CreditAttribution: Memeshift commented 21 February 2008 at 01:11

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)

Comment #3

zetxek CreditAttribution: zetxek commented 10 March 2009 at 12:01

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

Comment #4

bwright CreditAttribution: bwright commented 18 June 2009 at 00:33

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