Posted by anjjriit on November 13, 2011 at 3:17am
4 followers
Jump to:
| Project: | FriendList |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
I found this error when click community tab
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, friendlist_relations.requestee_id AS friendlist_relations_requestee_id, friendlist_relations.requester_id AS friendlist_relations_requester_id, friendlist_relations.rtid AS friendlist_relations_rtid 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 = 10 ) ) count_alias in ....../sites/all/modules/views/plugins/views_plugin_pager.inc on line 141I checked my 'friendlist_relations' table and really is no 'uid' column, is this an bug or i miss someting ?
Thank in advance
Comments
#1
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.
#2
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:
<?phpfunction 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.
#3
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!