Unknown column friendlist_relations.uid

Am having the same Issue;

user warning: Unknown column 'friendlist_relations.uid' in 'on clause' query: SELECT COUNT(*) FROM (SELECT users_friendlist_relations.picture AS users_friendlist_relations_picture, users_friendlist_relations.uid AS users_friendlist_relations_uid, users_friendlist_relations.name AS users_friendlist_relations_name, users_friendlist_relations.mail AS users_friendlist_relations_mail, friendlist_statuses.last_update_time AS friendlist_statuses_last_update_time FROM friendlist_relations friendlist_relations LEFT JOIN users users_friendlist_relations ON friendlist_relations.uid = users_friendlist_relations.uid LEFT JOIN users users_friendlist_relations_1 ON friendlist_relations.uid = users_friendlist_relations_1.uid INNER JOIN friendlist_statuses friendlist_statuses ON friendlist_relations.rid = friendlist_statuses.rid LEFT JOIN friendlist_relation_types friendlist_relation_types ON friendlist_relations.rtid = friendlist_relation_types.rtid WHERE (friendlist_statuses.status in ('TW_BOTH')) AND (friendlist_relation_types.active <> 0) AND (friendlist_relation_types.oneway = 0) AND (friendlist_relations.rtid in ('1')) AND (users_friendlist_relations_1.uid = 1 ) ) count_alias in ../sites/all/modules/views/plugins/views_plugin_pager.inc on line 141.

    user warning: Unknown column 'friendlist_relations.uid' in 'on clause' query: SELECT users_friendlist_relations.picture AS users_friendlist_relations_picture, users_friendlist_relations.uid AS users_friendlist_relations_uid, users_friendlist_relations.name AS users_friendlist_relations_name, users_friendlist_relations.mail AS users_friendlist_relations_mail, friendlist_statuses.last_update_time AS friendlist_statuses_last_update_time FROM friendlist_relations friendlist_relations LEFT JOIN users users_friendlist_relations ON friendlist_relations.uid = users_friendlist_relations.uid LEFT JOIN users users_friendlist_relations_1 ON friendlist_relations.uid = users_friendlist_relations_1.uid INNER JOIN friendlist_statuses friendlist_statuses ON friendlist_relations.rid = friendlist_statuses.rid LEFT JOIN friendlist_relation_types friendlist_relation_types ON friendlist_relations.rtid = friendlist_relation_types.rtid WHERE (friendlist_statuses.status in ('TW_BOTH')) AND (friendlist_relation_types.active <> 0) AND (friendlist_relation_types.oneway = 0) AND (friendlist_relations.rtid in ('1')) AND (users_friendlist_relations_1.uid = 1 ) ORDER BY friendlist_statuses_last_update_time DESC LIMIT 0, 12 in ..sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1150.

I've had exactly the same problem after upgrading Views 3 from alpha3 to rc3.

Looking at the queries generated by Views, I saw that the fields 'requestee_id' and 'requester_id' have been replaced by 'uid', which doesn't exist in the friendlist_relations table.

I don't know if the bug resides in Views or Friendlist but I found a quick fix by rewriting the query, using the views_query_alter hook:

function mymodule_views_query_alter(&$view, &$query) {
  if ($view->name == 'myviewname' && $view->current_display == 'myviewdisplay') {
    $query->table_queue['users_friendlist_relations']['join']->definition['left_field'] = 'requestee_id';
    $query->table_queue['users_friendlist_relations']['join']->left_field = 'requestee_id';
    $query->table_queue['users_friendlist_relations_1']['join']->definition['left_field'] = 'requester_id';
    $query->table_queue['users_friendlist_relations_1']['join']->left_field = 'requester_id';
  }
}

HTH.

Hi jfhovinne, I just got the same problem after upgrading to views3. Can you instruct me how I should edit views_query_alter hook? which file to edit? Thanks very much!

Hi I'm having this problem also after upgrading my views.
I'm going to attempt to make my own quick fix module as described in #2.
I say attempt because making my own module has never been a successful venture for me so far. I just don't quiet understand how to do it properly so I find is scary.

I can see that the fix is pretty simular to a patch I had to run on the heartbeat module to bring that up to speed with views3.

Is there a possibility the code above can be written as a patch for friendlist as I'm great with patches.

Patches I like.
Self module, I fail.

It's because I'm stupid you see.

Anyway in the mean time I'll read through the module creation tutorials I can find again in the hope that it will sink in this time while I prey my derp butt gets saved again with the submission here of a friendly patch.

Well what do you know I made a module afterall.

Thanks for the script to put in it.

Must say docs on drupal have improved since last I checked.

http://drupal.org/node/416986