Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-9378

Crossword causes invalid query in Moodle 4.1

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.1.5
    • Module: Game
    • None
    • 2023091101
    • MOODLE_401_STABLE

      We just encountered an issue when viewing a crossword. There is an invalid query executed: `Unknown column 'version' in 'order clause'`. After some analysis it seems that in locallib, method `game_questions_shortanswer_question_fraction` there is a order criteria added if moodle is 4.0 or newer. From my understanding the version column is only available if a query is executed against `question_versions` which is not always the case. For example see the invocation in `game_questions_shortanswer_quiz`.

       

      I suppose this issue affects Moodle 4.0+

            bdaloukas Vasilis Daloukas
            stephan.bauer Stephan Bauer
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.