-
Bug
-
Resolution: Fixed
-
Minor
-
2.1.3
-
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 (
)]