-
Bug
-
Resolution: Fixed
-
Minor
-
2.7.8, 2.8.6, 2.9
-
2014070403
-
PostgreSQL
-
MOODLE_27_STABLE, MOODLE_28_STABLE, MOODLE_29_STABLE
-
MOODLE_33_STABLE
Attempting to access the 'Recent activity' report in a course containing a Questionnaire instance results in the 'Error reading from database' message.
On investigation this turns out to be caused by a join in questionnaire_get_recent_mod_activity() on user.id = questionnaire_response.username, which have different types. As questionnaire_response.username is actually the Moodle user id it seems this should be an integer rather than a varchar.
- duplicates
-
CONTRIB-5706 Recent Activity Report Error (DML Read Exception)
- Closed
- will help resolve
-
CONTRIB-4761 Table questionnaire_response has field 'username' but is storing 'userid'
- Closed