Download & Extend

Keyword listing gives Unknown column 'b.biblio_keywords' ... biblio.pages.inc on line 85

Project:Bibliography Module
Version:6.x-1.0-rc4
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

When I visit the keyword listing, I get this warning:
user warning: Unknown column 'b.biblio_keywords' in 'order clause' query: SELECT DISTINCT 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 WHERE (n.language ='nl' OR n.language ='' OR n.language IS NULL) AND ( n.type='biblio' )ORDER BY SUBSTR(LTRIM(b.biblio_keywords),1,4) desc LIMIT 0, 150 in /sites/all/modules/biblio/biblio.pages.inc on line 85.

(Maybe because of remnants from earlier versions or so? I went through most beta's and at some point I used another vocabulary then the default one I now use).

Comments

#1

BTW, is this keyword sorting also the feature you mention in the release notes ("Keywords page which displays all keywords in the database linked to publication list filtered by that keyword")?

#2

When you say "visit the keyword listing" what URL are you referring to?

Keyword sorting is still broken.

#3

Yes, I meant keyword sorting. Sorry, I wasn't aware keyword sorting wasn't ready yet...

So the keyword sorting is not the "Keywords page" feature?

#4

The keywords page referred to in the release notes is biblio/keywords, which like biblo/authors list all the keywords or authors respectively.

There should be a biblio menu item with the above choices under it.

Ron.

#5

OK, I just fixed the keyword sorting. I'm going to roll a new RC since there is a nasty bug in the keyword taxonomy stuff, so you will find all the bugs we discussed tonight are fixed in RC5.

Ron.

#6

I see it now, I was looking for something to configure in the Biblio administration, but the links are already in the navigation menu.

#7

Status:active» fixed

Great work

#8

Status:fixed» closed (fixed)

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