Skip to main content

SQL error in Community quizzes

861 Views
0 Replies
1 min read

Hi

When clicking on the difficulties level option, I get the followng SQL error:

 

Error

Unknown column 'c.title' in 'order clause' SQL=SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.published, a.access, a.created, a.created_by, a.ordering, a.language,l.title AS language_title,uc.name AS editor,ag.title AS access_level FROM #__quiz_levels AS a LEFT JOIN `#__languages` AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access WHERE (a.published = 0 OR a.published = 1) ORDER BY c.title ASC, a.ordering ASC LIMIT 500
 
Please advise.

0 Replies

No Replies Yet

Topic Author

B

baileyn

@baileyn

Topic Stats

Created Monday, 30 January 2017 13:36
Last Updated Monday, 30 January 2017 13:36
Replies 0
Views 861
Likes 0

Share This Topic