Hi!
How can I fix this problem?
I can upload an image using the Atto editor in the general setting part, but I could not upload any image in the essay box questionnaire. The "Browse repository.." doesn't show up.

Hello:
When installing the latest mod_questionnaire update today, I get this error...
"Validating mod_questionnaire ... Error
[Error] Required Moodle version [2019052006]
Installation aborted due to validation failure"
I am running Moodle 3.7.3+ (Build: 20200103)

The latest version of questionnaire is version 2020062301, release 3.9.0. It requires Moodle version 2019052006 which is 3.7.6. This is actually a mistake and the Moodle requirement should be 2019052000, which would work with 3.7.3. You can change that in the version.php file, in the line "$plugin->requires = 2019052006;". I will get that fixed with the next release.

Hello. Is there any way of giving feedback or replying to individual questionnaire submissions?

Hi, I have problem with questionnaire submission notification. In the basic settings, I set Send submission notifications to yes . At the same time, I created a role where I enabled permission "mod/questionnaire:submissionnotification" and assigned this the role to me. I even set up an email address in questionnaire advanced settings to receive notifications, but i still do not receive any notification when somebody fill in the questionnaire. I use Moodle 3.3 version. Thanks. Martin

hello
Would be possible to change the colour of the radio button?
Thanks in advance
Carlos

Hello, I am using the latest version of this block with PHP 74 and I get an error "Deprecated: array_key_exists(): Using array_key_exists() on objects is deprecated. Use isset() or property_exists() instead in moodle/mod/questionnaire/classes/question/question.php on line 897". Any suggestions on how to fix this? isset and property_exists both cause errors in this plugin. Thanks in advance!

HI,
We are using Questionnaire: 3.9.0 (Build - 2020062300) for Moodle 3.7.2. On ......mod/questionnaire/complete.php?id=xxxx, a 'Continue' button is being displayed along message 'Thank you for completing this Questionnaire.' . Is there a way (other than custom css) to hide it?

Hi Mike ,
Thank you for great questionnaire plugin.
I'm wondering is there any way to add new fields/column in questionnaire download file? I found download option in plugin settings, but there I can choose only couple of standard fields. I made an extra fields which user fill in during signing up ((full adress or tax identity number), and it is very important to me to have data from that fields in questionnaire file in csv/html/pdf.
Could you let mi know if there is such option.
All the best
Wojtek

Hi Mike - Thanks for a great plugin.

I am wondering if there is a way to get the group average to only factor in group responses on the report? Currently, it averages the results out over the total participant count instead of just the users in one group. i.e there are 2 groups in the course collectively consisting of 5 learners. 3 in group A and 2 in group B. When all 3 learners in group A selects the same option from the radio button list it shows the group average as 60%. In actual fact, it would be helpful to see that 100% of the learners in that group selected the same option. Is this possible or have I misconfigured settings somehow?

Hi everybody,

Is there a chance that the radar view (in feeback view) will be restored for moodle 3.9 version. A suggestion has apparently been commited on github, but this one has not been validated.

Thank you for your answer (this plugin is great and essential)

I have tried to install this block, but it throws the following errors:

Información de depuración: Table 'mdl_questionnaire' already exists
CREATE TABLE mdl_questionnaire (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
intro LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
introformat SMALLINT(4) NOT NULL DEFAULT 0,
qtype BIGINT(10) NOT NULL DEFAULT 0,
respondenttype VARCHAR(9) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'fullname',
resp_eligible VARCHAR(8) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all',
resp_view TINYINT(2) NOT NULL DEFAULT 0,
notifications TINYINT(1) NOT NULL DEFAULT 0,
opendate BIGINT(10) NOT NULL DEFAULT 0,
closedate BIGINT(10) NOT NULL DEFAULT 0,
resume TINYINT(2) NOT NULL DEFAULT 0,
navigate TINYINT(2) NOT NULL DEFAULT 0,
grade BIGINT(10) NOT NULL DEFAULT 0,
sid BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
completionsubmit TINYINT(1) NOT NULL DEFAULT 0,
autonum TINYINT(1) NOT NULL DEFAULT 3,
progressbar TINYINT(1) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_ques_res2_ix (resp_view)
, KEY mdl_ques_sid2_ix (sid)
, KEY mdl_ques_cou2_ix (course)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Main questionnaire table.'
;
CREATE TABLE mdl_questionnaire_survey (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
courseid BIGINT(10),
realm VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
status BIGINT(10) NOT NULL DEFAULT 0,
title VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
email VARCHAR(255) COLLATE utf8mb4_unicode_ci,
subtitle LONGTEXT COLLATE utf8mb4_unicode_ci,
info LONGTEXT COLLATE utf8mb4_unicode_ci,
theme VARCHAR(64) COLLATE utf8mb4_unicode_ci,
thanks_page VARCHAR(255) COLLATE utf8mb4_unicode_ci,
thank_head VARCHAR(255) COLLATE utf8mb4_unicode_ci,
thank_body LONGTEXT COLLATE utf8mb4_unicode_ci,
feedbacksections TINYINT(2) DEFAULT 0,
feedbacknotes LONGTEXT COLLATE utf8mb4_unicode_ci,
feedbackscores TINYINT(1) DEFAULT 0,
chart_type VARCHAR(64) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quessurv_nam_ix (name)
, KEY mdl_quessurv_cou_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_survey table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_question (
id BIGINT(10) NOT NULL auto_increment,
surveyid BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(30) COLLATE utf8mb4_unicode_ci,
type_id BIGINT(10) NOT NULL DEFAULT 0,
result_id BIGINT(10),
length BIGINT(10) NOT NULL DEFAULT 0,
precise BIGINT(10) NOT NULL DEFAULT 0,
position BIGINT(10) NOT NULL DEFAULT 0,
content LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
required VARCHAR(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
deleted VARCHAR(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
extradata LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesques_surdel_ix (surveyid, deleted)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_question table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_quest_choice (
id BIGINT(10) NOT NULL auto_increment,
question_id BIGINT(10) NOT NULL DEFAULT 0,
content LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
value LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesqueschoi_que_ix (question_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_quest_choice table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_question_type (
id BIGINT(10) NOT NULL auto_increment,
typeid BIGINT(10) NOT NULL DEFAULT 0,
type VARCHAR(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
has_choices VARCHAR(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'y',
response_table VARCHAR(32) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_quesquestype_typ_uix (typeid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_question_type table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response (
id BIGINT(10) NOT NULL auto_increment,
questionnaireid BIGINT(10) NOT NULL DEFAULT 0,
submitted BIGINT(10) NOT NULL DEFAULT 0,
complete VARCHAR(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'n',
grade BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesresp_que_ix (questionnaireid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response_bool (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
choice_id VARCHAR(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'y',
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesrespbool_resque_ix (response_id, question_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response_bool table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response_date (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
response LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesrespdate_resque_ix (response_id, question_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response_date table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_resp_multiple (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
choice_id BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesrespmult_resquecho_ix (response_id, question_id, choice_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_resp_multiple table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response_other (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
choice_id BIGINT(10) NOT NULL DEFAULT 0,
response LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesrespothe_resquecho_ix (response_id, question_id, choice_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response_other table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response_rank (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
choice_id BIGINT(10) NOT NULL DEFAULT 0,
rankvalue BIGINT(11) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesresprank_resquecho_ix (response_id, question_id, choice_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response_rank table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_resp_single (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
choice_id BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesrespsing_resque_ix (response_id, question_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_resp_single table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_response_text (
id BIGINT(10) NOT NULL auto_increment,
response_id BIGINT(10) NOT NULL DEFAULT 0,
question_id BIGINT(10) NOT NULL DEFAULT 0,
response LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesresptext_resque_ix (response_id, question_id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_response_text table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_fb_sections (
id BIGINT(10) NOT NULL auto_increment,
surveyid BIGINT(10) NOT NULL DEFAULT 0,
section TINYINT(2),
scorecalculation LONGTEXT COLLATE utf8mb4_unicode_ci,
sectionlabel VARCHAR(50) COLLATE utf8mb4_unicode_ci,
sectionheading LONGTEXT COLLATE utf8mb4_unicode_ci,
sectionheadingformat TINYINT(2) DEFAULT 1,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesfbsect_sur_ix (surveyid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_fb_sections table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_feedback (
id BIGINT(10) NOT NULL auto_increment,
sectionid BIGINT(10) NOT NULL DEFAULT 0,
feedbacklabel VARCHAR(50) COLLATE utf8mb4_unicode_ci,
feedbacktext LONGTEXT COLLATE utf8mb4_unicode_ci,
feedbacktextformat TINYINT(2) DEFAULT 1,
minscore NUMERIC(10,5) DEFAULT 0.00000,
maxscore NUMERIC(10,5) DEFAULT 101.00000,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesfeed_sec_ix (sectionid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='questionnaire_feedback table retrofitted from MySQL'
;
CREATE TABLE mdl_questionnaire_dependency (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
surveyid BIGINT(10) NOT NULL,
dependquestionid BIGINT(10) NOT NULL DEFAULT 0,
dependchoiceid BIGINT(10) NOT NULL DEFAULT 0,
dependlogic TINYINT(2) NOT NULL DEFAULT 0,
dependandor VARCHAR(4) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_quesdepe_que_ix (questionid)
, KEY mdl_quesdepe_sur_ix (surveyid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Holds the combined dependencies per question to navigate in '
Error code: ddlexecuteerror

Trazado de la pila (stack):
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1098 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
line 427 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 372 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 835 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 570 of /lib/upgradelib.php: call to upgrade_plugins_modules()
line 1922 of /lib/upgradelib.php: call to upgrade_plugins()
line 713 of /admin/index.php: call to upgrade_noncore()

You say you are trying to install it, but the errors indicate that the tables are already in your database. So somehow you have the tables already created without your Moodle site knowing that the module is installed. Likely the only way to fix this is to manually remove all of the 'mdl_questionnaire_*' tables from your database and try to install again. Note that any data in those tables will be lost - but presumably you don't have any.

When responses have emoticons, we get this error message when trying to download the report as a PDF file:

Exception - TCPDF ERROR: [image] Unable to get the size of the image: https://(serveradress)/theme/image.php/adaptable/core/1630562462/s/smiley

Is this a known problem?
Is it a problem related to the theme rather than Questionnaire?
(A workaround is to turn off the emoticons filter in the questionnaire.)
Using Moodle 3.9.7 and Questionnaire 3.9.1 (Build - 2020111801)

Hello there,
A few days ago, we ran into a problem in our exam.

On the screen of some people, questions and random words that have never been uploaded to the system are seen. These words were not included in other questions. The longing and predicate of the questions were in different places. However, there was no such problem in the admin screen. What could be the cause of the problem. version: 3.9.0 (Build - 2020062300)