SQL error in Community quizzes

baileyn
baileyn
  • baileyn
  • 7 months ago

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.

Access to viewing replies is restricted.
Showing 2 of 2 replies
You do not have permissions for replying to this topic.
Loading...
Confirm delete? This action is irreversible and the data will be deleted permanently. Do you want to continue? Confirm Add New Delete Unpublish Cancel Import Uninstall The selected item successfully deleted.
Shondalai