Thanks for the great module.

I just installed on a Drupal 5.12/Uber site. All seems to be functioning well until I create a view to generate a nav block to display in sidebar left. I am looking to provide some means for visitors to select quotes by author name in a nav block (preferably A/B/C type but can't figure that one out yet). The view is created but when I change the block from "disabled" to "sidebar left" I receive the following error:

user warning: Unknown column 'quotes.author' in 'field list' query: SELECT DISTINCT(node.nid), quotes.author AS quotes_author FROM node node INNER JOIN quotes quotes ON node.vid = quotes.vid WHERE (node.status = '1') AND (node.type IN ('quotes')) ORDER BY quotes_author ASC LIMIT 0, 10 in /home/account/public_html/installdirectory/includes/database.mysqli.inc on line 156.

I upgraded to D5.15, same problem.

Any thoughts on this?

Thanks for your help.

-Greg

Comments

TrinitySEM’s picture

TrinitySEM commented
Title: user warning: Unknown column 'quotes.author' in 'field list' query: » Update

Update: It seems that the issue is a result of selecting Author Name as a sort criteria within the view. When I remove this from the sort the error is resolved.

TrinitySEM’s picture

TrinitySEM commented

Same issue with views fields. It appears that the issue occurs anytime when using Author Name as the criteria.

TrinitySEM’s picture

TrinitySEM commented
Title: Update » user warning: Unknown column 'quotes.author' in 'field list' query:
nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

Well, I can reproduce this, so hopefully I can fix it. It has probably been broken for a while (since the "Bios" change), so that tells me that few people are using Views. It will be a day or two until I can get back to Quotes. In the mean time, please test the newest -dev features.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

For the short term, you can get a block by authors by creating a PHP format block with this code:

  return drupal_get_form('quotes_author_form');
nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Active » Fixed

Well, it's not giving errors.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Fixed » Closed (fixed)

New release published.