Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I missed the fact that non-admin users need to have "administer FAQ" in addition to "answer a question" permissions, otherwise when they visit this page to answer questions:
faq_ask/more
The following error appears:
"user warning: Unknown column 'n.created' in 'order clause' query: SELECT * FROM faq_expert WHERE uid=2 ORDER BY n.created ASC in /home/user/public_html/includes/database.mysql.inc on line 172.
For some strange reason, I couldn't find any categories for you."
Comments
Comment #1
nancydruThat shouldn't be the case. I'll take a look at it.
Comment #2
nancydru"Administer FAQ" is only applicable if you want them to be able to edit an unanswered question.
However, the query is incorrect. You can remove "ORDER BY n.created ASC" entirely. I must have been really tired when I did that.
The fix will be committed when I figure out the dependency issue.
Comment #3
scedwar commentedThat links in with confusing behaviour (IMHO):
- if you click on the question in the block, you get presented with the form to answer the question. WHEREAS
- if you click on more in the block, then the question, you are presented with the option to edit the question, but not give the answer.
Perhaps the list should display links to the questions also, and if the author has the administer FAQ question they can edit the question?
Comment #4
nancydruHmm, that's strange because they use the same code. I'll have to see why you're getting what you're getting. But I think this should be a new issue.
I committed the fix for the original problem.
Comment #5
nancydruComment #6
nancydruFix committed.
Comment #7
Anonymous (not verified) commentedAutomatically closed -- issue fixed for two weeks with no activity.
Comment #8
nancydruFixed for 6.x