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

Questionnaire error reading from database on access answers with mssql

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1.3
    • Fix Version/s: 2.2
    • Component/s: Module: Questionnaire
    • Labels:
      None
    • Environment:
      php5.3.3, mssql on a windows2008 machine with iis.
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_21_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE

      Description

      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 (
      )]

        Attachments

          Activity

            People

            Assignee:
            mchurch Mike Churchward
            Reporter:
            jenny-gray Jenny Gray
            Participants:
            Component watchers:
            Mike Churchward
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              5/Dec/11