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

notice and sql errors in questionnaire module

XMLWordPrintable

    • PostgreSQL
    • MOODLE_18_STABLE
    • MOODLE_17_STABLE, MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE

      On View survey initially:

      Notice: Trying to get property of non-object in
      /oci/openlearn-wwwrootacct/mod/questionnaire/locallib.php on line 536

      ERROR: invalid input syntax for integer: ""

      SELECT * FROM mdl_user WHERE id = ''
      line 779 of lib/dmllib.php: call to debugging()
      line 576 of lib/dmllib.php: call to get_recordset_sql()
      line 516 of lib/dmllib.php: call to get_record_sql()
      line 739 of mod/questionnaire/locallib.php: call to get_record()
      line 712 of mod/questionnaire/locallib.php: call to
      questionnaire->print_survey_start()
      line 667 of mod/questionnaire/locallib.php: call to
      questionnaire->survey_render()
      line 266 of mod/questionnaire/locallib.php: call to
      questionnaire->print_survey()
      line 52 of mod/questionnaire/view.php: call to questionnaire->view()

      Notice: Undefined variable: resp in
      /oci/openlearn-wwwrootacct/mod/questionnaire/locallib.php on line 746

      Notice: Trying to get property of non-object in
      /oci/openlearn-wwwrootacct/mod/questionnaire/locallib.php on line 746

      On submit survey:

      Notice: Undefined variable: message in /oci/openlearn-wwwrootacct/mod/questionnaire/locallib.php on line 1394

      On clicking All responses button:

      ERROR: column "qc.content" must appear in the GROUP BY clause or be used in an aggregate function

      SELECT qc.id, qc.content, COUNT(rt.response_id) AS num FROM mdl_questionnaire_question_choice qc, mdl_questionnaire_response_single rt WHERE qc.question_id=5467 AND qc.content NOT LIKE '!other%' AND rt.question_id=qc.question_id AND rt.choice_id=qc.id AND response_id IN (455) GROUP BY qc.id

      line 779 of lib/dmllib.php: call to debugging()
      line 1020 of lib/dmllib.php: call to get_recordset_sql()
      line 506 of mod/questionnaire/questiontypes/questiontypes.class.php: call to get_records_sql()
      line 720 of mod/questionnaire/questiontypes/questiontypes.class.php: call to questionnaire_question->get_response_single_results()
      line 627 of mod/questionnaire/questiontypes/questiontypes.class.php: call to questionnaire_question->display_response_single_results()
      line 2376 of mod/questionnaire/locallib.php: call to questionnaire_question->display_results()
      line 50 of mod/questionnaire/results.inc: call to questionnaire->survey_results()
      line 343 of mod/questionnaire/report.php: call to include()

      View by Response

      ERROR: invalid input syntax for integer: "Anonymous"

      SELECT * FROM mdl_user WHERE id = 'Anonymous'

      line 779 of lib/dmllib.php: call to debugging()
      line 576 of lib/dmllib.php: call to get_recordset_sql()
      line 516 of lib/dmllib.php: call to get_record_sql()
      line 2105 of mod/questionnaire/locallib.php: call to get_record()
      line 28 of mod/questionnaire/results.inc: call to questionnaire->survey_results_navbar()
      line 343 of mod/questionnaire/report.php: call to include()

      Plus the same issue at lines 2096 and 739

            rezeau Joseph Rézeau
            jenny-gray Jenny Gray
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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