Several users have reported a MySQL 'unknown field' error for location.province_select. The source of this error is in the location_views.module. The error may be eliminated by changing line 95 from 'field' => 'province_select', to 'field' => 'province',.

Again, there is a definition on line 251:
$tables['user_location']['filters']['province'] = array(
which is overwritten on line 260, so the MySQL problem has never been triggered by this section of code.

Change line 251 to
$tables['user_location']['filters']['province_select'] = array(

and line 253 from
'field' => 'province_select',
to 'field' => 'province',
and the functionality should be restored in the user views as well.

Comments

bdragon’s picture

Status: Active » Fixed

Committed, thanks!

Anonymous’s picture

Status: Fixed » Closed (fixed)

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