Moodle plugins directory: Questionnaire

Hi mike;
1.Is there any problem installing moodle version 3.2.1+ (Build: 20170112) ?
2. is there a way to setup the questionnare so course students can get a pop up or notice when they need to fill in a survey?

hi,
is there a way to copy ready questionnaire activity to all courses (it is the same sutvey for all courses)

Hello Mike. This plugin has proved almost perfect for my needs and thanks for developing. I note this comment in the documentation "On an Individual Responses page, the current user's current results Chart will be displayed, and also the All participants (or current group) results Chart." and wonder whether this can be disabled. I only want to show individual results. Many thanks

Hello, I have an issue with the Rate (scale) question type, when a question is set to be mandatory and the user does not move any radiobuttons from the initial position, it allows the user to easily skip those questions. Can someone advice me on the matter please? It was pretty an unpleasant surprise on a large scale questionnaire. Thank you!

I'm developing an Ajax function that works on each question. But I need to use a session variable to obtain the response selected for the question by the user. Where I can find this kind of documentation? or How can I obtain this session variables? Thank you.

@Yegor - Please repost your question in the questionnare forum - https://moodle.org/mod/forum/view.php?id=2642

@Yackelyn - Please repost your question in the questionnare forum - https://moodle.org/mod/forum/view.php?id=2642

I am looking to create a playlist or Learning Plan consisting of specific content WHEN a student answers a question in a Quiz or Questionnaire. Is this possible with your plug?

Hi mike. is there a way to export to csv the summary results ?

Hi Meir. Yes, that is part of the standard function - https://docs.moodle.org/35/en/Questionnaire_module#Export_text_file.
It is a tab when you are looking at the results.

Hi Mike,

There's a bug with this plugin in that it doesn't work with MySQL 8.0.12... Given that MySQL 8.0.x is now GA, any chance you can get this fixed? I'm using this on a live server now, the semester has started and we've only just picked up on this issue.

One problem I found is that "rank" is now a reserved word, but got around that using backticks, however couldn't get the rest of it to work.

Here's the debugging info...

Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
FROM wsu_moodle_cybersec_questionnaire_response qr
' at line 3
SELECT CONCAT_WS('_', qr.id, 'checkboxes', qrm.id) AS id,
qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrm.question_id,
qrm.choice_id, qro.response AS response, 0 AS rank
FROM wsu_moodle_cybersec_questionnaire_response qr
JOIN wsu_moodle_cybersec_questionnaire_resp_multiple qrm ON qrm.response_id = qr.id
AND qr.survey_id = ? AND qr.complete = ?
LEFT JOIN wsu_moodle_cybersec_questionnaire_response_other qro ON qro.response_id = qr.id AND qro.choice_id = qrm.choice_id
LEFT JOIN wsu_moodle_cybersec_user u ON u.id = qr.userid
WHERE qr.id = ? UNION ALL
SELECT CONCAT_WS('_', qr.id, 'textbox', qrt.id) AS id,
qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrt.question_id,
0 AS choice_id, qrt.response AS response, 0 AS rank
FROM wsu_moodle_cybersec_questionnaire_response qr
JOIN wsu_moodle_cybersec_questionnaire_response_text qrt
ON qrt.response_id = qr.id
AND qr.survey_id = ? AND qr.complete = ?
LEFT JOIN wsu_moodle_cybersec_user u ON u.id = qr.userid
WHERE qr.id = ? ORDER BY usrid, id
[array (
0 => '2',
1 => 'y',
2 => 3,
3 => '2',
4 => 'y',
5 => 3,
)]
Error code: dmlreadexception
Stack trace:
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1184 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 2597 of /mod/questionnaire/questionnaire.class.php: call to mysqli_native_moodle_database->get_recordset_sql()
line 2782 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->get_survey_all_responses()
line 1902 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->generate_csv()
line 1599 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->response_send_email()
line 277 of /mod/questionnaire/questionnaire.class.php: call to questionnaire->submission_notify()
line 75 of /mod/questionnaire/complete.php: call to questionnaire->view()

This server is

Moodle 3.5.1+ (Build: 20180720)
MySQL 8.0.12
PHP 7.2.8.1.16.04.1.1

Much appreciated!

Cheers,
Ray

Mike - Never mind the "the rest of it" comment, it's only the backticks around the reserved word `rank` that i can tell is the issue. Adding those ticks there processes the command.

Cheers,
Ray

Hi Ray. Any chance you could post that as an issue either in the Moodle Tracker, or as a Github issue?

Did we get over this, my error

Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
FROM mdl_questionnaire_response qr
JOIN mdl_que' at line 3

SELECT CONCAT_WS('_', qr.id, 'checkboxes', qrm.id) AS id,
qr.submitted, qr.complete, qr.grade, qr.userid, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.firstname, u.lastname, u.username, u.department, u.institution, u.id as usrid, qr.id AS rid, qrm.question_id,
qrm.choice_id, qro.response AS response, 0 AS rank
FROM mdl_questionnaire_response qr
JOIN mdl_questionnaire_resp_multiple qrm ON qrm.response_id = qr.id

AND qr.survey_id = ? AND qr.complete = ?
LEFT JOIN mdl_questionnaire_response_other qro ON qro.response_id = qr.id AND qro.choice_id = qrm.choice_id
LEFT JOIN mdl_user u ON u.id = qr.userid

ORDER BY usrid, id
[array (
0 => '18034',
1 => 'y',
)]
Error code: dmlreadexception

Cheers

I believe this is the reported issue - https://tracker.moodle.org/browse/CONTRIB-7420