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

Questionnaire error reading from database on access answers with mssql

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 2.2
    • 2.1.3
    • Module: Questionnaire
    • None
    • php5.3.3, mssql on a windows2008 machine with iis.
    • Microsoft SQL
    • MOODLE_21_STABLE
    • MOODLE_22_STABLE

      Actually reported at http://moodle.org/mod/forum/discuss.php?d=193076

      I installed the questionnaire module and i made various questionnaires, now when i try to access the answers it gives 'error reading from database'. I turn on debug and the error is.

      Debug info: Incorrect syntax near the keyword 'user'.
      SELECT R.id, R.survey_id, R.submitted, R.username, U.id AS user
      FROM mdl_questionnaire_response R,
      mdl_user U
      WHERE R.survey_id=17 AND
      R.complete='y' AND CAST(R.username AS INT) =U.id
      ORDER BY user
      [array (
      )]

            mchurch Mike Churchward
            jenny-gray Jenny Gray (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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