error in moodle 2.1 beta

error in moodle 2.1 beta

ដោយ Nikita M នៅ
ចំនួនតប៖ 14

Hi,

when I try to load questions with deferred feedback in moodle 2.1 beta I receive this message:

 

Error writing to database

More information about this error

Debug info: Out of range value for column
'minfraction' at row 1

INSERT INTO mdl_question_attempts
(questionusageid,slot,behaviour,questionid,variant,maxmark,minfraction,flagged,questionsummary,rightanswer,responsesummary,timemodified)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?)

[array (

0 => 8,

1 => 1,

2 => 'deferredfeedback',

3 => '39',

4 => 1,

5 => '1.0000000',

6 => '-0.2500000',

7 => 0,

8 => '

Per copyright
relativamente al software si intende:: un insieme di norme che proteggono
legalmente la proprietà del software; la fase di copia di un software da CD a
disco fisso; un software creato per realizzare copie di altri software; un
dispositivo hardware preposto a realizzare copie di software da CD e DVD',

9 => 'un insieme di
norme che proteggono legalmente la proprietà del software',

10 => NULL,

11 => 1308498189,

)]

Stack trace:

line
396 of \lib\dml\moodle_database.php: dml_write_exception thrown

line
878 of \lib\dml\mysqli_native_moodle_database.php: call to
moodle_database->query_end()

line
920 of \lib\dml\mysqli_native_moodle_database.php: call to
mysqli_native_moodle_database->insert_record_raw()

line
95 of \question\engine\datalib.php: call to
mysqli_native_moodle_database->insert_record()

line
71 of \question\engine\datalib.php: call to
question_engine_data_mapper->insert_question_attempt()

line
93 of \question\engine\lib.php: call to question_engine_data_mapper->insert_questions_usage_by_activity()

line
196 of \mod\quiz\startattempt.php: call to
question_engine::save_questions_usage_by_activity()

how fix this error?

 

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Tim Hunt នៅ
រូបភាព Core developers រូបភាព Documentation writers រូបភាព Particularly helpful Moodlers រូបភាព Peer reviewers រូបភាព Plugin developers

It appears I defined that column as unsigned, which is stupid.

Doh!

Filed as MDL-27929.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

Good Tim.

In timhunt-Moodle-Question-Engine-2-43277d3 it works, but then then you have made some change and it began to give this error.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Tim Hunt នៅ
រូបភាព Core developers រូបភាព Documentation writers រូបភាព Particularly helpful Moodlers រូបភាព Peer reviewers រូបភាព Plugin developers

I don't seem to have a 43277d3 revision anywhere. Weird. Can you describe the version it works in in some other way? Thanks.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

Is it possible to send you this file in some way?

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Tim Hunt នៅ
រូបភាព Core developers រូបភាព Documentation writers រូបភាព Particularly helpful Moodlers រូបភាព Peer reviewers រូបភាព Plugin developers

Attach it to the bug report.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

done.

I Attach lib+mod+question to the bug report (http://tracker.moodle.org/browse/MDL-27929).

I hope this could help you to find a solution.

In the next version that I have (timhunt-Moodle-Question-Engine-2-ec27d5e) it stopped to work

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

Hi Tim,

is it possible to give this issue hight priority. How can I write in my thesis that it is the best LCMS quiz  if it it doesn't work?

Is there some something I can do?

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Tim Hunt នៅ
រូបភាព Core developers រូបភាព Documentation writers រូបភាព Particularly helpful Moodlers រូបភាព Peer reviewers រូបភាព Plugin developers

This is on my list for today, I hope.

If you want a quick fix, you can directly edit the table definition (using PHPMyAdmin or similar) to change the question_attempts.minfraction column to remove 'unsigned' from the data type.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

Thank you very much Tim

have a good work. ញញឹម

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Jean-Michel Védrine នៅ

Using a BETA version rather than a STABLE one clearly expose to more bugs ញាក់ចិញ្ចើម .

If you need a stable version for your thesis, you better have to  use 2.0 stable or wait for 2.1 release at the end of the month.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Jean-Michel Védrine

Re: error in moodle 2.1 beta

ដោយ Tim Hunt នៅ
រូបភាព Core developers រូបភាព Documentation writers រូបភាព Particularly helpful Moodlers រូបភាព Peer reviewers រូបភាព Plugin developers

No. 2.1 is in a state where it is fine to use for research, and helping to find the bugs is a very useful contribution.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Tim Hunt

Re: error in moodle 2.1 beta

ដោយ Jean-Michel Védrine នៅ

Bug hunting is also fun in my personal opinion សើចសប្បាយ

I played with 2.1 only for a few days but I too find it very stable. I am now quite sure I will upgrade my production website before the begining of the next academic year.

មធ្យមភាគនៃរង្វាយតម្លៃ: -
ឆ្លើយតបទៅកាន់ Nikita M

Re: error in moodle 2.1 beta

ដោយ Nikita M នៅ

I notice another problem:

when I go to Courses ->"CourseName" -> Participiants

it go back to Home-> Participants

and not to

Home->Courses->"CourseName"-> Participiants

as I would expect

មធ្យមភាគនៃរង្វាយតម្លៃ: -