I just upgraded from 6.x-1.6 to 6.x-1.7 (following the instructions at http://drupal.org/node/111017; including running update.php). I now receive the following error message when Ordered By in Block Settings is set to Year Published, but not when it is set to Date Created:

user warning: Unknown column 'b.biblio_year' in 'order clause' query: SELECT DISTINCT(n.nid), n.title FROM node n WHERE n.type = 'biblio' AND n.status=1 ORDER BY b.biblio_year DESC LIMIT 0, 3 in /home/ethan/public_html/sites/all/modules/biblio/biblio.module on line 1669.

I have the New Publications Block on all pages. The main publications page can still be sorted by Year.

I'm new to Drupal so it is definitely possible that I'm missing something simply, in which case please consider this a support request with my apologies.

I'm running Drupal 6.14 with CCK, Domain Access, Advanced Help, FCKeditor, IMCE, Page Title, Google Analytics and Views.

Comments

rjerome’s picture

rjerome commented
Status: Active » Fixed

That is definitely a bug which I inadvertently introduced in 1.7.

It's fixed now. (http://drupal.org/cvs?commit=269950)

If you want to fix it in your current installation, just add the line highlighted in green here http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/biblio/bibl... (line 1667) to your biblo.module file.

Cheers,

Ron.

Status: Fixed » Closed (fixed)

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