Moodle plugins directory: Multinumerical

Hello Taras,
We're using the plugin without any problems in Moodle 2.5. Can you please describe the problem encountered?

Using install on this page https://moodle.org/plugins/report/index.php?report=user_sites&pluginid=131
finished without result. Waiting on admin index. Have to delete plugin.

Hi Bohumil,
I'm not sure what "install on this page" does. Could you update me on this?

Tried to update Moodle 2.6.4 after installing some extra bits, including the Multinumerical question type.
Got this error message:

Upgrading to new version
qtype_multinumerical
Field "questionid" does not exist in table "question_multinumerical"

More information about this error
Debug info:
Error code: ddlfieldnotexist
Stack trace:

line 674 of /lib/ddl/database_manager.php: ddl_field_missing_exception thrown
line 50 of /question/type/multinumerical/db/upgrade.php: call to database_manager->rename_field()
line 531 of /lib/upgradelib.php: call to xmldb_qtype_multinumerical_upgrade()
line 1601 of /lib/upgradelib.php: call to upgrade_plugins()
line 438 of /admin/index.php: call to upgrade_noncore()

Unfortunately, this seems to prevent everything from upgrading, and removing the multinumerical files from the server doesn’t help as I still can't upgrade.
It looks as if the table in question is empty (but I know almost nothing about databases).

Mike,

Sorry about that. Would you be able to tell me which fields your question_multinumerical table contains?

Hi Nicolas, when I look at the structure of mo_question_multinumerical, in PHPMyAdmmin, it says "MySQL returned an empty result set (i.e. zero rows).
This is the third Moodle site I have set up with your question type, and it is the only one that has thrown an error. The database for this one is much larger - I have moved and upgraded our College Moodle site. This entailed using a tool to prevent the process timing out, but I used it on all of them.

Hi Mike,
In PHPMyAdmin you have to click the "structure" button next to the table name (or on top of the screen once the table is selected) to see the structure. It is possible that the table contains no records (i.e., no rows) but it is the structure of the table (not its content) that matters here.

Hi Nicolas,
I have 8 fields: id, question, parameters, conditions, feedbackperconditions, binarygrade, displaycalc and usecolorforfeedback.
So no questionid, but there is id.

Hi Mike,
Okay, there is apparently an upgrade path I didn't think of. To solve your problem, you can safely delete line 50 of the multinuerical/db/upgrade.php file. Then the upgrade process should be able to finish correctly.

When will this question type be compatible with 2.7? I only see it up to 2.6. Is 2.6 version work on 2.7?

Thank you,

Hello, just uploaded new version, supporting Moodle 2.3-2.7.

I am still getting the error with the new file.

----------------------------------
Field "questionid" does not exist in table "question_multinumerical"

More information about this error

Debug info:
Error code: ddlfieldnotexist
Stack trace:
line 669 of /lib/ddl/database_manager.php: ddl_field_missing_exception thrown
line 50 of /question/type/multinumerical/db/upgrade.php: call to database_manager->rename_field()
line 535 of /lib/upgradelib.php: call to xmldb_qtype_multinumerical_upgrade()
line 1615 of /lib/upgradelib.php: call to upgrade_plugins()
line 434 of /admin/index.php: call to upgrade_noncore()
---------------------------------

Thank you,

I've just updated the plugin. No changes but a couple bug fixes and now officially supporting up to Moodle 2.9.

Hi Nicolas,

I've just come across this question type and am interested in using it to set multi-part calculation questions where any calculation errors on the part of the user are carried forward and taken into account in their next answer.

It seems to work where the answers are whole numbers, but falls down where irrational numbers are concerned. I'd like to be able to set a tolerance on correct answers but haven't found a way to do it. I was thinking that Boolean operators might work but they don't seem to be recognised. Is that right? Is there any other way to do this that you can think of?

Hi James,

I'm not sure to understand precisely what you're trying to achieve, but intervals for correct responses can be defined, i.e.:

X + Y = [57;62]

There's no way to use boolean operators. If you feel like PM'ing me some more details, I can try to think of something.