Closed (outdated)
Project:
Bibliography Module
Version:
6.x-1.2
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
12 Apr 2009 at 19:38 UTC
Updated:
20 Dec 2018 at 17:14 UTC
Jump to comment: Most recent
Comments
Comment #1
tomski commentedI also noticed another bug connected to this: if I select in the filter tab any filter, and then I clik on my link to the filtered url, I get as a result a view filtered by both the url and the preselected filter.
And if the preselected filter is of the same type of the url filter, then I get an error :
* user warning: Not unique table/alias: 'bk' query: SELECT COUNT(DISTINCT(n.nid)) FROM node n left join biblio b on n.vid=b.vid inner join biblio_types bt on b.biblio_type=bt.tid inner join biblio_keyword as bk on n.vid = bk.vid inner join biblio_keyword as bk on n.vid = bk.vid LEFT JOIN domain_access da ON n.nid = da.nid WHERE ((da.realm = "domain_id" AND da.gid = 6) OR (da.realm = "domain_site" AND da.gid = 0)) AND (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( (bk.kid = 12 ) AND (bk.kid = 14 ) AND (n.type='biblio' ) ) in .../sites/all/modules/biblio/biblio.pages.inc on line 86.
* user warning: Not unique table/alias: 'bk' query: SELECT DISTINCT(n.nid), n.*, b.*, bt.name as biblio_type_name FROM node n left join biblio b on n.vid=b.vid inner join biblio_types bt on b.biblio_type=bt.tid inner join biblio_keyword as bk on n.vid = bk.vid inner join biblio_keyword as bk on n.vid = bk.vid LEFT JOIN domain_access da ON n.nid = da.nid WHERE ((da.realm = "domain_id" AND da.gid = 6) OR (da.realm = "domain_site" AND da.gid = 0)) AND (n.language ='fr' OR n.language ='' OR n.language IS NULL) AND ( (bk.kid = 12 ) AND (bk.kid = 14 ) AND (n.type='biblio' ) )ORDER BY b.biblio_year DESC, b.biblio_date DESC LIMIT 0, 40 in .../sites/all/modules/biblio/biblio.pages.inc on line 86.
Comment #2
tomski commentedA correction: the above error appears only when the filters associated are both "keyword".
Comment #3
rjerome commentedI've fixed the first part of this, and have been able to reproduce the error in comment #1, but it's not fixed yet.
So the sorting links will not reset the URL, but filtering by keyword and subsequently sorting by keyword does still produce the above mentioned error.
Ron.
Comment #4
liam morlandThis version is no longer maintained. If this issue is still relevant to the Drupal 7 version, please re-open and provide details.